eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_TIMECARD dependencies on HR_UTILITY

Line 9: g_debug boolean := hr_utility.debug_enabled;

5:
6: attribute_id_list attribute_list;
7:
8: g_package varchar2(12) := 'HXC_TIMECARD';
9: g_debug boolean := hr_utility.debug_enabled;
10: g_deposit_blocks hxc_block_table_type;
11: g_deposit_attributes hxc_attribute_table_type;
12: g_audit_messages hxc_message_table_type;
13:

Line 45: hr_utility.trace('Entering '||l_proc);

41:
42: BEGIN
43:
44: IF g_debug THEN
45: hr_utility.trace('Entering '||l_proc);
46: END IF;
47:
48: -- Bug 12370302
49: -- start

Line 122: hr_utility.trace('PA-PAY> '||p_attributes(l_index).ATTRIBUTE_CATEGORY||'is deleted.');

118: p_attributes(l_index).ATTRIBUTE30 IS NULL
119: )
120: THEN
121: IF g_debug THEN
122: hr_utility.trace('PA-PAY> '||p_attributes(l_index).ATTRIBUTE_CATEGORY||'is deleted.');
123: END IF;
124: p_attributes.delete(l_index);
125: END IF;
126: l_index := p_attributes.next(l_index);

Line 130: hr_utility.trace('Leaving '||l_proc);

126: l_index := p_attributes.next(l_index);
127: END LOOP;
128:
129: IF g_debug THEN
130: hr_utility.trace('Leaving '||l_proc);
131: END IF;
132:
133: END remove_null_attribute_category;
134:

Line 229: hr_utility.trace('PA-PAY> In hxc_timecard.save_timecard');

225: -- Added for Bug 10326049
226: -- OTL - Projects Payroll Integration
227:
228: IF g_debug THEN
229: hr_utility.trace('PA-PAY> In hxc_timecard.save_timecard');
230: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');
231: END IF;
232:
233: hxc_proj_pay_dep_validation.verify_proj_pay_setup(p_blocks => p_blocks,

Line 230: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');

226: -- OTL - Projects Payroll Integration
227:
228: IF g_debug THEN
229: hr_utility.trace('PA-PAY> In hxc_timecard.save_timecard');
230: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');
231: END IF;
232:
233: hxc_proj_pay_dep_validation.verify_proj_pay_setup(p_blocks => p_blocks,
234: p_attributes => p_attributes,

Line 318: hr_utility.trace('SVG: Rollingback to savepoint TC_SAVE_SAVEPOINT for any Projects related updates');

314: --svg start Bug 9181950
315: if NOT hxc_timecard_message_helper.noErrors then
316: --HXC_SVG_LOG.record_log('Reached here:svg');
317: if g_debug then
318: hr_utility.trace('SVG: Rollingback to savepoint TC_SAVE_SAVEPOINT for any Projects related updates');
319: end if;
320: rollback to TC_SAVE_SAVEPOINT;
321: end if;
322: -- svg end

Line 398: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.SAVE_TIMECARD');

394: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors
395: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope) THEN
396:
397: IF g_debug THEN
398: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.SAVE_TIMECARD');
399: END IF;
400:
401: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);
402: l_stop_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).stop_time);

Line 414: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);

410: p_messages);
411:
412:
413: IF g_debug THEN
414: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);
415: END IF;
416:
417: IF p_messages.COUNT > 0 THEN
418: IF g_debug THEN

Line 419: hr_utility.trace('ABS:Error in POST_ABSENCES');

415: END IF;
416:
417: IF p_messages.COUNT > 0 THEN
418: IF g_debug THEN
419: hr_utility.trace('ABS:Error in POST_ABSENCES');
420: END IF;
421: raise TC_SAVE_EXCEPTION;
422: END IF;
423:

Line 432: hr_utility.trace('ABS: Exception TC_SAVE_EXCEPTION');

428: EXCEPTION
429:
430: WHEN TC_SAVE_EXCEPTION THEN
431: IF g_debug THEN
432: hr_utility.trace('ABS: Exception TC_SAVE_EXCEPTION');
433: END IF;
434:
435: rollback to TC_SAVE_SAVEPOINT;
436: hxc_timecard_message_helper.processerrors

Line 443: hr_utility.trace('Leaving SAVE_TIMECARD');

439:
440: END ; -- Absences end
441:
442: IF g_debug THEN
443: hr_utility.trace('Leaving SAVE_TIMECARD');
444: END IF;
445:
446: End save_timecard;
447:

Line 497: hr_utility.trace('Entering '||l_proc);

493:
494: BEGIN
495:
496: IF g_debug THEN
497: hr_utility.trace('Entering '||l_proc);
498: END IF;
499:
500: savepoint TC_SUB_SAVEPOINT ;
501:

Line 509: hr_utility.trace('PA-PAY> '||

505: IF g_debug THEN
506: l_index := l_attributes.first;
507: LOOP
508: EXIT WHEN NOT l_attributes.exists(l_index);
509: hr_utility.trace('PA-PAY> '||
510: 'BB id : '||l_attributes(l_index).BUILDING_BLOCK_ID
511: ||'['||l_attributes(l_index).BUILDING_BLOCK_OVN||']'
512: ||' ATT CAT: '||l_attributes(l_index).ATTRIBUTE_CATEGORY
513: ||' ATTRIBUTE1: '||l_attributes(l_index).ATTRIBUTE1

Line 526: hr_utility.trace('PA-PAY> call to remove_null_attribute_category');

522: ||' ATT ID '||l_attributes(l_index).TIME_ATTRIBUTE_ID
523: );
524: l_index := l_attributes.next(l_index);
525: END LOOP;
526: hr_utility.trace('PA-PAY> call to remove_null_attribute_category');
527: END IF;
528:
529: -- Added for Bug 12370302
530: remove_null_attribute_category(l_attributes);

Line 536: hr_utility.trace('PA-PAY>'||

532: IF g_debug THEN
533: l_index := l_attributes.first;
534: LOOP
535: EXIT WHEN NOT l_attributes.exists(l_index);
536: hr_utility.trace('PA-PAY>'||
537: 'BB id : '||l_attributes(l_index).BUILDING_BLOCK_ID
538: ||'['||l_attributes(l_index).BUILDING_BLOCK_OVN||']'
539: ||' ATT CAT: '||l_attributes(l_index).ATTRIBUTE_CATEGORY
540: ||' ATTRIBUTE1: '||l_attributes(l_index).ATTRIBUTE1

Line 831: hr_utility.trace('PA-PAY> In hxc_timecard.deposit_controller');

827: -- Added for Bug 10326049
828: -- OTL - Projects Payroll Integration
829:
830: IF g_debug THEN
831: hr_utility.trace('PA-PAY> In hxc_timecard.deposit_controller');
832: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');
833: END IF;
834:
835: hxc_proj_pay_dep_validation.verify_proj_pay_setup(p_blocks => p_blocks,

Line 832: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');

828: -- OTL - Projects Payroll Integration
829:
830: IF g_debug THEN
831: hr_utility.trace('PA-PAY> In hxc_timecard.deposit_controller');
832: hr_utility.trace('PA-PAY> calling hxc_proj_pay_dep_validation.verify_proj_pay_setup');
833: END IF;
834:
835: hxc_proj_pay_dep_validation.verify_proj_pay_setup(p_blocks => p_blocks,
836: p_attributes => l_attributes,

Line 947: hr_utility.trace('SVG: Rollingback to savepoint TC_SUB_SAVEPOINT for any Projects related updates');

943: --svg start Bug 9181950
944: if NOT hxc_timecard_message_helper.noErrors then
945: --HXC_SVG_LOG.record_log('Reached here:svg');
946: if g_debug then
947: hr_utility.trace('SVG: Rollingback to savepoint TC_SUB_SAVEPOINT for any Projects related updates');
948: end if;
949: rollback to TC_SUB_SAVEPOINT;
950: end if;
951: -- svg end

Line 983: hr_utility.trace('>deposit_controller g_deposit_blocks 1');

979: OR l_restrict_blank_rows_on_save = 'No' THEN
980:
981: IF g_debug THEN
982:
983: hr_utility.trace('>deposit_controller g_deposit_blocks 1');
984: l_index := g_deposit_blocks.first;
985: LOOP
986: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
987: hr_utility.trace(

Line 987: hr_utility.trace(

983: hr_utility.trace('>deposit_controller g_deposit_blocks 1');
984: l_index := g_deposit_blocks.first;
985: LOOP
986: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
987: hr_utility.trace(
988: 'RESOURCE_ID :'||g_deposit_blocks(l_index).RESOURCE_ID
989: ||'BB id : '||g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID
990: ||'['||g_deposit_blocks(l_index).OBJECT_VERSION_NUMBER||']'
991: ||' PARENT_BUILDING_BLOCK_ID: '||g_deposit_blocks(l_index).PARENT_BUILDING_BLOCK_ID

Line 1006: hr_utility.trace('>deposit_controller l_blocks 1.1 ');

1002: l_index := g_deposit_blocks.next(l_index);
1003: END LOOP;
1004:
1005:
1006: hr_utility.trace('>deposit_controller l_blocks 1.1 ');
1007: l_index := l_blocks.first;
1008: LOOP
1009: EXIT WHEN NOT l_blocks.exists(l_index);
1010: hr_utility.trace(

Line 1010: hr_utility.trace(

1006: hr_utility.trace('>deposit_controller l_blocks 1.1 ');
1007: l_index := l_blocks.first;
1008: LOOP
1009: EXIT WHEN NOT l_blocks.exists(l_index);
1010: hr_utility.trace(
1011: 'RESOURCE_ID :'||l_blocks(l_index).RESOURCE_ID
1012: ||'BB id : '||l_blocks(l_index).TIME_BUILDING_BLOCK_ID
1013: ||'['||l_blocks(l_index).OBJECT_VERSION_NUMBER||']'
1014: ||' PARENT_BUILDING_BLOCK_ID: '||l_blocks(l_index).PARENT_BUILDING_BLOCK_ID

Line 1029: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);

1025: END LOOP;
1026: END IF;
1027:
1028:
1029: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);
1030: -- Added for DA
1031: IF((p_template <> c_yes) and (hxc_timecard_message_helper.noErrors)) THEN
1032: l_index := g_deposit_blocks.first;
1033: LOOP

Line 1050: hr_utility.trace('g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID : '||

1046:
1047: l_idx := l_blocks.next(l_idx);
1048: END LOOP;
1049:
1050: hr_utility.trace('g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID : '||
1051: g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID || '- sysdate :'||to_char(SYSDATE,'yyyy/mm/dd'));
1052: hr_utility.trace('bb_id_exists :'|| bb_id_exists);
1053:
1054: IF bb_id_exists = 'N' THEN

Line 1052: hr_utility.trace('bb_id_exists :'|| bb_id_exists);

1048: END LOOP;
1049:
1050: hr_utility.trace('g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID : '||
1051: g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID || '- sysdate :'||to_char(SYSDATE,'yyyy/mm/dd'));
1052: hr_utility.trace('bb_id_exists :'|| bb_id_exists);
1053:
1054: IF bb_id_exists = 'N' THEN
1055: g_deposit_blocks(l_index).DATE_TO := to_char(SYSDATE,'yyyy/mm/dd');
1056: END IF;

Line 1071: hr_utility.trace('>deposit_controller 2');

1067: -- End of DA
1068:
1069: IF g_debug THEN
1070:
1071: hr_utility.trace('>deposit_controller 2');
1072: l_index := g_deposit_blocks.first;
1073: LOOP
1074: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
1075: hr_utility.trace(

Line 1075: hr_utility.trace(

1071: hr_utility.trace('>deposit_controller 2');
1072: l_index := g_deposit_blocks.first;
1073: LOOP
1074: EXIT WHEN NOT g_deposit_blocks.exists(l_index);
1075: hr_utility.trace(
1076: 'RESOURCE_ID :'||g_deposit_blocks(l_index).RESOURCE_ID
1077: ||'BB id : '||g_deposit_blocks(l_index).TIME_BUILDING_BLOCK_ID
1078: ||'['||g_deposit_blocks(l_index).OBJECT_VERSION_NUMBER||']'
1079: ||' PARENT_BUILDING_BLOCK_ID: '||g_deposit_blocks(l_index).PARENT_BUILDING_BLOCK_ID

Line 1093: hr_utility.trace('>deposit_controller 2.1');

1089:
1090: l_index := g_deposit_blocks.next(l_index);
1091: END LOOP;
1092:
1093: hr_utility.trace('>deposit_controller 2.1');
1094: l_index := l_blocks.first;
1095: LOOP
1096: EXIT WHEN NOT l_blocks.exists(l_index);
1097: hr_utility.trace(

Line 1097: hr_utility.trace(

1093: hr_utility.trace('>deposit_controller 2.1');
1094: l_index := l_blocks.first;
1095: LOOP
1096: EXIT WHEN NOT l_blocks.exists(l_index);
1097: hr_utility.trace(
1098: 'RESOURCE_ID :'||l_blocks(l_index).RESOURCE_ID
1099: ||'BB id : '||l_blocks(l_index).TIME_BUILDING_BLOCK_ID
1100: ||'['||l_blocks(l_index).OBJECT_VERSION_NUMBER||']'
1101: ||' PARENT_BUILDING_BLOCK_ID: '||l_blocks(l_index).PARENT_BUILDING_BLOCK_ID

Line 1179: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DEPOSIT_CONTROLLER');

1175: and p_blocks(hxc_timecard_block_utils.find_active_timecard_index(p_blocks)).SCOPE <> hxc_timecard.c_template_scope)
1176: THEN
1177:
1178: IF g_debug THEN
1179: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DEPOSIT_CONTROLLER');
1180: END IF;
1181:
1182: l_resource_id := p_blocks(l_timecard_index).resource_id ;
1183: l_start_date := hxc_timecard_block_utils.date_value(p_blocks(l_timecard_index).start_time);

Line 1194: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);

1190: l_tc_status,
1191: p_messages);
1192:
1193: IF g_debug THEN
1194: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);
1195: END IF;
1196:
1197: if p_messages.COUNT > 0
1198: then

Line 1200: hr_utility.trace('ABS:Error in POST_ABSENCES');

1196:
1197: if p_messages.COUNT > 0
1198: then
1199: IF g_debug THEN
1200: hr_utility.trace('ABS:Error in POST_ABSENCES');
1201: END IF;
1202: raise TC_SUB_EXCEPTION;
1203: end if;
1204:

Line 1211: hr_utility.trace('ABS: Exception TC_SUB_EXCEPTION');

1207:
1208: EXCEPTION
1209: WHEN TC_SUB_EXCEPTION THEN
1210: IF g_debug THEN
1211: hr_utility.trace('ABS: Exception TC_SUB_EXCEPTION');
1212: END IF;
1213:
1214: rollback to TC_SUB_SAVEPOINT;
1215: hxc_timecard_message_helper.processerrors

Line 1241: hr_utility.trace('ABS:Checking status of BEGIN_APPROVAL');

1237: -- for Bug 8888138
1238: BEGIN
1239: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1240: IF g_debug THEN
1241: hr_utility.trace('ABS:Checking status of BEGIN_APPROVAL');
1242: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);
1243: END IF;
1244:
1245: if p_messages.COUNT > 0

Line 1242: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);

1238: BEGIN
1239: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1240: IF g_debug THEN
1241: hr_utility.trace('ABS:Checking status of BEGIN_APPROVAL');
1242: hr_utility.trace('ABS:p_messages.COUNT = '||p_messages.COUNT);
1243: END IF;
1244:
1245: if p_messages.COUNT > 0
1246: then

Line 1248: hr_utility.trace('ABS:Error in POST_ABSENCES');

1244:
1245: if p_messages.COUNT > 0
1246: then
1247: IF g_debug THEN
1248: hr_utility.trace('ABS:Error in POST_ABSENCES');
1249: END IF;
1250: raise TC_SUB_EXCEPTION;
1251: end if;
1252: END IF;

Line 1256: hr_utility.trace('ABS: Exception TC_SUB_EXCEPTION');

1252: END IF;
1253: EXCEPTION
1254: WHEN TC_SUB_EXCEPTION THEN
1255: IF g_debug THEN
1256: hr_utility.trace('ABS: Exception TC_SUB_EXCEPTION');
1257: END IF;
1258: rollback to TC_SUB_SAVEPOINT;
1259: hxc_timecard_message_helper.processerrors
1260: (p_messages => p_messages);

Line 1277: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);

1273: ,p_approval_process_name => p_approval_prc
1274: ,p_approval_item_key => l_item_key
1275: );
1276:
1277: hr_utility.trace('Restrict Blank Rows on Save : '||l_restrict_blank_rows_on_save);
1278:
1279: IF l_restrict_blank_rows_on_save = 'N' OR l_restrict_blank_rows_on_save = 'No' THEN
1280: -- Added for DA
1281: delete_null_entries(p_timecard_id => p_timecard_id

Line 1330: hr_utility.trace('Leaving '||l_proc);

1326:
1327: p_messages := hxc_timecard_message_helper.prepareMessages;
1328:
1329: IF g_debug THEN
1330: hr_utility.trace('Leaving '||l_proc);
1331: END IF;
1332:
1333: END deposit_controller;
1334:

Line 1382: g_debug := hr_utility.debug_enabled;

1378:
1379:
1380: Begin
1381:
1382: g_debug := hr_utility.debug_enabled;
1383:
1384: IF g_debug THEN
1385: hr_utility.trace('ABS> In hxc_timecard.create_timecard procedure');
1386: l_index := p_attributes.first;

Line 1385: hr_utility.trace('ABS> In hxc_timecard.create_timecard procedure');

1381:
1382: g_debug := hr_utility.debug_enabled;
1383:
1384: IF g_debug THEN
1385: hr_utility.trace('ABS> In hxc_timecard.create_timecard procedure');
1386: l_index := p_attributes.first;
1387: LOOP
1388: EXIT WHEN NOT p_attributes.exists(l_index);
1389: -- l_attribute := p_attributes(l_index);

Line 1391: hr_utility.trace('ABS> '||

1387: LOOP
1388: EXIT WHEN NOT p_attributes.exists(l_index);
1389: -- l_attribute := p_attributes(l_index);
1390:
1391: hr_utility.trace('ABS> '||
1392: 'BB id : '||p_attributes(l_index).BUILDING_BLOCK_ID
1393: ||'['||p_attributes(l_index).BUILDING_BLOCK_OVN||']'
1394: ||' ATT CAT: '||p_attributes(l_index).ATTRIBUTE_CATEGORY
1395: ||' ATTRIBUTE1: '||p_attributes(l_index).ATTRIBUTE1

Line 1413: hr_utility.trace('ABS> '||

1409:
1410: l_index := p_blocks.first;
1411: LOOP
1412: EXIT WHEN NOT p_blocks.exists(l_index);
1413: hr_utility.trace('ABS> '||
1414: 'RESOURCE_ID :'||p_blocks(l_index).RESOURCE_ID
1415: ||'BB id : '||p_blocks(l_index).TIME_BUILDING_BLOCK_ID
1416: ||'['||p_blocks(l_index).OBJECT_VERSION_NUMBER||']'
1417: ||' PARENT_BUILDING_BLOCK_ID: '||p_blocks(l_index).PARENT_BUILDING_BLOCK_ID

Line 1509: hr_utility.trace('p_template ::' || p_template);

1505: END;
1506:
1507: IF g_debug
1508: THEN
1509: hr_utility.trace('p_template ::' || p_template);
1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);
1511:
1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);
1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);

Line 1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);

1506:
1507: IF g_debug
1508: THEN
1509: hr_utility.trace('p_template ::' || p_template);
1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);
1511:
1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);
1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);
1514: hr_utility.trace('d_exists ::' || d_exists);

Line 1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);

1508: THEN
1509: hr_utility.trace('p_template ::' || p_template);
1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);
1511:
1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);
1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);
1514: hr_utility.trace('d_exists ::' || d_exists);
1515: END IF;
1516:

Line 1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);

1509: hr_utility.trace('p_template ::' || p_template);
1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);
1511:
1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);
1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);
1514: hr_utility.trace('d_exists ::' || d_exists);
1515: END IF;
1516:
1517: IF(p_template <> hxc_timecard.c_yes

Line 1514: hr_utility.trace('d_exists ::' || d_exists);

1510: hr_utility.trace('hxc_timecard.c_yes ::' || hxc_timecard.c_yes);
1511:
1512: hr_utility.trace('p_lock_rowid ::' || p_lock_rowid);
1513: hr_utility.trace('d_lock_rowid ::' || d_lock_rowid);
1514: hr_utility.trace('d_exists ::' || d_exists);
1515: END IF;
1516:
1517: IF(p_template <> hxc_timecard.c_yes
1518: AND d_exists = 1 ) THEN

Line 1520: hr_utility.trace('THROW HXC_MULTIPLE_SESSION ');

1516:
1517: IF(p_template <> hxc_timecard.c_yes
1518: AND d_exists = 1 ) THEN
1519:
1520: hr_utility.trace('THROW HXC_MULTIPLE_SESSION ');
1521:
1522: hxc_timecard_message_helper.adderrortocollection(p_messages,
1523: 'HXC_MULTIPLE_SESSION',
1524: hxc_timecard.c_error,

Line 1593: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');

1589:
1590: -- Added for OTL ABS Integration 8888902
1591: -- OTL-ABS START
1592: IF g_debug THEN
1593: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');
1594: hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
1595: END IF;
1596:
1597: IF (NVL(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN

Line 1594: hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');

1590: -- Added for OTL ABS Integration 8888902
1591: -- OTL-ABS START
1592: IF g_debug THEN
1593: hr_utility.trace('ABS> In hxc_timecard.create_timeecard');
1594: hr_utility.trace('ABS> call hxc_retrieve_absences.insert_absence_summary_row');
1595: END IF;
1596:
1597: IF (NVL(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
1598: hxc_retrieve_absences.insert_absence_summary_row;

Line 2030: hr_utility.trace('Start of delete attachments');

2026: else --For Timecard.
2027:
2028: -- Bug 13416941
2029: -- Delete Attachments if any exists
2030: hr_utility.trace('Start of delete attachments');
2031: OPEN c_timecard_attachment_exists(p_timecard_id);
2032: FETCH c_timecard_attachment_exists INTO l_pk1_value,l_pk2_value,l_pk3_value;
2033: CLOSE c_timecard_attachment_exists;
2034:

Line 2036: hr_utility.trace('Resounce Id ::'||l_pk1_value);

2032: FETCH c_timecard_attachment_exists INTO l_pk1_value,l_pk2_value,l_pk3_value;
2033: CLOSE c_timecard_attachment_exists;
2034:
2035: IF g_debug THEN
2036: hr_utility.trace('Resounce Id ::'||l_pk1_value);
2037: hr_utility.trace('Start Time ::'||l_pk2_value);
2038: hr_utility.trace('Stop Time ::'||l_pk3_value);
2039: END IF;
2040:

Line 2037: hr_utility.trace('Start Time ::'||l_pk2_value);

2033: CLOSE c_timecard_attachment_exists;
2034:
2035: IF g_debug THEN
2036: hr_utility.trace('Resounce Id ::'||l_pk1_value);
2037: hr_utility.trace('Start Time ::'||l_pk2_value);
2038: hr_utility.trace('Stop Time ::'||l_pk3_value);
2039: END IF;
2040:
2041: IF l_pk1_value is not null

Line 2038: hr_utility.trace('Stop Time ::'||l_pk3_value);

2034:
2035: IF g_debug THEN
2036: hr_utility.trace('Resounce Id ::'||l_pk1_value);
2037: hr_utility.trace('Start Time ::'||l_pk2_value);
2038: hr_utility.trace('Stop Time ::'||l_pk3_value);
2039: END IF;
2040:
2041: IF l_pk1_value is not null
2042: THEN

Line 2043: hr_utility.trace('call to delete attachments...fnd_attached_documents2_pkg.delete_attachments');

2039: END IF;
2040:
2041: IF l_pk1_value is not null
2042: THEN
2043: hr_utility.trace('call to delete attachments...fnd_attached_documents2_pkg.delete_attachments');
2044: fnd_attached_documents2_pkg.delete_attachments
2045: ( X_entity_name => 'HXC_TIMECARD_SUMMARY'
2046: , X_pk1_value => l_pk1_value
2047: , X_pk2_value => l_pk2_value

Line 2051: hr_utility.trace('End of delete attachments');

2047: , X_pk2_value => l_pk2_value
2048: , X_pk3_value => l_pk3_value
2049: , X_delete_document_flag => 'Y');
2050: END IF;
2051: hr_utility.trace('End of delete attachments');
2052: -- End of Delete Attachments
2053:
2054:
2055: hxc_timecard_summary_api.delete_timecard

Line 2086: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DELETE_TIMECARD');

2082: BEGIN
2083: IF (nvl(fnd_profile.value('HR_ABS_OTL_INTEGRATION'), 'N') = 'Y') THEN
2084: IF (p_timecard_id > 0 and hxc_timecard_message_helper.noerrors) THEN
2085: IF g_debug THEN
2086: hr_utility.trace('ABS:Initiated Online Retrieval from HXC_TIMECARD.DELETE_TIMECARD');
2087: END IF;
2088:
2089: HXC_ABS_RETRIEVAL_PKG.POST_ABSENCES(l_resource_id,
2090: l_start_time,

Line 2097: hr_utility.trace('ABS:l_messages.COUNT = '||l_messages.COUNT);

2093: l_messages);
2094:
2095:
2096: IF g_debug THEN
2097: hr_utility.trace('ABS:l_messages.COUNT = '||l_messages.COUNT);
2098: END IF;
2099:
2100: if l_messages.COUNT > 0 then
2101: IF g_debug THEN

Line 2102: hr_utility.trace('ABS:Error in POST_ABSENCES');

2098: END IF;
2099:
2100: if l_messages.COUNT > 0 then
2101: IF g_debug THEN
2102: hr_utility.trace('ABS:Error in POST_ABSENCES');
2103: END IF;
2104: raise TC_DEL_EXCEPTION;
2105: end if;
2106:

Line 2113: hr_utility.trace('ABS: Exception TC_DEL_EXCEPTION');

2109:
2110: EXCEPTION
2111: WHEN TC_DEL_EXCEPTION THEN
2112: IF g_debug THEN
2113: hr_utility.trace('ABS: Exception TC_DEL_EXCEPTION');
2114: END IF;
2115:
2116: rollback to TC_DEL_SAVEPOINT;
2117: hxc_timecard_message_helper.processerrors