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 647: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(l_bb_id) := 'SUCCESS';

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1206: HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.last

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1720: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

1716:
1717:
1718: procedure validate_process(p_operation IN varchar2) IS
1719:
1720: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1721: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1722: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1723:
1724: begin

Line 1721: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;

1717:
1718: procedure validate_process(p_operation IN varchar2) IS
1719:
1720: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1721: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1722: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1723:
1724: begin
1725:

Line 1722: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;

1718: procedure validate_process(p_operation IN varchar2) IS
1719:
1720: l_blocks HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1721: l_attributes HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info;
1722: l_messages HXC_USER_TYPE_DEFINITION_GRP.message_table;
1723:
1724: begin
1725:
1726: ---- get time information

Line 1749: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,

1745:
1746:
1747:
1748: procedure eam_validate_timecard( p_operation IN varchar2,
1749: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1750: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1751: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1752: IS
1753:

Line 1750: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,

1746:
1747:
1748: procedure eam_validate_timecard( p_operation IN varchar2,
1749: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1750: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1751: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1752: IS
1753:
1754: -- Define the variables that form part of the Deposit Mapping

Line 1751: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)

1747:
1748: procedure eam_validate_timecard( p_operation IN varchar2,
1749: p_time_building_blocks IN HXC_USER_TYPE_DEFINITION_GRP.timecard_info,
1750: p_time_attributes IN HXC_USER_TYPE_DEFINITION_GRP.app_attributes_info,
1751: p_messages IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.message_table)
1752: IS
1753:
1754: -- Define the variables that form part of the Deposit Mapping
1755: l_asset_number VARCHAR2(30);

Line 1782: l_current_week_tc HXC_USER_TYPE_DEFINITION_GRP.timecard_info;

1778: l_min_acct_period_date DATE := SYSDATE;
1779: l_max_acct_period_date DATE := SYSDATE;
1780: l_stop_time DATE := SYSDATE - 100000;
1781: l_start_time DATE := SYSDATE - 100000;
1782: l_current_week_tc HXC_USER_TYPE_DEFINITION_GRP.timecard_info;
1783: l_parent_bb_id NUMBER := -1;
1784: l_return_status NUMBER := 1;
1785:
1786: l_eam_card NUMBER :=0;

Line 2370: p_message_table IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE

2366: --
2367: -- description
2368: -- adds error to the TCO message stack
2369: PROCEDURE add_error_to_table (
2370: p_message_table IN OUT NOCOPY HXC_USER_TYPE_DEFINITION_GRP.MESSAGE_TABLE
2371: ,p_message_name IN FND_NEW_MESSAGES.MESSAGE_NAME%TYPE
2372: ,p_message_token IN VARCHAR2
2373: ,p_message_level IN VARCHAR2
2374: ,p_message_field IN VARCHAR2