DBA Data[Home] [Help]

APPS.FLM_RECEIPT_PUB dependencies on FND_LOG

Line 128: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

124: l_receivable_quantity NUMBER;
125:
126: BEGIN
127:
128: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
130: l_log_module || '.begin',
131: 'Parameters: ' ||
132: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||

Line 129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

125:
126: BEGIN
127:
128: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
129: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
130: l_log_module || '.begin',
131: 'Parameters: ' ||
132: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
133: 'p_quantity = ' || p_quantity);

Line 278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

274:
275: END IF;
276:
277:
278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
280: l_log_module || '.end',
281: 'x_ret_status = ' || x_ret_status || ', ' ||
282: 'x_err_msg = ' || x_err_msg);

Line 279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

275: END IF;
276:
277:
278: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
279: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
280: l_log_module || '.end',
281: 'x_ret_status = ' || x_ret_status || ', ' ||
282: 'x_err_msg = ' || x_err_msg);
283: END IF;

Line 335: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

331: l_str VARCHAR2(4000);
332:
333: BEGIN
334:
335: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
337: l_log_module || '.begin',
338: 'Parameters: p_group_id = ' || p_group_id);
339: END IF;

Line 336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

332:
333: BEGIN
334:
335: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
336: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
337: l_log_module || '.begin',
338: 'Parameters: p_group_id = ' || p_group_id);
339: END IF;
340:

Line 346: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

342: IF (l_timeout is NULL) THEN
343: l_timeout := 300;
344: END IF;
345:
346: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
348: l_log_module || '.calling_RCVTPO',
349: 'Before fnd_transaction.synchronous');
350: END IF;

Line 347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

343: l_timeout := 300;
344: END IF;
345:
346: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
347: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
348: l_log_module || '.calling_RCVTPO',
349: 'Before fnd_transaction.synchronous');
350: END IF;
351:

Line 360: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

356: NULL, NULL, NULL, NULL, NULL, NULL,
357: NULL, NULL, NULL, NULL, NULL, NULL
358: );
359:
360: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
362: l_log_module || '.calling_RCVTPO',
363: 'After fnd_transaction.synchronous: ' ||
364: 'status = ' || l_status || ', ' ||

Line 361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

357: NULL, NULL, NULL, NULL, NULL, NULL
358: );
359:
360: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
361: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
362: l_log_module || '.calling_RCVTPO',
363: 'After fnd_transaction.synchronous: ' ||
364: 'status = ' || l_status || ', ' ||
365: 'outcome = ' || l_outcome || ', ' ||

Line 435: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

431: COMMIT;
432:
433: END IF;
434:
435: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
437: l_log_module || '.end',
438: 'x_ret_status = ' || x_ret_status || ', ' ||
439: 'x_err_msg = ' || x_err_msg);

Line 436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

432:
433: END IF;
434:
435: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
436: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
437: l_log_module || '.end',
438: 'x_ret_status = ' || x_ret_status || ', ' ||
439: 'x_err_msg = ' || x_err_msg);
440: END IF;

Line 540: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

536: l_group_id NUMBER;
537:
538: BEGIN
539:
540: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
542: l_log_module || '.begin',
543: 'Parameters: ' ||
544: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||

Line 541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

537:
538: BEGIN
539:
540: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
541: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
542: l_log_module || '.begin',
543: 'Parameters: ' ||
544: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
545: 'p_receipt_quantity = ' || p_receipt_quantity);

Line 552: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

548: -- Initialize return status to success
549: x_ret_status := FND_API.G_RET_STS_SUCCESS;
550:
551:
552: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
554: l_log_module || '.receive_details',
555: 'Opening and Fetching c_rcv_details');
556: END IF;

Line 553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

549: x_ret_status := FND_API.G_RET_STS_SUCCESS;
550:
551:
552: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
553: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
554: l_log_module || '.receive_details',
555: 'Opening and Fetching c_rcv_details');
556: END IF;
557:

Line 571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

567:
568:
569: l_employee_id := get_employee_id;
570:
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_log_module || '.rcv_shipment_headers',
574: 'Before rcv_shipment_headers_pkg.insert_row');
575: END IF;

Line 572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

568:
569: l_employee_id := get_employee_id;
570:
571: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
572: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
573: l_log_module || '.rcv_shipment_headers',
574: 'Before rcv_shipment_headers_pkg.insert_row');
575: END IF;
576:

Line 628: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

624: X_customer_id => NULL,
625: X_customer_site_id => NULL
626: );
627:
628: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: l_log_module || '.rcv_shipment_headers',
631: 'After rcv_shipment_headers_pkg.insert_row: ' ||
632: 'l_shipment_header_id = ' || l_shipment_header_id || ', ' ||

Line 629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

625: X_customer_site_id => NULL
626: );
627:
628: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
629: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
630: l_log_module || '.rcv_shipment_headers',
631: 'After rcv_shipment_headers_pkg.insert_row: ' ||
632: 'l_shipment_header_id = ' || l_shipment_header_id || ', ' ||
633: 'x_receipt_num = ' || x_receipt_num);

Line 639: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

635:
636:
637: l_group_id := get_group_id;
638:
639: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
641: l_log_module || '.rcv_trx_interface',
642: 'Before rcv_trx_interface_insert_pkg.insert_row');
643: END IF;

Line 640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

636:
637: l_group_id := get_group_id;
638:
639: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
640: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
641: l_log_module || '.rcv_trx_interface',
642: 'Before rcv_trx_interface_insert_pkg.insert_row');
643: END IF;
644:

Line 806: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

802: X_secondary_unit_of_measure => l_rcv_details_rec.secondary_uom,
803: p_org_id => l_rcv_details_rec.org_id
804: );
805:
806: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
808: l_log_module || '.rcv_trx_interface',
809: 'After rcv_trx_interface_insert_pkg.insert_row: ' ||
810: 'l_interface_transaction_id = ' || l_interface_transaction_id);

Line 807: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

803: p_org_id => l_rcv_details_rec.org_id
804: );
805:
806: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
807: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
808: l_log_module || '.rcv_trx_interface',
809: 'After rcv_trx_interface_insert_pkg.insert_row: ' ||
810: 'l_interface_transaction_id = ' || l_interface_transaction_id);
811: END IF;

Line 821: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

817: x_ret_status => x_ret_status,
818: x_err_msg => x_err_msg
819: );
820:
821: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
823: l_log_module || '.request_online',
824: 'After request_online: ' ||
825: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

818: x_err_msg => x_err_msg
819: );
820:
821: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
822: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
823: l_log_module || '.request_online',
824: 'After request_online: ' ||
825: 'x_ret_status = ' || x_ret_status || ', ' ||
826: 'x_err_msg = ' || x_err_msg);

Line 834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

830: RETURN;
831: END IF;
832:
833:
834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
836: l_log_module || '.receive_supplier_hook',
837: 'Before FLM_KANBAN_CUSTOM_PKG.receive_supplier_hook');
838: END IF;

Line 835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

831: END IF;
832:
833:
834: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
835: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
836: l_log_module || '.receive_supplier_hook',
837: 'Before FLM_KANBAN_CUSTOM_PKG.receive_supplier_hook');
838: END IF;
839:

Line 850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

846: x_msg_data => x_err_msg
847: );
848:
849:
850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
851: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
852: l_log_module || '.end',
853: 'x_receipt_num = ' || x_receipt_num || ', ' ||
854: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 851: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

847: );
848:
849:
850: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
851: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
852: l_log_module || '.end',
853: 'x_receipt_num = ' || x_receipt_num || ', ' ||
854: 'x_ret_status = ' || x_ret_status || ', ' ||
855: 'x_err_msg = ' || x_err_msg);

Line 1007: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1003: l_interface_transaction_id NUMBER;
1004:
1005: BEGIN
1006:
1007: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1009: l_log_module || '.begin',
1010: 'Parameters: ' ||
1011: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||

Line 1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1004:
1005: BEGIN
1006:
1007: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1008: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1009: l_log_module || '.begin',
1010: 'Parameters: ' ||
1011: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
1012: 'p_receipt_quantity = ' || p_receipt_quantity);

Line 1023: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1019: -- remaining receipt quantity to carry over to subsequent shipment lines
1020: l_remaining_quantity := p_receipt_quantity;
1021:
1022:
1023: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1025: l_log_module || '.shipment_lines',
1026: 'Begin looping cursor c_shipment_lines');
1027: END IF;

Line 1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1020: l_remaining_quantity := p_receipt_quantity;
1021:
1022:
1023: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1024: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1025: l_log_module || '.shipment_lines',
1026: 'Begin looping cursor c_shipment_lines');
1027: END IF;
1028:

Line 1036: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1032:
1033: FOR i IN l_ship_lines_tbl.FIRST..l_ship_lines_tbl.LAST LOOP
1034: l_ship_line_rec := l_ship_lines_tbl(i);
1035:
1036: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1038: l_log_module || '.shipment_line',
1039: 'shipment_header_id = ' || l_ship_line_rec.shipment_header_id || ', ' ||
1040: 'shipment_line_id = ' || l_ship_line_rec.shipment_line_id);

Line 1037: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1033: FOR i IN l_ship_lines_tbl.FIRST..l_ship_lines_tbl.LAST LOOP
1034: l_ship_line_rec := l_ship_lines_tbl(i);
1035:
1036: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1037: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1038: l_log_module || '.shipment_line',
1039: 'shipment_header_id = ' || l_ship_line_rec.shipment_header_id || ', ' ||
1040: 'shipment_line_id = ' || l_ship_line_rec.shipment_line_id);
1041: END IF;

Line 1084: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1080: END LOOP;
1081:
1082: x_receipt_num := l_temp_receipt_num;
1083:
1084: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1085: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1086: l_log_module || '.gen_receipt_num',
1087: 'x_receipt_num = ' || x_receipt_num);
1088: END IF;

Line 1085: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1081:
1082: x_receipt_num := l_temp_receipt_num;
1083:
1084: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1085: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1086: l_log_module || '.gen_receipt_num',
1087: 'x_receipt_num = ' || x_receipt_num);
1088: END IF;
1089:

Line 1090: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1086: l_log_module || '.gen_receipt_num',
1087: 'x_receipt_num = ' || x_receipt_num);
1088: END IF;
1089:
1090: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1092: l_log_module || '.rcv_shipment_headers',
1093: 'Calling rcv_shipment_headers_pkg.update_row');
1094: END IF;

Line 1091: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1087: 'x_receipt_num = ' || x_receipt_num);
1088: END IF;
1089:
1090: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1091: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1092: l_log_module || '.rcv_shipment_headers',
1093: 'Calling rcv_shipment_headers_pkg.update_row');
1094: END IF;
1095:

Line 1162: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1158:
1159: -- keep track of the remaining receipt quantity for subsequent shipment lines
1160: l_remaining_quantity := l_remaining_quantity - l_quantity;
1161:
1162: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1163: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1164: l_log_module || '.remaining_quantity',
1165: 'l_quantity = ' || l_quantity || ', ' ||
1166: 'l_remaining_quantity = ' || l_remaining_quantity);

Line 1163: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1159: -- keep track of the remaining receipt quantity for subsequent shipment lines
1160: l_remaining_quantity := l_remaining_quantity - l_quantity;
1161:
1162: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1163: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1164: l_log_module || '.remaining_quantity',
1165: 'l_quantity = ' || l_quantity || ', ' ||
1166: 'l_remaining_quantity = ' || l_remaining_quantity);
1167: END IF;

Line 1172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1168:
1169:
1170: l_group_id := get_group_id;
1171:
1172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1174: l_log_module || '.rcv_trx_interface',
1175: 'Before rcv_trx_interface_insert_pkg.insert_row');
1176: END IF;

Line 1173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1169:
1170: l_group_id := get_group_id;
1171:
1172: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1173: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1174: l_log_module || '.rcv_trx_interface',
1175: 'Before rcv_trx_interface_insert_pkg.insert_row');
1176: END IF;
1177:

Line 1338: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1334: X_cost_group_id => l_ship_line_rec.cost_group_id,
1335: p_org_id => l_ship_line_rec.org_id
1336: );
1337:
1338: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1340: l_log_module || '.rcv_trx_interface',
1341: 'After rcv_trx_interface_insert_pkg.insert_row: ' ||
1342: 'l_interface_transaction_id = ' || l_interface_transaction_id);

Line 1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1335: p_org_id => l_ship_line_rec.org_id
1336: );
1337:
1338: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1339: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1340: l_log_module || '.rcv_trx_interface',
1341: 'After rcv_trx_interface_insert_pkg.insert_row: ' ||
1342: 'l_interface_transaction_id = ' || l_interface_transaction_id);
1343: END IF;

Line 1353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1349: x_ret_status => x_ret_status,
1350: x_err_msg => x_err_msg
1351: );
1352:
1353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1355: l_log_module || '.request_online',
1356: 'After request_online: ' ||
1357: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1350: x_err_msg => x_err_msg
1351: );
1352:
1353: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1354: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1355: l_log_module || '.request_online',
1356: 'After request_online: ' ||
1357: 'x_ret_status = ' || x_ret_status || ', ' ||
1358: 'x_err_msg = ' || x_err_msg);

Line 1366: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1362: RETURN;
1363: END IF;
1364:
1365:
1366: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1368: l_log_module || '.receive_interorg_hook',
1369: 'Before FLM_KANBAN_CUSTOM_PKG.receive_interorg_hook');
1370: END IF;

Line 1367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1363: END IF;
1364:
1365:
1366: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1367: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1368: l_log_module || '.receive_interorg_hook',
1369: 'Before FLM_KANBAN_CUSTOM_PKG.receive_interorg_hook');
1370: END IF;
1371:

Line 1389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1385: END IF;
1386:
1387: END LOOP;
1388:
1389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1391: l_log_module || '.end',
1392: 'x_receipt_num = ' || x_receipt_num || ', ' ||
1393: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1386:
1387: END LOOP;
1388:
1389: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1390: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1391: l_log_module || '.end',
1392: 'x_receipt_num = ' || x_receipt_num || ', ' ||
1393: 'x_ret_status = ' || x_ret_status || ', ' ||
1394: 'x_err_msg = ' || x_err_msg);

Line 1426: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1422: BEGIN
1423:
1424: SAVEPOINT kanban_receive;
1425:
1426: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1428: l_log_module || '.begin',
1429: 'Parameters: ' ||
1430: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||

Line 1427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1423:
1424: SAVEPOINT kanban_receive;
1425:
1426: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1427: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1428: l_log_module || '.begin',
1429: 'Parameters: ' ||
1430: 'p_kanban_card_id = ' || p_kanban_card_id || ', ' ||
1431: 'p_receipt_quantity = ' || p_receipt_quantity || ', ' ||

Line 1436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1432: 'p_process_flag = ' || p_process_flag);
1433: END IF;
1434:
1435:
1436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1437: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1438: l_log_module || '.validate',
1439: 'Calling validate');
1440: END IF;

Line 1437: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1433: END IF;
1434:
1435:
1436: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1437: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1438: l_log_module || '.validate',
1439: 'Calling validate');
1440: END IF;
1441:

Line 1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1443: p_quantity => p_receipt_quantity,
1444: x_ret_status => x_ret_status,
1445: x_err_msg => x_err_msg);
1446:
1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: l_log_module || '.validate',
1450: 'After validate: ' ||
1451: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1444: x_ret_status => x_ret_status,
1445: x_err_msg => x_err_msg);
1446:
1447: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1448: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1449: l_log_module || '.validate',
1450: 'After validate: ' ||
1451: 'x_ret_status = ' || x_ret_status || ', ' ||
1452: 'x_err_msg = ' || x_err_msg);

Line 1467: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1463: CLOSE c_get_kanban_source_type;
1464:
1465: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN
1466:
1467: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1469: l_log_module || '.receive_supplier',
1470: 'Calling receive_supplier');
1471: END IF;

Line 1468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1464:
1465: IF l_source_type = INV_KANBAN_PVT.G_Source_Type_Supplier THEN
1466:
1467: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1468: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1469: l_log_module || '.receive_supplier',
1470: 'Calling receive_supplier');
1471: END IF;
1472:

Line 1479: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1475: p_receipt_number,
1476: x_ret_status,
1477: x_err_msg);
1478:
1479: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1481: l_log_module || '.receive_supplier',
1482: 'After receive_supplier: ' ||
1483: 'x_receipt_num = ' || p_receipt_number || ', ' ||

Line 1480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1476: x_ret_status,
1477: x_err_msg);
1478:
1479: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1480: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1481: l_log_module || '.receive_supplier',
1482: 'After receive_supplier: ' ||
1483: 'x_receipt_num = ' || p_receipt_number || ', ' ||
1484: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1490: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1486: END IF;
1487:
1488: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
1489:
1490: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1492: l_log_module || '.receive_interorg',
1493: 'Calling receive_interorg');
1494: END IF;

Line 1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1487:
1488: ELSIF l_source_type = INV_KANBAN_PVT.G_Source_Type_InterOrg THEN
1489:
1490: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1491: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1492: l_log_module || '.receive_interorg',
1493: 'Calling receive_interorg');
1494: END IF;
1495:

Line 1502: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1498: p_receipt_number,
1499: x_ret_status,
1500: x_err_msg);
1501:
1502: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1504: l_log_module || '.receive_interorg',
1505: 'After receive_interorg: ' ||
1506: 'x_receipt_num = ' || p_receipt_number || ', ' ||

Line 1503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,

1499: x_ret_status,
1500: x_err_msg);
1501:
1502: IF FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1503: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,
1504: l_log_module || '.receive_interorg',
1505: 'After receive_interorg: ' ||
1506: 'x_receipt_num = ' || p_receipt_number || ', ' ||
1507: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1515: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN

1511: END IF; -- l_source_type
1512:
1513: END IF; -- p_process_flag
1514:
1515: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1517: l_log_module || '.end',
1518: 'p_receipt_number = ' || p_receipt_number || ', ' ||
1519: 'x_ret_status = ' || x_ret_status || ', ' ||

Line 1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,

1512:
1513: END IF; -- p_process_flag
1514:
1515: IF FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
1516: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE,
1517: l_log_module || '.end',
1518: 'p_receipt_number = ' || p_receipt_number || ', ' ||
1519: 'x_ret_status = ' || x_ret_status || ', ' ||
1520: 'x_err_msg = ' || x_err_msg);