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_SO_MDTR dependencies on FND_LOG

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

54: )
55: IS
56: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Transactions';
57: BEGIN
58: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
59: THEN
60: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
61: , G_MODULE_NAME || l_procedure_name || '.begin'
62: ,'enter procedure'

Line 60: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

56: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_SO_Transactions';
57: BEGIN
58: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
59: THEN
60: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
61: , G_MODULE_NAME || l_procedure_name || '.begin'
62: ,'enter procedure'
63: );
64: END IF;

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

192: AND wnd.initial_pickup_date is NOT NULL
193: AND wnd.name = p_movement_transaction.shipment_reference;
194: END IF;
195:
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
197: THEN
198: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
199: , G_MODULE_NAME || l_procedure_name || '.end'
200: ,'exit procedure'

Line 198: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

194: END IF;
195:
196: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
197: THEN
198: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
199: , G_MODULE_NAME || l_procedure_name || '.end'
200: ,'exit procedure'
201: );
202: END IF;

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

203:
204: EXCEPTION
205: WHEN NO_DATA_FOUND THEN
206: x_return_status := 'N';
207: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
208: THEN
209: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
210: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
211: , 'Exception'

Line 209: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

205: WHEN NO_DATA_FOUND THEN
206: x_return_status := 'N';
207: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
208: THEN
209: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
210: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
211: , 'Exception'
212: );
213: END IF;

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

212: );
213: END IF;
214: WHEN OTHERS THEN
215: x_return_status := 'N';
216: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
217: THEN
218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
219: , G_MODULE_NAME || l_procedure_name||'. Others exception'
220: , 'Exception'

Line 218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

214: WHEN OTHERS THEN
215: x_return_status := 'N';
216: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
217: THEN
218: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
219: , G_MODULE_NAME || l_procedure_name||'. Others exception'
220: , 'Exception'
221: );
222: END IF;

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

247: )
248: IS
249: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Triangulation_Txns';
250: BEGIN
251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
252: THEN
253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
254: , G_MODULE_NAME || l_procedure_name || '.begin'
255: ,'enter procedure'

Line 253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

249: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Triangulation_Txns';
250: BEGIN
251: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
252: THEN
253: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
254: , G_MODULE_NAME || l_procedure_name || '.begin'
255: ,'enter procedure'
256: );
257: END IF;

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

305: ('SOLD_TO', ol.sold_to_org_id
306: , null, null, ol.org_id);*/
307: END IF;
308:
309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
310: THEN
311: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
312: , G_MODULE_NAME || l_procedure_name || '.end'
313: ,'exit procedure'

Line 311: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

307: END IF;
308:
309: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
310: THEN
311: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
312: , G_MODULE_NAME || l_procedure_name || '.end'
313: ,'exit procedure'
314: );
315: END IF;

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

316:
317: EXCEPTION
318: WHEN NO_DATA_FOUND THEN
319: x_return_status := 'N';
320: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
321: THEN
322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
323: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
324: , 'Exception'

Line 322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

318: WHEN NO_DATA_FOUND THEN
319: x_return_status := 'N';
320: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
321: THEN
322: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
323: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
324: , 'Exception'
325: );
326: END IF;

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

325: );
326: END IF;
327: WHEN OTHERS THEN
328: x_return_status := 'N';
329: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
330: THEN
331: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
332: , G_MODULE_NAME || l_procedure_name||'. Others exception'
333: , 'Exception'

Line 331: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

327: WHEN OTHERS THEN
328: x_return_status := 'N';
329: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
330: THEN
331: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
332: , G_MODULE_NAME || l_procedure_name||'. Others exception'
333: , 'Exception'
334: );
335: END IF;

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

466: CST_ITEM_COSTS_FOR_GL_VIEW
467: WHERE organization_id = x_movement_transaction.organization_id
468: AND inventory_item_id = x_movement_transaction.inventory_item_id;
469: BEGIN
470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
471: THEN
472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
473: , G_MODULE_NAME || l_procedure_name || '.begin'
474: ,'enter procedure'

Line 472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

468: AND inventory_item_id = x_movement_transaction.inventory_item_id;
469: BEGIN
470: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
471: THEN
472: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
473: , G_MODULE_NAME || l_procedure_name || '.begin'
474: ,'enter procedure'
475: );
476: END IF;

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

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

Line 524: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

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

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

599: , p_item_id => x_movement_transaction.inventory_item_id
600: , p_transaction_date => x_movement_transaction.transaction_date
601: );
602:
603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
604: THEN
605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
606: , G_MODULE_NAME || l_procedure_name
607: ,'item_cost from OPM:' || x_movement_transaction.item_cost

Line 605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

601: );
602:
603: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
604: THEN
605: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
606: , G_MODULE_NAME || l_procedure_name
607: ,'item_cost from OPM:' || x_movement_transaction.item_cost
608: );
609: END IF;

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

614: FETCH c_item_cost INTO
615: x_movement_transaction.item_cost;
616: CLOSE c_item_cost;
617:
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
619: THEN
620: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
621: , G_MODULE_NAME || l_procedure_name
622: ,'item_cost from discrete:' || x_movement_transaction.item_cost

Line 620: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

616: CLOSE c_item_cost;
617:
618: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
619: THEN
620: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
621: , G_MODULE_NAME || l_procedure_name
622: ,'item_cost from discrete:' || x_movement_transaction.item_cost
623: );
624: END IF;

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

685: INV_MGD_MVT_UTILS_PKG.Convert_Territory_Code
686: (x_movement_transaction.triangulation_country_code);
687: END IF;
688:
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
690: THEN
691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
692: , G_MODULE_NAME || l_procedure_name || '.end'
693: ,'exit procedure'

Line 691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

687: END IF;
688:
689: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
690: THEN
691: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
692: , G_MODULE_NAME || l_procedure_name || '.end'
693: ,'exit procedure'
694: );
695: END IF;

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

695: END IF;
696: EXCEPTION
697: WHEN NO_DATA_FOUND THEN
698: x_return_status := 'N';
699: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
700: THEN
701: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
702: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
703: , 'Exception'

Line 701: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

697: WHEN NO_DATA_FOUND THEN
698: x_return_status := 'N';
699: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
700: THEN
701: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
702: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
703: , 'Exception'
704: );
705: END IF;

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

704: );
705: END IF;
706: WHEN OTHERS THEN
707: x_return_status := 'N';
708: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
709: THEN
710: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
711: , G_MODULE_NAME || l_procedure_name||'. Others exception'
712: , 'Exception'

Line 710: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

706: WHEN OTHERS THEN
707: x_return_status := 'N';
708: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
709: THEN
710: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
711: , G_MODULE_NAME || l_procedure_name||'. Others exception'
712: , 'Exception'
713: );
714: END IF;

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

750: WHERE oola.inventory_item_id = msi.inventory_item_id
751: AND oola.ship_from_org_id = msi.organization_id
752: AND line_id = p_link_to_line_id;
753: BEGIN
754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
755: THEN
756: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
757: , G_MODULE_NAME || l_procedure_name || '.begin'
758: ,'enter procedure'

Line 756: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

752: AND line_id = p_link_to_line_id;
753: BEGIN
754: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
755: THEN
756: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
757: , G_MODULE_NAME || l_procedure_name || '.begin'
758: ,'enter procedure'
759: );
760: END IF;

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

797:
798: --Create record for parent kit, so set line id to parent line id
799: x_movement_transaction.order_line_id := p_link_to_line_id;
800:
801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
802: THEN
803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
804: , G_MODULE_NAME || l_procedure_name || '.end'
805: ,'exit procedure'

Line 803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

799: x_movement_transaction.order_line_id := p_link_to_line_id;
800:
801: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
802: THEN
803: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
804: , G_MODULE_NAME || l_procedure_name || '.end'
805: ,'exit procedure'
806: );
807: END IF;

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

806: );
807: END IF;
808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
811: THEN
812: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
813: , G_MODULE_NAME || l_procedure_name
814: ,'when no data found exception'

Line 812: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

808: EXCEPTION
809: WHEN NO_DATA_FOUND THEN
810: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
811: THEN
812: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
813: , G_MODULE_NAME || l_procedure_name
814: ,'when no data found exception'
815: );
816: END IF;

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

815: );
816: END IF;
817:
818: WHEN OTHERS THEN
819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
820: THEN
821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
822: , G_MODULE_NAME || l_procedure_name
823: ,'when others exception'

Line 821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

817:
818: WHEN OTHERS THEN
819: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
820: THEN
821: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
822: , G_MODULE_NAME || l_procedure_name
823: ,'when others exception'
824: );
825: END IF;

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

862: po_requisition_lines_all
863: WHERE
864: requisition_line_id = x_movement_transaction.requisition_line_id;
865: BEGIN
866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
867: THEN
868: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
869: , G_MODULE_NAME || l_procedure_name || '.begin'
870: ,'enter procedure'

Line 868: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

864: requisition_line_id = x_movement_transaction.requisition_line_id;
865: BEGIN
866: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
867: THEN
868: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
869: , G_MODULE_NAME || l_procedure_name || '.begin'
870: ,'enter procedure'
871: );
872: END IF;

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

910: x_movement_transaction.customer_trx_line_id := null;
911: x_movement_transaction.financial_document_flag := 'NOT_REQUIRED';
912: x_movement_transaction.document_source_type := 'IO';
913:
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
915: THEN
916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
917: , G_MODULE_NAME || l_procedure_name || '.end'
918: ,'exit procedure'

Line 916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

912: x_movement_transaction.document_source_type := 'IO';
913:
914: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
915: THEN
916: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
917: , G_MODULE_NAME || l_procedure_name || '.end'
918: ,'exit procedure'
919: );
920: END IF;

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

921:
922: EXCEPTION
923: WHEN NO_DATA_FOUND THEN
924: x_return_status := 'N';
925: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
926: THEN
927: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
928: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
929: , 'Exception'

Line 927: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

923: WHEN NO_DATA_FOUND THEN
924: x_return_status := 'N';
925: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
926: THEN
927: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
928: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
929: , 'Exception'
930: );
931: END IF;

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

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

Line 936: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

958: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
959: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
960: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_SO_Transactions';
961: BEGIN
962: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
963: THEN
964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
965: , G_MODULE_NAME || l_procedure_name || '.begin'
966: ,'enter procedure'

Line 964: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

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

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

1009: , movement_id = p_movement_transaction.movement_id
1010: WHERE delivery_detail_id = p_movement_transaction.picking_line_detail_id;
1011: END IF;
1012:
1013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1014: THEN
1015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1016: , G_MODULE_NAME || l_procedure_name || '.end'
1017: ,'exit procedure'

Line 1015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1011: END IF;
1012:
1013: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1014: THEN
1015: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1016: , G_MODULE_NAME || l_procedure_name || '.end'
1017: ,'exit procedure'
1018: );
1019: END IF;

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

1020:
1021: EXCEPTION
1022: WHEN NO_DATA_FOUND THEN
1023: x_return_status := 'N';
1024: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1025: THEN
1026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1027: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1028: , 'Exception'

Line 1026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1022: WHEN NO_DATA_FOUND THEN
1023: x_return_status := 'N';
1024: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1025: THEN
1026: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1027: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1028: , 'Exception'
1029: );
1030: END IF;

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

1029: );
1030: END IF;
1031: WHEN OTHERS THEN
1032: x_return_status := 'N';
1033: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1034: THEN
1035: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1036: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1037: , 'Exception'

Line 1035: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1031: WHEN OTHERS THEN
1032: x_return_status := 'N';
1033: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1034: THEN
1035: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1036: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1037: , 'Exception'
1038: );
1039: END IF;

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

1058: l_shipment_transaction INV_MGD_MVT_DATA_STR.Shipment_Transaction_Rec_Type;
1059: l_mvt_stat_status wsh_delivery_details.mvt_stat_status%TYPE;
1060: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_KIT_SO_Transactions';
1061: BEGIN
1062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1063: THEN
1064: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1065: , G_MODULE_NAME || l_procedure_name || '.begin'
1066: ,'enter procedure'

Line 1064: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1060: l_procedure_name CONSTANT VARCHAR2(30) := 'Update_KIT_SO_Transactions';
1061: BEGIN
1062: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1063: THEN
1064: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1065: , G_MODULE_NAME || l_procedure_name || '.begin'
1066: ,'enter procedure'
1067: );
1068: END IF;

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

1117: FROM oe_order_lines_all
1118: WHERE link_to_line_id = p_link_to_line_id);
1119: END IF;
1120:
1121: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1122: THEN
1123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1124: , G_MODULE_NAME || l_procedure_name || '.end'
1125: ,'exit procedure'

Line 1123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1119: END IF;
1120:
1121: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1122: THEN
1123: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1124: , G_MODULE_NAME || l_procedure_name || '.end'
1125: ,'exit procedure'
1126: );
1127: END IF;

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

1128:
1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN
1131: x_return_status := 'N';
1132: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1133: THEN
1134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1135: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1136: , 'Exception'

Line 1134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1130: WHEN NO_DATA_FOUND THEN
1131: x_return_status := 'N';
1132: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1133: THEN
1134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1135: , G_MODULE_NAME || l_procedure_name||'. No data found exception'
1136: , 'Exception'
1137: );
1138: END IF;

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

1137: );
1138: END IF;
1139: WHEN OTHERS THEN
1140: x_return_status := 'N';
1141: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1142: THEN
1143: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1144: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1145: , 'Exception'

Line 1143: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1139: WHEN OTHERS THEN
1140: x_return_status := 'N';
1141: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1142: THEN
1143: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1144: , G_MODULE_NAME || l_procedure_name||'. Others exception'
1145: , 'Exception'
1146: );
1147: END IF;

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

1173: wsh_delivery_details
1174: WHERE
1175: delivery_detail_id = p_delivery_detail_id;
1176: BEGIN
1177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1178: THEN
1179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1180: , G_MODULE_NAME || l_function_name || '.begin'
1181: ,'enter procedure'

Line 1179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1175: delivery_detail_id = p_delivery_detail_id;
1176: BEGIN
1177: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1178: THEN
1179: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1180: , G_MODULE_NAME || l_function_name || '.begin'
1181: ,'enter procedure'
1182: );
1183: END IF;

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

1195: ELSE
1196: l_kit_status := 'N';
1197: END IF;
1198:
1199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1200: THEN
1201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1202: , G_MODULE_NAME || l_function_name || '.end'
1203: ,'exit procedure'

Line 1201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1197: END IF;
1198:
1199: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1200: THEN
1201: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1202: , G_MODULE_NAME || l_function_name || '.end'
1203: ,'exit procedure'
1204: );
1205: END IF;

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

1207: RETURN (l_kit_status);
1208:
1209: EXCEPTION
1210: WHEN NO_DATA_FOUND THEN
1211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1212: THEN
1213: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1214: , G_MODULE_NAME || l_function_name||'. No data found exception'
1215: , 'Exception'

Line 1213: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1209: EXCEPTION
1210: WHEN NO_DATA_FOUND THEN
1211: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1212: THEN
1213: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1214: , G_MODULE_NAME || l_function_name||'. No data found exception'
1215: , 'Exception'
1216: );
1217: END IF;

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

1217: END IF;
1218: RETURN null;
1219: WHEN TOO_MANY_ROWS
1220: THEN
1221: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1222: THEN
1223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1224: , G_MODULE_NAME || l_function_name||'. too many rows exception'
1225: , 'Exception'

Line 1223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1219: WHEN TOO_MANY_ROWS
1220: THEN
1221: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1222: THEN
1223: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1224: , G_MODULE_NAME || l_function_name||'. too many rows exception'
1225: , 'Exception'
1226: );
1227: END IF;

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

1226: );
1227: END IF;
1228: RETURN null;
1229: WHEN OTHERS THEN
1230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1231: THEN
1232: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1233: , G_MODULE_NAME || l_function_name||'. Others exception'
1234: , 'Exception'

Line 1232: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1228: RETURN null;
1229: WHEN OTHERS THEN
1230: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1231: THEN
1232: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1233: , G_MODULE_NAME || l_function_name||'. Others exception'
1234: , 'Exception'
1235: );
1236: END IF;

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

1261: wsh_delivery_details
1262: WHERE
1263: delivery_detail_id = p_delivery_detail_id;
1264: BEGIN
1265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1266: THEN
1267: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1268: , G_MODULE_NAME || l_api_name || '.begin'
1269: ,'enter procedure'

Line 1267: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1263: delivery_detail_id = p_delivery_detail_id;
1264: BEGIN
1265: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1266: THEN
1267: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1268: , G_MODULE_NAME || l_api_name || '.begin'
1269: ,'enter procedure'
1270: );
1271: END IF;

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

1283: ELSE
1284: l_kit_status := 'N';
1285: END IF;
1286:
1287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1288: THEN
1289: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1290: , G_MODULE_NAME || l_api_name || '.end'
1291: ,'exit procedure'

Line 1289: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1285: END IF;
1286:
1287: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1288: THEN
1289: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1290: , G_MODULE_NAME || l_api_name || '.end'
1291: ,'exit procedure'
1292: );
1293: END IF;

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

1295: RETURN (l_kit_status);
1296:
1297: EXCEPTION
1298: WHEN NO_DATA_FOUND THEN
1299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1302: , G_MODULE_NAME || l_api_name||'. No data found exception'
1303: , 'Exception'

Line 1301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1297: EXCEPTION
1298: WHEN NO_DATA_FOUND THEN
1299: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1300: THEN
1301: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1302: , G_MODULE_NAME || l_api_name||'. No data found exception'
1303: , 'Exception'
1304: );
1305: END IF;

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

1305: END IF;
1306: RETURN null;
1307: WHEN TOO_MANY_ROWS
1308: THEN
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_api_name||'. too many rows exception'
1313: , 'Exception'

Line 1311: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1307: WHEN TOO_MANY_ROWS
1308: THEN
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_api_name||'. too many rows exception'
1313: , 'Exception'
1314: );
1315: END IF;

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

1314: );
1315: END IF;
1316: RETURN null;
1317: WHEN OTHERS THEN
1318: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1319: THEN
1320: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1321: , G_MODULE_NAME || l_api_name||'. Others exception'
1322: , 'Exception'

Line 1320: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1316: RETURN null;
1317: WHEN OTHERS THEN
1318: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1319: THEN
1320: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1321: , G_MODULE_NAME || l_api_name||'. Others exception'
1322: , 'Exception'
1323: );
1324: END IF;