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

Line 76: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

72: IS
73: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_PO_Transactions';
74:
75: BEGIN
76: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
77: THEN
78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
79: , G_MODULE_NAME || l_procedure_name || '.begin'
80: ,'enter procedure'

Line 78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

74:
75: BEGIN
76: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
77: THEN
78: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
79: , G_MODULE_NAME || l_procedure_name || '.begin'
80: ,'enter procedure'
81: );
82: END IF;

Line 161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

157: AND hoi.org_information2 = to_char(p_movement_transaction.entity_org_id) /* bug 7676431: Added to_char */
158: AND rcv.organization_id = p_movement_transaction.organization_id;
159: END IF;
160:
161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
162: THEN
163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
164: , G_MODULE_NAME || l_procedure_name || '.end'
165: ,'exit procedure'

Line 163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

159: END IF;
160:
161: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
162: THEN
163: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
164: , G_MODULE_NAME || l_procedure_name || '.end'
165: ,'exit procedure'
166: );
167: END IF;

Line 172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

168:
169: EXCEPTION
170: WHEN OTHERS THEN
171: x_return_status := 'N';
172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
173: THEN
174: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
175: , G_MODULE_NAME || l_procedure_name||'. Others exception'
176: , 'Exception'

Line 174: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

170: WHEN OTHERS THEN
171: x_return_status := 'N';
172: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
173: THEN
174: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
175: , G_MODULE_NAME || l_procedure_name||'. Others exception'
176: , 'Exception'
177: );
178: END IF;

Line 241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

237: AND line_location_id = x_movement_transaction.po_line_location_id
238: ORDER BY line_id;
239:
240: BEGIN
241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
242: THEN
243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
244: , G_MODULE_NAME || l_procedure_name || '.begin'
245: ,'enter procedure'

Line 243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

239:
240: BEGIN
241: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
242: THEN
243: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
244: , G_MODULE_NAME || l_procedure_name || '.begin'
245: ,'enter procedure'
246: );
247: END IF;

Line 289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

285: EXIT;
286: --Fix bug 5060410, incase no match found, exit anyway to avoice endless loop
287: ELSIF l_rt_seq = l_count
288: THEN
289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
290: THEN
291: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
292: , G_MODULE_NAME
293: || '.no rt id matched - data problem - exit loop anyway'

Line 291: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

287: ELSIF l_rt_seq = l_count
288: THEN
289: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
290: THEN
291: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
292: , G_MODULE_NAME
293: || '.no rt id matched - data problem - exit loop anyway'
294: ,'data has problem');
295: END IF;

Line 324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

320: END IF;
321: END IF;
322: CLOSE l_drpshp_count;
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
325: THEN
326: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
327: , G_MODULE_NAME || l_procedure_name || '.end'
328: ,'exit procedure'

Line 326: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

322: CLOSE l_drpshp_count;
323:
324: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
325: THEN
326: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
327: , G_MODULE_NAME || l_procedure_name || '.end'
328: ,'exit procedure'
329: );
330: END IF;

Line 334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

330: END IF;
331:
332: EXCEPTION
333: WHEN OTHERS THEN
334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
335: THEN
336: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
337: , G_MODULE_NAME || l_procedure_name||'. Others exception'
338: , 'Exception'

Line 336: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

332: EXCEPTION
333: WHEN OTHERS THEN
334: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
335: THEN
336: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
337: , G_MODULE_NAME || l_procedure_name||'. Others exception'
338: , 'Exception'
339: );
340: END IF;

Line 467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

463: AND mvt_stat_status = 'NEW'
464: AND transaction_type = 'CORRECT';
465:
466: BEGIN
467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
468: THEN
469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
470: , G_MODULE_NAME || l_procedure_name || '.begin'
471: ,'enter procedure'

Line 469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

465:
466: BEGIN
467: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
468: THEN
469: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
470: , G_MODULE_NAME || l_procedure_name || '.begin'
471: ,'enter procedure'
472: );
473: END IF;

Line 519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

515: THEN
516: CLOSE po_details;
517: x_return_status := 'N';
518:
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
520: THEN
521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
522: , G_MODULE_NAME || l_procedure_name || '.end return N'
523: ,'exit procedure'

Line 521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

517: x_return_status := 'N';
518:
519: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
520: THEN
521: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
522: , G_MODULE_NAME || l_procedure_name || '.end return N'
523: ,'exit procedure'
524: );
525: END IF;

Line 541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

537: , p_item_id => x_movement_transaction.inventory_item_id
538: , p_transaction_date => x_movement_transaction.transaction_date
539: );
540:
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
542: THEN
543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
544: , G_MODULE_NAME || l_procedure_name
545: ,'item_cost from OPM:' || x_movement_transaction.item_cost

Line 543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

539: );
540:
541: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
542: THEN
543: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
544: , G_MODULE_NAME || l_procedure_name
545: ,'item_cost from OPM:' || x_movement_transaction.item_cost
546: );
547: END IF;

Line 555: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

551: FETCH c_item_cost INTO
552: x_movement_transaction.item_cost;
553: CLOSE c_item_cost;
554:
555: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
556: THEN
557: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
558: , G_MODULE_NAME || l_procedure_name
559: ,'item_cost from discrete:' || x_movement_transaction.item_cost

Line 557: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

553: CLOSE c_item_cost;
554:
555: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
556: THEN
557: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
558: , G_MODULE_NAME || l_procedure_name
559: ,'item_cost from discrete:' || x_movement_transaction.item_cost
560: );
561: END IF;

Line 710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

706: x_movement_transaction.document_line_ext_value :=
707: abs(x_movement_transaction.document_line_ext_value);
708: END IF;
709:
710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
711: THEN
712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
713: , G_MODULE_NAME || l_procedure_name || '.end'
714: ,'exit procedure'

Line 712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

708: END IF;
709:
710: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
711: THEN
712: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
713: , G_MODULE_NAME || l_procedure_name || '.end'
714: ,'exit procedure'
715: );
716: END IF;

Line 720: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

716: END IF;
717: EXCEPTION
718: WHEN OTHERS THEN
719: x_return_status := 'N';
720: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
721: THEN
722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
723: , G_MODULE_NAME || l_procedure_name||'. Others exception'
724: , 'Exception'

Line 722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

718: WHEN OTHERS THEN
719: x_return_status := 'N';
720: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
721: THEN
722: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
723: , G_MODULE_NAME || l_procedure_name||'. Others exception'
724: , 'Exception'
725: );
726: END IF;

Line 821: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

817: WHERE cst.organization_id = l_ship_from_org_id
818: AND cst.inventory_item_id = x_movement_transaction.inventory_item_id;
819:
820: BEGIN
821: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
822: THEN
823: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
824: , G_MODULE_NAME || l_procedure_name || '.begin'
825: ,'enter procedure'

Line 823: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

819:
820: BEGIN
821: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
822: THEN
823: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
824: , G_MODULE_NAME || l_procedure_name || '.begin'
825: ,'enter procedure'
826: );
827: END IF;

Line 869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

865: THEN
866: CLOSE l_drpshp_so_om;
867: x_return_status := 'N';
868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
870: THEN
871: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
872: , G_MODULE_NAME || l_procedure_name || '.end return N'
873: ,'exit procedure'

Line 871: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

867: x_return_status := 'N';
868:
869: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
870: THEN
871: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
872: , G_MODULE_NAME || l_procedure_name || '.end return N'
873: ,'exit procedure'
874: );
875: END IF;

Line 892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

888: , p_item_id => x_movement_transaction.inventory_item_id
889: , p_transaction_date => x_movement_transaction.transaction_date
890: );
891:
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
893: THEN
894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
895: , G_MODULE_NAME || l_procedure_name
896: ,'item_cost from OPM:' || x_movement_transaction.item_cost

Line 894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

890: );
891:
892: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
893: THEN
894: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
895: , G_MODULE_NAME || l_procedure_name
896: ,'item_cost from OPM:' || x_movement_transaction.item_cost
897: );
898: END IF;

Line 907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

903: FETCH c_item_cost INTO
904: x_movement_transaction.item_cost;
905: CLOSE c_item_cost;
906:
907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
908: THEN
909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
910: , G_MODULE_NAME || l_procedure_name
911: ,'item_cost from discrete:' || x_movement_transaction.item_cost

Line 909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

905: CLOSE c_item_cost;
906:
907: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
908: THEN
909: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
910: , G_MODULE_NAME || l_procedure_name
911: ,'item_cost from discrete:' || x_movement_transaction.item_cost
912: );
913: END IF;

Line 921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

917: x_movement_transaction.document_source_type := 'SO';
918:
919: x_movement_transaction.transaction_nature := '17';
920:
921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
922: THEN
923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
924: , G_MODULE_NAME || l_procedure_name || '.end'
925: ,'exit procedure'

Line 923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

919: x_movement_transaction.transaction_nature := '17';
920:
921: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
922: THEN
923: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
924: , G_MODULE_NAME || l_procedure_name || '.end'
925: ,'exit procedure'
926: );
927: END IF;

Line 932: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

928: EXCEPTION
929: WHEN OTHERS THEN
930: x_return_status := 'N';
931:
932: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
933: THEN
934: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
935: , G_MODULE_NAME || l_procedure_name||'. Others exception'
936: , 'Exception'

Line 934: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

930: x_return_status := 'N';
931:
932: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
933: THEN
934: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
935: , G_MODULE_NAME || l_procedure_name||'. Others exception'
936: , 'Exception'
937: );
938: END IF;

Line 961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

957: IS
958: l_receipt_transaction INV_MGD_MVT_DATA_STR.Receipt_Transaction_Rec_Type;
959: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_PO_Transactions';
960: BEGIN
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
962: THEN
963: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
964: , G_MODULE_NAME || l_procedure_name || '.begin'
965: ,'enter procedure'

Line 963: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

959: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_PO_Transactions';
960: BEGIN
961: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
962: THEN
963: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
964: , G_MODULE_NAME || l_procedure_name || '.begin'
965: ,'enter procedure'
966: );
967: END IF;

Line 990: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

986: , movement_id = p_movement_transaction.movement_id
987: WHERE transaction_id = p_movement_transaction.rcv_transaction_id;
988: END IF;
989:
990: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
991: THEN
992: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
993: , G_MODULE_NAME || l_procedure_name || '.end'
994: ,'exit procedure'

Line 992: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

988: END IF;
989:
990: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
991: THEN
992: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
993: , G_MODULE_NAME || l_procedure_name || '.end'
994: ,'exit procedure'
995: );
996: END IF;

Line 1000: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

996: END IF;
997: EXCEPTION
998: WHEN OTHERS THEN
999: x_return_status := 'N';
1000: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1001: THEN
1002: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1003: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1004: , 'Exception'

Line 1002: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

998: WHEN OTHERS THEN
999: x_return_status := 'N';
1000: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1001: THEN
1002: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1003: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1004: , 'Exception'
1005: );
1006: END IF;

Line 1026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1022: )
1023: IS
1024: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RTV_Transactions';
1025: BEGIN
1026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1027: THEN
1028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1029: , G_MODULE_NAME || l_procedure_name || '.begin'
1030: ,'enter procedure'

Line 1028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1024: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RTV_Transactions';
1025: BEGIN
1026: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1027: THEN
1028: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1029: , G_MODULE_NAME || l_procedure_name || '.begin'
1030: ,'enter procedure'
1031: );
1032: END IF;

Line 1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1043: , transaction_type
1044: FROM RCV_TRANSACTIONS
1045: WHERE transaction_id = p_parent_id;
1046:
1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1048: THEN
1049: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1050: , G_MODULE_NAME || l_procedure_name || '.end'
1051: ,'exit procedure'

Line 1049: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1045: WHERE transaction_id = p_parent_id;
1046:
1047: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1048: THEN
1049: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1050: , G_MODULE_NAME || l_procedure_name || '.end'
1051: ,'exit procedure'
1052: );
1053: END IF;

Line 1057: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1053: END IF;
1054: EXCEPTION
1055: WHEN OTHERS THEN
1056: x_return_status := 'N';
1057: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1058: THEN
1059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1060: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1061: , 'Exception'

Line 1059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1055: WHEN OTHERS THEN
1056: x_return_status := 'N';
1057: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1058: THEN
1059: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1060: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1061: , 'Exception'
1062: );
1063: END IF;

Line 1096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1092: WHERE po.po_header_id = poh.po_header_id
1093: AND po.transaction_id = x_movement_transaction.rcv_transaction_id;
1094:
1095: BEGIN
1096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1097: THEN
1098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1099: , G_MODULE_NAME || l_procedure_name || '.begin'
1100: ,'enter procedure'

Line 1098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1094:
1095: BEGIN
1096: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1097: THEN
1098: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1099: , G_MODULE_NAME || l_procedure_name || '.begin'
1100: ,'enter procedure'
1101: );
1102: END IF;

Line 1114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1110: , x_movement_transaction.po_line_location_id
1111: , x_movement_transaction.type_lookup_code;
1112: CLOSE l_bpo;
1113:
1114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1115: THEN
1116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1117: , G_MODULE_NAME || l_procedure_name || '.end'
1118: ,'exit procedure'

Line 1116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1112: CLOSE l_bpo;
1113:
1114: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1115: THEN
1116: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1117: , G_MODULE_NAME || l_procedure_name || '.end'
1118: ,'exit procedure'
1119: );
1120: END IF;

Line 1124: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1120: END IF;
1121: EXCEPTION
1122: WHEN OTHERS THEN
1123: x_movement_transaction := l_movement_transaction;
1124: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1127: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1128: , 'Exception'

Line 1126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1122: WHEN OTHERS THEN
1123: x_movement_transaction := l_movement_transaction;
1124: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1127: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1128: , 'Exception'
1129: );
1130: END IF;

Line 1156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1152: )
1153: IS
1154: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Transactions';
1155: BEGIN
1156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1157: THEN
1158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1159: , G_MODULE_NAME || l_procedure_name || '.begin'
1160: ,'enter procedure'

Line 1158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1154: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_RMA_Transactions';
1155: BEGIN
1156: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1157: THEN
1158: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1159: , G_MODULE_NAME || l_procedure_name || '.begin'
1160: ,'enter procedure'
1161: );
1162: END IF;

Line 1299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1295: AND rcv.transaction_type IN ('DELIVER')
1296: AND rcv.source_document_code = 'RMA';
1297: END IF;
1298:
1299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1302: , G_MODULE_NAME || l_procedure_name || '.end'
1303: ,'exit procedure'

Line 1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1297: END IF;
1298:
1299: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1302: , G_MODULE_NAME || l_procedure_name || '.end'
1303: ,'exit procedure'
1304: );
1305: END IF;

Line 1309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1305: END IF;
1306: EXCEPTION
1307: WHEN OTHERS THEN
1308: x_return_status := 'N';
1309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1310: THEN
1311: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1312: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1313: , 'Exception'

Line 1311: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1307: WHEN OTHERS THEN
1308: x_return_status := 'N';
1309: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1310: THEN
1311: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1312: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1313: , 'Exception'
1314: );
1315: END IF;

Line 1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1420: AND muc.organization_id = x_movement_transaction.organization_id
1421: AND muc.unit_of_measure = l_receipt_transaction.primary_unit_of_measure;*/
1422:
1423: BEGIN
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1425: THEN
1426: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1427: , G_MODULE_NAME || l_procedure_name || '.begin'
1428: ,'enter procedure'

Line 1426: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1422:
1423: BEGIN
1424: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1425: THEN
1426: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1427: , G_MODULE_NAME || l_procedure_name || '.begin'
1428: ,'enter procedure'
1429: );
1430: END IF;

Line 1468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1464: IF rma_details%NOTFOUND THEN
1465: CLOSE rma_details;
1466: x_return_status := 'N';
1467:
1468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1469: THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1471: , G_MODULE_NAME || l_procedure_name || '.end return N'
1472: ,'exit procedure'

Line 1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1466: x_return_status := 'N';
1467:
1468: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1469: THEN
1470: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1471: , G_MODULE_NAME || l_procedure_name || '.end return N'
1472: ,'exit procedure'
1473: );
1474: END IF;

Line 1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1486: ( p_org_id => x_movement_transaction.organization_id
1487: , p_item_id => x_movement_transaction.inventory_item_id
1488: , p_transaction_date => x_movement_transaction.transaction_date
1489: );
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1491: THEN
1492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1493: , G_MODULE_NAME || l_procedure_name
1494: ,'item_cost from OPM:' || x_movement_transaction.item_cost

Line 1492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1488: , p_transaction_date => x_movement_transaction.transaction_date
1489: );
1490: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1491: THEN
1492: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1493: , G_MODULE_NAME || l_procedure_name
1494: ,'item_cost from OPM:' || x_movement_transaction.item_cost
1495: );
1496: END IF;

Line 1504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1500: FETCH c_item_cost INTO
1501: x_movement_transaction.item_cost;
1502: CLOSE c_item_cost;
1503:
1504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1505: THEN
1506: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1507: , G_MODULE_NAME || l_procedure_name
1508: ,'item_cost from discrete:' || x_movement_transaction.item_cost

Line 1506: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1502: CLOSE c_item_cost;
1503:
1504: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1505: THEN
1506: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1507: , G_MODULE_NAME || l_procedure_name
1508: ,'item_cost from discrete:' || x_movement_transaction.item_cost
1509: );
1510: END IF;

Line 1579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1575: x_movement_transaction.document_source_type := 'RMA';
1576: -- x_movement_transaction.currency_conversion_rate := 1;
1577: x_movement_transaction.transaction_nature := '20';
1578:
1579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1580: THEN
1581: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1582: , G_MODULE_NAME || l_procedure_name || '.end'
1583: ,'exit procedure'

Line 1581: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1577: x_movement_transaction.transaction_nature := '20';
1578:
1579: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1580: THEN
1581: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1582: , G_MODULE_NAME || l_procedure_name || '.end'
1583: ,'exit procedure'
1584: );
1585: END IF;

Line 1589: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1585: END IF;
1586: EXCEPTION
1587: WHEN NO_DATA_FOUND THEN
1588: x_return_status := 'N';
1589: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1590: THEN
1591: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1592: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1593: , 'Exception'

Line 1591: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1587: WHEN NO_DATA_FOUND THEN
1588: x_return_status := 'N';
1589: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1590: THEN
1591: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1592: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1593: , 'Exception'
1594: );
1595: END IF;

Line 1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1594: );
1595: END IF;
1596: WHEN OTHERS THEN
1597: x_return_status := 'N';
1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1599: THEN
1600: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1601: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1602: , 'Exception'

Line 1600: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1596: WHEN OTHERS THEN
1597: x_return_status := 'N';
1598: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1599: THEN
1600: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1601: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1602: , 'Exception'
1603: );
1604: END IF;

Line 1648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1644: EXCEPTION
1645: WHEN OTHERS THEN
1646: x_movement_id := null;
1647: x_movement_status := null;
1648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1649: THEN
1650: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1651: , G_MODULE_NAME ||'Get_Parent_Mvt'||'. Others exception'
1652: , 'Exception'

Line 1650: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1646: x_movement_id := null;
1647: x_movement_status := null;
1648: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1649: THEN
1650: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1651: , G_MODULE_NAME ||'Get_Parent_Mvt'||'. Others exception'
1652: , 'Exception'
1653: );
1654: END IF;

Line 1679: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1675: )
1676: IS
1677: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Txn';
1678: BEGIN
1679: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1680: THEN
1681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1682: , G_MODULE_NAME || l_procedure_name || '.begin'
1683: ,'enter procedure'

Line 1681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1677: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_IO_Arrival_Txn';
1678: BEGIN
1679: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1680: THEN
1681: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1682: , G_MODULE_NAME || l_procedure_name || '.begin'
1683: ,'enter procedure'
1684: );
1685: END IF;

Line 1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1732: AND rcv.transaction_date BETWEEN p_start_date AND p_end_date
1733: ORDER BY rcv.transaction_id;
1734: END IF;
1735:
1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1737: THEN
1738: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1739: , G_MODULE_NAME || l_procedure_name || '.end'
1740: ,'exit procedure'

Line 1738: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1734: END IF;
1735:
1736: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1737: THEN
1738: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1739: , G_MODULE_NAME || l_procedure_name || '.end'
1740: ,'exit procedure'
1741: );
1742: END IF;

Line 1746: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1742: END IF;
1743: EXCEPTION
1744: WHEN NO_DATA_FOUND THEN
1745: x_return_status := 'N';
1746: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1747: THEN
1748: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1749: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1750: , 'Exception'

Line 1748: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1744: WHEN NO_DATA_FOUND THEN
1745: x_return_status := 'N';
1746: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1747: THEN
1748: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1749: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1750: , 'Exception'
1751: );
1752: END IF;

Line 1755: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1751: );
1752: END IF;
1753: WHEN OTHERS THEN
1754: x_return_status := 'N';
1755: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1756: THEN
1757: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1758: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1759: , 'Exception'

Line 1757: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1753: WHEN OTHERS THEN
1754: x_return_status := 'N';
1755: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1756: THEN
1757: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1758: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1759: , 'Exception'
1760: );
1761: END IF;

Line 1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1881: WHERE organization_id = x_movement_transaction.organization_id
1882: AND inventory_item_id = x_movement_transaction.inventory_item_id;
1883:
1884: BEGIN
1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1886: THEN
1887: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1888: , G_MODULE_NAME || l_procedure_name || '.begin'
1889: ,'enter procedure'

Line 1887: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1883:
1884: BEGIN
1885: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1886: THEN
1887: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1888: , G_MODULE_NAME || l_procedure_name || '.begin'
1889: ,'enter procedure'
1890: );
1891: END IF;

Line 1923: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1919: THEN
1920: CLOSE io_po_details;
1921: x_return_status := 'N';
1922:
1923: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1924: THEN
1925: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1926: , G_MODULE_NAME || l_procedure_name || '.end return N at io_po_details'
1927: ,'exit procedure'

Line 1925: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1921: x_return_status := 'N';
1922:
1923: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1924: THEN
1925: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1926: , G_MODULE_NAME || l_procedure_name || '.end return N at io_po_details'
1927: ,'exit procedure'
1928: );
1929: END IF;

Line 1945: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1941: , p_item_id => x_movement_transaction.inventory_item_id
1942: , p_transaction_date => x_movement_transaction.transaction_date
1943: );
1944:
1945: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1946: THEN
1947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1948: , G_MODULE_NAME || l_procedure_name
1949: ,'item_cost from OPM:' || x_movement_transaction.item_cost

Line 1947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1943: );
1944:
1945: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1946: THEN
1947: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1948: , G_MODULE_NAME || l_procedure_name
1949: ,'item_cost from OPM:' || x_movement_transaction.item_cost
1950: );
1951: END IF;

Line 1959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1955: FETCH c_item_cost INTO
1956: x_movement_transaction.item_cost;
1957: CLOSE c_item_cost;
1958:
1959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1960: THEN
1961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1962: , G_MODULE_NAME || l_procedure_name
1963: ,'item_cost from discrete:' || x_movement_transaction.item_cost

Line 1961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1957: CLOSE c_item_cost;
1958:
1959: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1960: THEN
1961: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1962: , G_MODULE_NAME || l_procedure_name
1963: ,'item_cost from discrete:' || x_movement_transaction.item_cost
1964: );
1965: END IF;

Line 2011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2007: THEN
2008: CLOSE io_so_details;
2009: x_return_status := 'N';
2010:
2011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2012: THEN
2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2014: , G_MODULE_NAME || l_procedure_name || '.end return N at io_so_details'
2015: ,'exit procedure'

Line 2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2009: x_return_status := 'N';
2010:
2011: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2012: THEN
2013: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2014: , G_MODULE_NAME || l_procedure_name || '.end return N at io_so_details'
2015: ,'exit procedure'
2016: );
2017: END IF;

Line 2048: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2044: ( x_movement_transaction => x_movement_transaction
2045: , x_return_status => x_return_status
2046: );
2047:
2048: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2049: THEN
2050: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2051: , G_MODULE_NAME || l_procedure_name || '.end'
2052: ,'exit procedure'

Line 2050: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2046: );
2047:
2048: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2049: THEN
2050: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2051: , G_MODULE_NAME || l_procedure_name || '.end'
2052: ,'exit procedure'
2053: );
2054: END IF;

Line 2058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2054: END IF;
2055: EXCEPTION
2056: WHEN NO_DATA_FOUND THEN
2057: x_return_status := 'N';
2058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2059: THEN
2060: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2061: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
2062: , 'Exception'

Line 2060: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2056: WHEN NO_DATA_FOUND THEN
2057: x_return_status := 'N';
2058: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2059: THEN
2060: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2061: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
2062: , 'Exception'
2063: );
2064: END IF;

Line 2067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2063: );
2064: END IF;
2065: WHEN OTHERS THEN
2066: x_return_status := 'N';
2067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2068: THEN
2069: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2070: , G_MODULE_NAME || l_procedure_name||'. Others exception'
2071: , 'Exception'

Line 2069: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2065: WHEN OTHERS THEN
2066: x_return_status := 'N';
2067: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2068: THEN
2069: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2070: , G_MODULE_NAME || l_procedure_name||'. Others exception'
2071: , 'Exception'
2072: );
2073: END IF;