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.RCV_HXT_GRP dependencies on FND_LOG

Line 172: -- bug 5976883 : Have changed the fnd logging logic according to PO standards

168: -- package globals
169: G_PKG_NAME CONSTANT VARCHAR2(30) := 'RCV_HXT_GRP';
170: G_LOG_MODULE CONSTANT VARCHAR2(40) := 'po.plsql.' || G_PKG_NAME;
171: G_CONC_LOG VARCHAR2(32767);
172: -- bug 5976883 : Have changed the fnd logging logic according to PO standards
173: -- Now at all places we are using the module.package.procedure convention.
174: g_debug_stmt CONSTANT BOOLEAN := PO_DEBUG.is_debug_stmt_on;
175: g_debug_unexp CONSTANT BOOLEAN := PO_DEBUG.is_debug_unexp_on;
176: -- global counters for summary reporting

Line 272: -- add to fnd_log_messages

268: BEGIN
269: IF NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N') = 'Y' THEN
270: l_debug_on := TRUE;
271: END IF;
272: -- add to fnd_log_messages
273: -- asn_debug.put_line(module||': '||message,log_level);
274: if (log_level = FND_LOG.LEVEL_STATEMENT and g_debug_stmt ) then
275: po_debug.debug_stmt(module,l_progress,message);
276:

Line 274: if (log_level = FND_LOG.LEVEL_STATEMENT and g_debug_stmt ) then

270: l_debug_on := TRUE;
271: END IF;
272: -- add to fnd_log_messages
273: -- asn_debug.put_line(module||': '||message,log_level);
274: if (log_level = FND_LOG.LEVEL_STATEMENT and g_debug_stmt ) then
275: po_debug.debug_stmt(module,l_progress,message);
276:
277: elsif (log_level = FND_LOG.LEVEL_UNEXPECTED and g_debug_unexp ) then
278: po_debug.debug_unexp(module,l_progress,message);

Line 277: elsif (log_level = FND_LOG.LEVEL_UNEXPECTED and g_debug_unexp ) then

273: -- asn_debug.put_line(module||': '||message,log_level);
274: if (log_level = FND_LOG.LEVEL_STATEMENT and g_debug_stmt ) then
275: po_debug.debug_stmt(module,l_progress,message);
276:
277: elsif (log_level = FND_LOG.LEVEL_UNEXPECTED and g_debug_unexp ) then
278: po_debug.debug_unexp(module,l_progress,message);
279:
280: elsif (l_debug_on and log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
281: FND_LOG.string(

Line 280: elsif (l_debug_on and log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

276:
277: elsif (log_level = FND_LOG.LEVEL_UNEXPECTED and g_debug_unexp ) then
278: po_debug.debug_unexp(module,l_progress,message);
279:
280: elsif (l_debug_on and log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
281: FND_LOG.string(
282: log_level
283: , module||'.'||l_progress
284: , message

Line 281: FND_LOG.string(

277: elsif (log_level = FND_LOG.LEVEL_UNEXPECTED and g_debug_unexp ) then
278: po_debug.debug_unexp(module,l_progress,message);
279:
280: elsif (l_debug_on and log_level >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
281: FND_LOG.string(
282: log_level
283: , module||'.'||l_progress
284: , message
285: );

Line 365: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

361: l_api_name CONSTANT varchar2(30) := 'set_rhi_table_status';
362: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
363: l_progress VARCHAR2(3) := '000';
364: BEGIN
365: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
366: , module => l_log_head
367: , message => 'Begin set_rhi_table_status'
368: );
369: -- bug 6000903

Line 411: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>

407: -- Added logic to overcome this problem. by using .exists() function.
408:
409: p_processable_rows_exist := 'N';
410: for i in 1..p_rti_rows.count loop
411: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>
412: l_log_head,message => 'p_rti_rows(i).processing_status_code :'||p_rti_rows(i).processing_status_code);
413: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>
414: l_log_head,message => 'p_rti_rows(i).header_interface_id :'||p_rti_rows(i).header_interface_id);
415:

Line 413: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>

409: p_processable_rows_exist := 'N';
410: for i in 1..p_rti_rows.count loop
411: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>
412: l_log_head,message => 'p_rti_rows(i).processing_status_code :'||p_rti_rows(i).processing_status_code);
413: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module =>
414: l_log_head,message => 'p_rti_rows(i).header_interface_id :'||p_rti_rows(i).header_interface_id);
415:
416: if ((p_rti_rows(i).processing_status_code = 'ERROR') AND
417: (p_rti_rows(i).header_interface_id is not null)) THEN

Line 419: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>

415:
416: if ((p_rti_rows(i).processing_status_code = 'ERROR') AND
417: (p_rti_rows(i).header_interface_id is not null)) THEN
418: if l_temp.exists(p_rti_rows(i).header_interface_id) THEN
419: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>
420: 'Setting ERROR l_temp(p_rti_rows(i).header_interface_id) :'||l_temp(p_rti_rows(i).header_interface_id));
421: if nvl(l_temp(p_rti_rows(i).header_interface_id),'ERROR') <> 'PENDING' then
422: l_temp(p_rti_rows(i).header_interface_id) := 'ERROR';
423: end if;

Line 425: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message => 'Setting ERROR l_temp header_interface_id ');

421: if nvl(l_temp(p_rti_rows(i).header_interface_id),'ERROR') <> 'PENDING' then
422: l_temp(p_rti_rows(i).header_interface_id) := 'ERROR';
423: end if;
424: ELSE
425: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message => 'Setting ERROR l_temp header_interface_id ');
426: l_temp(p_rti_rows(i).header_interface_id) := 'ERROR';
427: end if;
428:
429: -- do nothing for condition rti_processing_status_code = ERROR AND

Line 435: FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message => 'Setting Pending l_temp');

431: elsif ((p_rti_rows(i).processing_status_code <> 'ERROR') AND
432: (p_rti_rows(i).header_interface_id is not null)) then
433: l_temp(p_rti_rows(i).header_interface_id) := 'PENDING';
434: RCV_HXT_GRP.string( log_level =>
435: FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message => 'Setting Pending l_temp');
436: p_processable_rows_exist := 'Y';
437:
438: elsif ((p_rti_rows(i).processing_status_code <> 'ERROR') AND
439: (p_rti_rows(i).header_interface_id is null)) then

Line 446: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>

442: end loop;
443:
444: if p_rhi_rows.count > 0 then
445: for i in 1..p_rhi_rows.count loop
446: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>
447: 'Loop 2 p_rhi_rows.header_interface_id :'||p_rhi_rows(i).header_interface_id);
448: if l_temp.exists(p_rhi_rows(i).header_interface_id) THEN
449: if l_temp(p_rhi_rows(i).header_interface_id) = 'ERROR' THEN
450: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>

Line 450: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>

446: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>
447: 'Loop 2 p_rhi_rows.header_interface_id :'||p_rhi_rows(i).header_interface_id);
448: if l_temp.exists(p_rhi_rows(i).header_interface_id) THEN
449: if l_temp(p_rhi_rows(i).header_interface_id) = 'ERROR' THEN
450: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE,module => l_log_head,message =>
451: 'Loop 2 l_temp :'||l_temp(p_rhi_rows(i).header_interface_id));
452: p_rhi_rows(i).processing_status_code := 'ERROR';
453: end if;
454: end if;

Line 459: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

455: end loop;
456: end if;
457: EXCEPTION
458: WHEN OTHERS THEN
459: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
460: , module => l_log_head
461: , message => 'Unexpected exception in set_rhi_table_status ' || SQLERRM
462: );
463: RAISE;

Line 671: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

667: WHERE pol.po_line_id = p_po_line_id
668: AND poll.po_line_id = pol.po_line_id;
669: END IF;
670:
671: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
672: , module => G_LOG_MODULE
673: , message => 'after po_line_id ' ||g_po_line_cache(p_po_line_id).po_line_id||'**'
674: ||'po_header_id '||g_po_line_cache(p_po_line_id).po_header_id||'**'
675: ||'line_num '||g_po_line_cache(p_po_line_id).line_num||'**'

Line 747: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

743:
744: RETURN g_po_distribution_cache(p_po_line_id);
745: EXCEPTION
746: WHEN OTHERS THEN
747: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
748: , module => l_log_head
749: , message => 'Unexpected exception deriving po_distribution_id (po_line_id=' || p_po_line_id || ', project_id=' || p_project_id || ', task_id=' || p_task_id || '): ' || SQLERRM
750: );
751: RAISE DERIVE_DISTRIBUTION_ID_FAILED;

Line 931: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

927: ) RETURN rcv_transactions_cr IS
928: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
929: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
930: BEGIN
931: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
932: , module => l_log_head
933: , message => 'Finding Parent Transcations , TimeCard ID: ' || p_timecard_bb_id || ' Po line Id: ' || p_po_line_id
934: );
935: g_rcv_transactions_calls := g_rcv_transactions_calls + 1;

Line 954: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

950: AND receive.transaction_type = 'RECEIVE';
951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;
954: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
955: , module => l_log_head
956: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id
957: );
958:

Line 971: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

967: AND deliver.transaction_type = 'DELIVER';
968: EXCEPTION
969: WHEN NO_DATA_FOUND THEN
970: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;
971: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
972: , module => l_log_head
973: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id
974: );
975:

Line 991: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

987: ) RETURN rcv_transactions_cr IS
988: l_api_name CONSTANT varchar2(30) := 'get_rcv_transaction';
989: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
990: BEGIN
991: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
992: , module => l_log_head
993: , message => 'Finding Parent Transcations , TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id || ' po_distribution_id: ' || p_po_distribution_id
994: );
995: IF p_po_distribution_id IS NULL THEN

Line 1018: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1014: AND receive.transaction_type = 'RECEIVE';
1015: EXCEPTION
1016: WHEN NO_DATA_FOUND THEN
1017: g_rcv_transactions_cache(p_timecard_bb_id).receive_transaction_id := NULL;
1018: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1019: , module => l_log_head
1020: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id || ' po_distribution_id: ' || p_po_distribution_id
1021: );
1022: END;

Line 1034: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1030: AND deliver.transaction_type = 'DELIVER';
1031: EXCEPTION
1032: WHEN NO_DATA_FOUND THEN
1033: g_rcv_transactions_cache(p_timecard_bb_id).deliver_transaction_id := NULL;
1034: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1035: , module => l_log_head
1036: , message => 'Unable to find Parent Transcations ,TimeCard ID: ' || p_timecard_bb_id || ' po_line_id: ' || p_po_line_id || ' po_distribution_id: ' || p_po_distribution_id
1037: );
1038: END;

Line 1126: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1122: l_attribute_name HXC_MAPPING_COMPONENTS.field_name%TYPE;
1123: l_api_name CONSTANT varchar2(30) := 'Set_Attribute';
1124: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1125: BEGIN
1126: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1127: , module => l_log_head
1128: , message => 'Setting attribute ' || p_attribute_name || ' with value ' || p_attribute_value || ' (p_attribute_id=' || p_attribute_id || ')'
1129: );
1130:

Line 1170: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

1166: l_bb_id HXC_TIME_BUILDING_BLOCKS.time_building_block_id%TYPE;
1167: l_api_name CONSTANT varchar2(30) := 'Sort_Attributes';
1168: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1169: BEGIN
1170: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
1171: , module => l_log_head
1172: , message => 'Begin Sort_Attributes'
1173: );
1174:

Line 1183: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1179: IF NOT p_all_attributes.EXISTS(l_bb_id) THEN
1180: p_all_attributes(l_bb_id).detail_bb_id := l_bb_id;
1181: END IF;
1182:
1183: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1184: , module => l_log_head
1185: , message => 'Capturing attribute_id=' || p_raw_attributes(att_idx).time_attribute_id || ', attribute_name=' || p_raw_attributes(att_idx).attribute_name
1186: );
1187:

Line 1195: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

1191: , p_raw_attributes(att_idx).time_attribute_id
1192: );
1193: END LOOP;
1194:
1195: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
1196: , module => l_log_head
1197: , message => 'End Sort_Attributes'
1198: );
1199: END Sort_Attributes;

Line 1209: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

1205: l_api_name CONSTANT varchar2(30) := 'Update_Attributes';
1206: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1207: po_update_flag VARCHAR2(1) :='N'; --bug 6998132
1208: BEGIN
1209: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
1210: , module => l_log_head
1211: , message => 'Begin Update_Attributes'
1212: );
1213:

Line 1260: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1256: p_attributes.po_number := get_po_header(p_attributes.po_header_id).segment1;
1257: EXCEPTION
1258: WHEN OTHERS THEN
1259: -- unexpected exception deriving po header id
1260: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1261: , module => l_log_head
1262: , message => 'Unexpected exception deriving PO Header Id (PO Number=' || p_attributes.po_number || '): ' || SQLERRM
1263: );
1264: END;

Line 1276: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1272: p_attributes.po_line := get_po_line(p_attributes.po_line_id).line_num;
1273: EXCEPTION
1274: WHEN OTHERS THEN
1275: -- unexpected exception deriving po line id
1276: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1277: , module => l_log_head
1278: , message => 'Unexpected exception deriving PO Line Number (PO Header Id=' || p_attributes.po_header_id || ', PO Line Id=' || p_attributes.po_line_id || '): ' || SQLERRM
1279: );
1280: END;

Line 1294: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1290: p_attributes.po_price_type_display := get_price_type_lookup(p_attributes.po_price_type).meaning;
1291: EXCEPTION
1292: WHEN OTHERS THEN
1293: -- unexpected exception deriving price type
1294: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1295: , module => l_log_head
1296: , message => 'Unexpected exception deriving PO Price Type Display (PO Price Type=' || p_attributes.po_price_type || '): ' || SQLERRM
1297: );
1298: END;

Line 1313: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1309: p_attributes.po_billable_amount := p_attributes.detail_measure * get_price_differentials(p_attributes.po_line_id, p_attributes.po_price_type).price;
1310: EXCEPTION
1311: WHEN OTHERS THEN
1312: -- unexpected exception deriving PO Billable Amount
1313: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1314: , module => l_log_head
1315: , message => 'Unexpected exception deriving PO Billable Amount (PO Price Type=' || p_attributes.po_price_type || ', PO Line Id=' || p_attributes.po_line_id || '): ' || SQLERRM
1316: );
1317: END;

Line 1326: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

1322: -- can be determined much more easily at retrieval time, when it is clear whether
1323: -- the receiving transaction type is RECEIVE or CORRECT
1324: p_attributes.po_receipt_date := SYSDATE;
1325:
1326: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
1327: , module => l_log_head
1328: , message => 'End Update_Attributes'
1329: );
1330: END Update_Attributes;

Line 1425: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1421: l_include_closed_po := NVL (FND_PROFILE.value('RCV_CLOSED_PO_DEFAULT_OPTION'), 'N');
1422:
1423: /*bug 6902391 Changing to single org as in 11.5.10*/
1424:
1425: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1426: , module => l_log_head
1427: , message => 'TimeCard day_start_time ' || p_attributes.day_start_time || 'Timecard resource_id = '||p_attributes.resource_id
1428: );
1429:

Line 1430: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1426: , module => l_log_head
1427: , message => 'TimeCard day_start_time ' || p_attributes.day_start_time || 'Timecard resource_id = '||p_attributes.resource_id
1428: );
1429:
1430: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1431: , module => l_log_head
1432: , message => 'hr_organization_api.get_operating_unit = ' || hxc_timecard_properties.setup_mo_global_params(fnd_global.employee_id)
1433: );
1434:

Line 1442: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

1438: -- Condition removed as not required. After R12 MOAC. User can use Purchase
1439: -- Order Created in other Operating Unit.
1440: -- get_po_header(p_attributes.po_header_id).org_id <> FND_GLOBAL.org_id
1441: THEN
1442: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1443: , module => l_log_head
1444: , message => 'PO is invalid: ' || '*'
1445: || get_po_header(p_attributes.po_header_id).user_hold_flag || '*'
1446: );

Line 1463: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

1459: get_po_line(p_attributes.po_line_id).cancel_flag <> 'N' OR
1460: get_po_line(p_attributes.po_line_id).closed_code = 'FINALLY CLOSED' OR
1461: (l_include_closed_po <> 'Y' AND get_po_line(p_attributes.po_line_id).closed_code IN ('CLOSED','CLOSED FOR RECEIVING'))
1462: THEN
1463: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1464: , module => l_log_head
1465: , message => 'Line is invalid: ' || '*'
1466: || get_po_line(p_attributes.po_line_id).matching_basis || '*'
1467: || get_po_line(p_attributes.po_line_id).purchase_basis || '*'

Line 1662: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

1658: -- be careful if moving this block of code
1659: g_po_line_cache(p_attributes.po_line_id).timecard_amount := get_po_line(p_attributes.po_line_id).timecard_amount + p_attributes.po_billable_amount;
1660: g_po_line_cache(p_attributes.po_line_id).time_attribute_id := NVL(get_po_line(p_attributes.po_line_id).time_attribute_id, p_attributes.time_attribute_id);
1661:
1662: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1663: , module => l_log_head
1664: , message => 'Amount for PO Line Id ' || p_attributes.po_line_id || ' updated to ' || get_po_line(p_attributes.po_line_id).timecard_amount
1665: );
1666: END IF;

Line 1798: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1794: BEGIN
1795: l_po_line_id := g_po_line_cache.FIRST;
1796: WHILE l_po_line_id IS NOT NULL LOOP
1797: BEGIN
1798: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1799: , module => l_log_head
1800: , message => 'Validating amount tolerance for PO Line Id=' || l_po_line_id || ' (Billable Amount=' || get_po_line(l_po_line_id).timecard_amount || ')'
1801: );
1802:

Line 1808: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1804: -- do not consider the received amounts because that is already included in the timecard amount below
1805: l_qty_rcv_exception_code := get_po_line(l_po_line_id).qty_rcv_exception_code;
1806: l_tolerable_amount := get_po_line(l_po_line_id).tolerable_amount;
1807:
1808: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1809: , module => l_log_head
1810: , message => 'Fetched Tolerable Amount=' || l_tolerable_amount || ', Receiving Tolerance Exception Code=' || l_qty_rcv_exception_code || ' (PO Line Id=' || l_po_line_id || ')'
1811: );
1812:

Line 1829: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1825: IF l_timecard_amount_sum IS NULL THEN
1826: l_timecard_amount_sum := 0;
1827: END IF;
1828:
1829: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1830: , module => l_log_head
1831: , message => 'Fetched Timecard Amount Sum=' || l_timecard_amount_sum || ' (PO Line Id=' || l_po_line_id || ')'
1832: );
1833:

Line 1863: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

1859:
1860: l_po_line_id := g_po_line_cache.NEXT(l_po_line_id);
1861: EXCEPTION
1862: WHEN GET_TIMECARD_AMOUNT_FAILED THEN
1863: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
1864: , module => l_log_head
1865: , message => 'PO_HXC_INTERFACE_PVT.get_timecard_amount returned error'
1866: );
1867:

Line 1883: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1879: END;
1880: END LOOP;
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1884: , module => l_log_head
1885: , message => 'Unexpected exception validating amount tolerances: ' || SQLERRM
1886: );
1887:

Line 1916: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

1912: BEGIN
1913: p_rti_row.job_id := get_po_line(p_attributes.po_line_id).job_id;
1914: EXCEPTION
1915: WHEN OTHERS THEN
1916: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
1917: , module => l_log_head
1918: , message => 'Unexpected exception deriving job_id (po_line_id=' || p_attributes.po_line_id || '): ' || SQLERRM
1919: );
1920: RAISE DERIVE_JOB_ID_FAILED;

Line 1971: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

1967: l_rti_row_idx BINARY_INTEGER;
1968: l_api_name CONSTANT varchar2(30) := 'Derive_Receive_Values';
1969: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
1970: BEGIN
1971: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
1972: , module => l_log_head
1973: , message => 'Begin Derive_Receive_Values'
1974: );
1975:

Line 1980: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

1976: -- check for existing rhi row
1977: l_rhi_row_idx := get_rhi_idx( p_attributes, p_rhi_rows, p_rti_rows );
1978: IF l_rhi_row_idx IS NOT NULL THEN
1979: -- found a match
1980: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
1981: , module => l_log_head
1982: , message => 'Using existing RHI row'
1983: );
1984:

Line 2025: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2021: -- check for existing rti row
2022: l_rti_row_idx := get_rti_idx( p_attributes, p_rti_rows );
2023: IF l_rti_row_idx IS NOT NULL THEN
2024: -- found a match
2025: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2026: , module => l_log_head
2027: , message => 'Using existing RTI row'
2028: );
2029:

Line 2039: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2035: trunc(p_attributes.detail_start_time) > l_rti_row.transaction_date
2036: THEN
2037: l_rti_row.transaction_date := trunc(p_attributes.detail_start_time);
2038:
2039: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2040: , module => l_log_head
2041: , message => 'Updated transaction_date=' || l_rti_row.transaction_date
2042: );
2043: END IF;

Line 2068: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2064:
2065: -- associate the rti rows to the building block
2066: p_attributes.receive_rti_id := l_rti_row.interface_transaction_id;
2067:
2068: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2069: , module => l_log_head
2070: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id
2071: );
2072: ELSE -- found existing rti row

Line 2086: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2082: Derive_Common_RTI_Values( l_rti_row
2083: , p_attributes
2084: );
2085:
2086: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2087: , module => l_log_head
2088: , message => 'Set po_distribution_id=' || l_rti_row.po_distribution_id
2089: );
2090:

Line 2102: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2098: ELSE
2099: l_rti_row.transaction_date := trunc(p_attributes.detail_start_time);
2100: END IF;
2101:
2102: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2103: , module => l_log_head
2104: , message => 'Initialized transaction_date=' || l_rti_row.transaction_date
2105: );
2106:

Line 2110: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2106:
2107: -- amount received
2108: l_rti_row.amount := p_attributes.po_billable_amount;
2109:
2110: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2111: , module => l_log_head
2112: , message => 'Set amount=' || l_rti_row.amount || ' from ' || p_attributes.po_billable_amount
2113: );
2114:

Line 2131: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2127:
2128: -- associate the rti rows to the building block
2129: p_attributes.receive_rti_id := l_rti_row.interface_transaction_id;
2130:
2131: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2132: , module => l_log_head
2133: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id
2134: );
2135: END IF; -- found existing rti row

Line 2141: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2137: -- copy data back to the main tables
2138: p_rhi_rows(l_rhi_row_idx) := l_rhi_row;
2139: p_rti_rows(l_rti_row_idx) := l_rti_row;
2140:
2141: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2142: , module => l_log_head
2143: , message => 'End Derive_Receive_Values'
2144: );
2145: END Derive_Receive_Values;

Line 2162: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2158: l_rti_row_idx BINARY_INTEGER;
2159: l_api_name CONSTANT varchar2(30) := 'Derive_Correction_Values';
2160: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2161: BEGIN
2162: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2163: , module => l_log_head
2164: , message => 'Begin Derive_Correction_Values'
2165: );
2166:

Line 2171: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2167: -- determine the correction amount
2168: l_correction_amount := p_attributes.po_billable_amount
2169: - p_old_attributes.po_billable_amount;
2170:
2171: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2172: , module => l_log_head
2173: , message => 'Derived correction amount=' || l_correction_amount
2174: );
2175:

Line 2180: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2176: -- check if we already have this correction so we can just add the amount to it
2177: l_rti_row_idx := get_rti_idx( p_attributes, p_rti_rows );
2178: IF l_rti_row_idx IS NOT NULL THEN
2179: -- found a match
2180: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2181: , module => l_log_head
2182: , message => 'Using existing RTI rows'
2183: );
2184:

Line 2215: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2211: -- This means that one is a positive correction and the other is a negative correction.
2212: -- If this happens we need to swap the order of the correction records, because for
2213: -- negative correction the correction record for deliver xaction should go first and
2214: -- for positive correction the correction record for receipt xaction should go first.
2215: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2216: , module => l_log_head
2217: , message => 'sign(l_correction_amount)=' ||sign(l_correction_amount) || ',sign(l_old_correction_amount) ' || sign(l_old_correction_amount)||',hence swap'
2218: );
2219: l_swap:= p_rti_rows(l_rti_row_idx).interface_transaction_id;

Line 2262: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2258: p_attributes.deliver_rti_id := p_rti_rows(l_rti_row_idx).interface_transaction_id;
2259: END IF;
2260: END IF;
2261:
2262: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2263: , module => l_log_head
2264: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id || ', deliver_rti_id=' || p_attributes.deliver_rti_id
2265: );
2266: ELSE -- found existing rti rows

Line 2268: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2264: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id || ', deliver_rti_id=' || p_attributes.deliver_rti_id
2265: );
2266: ELSE -- found existing rti rows
2267: -- did not find any match, let's create a new transaction
2268: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2269: , module => l_log_head
2270: , message => 'Creating new RTI rows'
2271: );
2272:

Line 2291: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2287: ELSE
2288: l_rcv_rti_row.transaction_date := trunc(SYSDATE);
2289: END IF;
2290:
2291: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2292: , module => l_log_head
2293: , message => 'Initialized transaction_date=' || l_rcv_rti_row.transaction_date
2294: );
2295:

Line 2345: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2341: -- associate the rti rows to the building block
2342: p_attributes.receive_rti_id := l_rcv_rti_row.interface_transaction_id;
2343: p_attributes.deliver_rti_id := l_del_rti_row.interface_transaction_id;
2344:
2345: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2346: , module => l_log_head
2347: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id || ', deliver_rti_id=' || p_attributes.deliver_rti_id
2348: );
2349: END IF; -- found existing rti rows

Line 2351: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2347: , message => 'Set receive_rti_id=' || p_attributes.receive_rti_id || ', deliver_rti_id=' || p_attributes.deliver_rti_id
2348: );
2349: END IF; -- found existing rti rows
2350:
2351: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2352: , module => l_log_head
2353: , message => 'End Derive_Correction_Values'
2354: );
2355: END Derive_Correction_Values;

Line 2369: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2365: l_new_attributes TimecardAttributesRec;
2366: l_api_name CONSTANT varchar2(30) := 'Derive_Delete_Values';
2367: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2368: BEGIN
2369: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2370: , module => l_log_head
2371: , message => 'Begin Derive_Delete_Values'
2372: );
2373:

Line 2394: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2390: -- derive_correction_values only sets the rti-bb relationship in the new attributes
2391: p_attributes.receive_rti_id := l_new_attributes.receive_rti_id;
2392: p_attributes.deliver_rti_id := l_new_attributes.deliver_rti_id;
2393:
2394: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2395: , module => l_log_head
2396: , message => 'End Derive_Delete_Values'
2397: );
2398: END Derive_Delete_Values;

Line 2409: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2405: ) IS
2406: l_api_name CONSTANT varchar2(30) := 'Derive_New_Block_Values';
2407: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2408: BEGIN
2409: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2410: , module => l_log_head
2411: , message => 'Begin Derive_New_Block_Values'
2412: );
2413:

Line 2443: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2439: -- save the transaction type
2440: p_attributes.transaction_type := 'RECEIVE';
2441: END IF;
2442:
2443: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2444: , module => l_log_head
2445: , message => 'End Derive_New_Block_Values'
2446: );
2447: END Derive_New_Block_Values;

Line 2460: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2456: l_api_name CONSTANT varchar2(30) := 'Derive_Interface_Values';
2457: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2458: l_progress VARCHAR2(3) := '000';
2459: BEGIN
2460: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2461: , module => l_log_head
2462: , message => 'Begin Derive_Interface_Values'
2463: );
2464:

Line 2474: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2470:
2471: p_old_attributes.lpn_group_id := p_attributes.lpn_group_id;
2472: EXCEPTION
2473: WHEN OTHERS THEN
2474: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2475: , module => l_log_head
2476: , message => 'Unexpected exception setting lpn_group_id: ' || SQLERRM
2477: );
2478: RAISE DERIVE_ROI_VALUES_FAILED;

Line 2495: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2491: p_old_attributes.parent_receive_txn_id := p_attributes.parent_receive_txn_id;
2492: p_old_attributes.parent_deliver_txn_id := p_attributes.parent_deliver_txn_id;
2493: EXCEPTION
2494: WHEN OTHERS THEN
2495: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2496: , module => l_log_head
2497: , message => 'Unexpected exception querying for parent transactions in Derive_Interface_Values (po_line_id=' || p_attributes.po_line_id || ', timecard_bb_id=' || p_attributes.timecard_bb_id || '): ' || SQLERRM
2498: );
2499: RAISE DERIVE_ROI_VALUES_FAILED;

Line 2514: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2510:
2511: -- if the user changed po information we need to correct
2512: -- the old receipt to zero and either create a new receipt
2513: -- or correct an existing one
2514: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2515: , module => l_log_head
2516: , message => 'Correction : Either PO Line OR Project/Task information changed '
2517: );
2518: -- in this case the old block does not have the same parents

Line 2531: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2527: p_old_attributes.parent_receive_txn_id := get_rcv_transaction(p_old_attributes.timecard_bb_id, p_old_attributes.po_line_id, p_old_attributes.po_distribution_id).receive_transaction_id;
2528: p_old_attributes.parent_deliver_txn_id := get_rcv_transaction(p_old_attributes.timecard_bb_id, p_old_attributes.po_line_id, p_old_attributes.po_distribution_id).deliver_transaction_id;
2529: EXCEPTION
2530: WHEN OTHERS THEN
2531: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2532: , module => l_log_head
2533: , message => 'Unexpected exception querying for parent transactions for the old block in Derive_Interface_Values ('
2534: || 'po_line_id=' || p_old_attributes.po_line_id
2535: || ', timecard_bb_id=' || p_old_attributes.timecard_bb_id

Line 2565: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2561: -- save the transaction type
2562: p_attributes.transaction_type := 'DELETE ' || p_attributes.transaction_type;
2563:
2564: ELSE -- po line changed
2565: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2566: , module => l_log_head
2567: , message => 'Correction : Either Rate type or the hours worked changed '
2568: );
2569: -- if the user only changed the rate type or the hours worked

Line 2598: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

2594: p_attributes.transaction_type := 'CORRECT';
2595: END IF;
2596: END IF; -- po line changed
2597: ELSE -- detail_changed
2598: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
2599: , module => l_log_head
2600: , message => 'Receive : Block is newly created.'
2601: );
2602: Derive_New_Block_Values( p_rhi_rows

Line 2608: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2604: , p_attributes
2605: );
2606: END IF; -- detail_changed
2607:
2608: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2609: , module => l_log_head
2610: , message => 'Done deriving ROI values. Calling iSP to store timecard detail information...'
2611: );
2612:

Line 2624: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2620: l_rti_idx BINARY_INTEGER;
2621: l_rhi_row rcv_headers_interface%ROWTYPE;
2622: l_rti_row rcv_transactions_interface%ROWTYPE;
2623: BEGIN
2624: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2625: , module => l_log_head
2626: , message => 'Finding ROI rows: p_rhi_rows.COUNT=' || p_rhi_rows.COUNT || ' p_rti_rows.COUNT=' || p_rti_rows.COUNT || ' p_attributes.po_distribution_id=' || p_attributes.po_distribution_id
2627: );
2628:

Line 2631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2627: );
2628:
2629: l_rhi_idx := get_rhi_idx(p_attributes, p_rhi_rows, p_rti_rows);
2630: IF l_rhi_idx IS NOT NULL THEN
2631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2632: , module => l_log_head
2633: , message => 'rhi_idx=' || l_rhi_idx
2634: );
2635: l_rhi_row := p_rhi_rows(l_rhi_idx);

Line 2639: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2635: l_rhi_row := p_rhi_rows(l_rhi_idx);
2636: END IF;
2637:
2638: l_rti_idx := get_rti_idx(p_attributes, p_rti_rows);
2639: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2640: , module => l_log_head
2641: , message => 'rti_idx=' || l_rti_idx
2642: );
2643: l_rti_row := p_rti_rows(l_rti_idx);

Line 2645: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2641: , message => 'rti_idx=' || l_rti_idx
2642: );
2643: l_rti_row := p_rti_rows(l_rti_idx);
2644:
2645: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2646: , module => l_log_head
2647: , message => 'Setting p_action for store_timecard_details'
2648: );
2649:

Line 2660: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2656: ELSE
2657: l_action := 'INSERT';
2658: END IF;
2659:
2660: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2661: , module => l_log_head
2662: , message => 'p_action=' || l_action
2663: );
2664:

Line 2697: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2693: , p_action => l_action
2694: , p_interface_transaction_id => l_rti_row.interface_transaction_id
2695: );
2696:
2697: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2698: , module => l_log_head
2699: , message => 'After store_timecard_details'
2700: );
2701:

Line 2707: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

2703: RAISE ISP_STORE_TIMECARD_FAILED;
2704: END IF;
2705: EXCEPTION
2706: WHEN ISP_STORE_TIMECARD_FAILED THEN
2707: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
2708: , module => l_log_head
2709: , message => 'iSP store_timecard_details failed: x_return_status=' || l_return_status || ', x_msg_data=' || l_msg_data
2710: );
2711: RAISE DERIVE_ROI_VALUES_FAILED;

Line 2713: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

2709: , message => 'iSP store_timecard_details failed: x_return_status=' || l_return_status || ', x_msg_data=' || l_msg_data
2710: );
2711: RAISE DERIVE_ROI_VALUES_FAILED;
2712: WHEN OTHERS THEN
2713: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
2714: , module => l_log_head
2715: , message => 'Exception trying to call iSP store_timecard_details: x_return_status=' || l_return_status || ', x_msg_data=' || l_msg_data || ', sqlerrm=' || sqlerrm
2716: );
2717: RAISE DERIVE_ROI_VALUES_FAILED;

Line 2720: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2716: );
2717: RAISE DERIVE_ROI_VALUES_FAILED;
2718: END; -- end of isp integration
2719:
2720: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2721: , module => l_log_head
2722: , message => 'End Derive_Interface_Values'
2723: );
2724: EXCEPTION

Line 2861: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

2857: l_api_name CONSTANT varchar2(30) := 'Insert_Interface_Values';
2858: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
2859: BEGIN
2860: -- save new ROI data to the database
2861: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
2862: , module => l_log_head
2863: , message => 'Begin Insert_Interface_Values'
2864: );
2865:

Line 2866: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2862: , module => l_log_head
2863: , message => 'Begin Insert_Interface_Values'
2864: );
2865:
2866: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2867: , module => l_log_head
2868: , message => 'RHI rows: ' || p_rhi_rows.COUNT || ' RTI rows: '
2869: || p_rti_rows.COUNT
2870: );

Line 2872: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2868: , message => 'RHI rows: ' || p_rhi_rows.COUNT || ' RTI rows: '
2869: || p_rti_rows.COUNT
2870: );
2871:
2872: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2873: , module => l_log_head
2874: , message => 'Coping the RHI Records to Local PL/SQL tables'
2875: );
2876: -- transfer data from table of records to tables of each column

Line 2907: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2903: -- also in error.
2904: p_rhi_rows(i).processing_status_code := 'ERROR';
2905: l_rhi_stat(p_rhi_rows(i).header_interface_id) := 'ERROR';
2906: row_idx := row_idx - 1;
2907: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2908: , module => l_log_head
2909: , message => 'Exception while populating RHI plsql table ' ||
2910: p_rhi_rows(i).header_interface_id
2911: || ' Error '||SQLERRM

Line 2917: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2913: END;
2914: END IF;
2915: END LOOP;
2916:
2917: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2918: , module => l_log_head
2919: , message => 'Inserting ' || rhi_header_interface_id.COUNT || ' rows into RHI'
2920: );
2921:

Line 2962: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2958: );
2959:
2960: -- transfer data from table of records to tables of each column
2961:
2962: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2963: , module => l_log_head
2964: , message => 'Inserted ' || rhi_header_interface_id.COUNT || ' rows into RHI'
2965: );
2966:

Line 2968: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

2964: , message => 'Inserted ' || rhi_header_interface_id.COUNT || ' rows into RHI'
2965: );
2966:
2967: -- bug 6031665
2968: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
2969: , module => l_log_head
2970: , message => 'Copying the RTI Records to Local PL/SQL tables'
2971: );
2972: FOR i IN 1..p_rti_rows.COUNT LOOP

Line 3028: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3024: -- from RTI record.
3025:
3026: row_idx := row_idx - 1;
3027: p_rti_rows(i).processing_status_code := 'ERROR';
3028: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3029: , module => l_log_head
3030: , message => 'Exception while populating RTI plsql table. Interface transaction id :'
3031: || p_rti_rows(i).interface_transaction_id ||
3032: ' Time card id : '||p_rti_rows(i).timecard_id|| ' Error '||SQLERRM

Line 3050: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3046: p_rti_status(p_rti_rows(i).interface_transaction_id) := 1;
3047: ELSE
3048: -- No Need to decrease the Counter here as we didnt increased.
3049: p_rti_rows(i).processing_status_code := 'ERROR';
3050: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3051: , module => l_log_head
3052: , message => 'Exception while propogating fake success. Interface transaction id is NULL:'
3053: ||' Time card id : '||p_rti_rows(i).timecard_id|| ' Error '||SQLERRM
3054: );

Line 3058: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3054: );
3055: END IF;*/
3056: END IF;
3057: END LOOP;
3058: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3059: , module => l_log_head
3060: , message => 'Inserting '|| rti_interface_transaction_id.COUNT || ' rows into RHI'
3061: );
3062:

Line 3129: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3125: );
3126:
3127: COMMIT;
3128:
3129: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3130: , module => l_log_head
3131: , message => 'Inserted ' || rti_interface_transaction_id.COUNT || ' rows into RTI'
3132: );
3133:

Line 3134: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3130: , module => l_log_head
3131: , message => 'Inserted ' || rti_interface_transaction_id.COUNT || ' rows into RTI'
3132: );
3133:
3134: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3135: , module => l_log_head
3136: , message => 'End Insert_Interface_Values'
3137: );
3138: END Insert_Interface_Values;

Line 3150: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3146: l_api_name CONSTANT varchar2(30) := 'Capture_Timecard_Info';
3147: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
3148: l_progress varchar2(3) := '000';
3149: BEGIN
3150: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3151: , module => l_log_head
3152: , message => 'Begin Capture_Timecard_Info'
3153: );
3154:

Line 3155: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3151: , module => l_log_head
3152: , message => 'Begin Capture_Timecard_Info'
3153: );
3154:
3155: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3156: , module => l_log_head
3157: , message => 'Capturing info from block record for detail bb_id=' || p_block.bb_id || ' ovn=' || p_block.ovn
3158: );
3159:

Line 3176: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3172: p_dst_attributes.timecard_bb_ovn := p_block.timecard_ovn;
3173: p_dst_attributes.timecard_comment := p_block.comment_text;
3174:
3175: -- add timecard info
3176: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3177: , module => l_log_head
3178: , message => 'Deriving timecard info for timecard bb_id=' || p_dst_attributes.timecard_bb_id || ' ovn=' || p_dst_attributes.timecard_bb_ovn
3179: );
3180:

Line 3205: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3201: p_dst_attributes.timecard_approval_status);
3202: END IF;
3203: END;
3204:
3205: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3206: , module => l_log_head
3207: , message => 'Capturing info from attribute records for detail bb_id=' || p_dst_attributes.detail_bb_id || ' ovn=' || p_dst_attributes.detail_bb_ovn
3208: );
3209:

Line 3219: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3215: );
3216: p_att_idx := p_att_idx + 1;
3217: END LOOP;
3218:
3219: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3220: , module => l_log_head
3221: , message => 'End Capture_Timecard_Info'
3222: );
3223: END Capture_Timecard_Info;

Line 3234: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3230: ) IS
3231: l_api_name CONSTANT varchar2(30) := 'Capture_Old_Timecard_Info';
3232: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
3233: BEGIN
3234: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3235: , module => l_log_head
3236: , message => 'Begin Capture_Old_Timecard_Info'
3237: );
3238:

Line 3239: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3235: , module => l_log_head
3236: , message => 'Begin Capture_Old_Timecard_Info'
3237: );
3238:
3239: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3240: , module => l_log_head
3241: , message => 'Capturing info from block record for old detail bb_id=' || p_block.bb_id || ' ovn=' || p_block.ovn
3242: );
3243:

Line 3258: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3254: p_dst_attributes.detail_stop_time := p_block.stop_time;
3255: p_dst_attributes.detail_measure := p_block.measure;
3256: p_dst_attributes.resource_id := p_block.resource_id;
3257:
3258: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3259: , module => l_log_head
3260: , message => 'Deriving day/timecard info for old detail bb_id=' || p_dst_attributes.detail_bb_id || ' ovn=' || p_dst_attributes.detail_bb_ovn
3261: );
3262:

Line 3279: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3275: p_dst_attributes.day_bb_id := l_day_block.time_building_block_id;
3276: p_dst_attributes.timecard_bb_id := l_day_block.parent_building_block_id;
3277: p_dst_attributes.timecard_bb_ovn := l_day_block.parent_building_block_ovn;
3278:
3279: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3280: , module => l_log_head
3281: , message => 'Derived for old detail block: day_bb_id=' || p_dst_attributes.day_bb_id || ', timecard_bb_id=' || p_dst_attributes.timecard_bb_id || ', timecard_bb_ovn=' || p_dst_attributes.timecard_bb_ovn
3282: );
3283: END;

Line 3285: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3281: , message => 'Derived for old detail block: day_bb_id=' || p_dst_attributes.day_bb_id || ', timecard_bb_id=' || p_dst_attributes.timecard_bb_id || ', timecard_bb_ovn=' || p_dst_attributes.timecard_bb_ovn
3282: );
3283: END;
3284:
3285: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3286: , module => l_log_head
3287: , message => 'Capturing info from attribute records for old detail bb_id=' || p_dst_attributes.detail_bb_id || ' ovn=' || p_dst_attributes.detail_bb_ovn
3288: );
3289:

Line 3300: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3296:
3297: p_att_idx := p_att_idx + 1;
3298: END LOOP;
3299:
3300: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3301: , module => l_log_head
3302: , message => 'End Capture_Old_Timecard_Info'
3303: );
3304: END Capture_Old_Timecard_Info;

Line 3316: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3312: l_log_head CONSTANT VARCHAR2(100) := G_LOG_MODULE || '.'||l_api_name;
3313: l_block HXC_USER_TYPE_DEFINITION_GRP.building_block_info;
3314: l_attributes HXC_USER_TYPE_DEFINITION_GRP.attribute_info;
3315: BEGIN
3316: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3317: , module => l_log_head
3318: , message => 'Querying bb_id=' || p_bb_id || ' bb_ovn=' || p_bb_ovn
3319: );
3320:

Line 3337: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3333: p_attributes_rec.detail_date_from := l_block.date_from;
3334: p_attributes_rec.detail_date_to := l_block.date_to;
3335:
3336: -- manually pull up attributes
3337: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3338: , module => l_log_head
3339: , message => 'Querying timecard attributes'
3340: );
3341:

Line 3356: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

3352: p_attributes_rec.po_price_type_display := l_attributes.attribute7;
3353: p_attributes_rec.po_header_id := l_attributes.attribute8;
3354: EXCEPTION
3355: WHEN OTHERS THEN
3356: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3357: , module => l_log_head
3358: , message => 'Unexpected exception in Query_Timecard_Info (bb_id=' || p_bb_id || ', bb_ovn=' || p_bb_ovn || '): ' || SQLERRM
3359: );
3360: RAISE;

Line 3418: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

3414: -- and get the Details blocks for the same timecards which are processed and make them
3415: -- with errors.
3416: l_exp_idx BINARY_INTEGER;
3417: BEGIN
3418: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3419: , module => l_log_head
3420: , message => 'Begin Retrieve_Timecards_Body'
3421: );
3422: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

Line 3422: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3418: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
3419: , module => l_log_head
3420: , message => 'Begin Retrieve_Timecards_Body'
3421: );
3422: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3423: , module => l_log_head
3424: , message => 'last_blk_idx=' || last_blk_idx || ' last_old_blk_idx=' || last_old_blk_idx || ' last_att_idx=' || last_att_idx || ' last_old att_idx=' || last_old_att_idx
3425: );
3426:

Line 3450: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3446: --
3447: -- Need to Verified this message is stored in local variable
3448: -- which might not get into OTL in Retrieval Program Crash...
3449: g_txn_msg := 'Stage 01 - ISP Reconcile Action is been called for First Time';
3450: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3451: , module => l_log_head
3452: , message => 'Calling iSP to reconcile actions'
3453: );
3454:

Line 3460: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3456: , x_return_status => l_return_status
3457: , x_msg_data => l_msg_data
3458: );
3459:
3460: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3461: , module => l_log_head
3462: , message => 'Done with iSP reconcile actions'
3463: );
3464:

Line 3470: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

3466: RAISE ISP_RECONCILE_ACTIONS_FAILED;
3467: END IF;
3468: EXCEPTION
3469: WHEN ISP_RECONCILE_ACTIONS_FAILED THEN
3470: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
3471: ,module=>l_log_head
3472: , message => 'iSP reconcile actions failed: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data
3473: );
3474: RAISE;

Line 3476: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

3472: , message => 'iSP reconcile actions failed: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data
3473: );
3474: RAISE;
3475: WHEN OTHERS THEN
3476: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3477: , module => l_log_head
3478: , message => 'Unexpected exception while calling iSP reconcile actions: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data || ' sqlerrm=' || SQLERRM
3479: );
3480: RAISE ISP_RECONCILE_ACTIONS_FAILED;

Line 3483: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3479: );
3480: RAISE ISP_RECONCILE_ACTIONS_FAILED;
3481: END;
3482:
3483: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3484: , module => l_log_head
3485: , message => 'Starting main loop through detail building blocks...'
3486: );
3487:

Line 3492: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3488: -- loop through the detail building blocks
3489: g_txn_msg := 'Stage 02 - Start Processing the Blocks one by one before inserting in ROI';
3490: WHILE blk_idx <= last_blk_idx LOOP
3491: BEGIN
3492: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3493: , module => l_log_head
3494: , message => '|------------------ blk_idx = ' || blk_idx || ' ------------------|'
3495: );
3496: --Bug6357273

Line 3566: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3562:
3563: -- maintain the old block index
3564: old_blk_idx := old_blk_idx + 1;
3565: END IF;
3566: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3567: , module => l_log_head
3568: , message => 'fill the po_distribution_id and line_location_id for NEW attributes'
3569: );
3570: --Bug6357273

Line 3592: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3588: -- only and the rti does not contain the dist, shipment_id values.
3589: -- Hence get_rti_idx fails in case of a po-projects OTL setup, since in this case we use distribution_id
3590: -- to get the rti_idx, before calling PO_STORE_TIMECARD_PKG_GRP.store_timecard_details
3591: IF p_blocks(blk_idx).changed = 'Y' THEN
3592: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3593: , module => l_log_head
3594: , message => 'fill the po_distribution_id and line_location_id for old attributes'
3595: );
3596: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := 'PO-90- Get the PO line for Old block - Start';

Line 3631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

3627: -- Status message for that block.
3628: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'ERRORS';
3629: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3630: || 'Unexpected exception while processing results from Generic Retrieval: ' || SQLERRM;
3631: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3632: , module => l_log_head
3633: , message =>HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3634: );
3635:

Line 3683: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3679: l_processable_rows_exist := 'N';
3680: g_txn_msg := 'Stage 03 - Done with Capture TimeCard Block Process, going to insert valid one to Receiving interface table';
3681: set_rhi_table_status(l_rhi_rows, l_rti_rows,l_processable_rows_exist);
3682:
3683: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3684: , module => l_log_head
3685: , message => 'l_processable_rows_exist' || l_processable_rows_exist
3686: );
3687:

Line 3715: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3711: l_outcome VARCHAR2(240);
3712:
3713: RVCTP_FAILED EXCEPTION;
3714: BEGIN
3715: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3716: , module => l_log_head
3717: , message => 'Calling Receiving Transaction Processor with group_id=' || g_group_id
3718: );
3719:

Line 3730: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

3726: , argument2 => g_group_id
3727: );
3728:
3729: IF (g_req_id = 0) THEN
3730: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
3731: , module => l_log_head
3732: , message => 'Concurrent request submission failed'
3733: );
3734:

Line 3740: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3736: ELSE
3737: COMMIT;
3738: END IF;
3739:
3740: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3741: , module => l_log_head
3742: , message => 'Request ID for RVCTP: ' || TO_CHAR(g_req_id)
3743: );
3744:

Line 3758: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3754:
3755: g_receiving_stop := SYSDATE;
3756: g_receiving_time := g_receiving_time + ( g_receiving_stop - g_receiving_start );
3757:
3758: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3759: , module => l_log_head
3760: , message => 'RVCTP done: ' || '*' || l_phase || '*' || l_status || '*' || l_dev_phase || '*' || l_dev_status || '*' || l_message || '*'
3761: );
3762:

Line 3764: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

3760: , message => 'RVCTP done: ' || '*' || l_phase || '*' || l_status || '*' || l_dev_phase || '*' || l_dev_status || '*' || l_message || '*'
3761: );
3762:
3763: IF NOT l_success THEN
3764: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
3765: , module => l_log_head
3766: , message => 'Receiving Transaction Processor returned false.'
3767: );
3768:

Line 3787: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

3783:
3784: COMMIT;
3785:
3786: WHEN OTHERS THEN
3787: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
3788: , module => l_log_head
3789: , message => 'Exception trying to run Receiving Transaction Processor: ' || SQLERRM
3790: );
3791: RAISE TRANSACTION_FAILED;

Line 3795: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3791: RAISE TRANSACTION_FAILED;
3792: END;
3793: END IF;
3794:
3795: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3796: , module => l_log_head
3797: , message => 'Finding successful receiving transactions'
3798: );
3799: g_txn_msg := 'Stage 04 - RTP is Sucess, Looping through RCV Transaction for Getting Success Records.';

Line 3803: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3799: g_txn_msg := 'Stage 04 - RTP is Sucess, Looping through RCV Transaction for Getting Success Records.';
3800:
3801: -- get the successful transactions we just created
3802: FOR l_rt_row IN new_rt_rows( l_rti_rows(1).group_id ) LOOP
3803: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3804: , module => l_log_head
3805: , message => 'Successful RTI id ' || l_rt_row.interface_transaction_id
3806: );
3807: l_rti_status(l_rt_row.interface_transaction_id) := 1;

Line 3810: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3806: );
3807: l_rti_status(l_rt_row.interface_transaction_id) := 1;
3808: END LOOP;
3809:
3810: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3811: , module => l_log_head
3812: , message => 'Setting Detail Statuses'
3813: );
3814:

Line 3817: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3813: );
3814:
3815: -- update detail statuses
3816: FOR blk_idx IN 1..last_blk_idx LOOP
3817: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3818: , module => l_log_head
3819: , message => 'Setting Detail Status for blk_idx=' || blk_idx || ' bb_id=' || p_blocks(blk_idx).bb_id
3820: );
3821:

Line 3832: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3828: l_delete_deliver_rti_id RCV_TRANSACTIONS_INTERFACE.interface_transaction_id%TYPE;
3829: l_message VARCHAR2(1000);
3830: DETAIL_NOT_PROCESSED EXCEPTION;
3831: BEGIN
3832: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3833: , module => l_log_head
3834: , message => 'Finding RTI ids'
3835: );
3836:

Line 3849: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3845: l_deliver_rti_id := l_all_attributes(l_bb_id).deliver_rti_id;
3846: l_delete_receive_rti_id := l_all_attributes(l_bb_id).delete_receive_rti_id;
3847: l_delete_deliver_rti_id := l_all_attributes(l_bb_id).delete_deliver_rti_id;
3848:
3849: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3850: , module => l_log_head
3851: , message => 'Found bb_id=' || l_bb_id
3852: || ' transaction_type=' || l_transaction_type
3853: || ' receive_rti_id=' || l_receive_rti_id

Line 3880: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3876:
3877: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_status(blk_idx) := 'SUCCESS';
3878: g_successful_details := g_successful_details + 1;
3879:
3880: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3881: , module => l_log_head
3882: , message => 'Detail success'
3883: );
3884:

Line 3892: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3888: -- Propogating RTP errors back to the OTL.
3889: -- Logic : We are looping through all the records from rcv_transaction_interface
3890: -- for the Transaction Line id which is not there in the l_rti_status table which
3891: -- is means this records have failed and can have RTP Error Message.
3892: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3893: , module => l_log_head
3894: , message => 'Stamping RTP errors to the Timecards '
3895: );
3896:

Line 3903: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3899: WHERE interface_line_id IN (l_receive_rti_id,l_deliver_rti_id,
3900: l_delete_receive_rti_id,l_delete_deliver_rti_id)
3901: AND table_name = 'RCV_TRANSACTIONS_INTERFACE') LOOP
3902:
3903: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3904: , module => l_log_head
3905: , message => 'RTP errors : ' || rec.msg
3906: );
3907:

Line 3918: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3914: HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) := HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx) || ' Receipt not created : '||l_message;
3915: END IF;
3916: g_failed_details := g_failed_details + 1;
3917:
3918: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3919: , module => l_log_head
3920: , message => 'Detail error '||HXC_USER_TYPE_DEFINITION_GRP.t_tx_detail_exception(blk_idx)
3921: );
3922: END IF;

Line 3935: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3931: || ' Detail block not processed';
3932: END IF;
3933: g_failed_details := g_failed_details + 1;
3934:
3935: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3936: , module => l_log_head
3937: , message => 'Detail block not processed'
3938: );
3939:

Line 3951: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

3947: (blk_idx) || 'Exception while checking receipt for detail block: ' || SQLERRM;
3948: END IF;
3949: g_failed_details := g_failed_details + 1;
3950:
3951: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3952: , module => l_log_head
3953: , message => 'Unexpected exception while checking receipt for detail block: ' || SQLERRM
3954: );
3955: END;

Line 3964: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3960: l_msg_data VARCHAR2(2000);
3961:
3962: ISP_RECONCILE_ACTIONS_FAILED EXCEPTION;
3963: BEGIN
3964: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3965: , module => l_log_head
3966: , message => 'Calling iSP to reconcile actions'
3967: );
3968:

Line 3974: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3970: , x_return_status => l_return_status
3971: , x_msg_data => l_msg_data
3972: );
3973:
3974: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3975: , module => l_log_head
3976: , message => 'Done with iSP reconcile actions'
3977: );
3978:

Line 3984: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

3980: RAISE ISP_RECONCILE_ACTIONS_FAILED;
3981: END IF;
3982: EXCEPTION
3983: WHEN ISP_RECONCILE_ACTIONS_FAILED THEN
3984: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
3985: , module => l_log_head
3986: , message => 'iSP reconcile actions failed: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data
3987: );
3988: WHEN OTHERS THEN

Line 3989: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

3985: , module => l_log_head
3986: , message => 'iSP reconcile actions failed: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data
3987: );
3988: WHEN OTHERS THEN
3989: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
3990: , module => l_log_head
3991: , message => 'Unexpected exception while calling iSP reconcile actions: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data || ' sqlerrm=' || SQLERRM
3992: );
3993: END;

Line 3995: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3991: , message => 'Unexpected exception while calling iSP reconcile actions: x_return_status=' || l_return_status || ' x_msg_data=' || l_msg_data || ' sqlerrm=' || SQLERRM
3992: );
3993: END;
3994:
3995: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
3996: , module => l_log_head
3997: , message => 'Setting Day/Timecard Statuses'
3998: );
3999:

Line 4003: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

3999:
4000: -- update status for day and timecard building blocks
4001: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4002:
4003: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4004: , module => l_log_head
4005: , message => 'Setting Transaction Status'
4006: );
4007:

Line 4008: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4004: , module => l_log_head
4005: , message => 'Setting Transaction Status'
4006: );
4007:
4008: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4009: , module => l_log_head
4010: , message => 'RT status count = ' || l_rti_status.COUNT
4011: );
4012:

Line 4029: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4025: , p_status => g_txn_status
4026: , p_exception_description => g_txn_msg
4027: );
4028:
4029: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4030: , module => l_log_head
4031: , message => 'Retrieval Transaction ' || g_txn_status || ': ' || g_txn_msg
4032: );
4033:

Line 4036: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4032: );
4033:
4034: COMMIT;
4035:
4036: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4037: , module => l_log_head
4038: , message => 'Transaction committed'
4039: );
4040:

Line 4041: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4037: , module => l_log_head
4038: , message => 'Transaction committed'
4039: );
4040:
4041: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4042: , module => l_log_head
4043: , message => 'End Retrieve_Timecards_Body'
4044: );
4045: EXCEPTION

Line 4057: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

4053: p_process => 'Purchasing Retrieval Process'
4054: , p_status => 'ERRORS'
4055: , p_exception_description => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'
4056: );
4057: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
4058: , module => l_log_head
4059: , message => g_txn_msg || 'Hit Breakpoint. Ending process in error, because we are still debugging.'
4060: );
4061: COMMIT;

Line 4073: , p_exception_description => g_txn_msg || 'Error calling Reconcile_Actions, please see FND_LOG_MESSAGES for details'

4069: -- this is only raised in the first call to reconcile actions. the later one is not fatal.
4070: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4071: p_process => 'Purchasing Retrieval Process'
4072: , p_status => 'ERRORS'
4073: , p_exception_description => g_txn_msg || 'Error calling Reconcile_Actions, please see FND_LOG_MESSAGES for details'
4074: );
4075: COMMIT;
4076: RAISE RETRIEVAL_FAILED;
4077: WHEN ISP_STORE_TIMECARD_FAILED THEN

Line 4086: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

4082: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4083: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4084: p_process => 'Purchasing Retrieval Process'
4085: , p_status => 'ERRORS'
4086: , p_exception_description => g_txn_msg || 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4087: );
4088: COMMIT;
4089: RAISE RETRIEVAL_FAILED;
4090: WHEN TRANSACTION_FAILED THEN

Line 4099: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'

4095: HXC_INTEGRATION_LAYER_V1_GRP.set_parent_statuses;
4096: HXC_INTEGRATION_LAYER_V1_GRP.update_transaction_status (
4097: p_process => 'Purchasing Retrieval Process'
4098: , p_status => 'ERRORS'
4099: , p_exception_description => 'Error in Retrieve_Timecards_Body, please see FND_LOG_MESSAGES for details'
4100: );
4101: COMMIT;
4102: RAISE RETRIEVAL_FAILED;
4103: WHEN OTHERS THEN

Line 4116: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

4112: p_process => 'Purchasing Retrieval Process'
4113: , p_status => 'ERRORS'
4114: , p_exception_description => SUBSTR(g_txn_msg || 'Unexpected exception in Retrieve_Timecards_Body: ' || SQLERRM, 1, 2000)
4115: );
4116: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
4117: , module => l_log_head
4118: , message => SUBSTR(g_txn_msg || 'Unexpected exception in Retrieve_Timecards_Body: ' || SQLERRM, 1, 2000)
4119: );
4120: COMMIT;

Line 4149: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4145: g_update_start := SYSDATE;
4146: initialize_cache_statistics;
4147: initialize_caches;
4148:
4149: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4150: , module => l_log_head
4151: , message => 'Begin Update_Timecard'
4152: );
4153:

Line 4207: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4203: p_building_blocks => l_blocks,
4204: p_app_attributes => l_attributes,
4205: p_messages => l_messages);
4206:
4207: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4208: , module => l_log_head
4209: , message => 'End Update_Timecard'
4210: );
4211:

Line 4236: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4232: /* Bug 5401262: Procedure Validate_Amount_Tolerances() validates all rows in po
4233: cache. We need to clear cache to prevent false errors/warnings */
4234: g_po_line_cache.delete;
4235:
4236: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4237: , module => l_log_head
4238: , message => 'Begin Validate_Timecard'
4239: );
4240:

Line 4277: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4273: ELSE
4274: l_attributes_rec.detail_deleted := 'N';
4275: END IF;
4276:
4277: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4278: , module => l_log_head
4279: , message => 'Detail block flags *'
4280: || l_attributes_rec.detail_changed || '*'
4281: || l_attributes_rec.detail_new || '*'

Line 4342: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4338: -- validate the old attributes if relevant
4339: IF l_all_attributes(l_bb_id).detail_new = 'N' AND
4340: l_all_attributes(l_bb_id).detail_changed = 'Y' AND
4341: l_old_attributes(l_bb_id).timecard_approval_status = 'SUBMITTED' THEN
4342: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4343: , module => G_LOG_MODULE
4344: , message => 'Validating old block'
4345: );
4346: Validate_Attributes(l_old_attributes(l_bb_id), l_messages);

Line 4360: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4356: l_all_attributes(l_bb_id).detail_deleted = 'N' AND
4357: l_old_attributes(l_bb_id).validation_status IN ('SUCCESS','SKIPPED')
4358: )
4359: THEN
4360: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4361: , module => l_log_head
4362: , message => 'Validating new block'
4363: );
4364: Validate_Attributes(l_all_attributes(l_bb_id), l_messages);

Line 4380: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4376: ( l_all_attributes(l_bb_id).detail_changed = 'N' AND
4377: l_all_attributes(l_bb_id).detail_deleted = 'Y'
4378: )
4379: THEN
4380: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4381: , module => l_log_head
4382: , message => 'Validating block that is deleted '||l_all_attributes(l_bb_id).old_block
4383: );
4384: Validate_Attributes(l_all_attributes(l_bb_id), l_messages);

Line 4399: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4395: p_building_blocks => l_blocks,
4396: p_app_attributes => l_attributes,
4397: p_messages => l_messages);
4398:
4399: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4400: , module => l_log_head
4401: , message => 'End Validate_Timecard'
4402: );
4403:

Line 4406: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4402: );
4403:
4404: g_validate_stop := SYSDATE;
4405:
4406: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4407: , module => l_log_head
4408: , message => 'Cache hit rates: ' || FND_GLOBAL.local_chr(10)
4409: || ' build_block: ' || (g_build_block_calls - g_build_block_misses) || '/' || g_build_block_calls || FND_GLOBAL.local_chr(10)
4410: || ' build_attribute: ' || (g_build_attribute_calls - g_build_attribute_misses) || '/' || g_build_attribute_calls || FND_GLOBAL.local_chr(10)

Line 4501: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4497: initialize_timing_statistics;
4498:
4499: G_CONC_LOG := '';
4500:
4501: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4502: , module => l_log_head
4503: , message => 'Begin Retrieve_Timecards'
4504: );
4505:

Line 4506: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT

4502: , module => l_log_head
4503: , message => 'Begin Retrieve_Timecards'
4504: );
4505:
4506: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_STATEMENT
4507: , module => l_log_head
4508: , message => 'Parameters: p_vendor_id=' || p_vendor_id
4509: || ', p_start_date=' || p_start_date
4510: || ', p_end_date=' || p_end_date

Line 4538: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4534: FROM po_lines pol
4535: WHERE pol.order_type_lookup_code in (''RATE'',''FIXED PRICE''))}');
4536: END IF;
4537:
4538: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4539: , module => l_log_head
4540: , message => 'Calling Generic Retrieval with p_where_clause: '
4541: || l_where_clause
4542: );

Line 4565: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION

4561: g_generic_stop := SYSDATE;
4562: g_generic_time := g_generic_time + (g_generic_stop - g_generic_start);
4563: EXCEPTION
4564: WHEN OTHERS THEN
4565: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_EXCEPTION
4566: , module => l_log_head
4567: , message => 'Generic Retrieval failed: ' || SQLERRM
4568: );
4569: IF SQLERRM like 'ORA-20001: HXC_0013_GNRET_NO_BLD_BLKS%' OR

Line 4584: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4580: END;
4581:
4582: g_retrieved_details := g_retrieved_details + HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT;
4583:
4584: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4585: , module => l_log_head
4586: , message => 'Returned from Generic Retrieval with '
4587: || HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT
4588: || ' detail blocks'

Line 4593: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4589: );
4590:
4591: -- are there any more timecard blocks to process?
4592: IF HXC_USER_TYPE_DEFINITION_GRP.t_detail_bld_blks.COUNT > 0 THEN
4593: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4594: , module => l_log_head
4595: , message => 'Calling Retrieval Body...'
4596: );
4597:

Line 4612: RCV_HXT_GRP.string ( log_level => FND_LOG.LEVEL_UNEXPECTED , module => l_log_head , message => 'Retrieve_Timecards_Body failed. Error:'|| sqlerrm );

4608: , p_receipt_date => l_receipt_date
4609: );
4610: EXCEPTION
4611: WHEN OTHERS THEN
4612: RCV_HXT_GRP.string ( log_level => FND_LOG.LEVEL_UNEXPECTED , module => l_log_head , message => 'Retrieve_Timecards_Body failed. Error:'|| sqlerrm );
4613: END;
4614:
4615: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4616: , module => l_log_head

Line 4615: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4611: WHEN OTHERS THEN
4612: RCV_HXT_GRP.string ( log_level => FND_LOG.LEVEL_UNEXPECTED , module => l_log_head , message => 'Retrieve_Timecards_Body failed. Error:'|| sqlerrm );
4613: END;
4614:
4615: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4616: , module => l_log_head
4617: , message => 'Returned from Retrieval Body'
4618: );
4619: ELSE

Line 4633: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE

4629:
4630: g_retrieval_stop := SYSDATE;
4631: g_retrieval_time := g_retrieval_stop - g_retrieval_start;
4632:
4633: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_PROCEDURE
4634: , module => l_log_head
4635: , message => 'End Retrieve_Timecards'
4636: );
4637:

Line 4686: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED

4682: WHEN GENERIC_RETRIEVAL_FAILED THEN
4683: errbuf := G_CONC_LOG;
4684: retcode := 2;
4685: WHEN OTHERS THEN
4686: RCV_HXT_GRP.string( log_level => FND_LOG.LEVEL_UNEXPECTED
4687: , module => l_log_head
4688: , message => 'Unexpected exception in RCV_HXT_GRP.Retrieve_Timecards: ' || SQLERRM
4689: );
4690: errbuf := G_CONC_LOG;