343: --Bug 4259255. Added exception handling for corrupt data in hxc_time_attributes table.
344: --Change for version 115.46
345: exception
346: WHEN INVALID_NUMBER THEN
347: fnd_message.set_name('HXC', 'HXC_INVALID_PROJECT_ID');
348: FND_MSG_PUB.ADD;
349:
350: END;
351: CLOSE l_valcursor;
411:
412: RETURN (''''||'-1'||''''); --Fix for Bug#3362876
413: exception
414: when e_null_flex_name then
415: fnd_message.set_name('HXC', 'HXC_FLEX_NAME_NULL');
416: fnd_message.raise_error;
417:
418:
419: when e_null_flex_context then
412: RETURN (''''||'-1'||''''); --Fix for Bug#3362876
413: exception
414: when e_null_flex_name then
415: fnd_message.set_name('HXC', 'HXC_FLEX_NAME_NULL');
416: fnd_message.raise_error;
417:
418:
419: when e_null_flex_context then
420: fnd_message.set_name('HXC', 'HXC_FLEX_CONTEXT_NULL');
416: fnd_message.raise_error;
417:
418:
419: when e_null_flex_context then
420: fnd_message.set_name('HXC', 'HXC_FLEX_CONTEXT_NULL');
421: fnd_message.raise_error;
422:
423: when e_null_flex_segment then
424: fnd_message.set_name('HXC', 'HXC_FLEX_SEGMENT_NULL');
417:
418:
419: when e_null_flex_context then
420: fnd_message.set_name('HXC', 'HXC_FLEX_CONTEXT_NULL');
421: fnd_message.raise_error;
422:
423: when e_null_flex_segment then
424: fnd_message.set_name('HXC', 'HXC_FLEX_SEGMENT_NULL');
425: fnd_message.raise_error;
420: fnd_message.set_name('HXC', 'HXC_FLEX_CONTEXT_NULL');
421: fnd_message.raise_error;
422:
423: when e_null_flex_segment then
424: fnd_message.set_name('HXC', 'HXC_FLEX_SEGMENT_NULL');
425: fnd_message.raise_error;
426:
427: when others then
428: -- fnd_message.set_name('HXC', 'HXC_FLEX_CANNOT_BE_SEARCHED');
421: fnd_message.raise_error;
422:
423: when e_null_flex_segment then
424: fnd_message.set_name('HXC', 'HXC_FLEX_SEGMENT_NULL');
425: fnd_message.raise_error;
426:
427: when others then
428: -- fnd_message.set_name('HXC', 'HXC_FLEX_CANNOT_BE_SEARCHED');
429: -- fnd_message.raise_error;
424: fnd_message.set_name('HXC', 'HXC_FLEX_SEGMENT_NULL');
425: fnd_message.raise_error;
426:
427: when others then
428: -- fnd_message.set_name('HXC', 'HXC_FLEX_CANNOT_BE_SEARCHED');
429: -- fnd_message.raise_error;
430: raise;
431:
432: END get_attributes_by_flex;
425: fnd_message.raise_error;
426:
427: when others then
428: -- fnd_message.set_name('HXC', 'HXC_FLEX_CANNOT_BE_SEARCHED');
429: -- fnd_message.raise_error;
430: raise;
431:
432: END get_attributes_by_flex;
433:
611: /**
612: * If we get here, it means the building block id did not exist
613: * in the time building blocks table (partioned?), and we should error.
614: */
615: fnd_message.set_name('HXC','HXC_APR_NO_TIMECARD_INFO');
616: fnd_message.set_token('TIMECARD_ID',to_char(bb_id));
617: fnd_message.raise_error;
618: else
619: close c_last_timecard_status;
612: * If we get here, it means the building block id did not exist
613: * in the time building blocks table (partioned?), and we should error.
614: */
615: fnd_message.set_name('HXC','HXC_APR_NO_TIMECARD_INFO');
616: fnd_message.set_token('TIMECARD_ID',to_char(bb_id));
617: fnd_message.raise_error;
618: else
619: close c_last_timecard_status;
620: end if;
613: * in the time building blocks table (partioned?), and we should error.
614: */
615: fnd_message.set_name('HXC','HXC_APR_NO_TIMECARD_INFO');
616: fnd_message.set_token('TIMECARD_ID',to_char(bb_id));
617: fnd_message.raise_error;
618: else
619: close c_last_timecard_status;
620: end if;
621: else
839:
840: exception
841:
842: when others then
843: fnd_message.set_name('HXC', 'HXC_ERROR_FINDING_TIMECARD_STATUS');
844: fnd_message.raise_error;
845:
846:
847: END get_timecard_status_code;
840: exception
841:
842: when others then
843: fnd_message.set_name('HXC', 'HXC_ERROR_FINDING_TIMECARD_STATUS');
844: fnd_message.raise_error;
845:
846:
847: END get_timecard_status_code;
848:
1220: IF c_mapping_segment%NOTFOUND
1221: THEN
1222: CLOSE c_mapping_segment;
1223:
1224: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1225: FND_MESSAGE.RAISE_ERROR;
1226: END IF;
1227:
1228: CLOSE c_mapping_segment;
1221: THEN
1222: CLOSE c_mapping_segment;
1223:
1224: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1225: FND_MESSAGE.RAISE_ERROR;
1226: END IF;
1227:
1228: CLOSE c_mapping_segment;
1229:
1494: IF c_mapping_segment%NOTFOUND
1495: THEN
1496: CLOSE c_mapping_segment;
1497:
1498: FND_MESSAGE.set_name('HXC','HXC_NO_MAPPING_COMPONENT');
1499:
1500: -- Bug Fix for 2581640 Start
1501: -- Add error to the multi-message stack and retreive the error
1502: -- message in TimecardSearch.java. No need for RAISE_ERROR.
1500: -- Bug Fix for 2581640 Start
1501: -- Add error to the multi-message stack and retreive the error
1502: -- message in TimecardSearch.java. No need for RAISE_ERROR.
1503: FND_MSG_PUB.ADD;
1504: -- FND_MESSAGE.RAISE_ERROR;
1505: -- Bug Fix for 2581640 End
1506:
1507: END IF;
1508: