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.EAM_OTL_TIMECARD_PUB dependencies on HXC_USER_TYPE_DEFINITION_GRP

Line 22: PROCEDURE get_attribute_id (p_att_table IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute,

18: -- 6- Owning Department Id
19: -- 7- Asset Number
20:
21:
22: PROCEDURE get_attribute_id (p_att_table IN HXC_USER_TYPE_DEFINITION_GRP.t_time_attribute,
23: p_bb_id IN number,
24: p_last_att_index IN OUT NOCOPY BINARY_INTEGER,
25: x_workorder OUT NOCOPY NUMBER,
26: x_operation OUT NOCOPY NUMBER,

Line 649: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'SUCCESS';

645: g_msg := 'Insert into WCTI - SUCCESS';
646: fnd_file.put_line(FND_FILE.LOG, g_msg);
647: -- dbms_output.put_line(g_msg);
648:
649: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'SUCCESS';
650: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Processed Successfully';
651:
652: else
653:

Line 650: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Processed Successfully';

646: fnd_file.put_line(FND_FILE.LOG, g_msg);
647: -- dbms_output.put_line(g_msg);
648:
649: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'SUCCESS';
650: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Processed Successfully';
651:
652: else
653:
654: g_msg := 'Insert into WCTI failed';

Line 658: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'ERRORS';

654: g_msg := 'Insert into WCTI failed';
655: fnd_file.put_line(FND_FILE.LOG, g_msg);
656: -- dbms_output.put_line(g_msg);
657:
658: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'ERRORS';
659: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Failed';
660:
661: end if;
662:

Line 659: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Failed';

655: fnd_file.put_line(FND_FILE.LOG, g_msg);
656: -- dbms_output.put_line(g_msg);
657:
658: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'ERRORS';
659: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_bb_id) := 'Resource Transaction Failed';
660:
661: end if;
662:
663: else

Line 1199: -- dbms_output.put_line(HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT);

1195: g_msg := 'Start Processing of Building Blocks start now ';
1196: fnd_file.put_line(FND_FILE.LOG, g_msg);
1197: -- dbms_output.put_line(g_msg);
1198:
1199: -- dbms_output.put_line(HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT);
1200:
1201:
1202:
1203: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT <> 0 THEN

Line 1203: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT <> 0 THEN

1199: -- dbms_output.put_line(HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT);
1200:
1201:
1202:
1203: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT <> 0 THEN
1204:
1205: l_old_count := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.first;
1206:
1207: FOR l_cnt in HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.first ..

Line 1205: l_old_count := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.first;

1201:
1202:
1203: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT <> 0 THEN
1204:
1205: l_old_count := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.first;
1206:
1207: FOR l_cnt in HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.first ..
1208: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.last
1209:

Line 1207: FOR l_cnt in HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.first ..

1203: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT <> 0 THEN
1204:
1205: l_old_count := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.first;
1206:
1207: FOR l_cnt in HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.first ..
1208: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.last
1209:
1210: LOOP
1211:

Line 1208: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.last

1204:
1205: l_old_count := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks.first;
1206:
1207: FOR l_cnt in HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.first ..
1208: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.last
1209:
1210: LOOP
1211:
1212: g_msg := 'Processing Building Blocks : ' || l_cnt;

Line 1219: l_bb_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).bb_id;

1215:
1216: g_status := 'SUCCESS';
1217:
1218: BEGIN
1219: l_bb_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).bb_id;
1220: l_bb_index := l_cnt;
1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;

Line 1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;

1217:
1218: BEGIN
1219: l_bb_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).bb_id;
1220: l_bb_index := l_cnt;
1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;

Line 1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;

1218: BEGIN
1219: l_bb_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).bb_id;
1220: l_bb_index := l_cnt;
1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;

Line 1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;

1219: l_bb_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).bb_id;
1220: l_bb_index := l_cnt;
1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;

Line 1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;

1220: l_bb_index := l_cnt;
1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;

Line 1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;

1221: l_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).type;
1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;
1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;

Line 1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;

1222: l_measure := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).measure;
1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;
1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;
1230:

Line 1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;

1223: l_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).start_time;
1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;
1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;
1230:
1231:

Line 1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;

1224: l_stop_time := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).stop_time;
1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;
1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;
1230:
1231:
1232: g_msg := 'Building Block Id : ' || l_bb_id || 'Measure : ' || l_measure || ' Resource Id : '|| l_resource_id || ' Start Time : ' || l_start_time;

Line 1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;

1225: l_scope := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).scope;
1226: l_resource_id := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_id;
1227: l_resource_type := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).resource_type;
1228: l_changed := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).changed;
1229: l_deleted := HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks(l_cnt).deleted;
1230:
1231:
1232: g_msg := 'Building Block Id : ' || l_bb_id || 'Measure : ' || l_measure || ' Resource Id : '|| l_resource_id || ' Start Time : ' || l_start_time;
1233: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1263: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,

1259: fnd_file.put_line(FND_FILE.LOG, g_msg);
1260: -- dbms_output.put_line(g_msg);
1261:
1262:
1263: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1264: p_bb_id => l_bb_id,
1265: p_last_att_index => l_last_att_index,
1266: x_workorder => l_workorder,
1267: x_operation => l_operation,

Line 1321: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,

1317: g_msg := 'Update OTL Timecard. Resource Transaction reversed.';
1318: fnd_file.put_line(FND_FILE.LOG, g_msg);
1319: -- dbms_output.put_line(g_msg);
1320:
1321: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1322: p_bb_id => l_bb_id,
1323: p_last_att_index => l_last_att_index,
1324: x_workorder => l_workorder,
1325: x_operation => l_operation,

Line 1341: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes,

1337: fnd_file.put_line(FND_FILE.LOG, g_msg);
1338: -- dbms_output.put_line(g_msg);
1339:
1340:
1341: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes,
1342: p_bb_id => l_bb_id,
1343: p_last_att_index => t_temp_attr_index,
1344: x_workorder => l_old_workorder,
1345: x_operation => l_old_operation,

Line 1358: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;

1354: -- dbms_output.put_line(g_msg);
1355:
1356:
1357: -- t_temp_attr_index := l_last_att_index;
1358: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;
1359: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;
1360: l_old_count := l_old_count + 1;
1361:
1362: perform_res_txn (p_wip_entity_id => l_old_workorder,

Line 1359: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;

1355:
1356:
1357: -- t_temp_attr_index := l_last_att_index;
1358: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;
1359: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;
1360: l_old_count := l_old_count + 1;
1361:
1362: perform_res_txn (p_wip_entity_id => l_old_workorder,
1363: p_operation_seq_num => l_old_operation,

Line 1394: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,

1390: g_msg := 'Before get_attribute_id - NEW (Y,N)-> (Delete,Change)';
1391: fnd_file.put_line(FND_FILE.LOG, g_msg);
1392: -- dbms_output.put_line(g_msg);
1393:
1394: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1395: p_bb_id => l_bb_id,
1396: p_last_att_index => l_last_att_index,
1397: x_workorder => l_workorder,
1398: x_operation => l_operation,

Line 1434: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,

1430:
1431: g_msg := 'Updating OTL Timecard';
1432: fnd_file.put_line(FND_FILE.LOG, g_msg);
1433:
1434: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_detail_attributes,
1435: p_bb_id => l_bb_id,
1436: p_last_att_index => l_last_att_index,
1437: x_workorder => l_workorder,
1438: x_operation => l_operation,

Line 1455: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes,

1451: -- dbms_output.put_line(g_msg);
1452:
1453:
1454:
1455: get_attribute_id (p_att_table => HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_attributes,
1456: p_bb_id => l_bb_id,
1457: p_last_att_index => t_temp_attr_index,
1458: x_workorder => l_old_workorder,
1459: x_operation => l_old_operation,

Line 1472: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;

1468: -- dbms_output.put_line(g_msg);
1469:
1470: -- t_temp_attr_index := l_last_att_index;
1471:
1472: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;
1473: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;
1474: l_old_count := l_old_count + 1;
1475:
1476: perform_res_txn (p_wip_entity_id => l_old_workorder,

Line 1473: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;

1469:
1470: -- t_temp_attr_index := l_last_att_index;
1471:
1472: l_old_measure := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).measure;
1473: l_old_start_time := HXC_USER_TYPE_DEFINITION_GRP.t_old_detail_bld_blks(l_old_count).start_time;
1474: l_old_count := l_old_count + 1;
1475:
1476: perform_res_txn (p_wip_entity_id => l_old_workorder,
1477: p_operation_seq_num => l_old_operation,

Line 1512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';

1508:
1509: -- set the transaction status for the block we have processed
1510:
1511: /**changed for bug#3949853
1512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1513: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1514:
1515: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1516: fnd_file.put_line(FND_FILE.LOG, g_msg);

Line 1513: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';

1509: -- set the transaction status for the block we have processed
1510:
1511: /**changed for bug#3949853
1512: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1513: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1514:
1515: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1516: fnd_file.put_line(FND_FILE.LOG, g_msg);
1517: **/

Line 1520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';

1516: fnd_file.put_line(FND_FILE.LOG, g_msg);
1517: **/
1518:
1519: if g_status <> 'ERRORS' then
1520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1521: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1522: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1523: fnd_file.put_line(FND_FILE.LOG, g_msg);
1524: COMMIT WORK;

Line 1521: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';

1517: **/
1518:
1519: if g_status <> 'ERRORS' then
1520: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := 'SUCCESS';
1521: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := 'Building Block Processed Successfully';
1522: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1523: fnd_file.put_line(FND_FILE.LOG, g_msg);
1524: COMMIT WORK;
1525: else

Line 1526: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := g_status;

1522: g_msg := 'SUCCESS -- Building Block Processed Successfully';
1523: fnd_file.put_line(FND_FILE.LOG, g_msg);
1524: COMMIT WORK;
1525: else
1526: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := g_status;
1527: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := g_exception_description;
1528: g_msg := 'FAILURE -- Building Block Processing Failed';
1529: fnd_file.put_line(FND_FILE.LOG, g_msg);
1530: end if;

Line 1527: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := g_exception_description;

1523: fnd_file.put_line(FND_FILE.LOG, g_msg);
1524: COMMIT WORK;
1525: else
1526: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_cnt) := g_status;
1527: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(l_cnt) := g_exception_description;
1528: g_msg := 'FAILURE -- Building Block Processing Failed';
1529: fnd_file.put_line(FND_FILE.LOG, g_msg);
1530: end if;
1531:

Line 1725: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

1721:
1722:
1723: procedure validate_process(p_operation IN varchar2) IS
1724:
1725: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1726: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1727: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1728:
1729: begin

Line 1726: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

1722:
1723: procedure validate_process(p_operation IN varchar2) IS
1724:
1725: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1726: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1727: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1728:
1729: begin
1730:

Line 1727: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;

1723: procedure validate_process(p_operation IN varchar2) IS
1724:
1725: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1726: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1727: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1728:
1729: begin
1730:
1731: ---- get time information

Line 1754: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,

1750:
1751:
1752:
1753: procedure eam_validate_timecard( p_operation IN varchar2,
1754: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1755: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1756: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1757: IS
1758:

Line 1755: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,

1751:
1752:
1753: procedure eam_validate_timecard( p_operation IN varchar2,
1754: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1755: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1756: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1757: IS
1758:
1759: -- Define the variables that form part of the Deposit Mapping

Line 1756: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

1752:
1753: procedure eam_validate_timecard( p_operation IN varchar2,
1754: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1755: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1756: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1757: IS
1758:
1759: -- Define the variables that form part of the Deposit Mapping
1760: l_asset_number VARCHAR2(30);

Line 1789: l_current_week_tc HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

1785: l_wo_released_date DATE := SYSDATE;
1786: l_stop_time DATE := SYSDATE - 100000;
1787: l_start_time DATE := SYSDATE - 100000;
1788: l_exact_start_time DATE := SYSDATE - 100000;
1789: l_current_week_tc HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1790: l_parent_bb_id NUMBER := -1;
1791: l_return_status NUMBER := 1;
1792:
1793: l_eam_card NUMBER :=0;

Line 2405: p_message_table IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE

2401: --
2402: -- description
2403: -- adds error to the TCO message stack
2404: PROCEDURE add_error_to_table (
2405: p_message_table IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE
2406: ,p_message_name IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
2407: ,p_message_token IN VARCHAR2
2408: ,p_message_level IN VARCHAR2
2409: ,p_message_field IN VARCHAR2