APPS.INV_MGD_MVT_UTILS_PKG dependencies on FND_LOG

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

91: l_rounding_method VARCHAR2(30);
92: l_total_weight NUMBER;
93:
94: BEGIN
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
96: THEN
97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
98: , G_MODULE_NAME || l_procedure_name || '.begin'
99: ,'enter procedure'

Line 97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

93:
94: BEGIN
95: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
96: THEN
97: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
98: , G_MODULE_NAME || l_procedure_name || '.begin'
99: ,'enter procedure'
100: );
101: END IF;

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

248: x_movement_transaction.destination_territory_eu_code :=
249: Convert_Territory_Code (x_movement_transaction.destination_territory_code);
250: END IF;
251:
252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
253: THEN
254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
255: , G_MODULE_NAME || l_procedure_name || '.end'
256: ,'exit procedure'

Line 254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

250: END IF;
251:
252: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
253: THEN
254: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
255: , G_MODULE_NAME || l_procedure_name || '.end'
256: ,'exit procedure'
257: );
258: END IF;

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

260: WHEN g_period_name_not_found_exc THEN
261:
262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263:
264: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
267: , G_MODULE_NAME || l_procedure_name
268: ,'Mvt_Stats_Util_Info: GL Period is not defined. '

Line 266: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

262: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263:
264: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
265: THEN
266: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
267: , G_MODULE_NAME || l_procedure_name
268: ,'Mvt_Stats_Util_Info: GL Period is not defined. '
269: || 'Please define the GL Period for the transaction date '
270: || x_movement_transaction.transaction_date

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

294: x_movement_transaction := l_movement_transaction;
295:
296: WHEN NO_DATA_FOUND THEN
297: x_movement_transaction := l_movement_transaction;
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
302: , 'Exception'

Line 300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

296: WHEN NO_DATA_FOUND THEN
297: x_movement_transaction := l_movement_transaction;
298: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
299: THEN
300: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
301: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
302: , 'Exception'
303: );
304: END IF;

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

304: END IF;
305:
306: WHEN TOO_MANY_ROWS THEN
307: x_movement_transaction := l_movement_transaction;
308: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
309: THEN
310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
311: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
312: , 'Exception'

Line 310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

306: WHEN TOO_MANY_ROWS THEN
307: x_movement_transaction := l_movement_transaction;
308: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
309: THEN
310: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
311: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
312: , 'Exception'
313: );
314: END IF;

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

315:
316: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: x_movement_transaction := l_movement_transaction;
319: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
320: THEN
321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
322: , G_MODULE_NAME || l_procedure_name||'.unexpected exception'
323: , 'Exception'

Line 321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

317: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
318: x_movement_transaction := l_movement_transaction;
319: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
320: THEN
321: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
322: , G_MODULE_NAME || l_procedure_name||'.unexpected exception'
323: , 'Exception'
324: );
325: END IF;

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

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

Line 333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

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

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

395: RETURN (l_rate);
396:
397: EXCEPTION
398: WHEN OTHERS THEN
399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
400: THEN
401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
402: , G_MODULE_NAME || 'Get_Conversion_Rate'||'.Others exception'
403: , 'Exception'

Line 401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

397: EXCEPTION
398: WHEN OTHERS THEN
399: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
400: THEN
401: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
402: , G_MODULE_NAME || 'Get_Conversion_Rate'||'.Others exception'
403: , 'Exception'
404: );
405: END IF;

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

453: RETURN (l_conversion_rate);
454:
455: EXCEPTION
456: WHEN OTHERS THEN
457: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
458: THEN
459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
460: , G_MODULE_NAME || 'Get_Rate_Two_Uom'||'.Others exception'
461: , 'Exception'

Line 459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

455: EXCEPTION
456: WHEN OTHERS THEN
457: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
458: THEN
459: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
460: , G_MODULE_NAME || 'Get_Rate_Two_Uom'||'.Others exception'
461: , 'Exception'
462: );
463: END IF;

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

494: l_rate1 NUMBER;
495: l_rate2 NUMBER;
496: l_procedure_name CONSTANT VARCHAR2(30) := 'Calc_Unit_Weight';
497: BEGIN
498: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
499: THEN
500: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
501: , G_MODULE_NAME || l_procedure_name || '.begin'
502: ,'enter procedure'

Line 500: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

496: l_procedure_name CONSTANT VARCHAR2(30) := 'Calc_Unit_Weight';
497: BEGIN
498: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
499: THEN
500: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
501: , G_MODULE_NAME || l_procedure_name || '.begin'
502: ,'enter procedure'
503: );
504: END IF;

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

614: ELSE
615: l_unit_weight := null;
616: END IF;
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 || '.end'
622: ,'exit procedure'

Line 620: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

616: END IF;
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 || '.end'
622: ,'exit procedure'
623: );
624: END IF;

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

626: RETURN round(l_unit_weight,10); -- Fix bug 4197941
627:
628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
631: THEN
632: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
633: , G_MODULE_NAME || l_procedure_name||'.Others exception'
634: , 'Exception'

Line 632: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

628: EXCEPTION
629: WHEN OTHERS THEN
630: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
631: THEN
632: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
633: , G_MODULE_NAME || l_procedure_name||'.Others exception'
634: , 'Exception'
635: );
636: END IF;

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

698: RETURN(l_weight);
699:
700: EXCEPTION
701: WHEN OTHERS THEN
702: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
703: THEN
704: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
705: , G_MODULE_NAME ||'Calc_Total_Weight'||'.Others exception'
706: , 'Exception'

Line 704: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

700: EXCEPTION
701: WHEN OTHERS THEN
702: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
703: THEN
704: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
705: , G_MODULE_NAME ||'Calc_Total_Weight'||'.Others exception'
706: , 'Exception'
707: );
708: END IF;

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

734: l_alternate_quantity NUMBER;
735: l_procedure_name CONSTANT VARCHAR2(30) := 'Convert_alternate_Quantity';
736:
737: BEGIN
738: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
739: THEN
740: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
741: , G_MODULE_NAME || l_procedure_name || '.begin'
742: ,'enter procedure'

Line 740: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

736:
737: BEGIN
738: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
739: THEN
740: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
741: , G_MODULE_NAME || l_procedure_name || '.begin'
742: ,'enter procedure'
743: );
744: END IF;

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

752: -- Calculate alternate quantity
753: l_alternate_quantity :=
754: p_transaction_quantity * round(l_conv_rate,3);
755:
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
757: THEN
758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
759: , G_MODULE_NAME || l_procedure_name || '.end'
760: ,'exit procedure'

Line 758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

754: p_transaction_quantity * round(l_conv_rate,3);
755:
756: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
757: THEN
758: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
759: , G_MODULE_NAME || l_procedure_name || '.end'
760: ,'exit procedure'
761: );
762: END IF;

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

764: RETURN l_alternate_quantity;
765:
766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN
768: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
769: THEN
770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
771: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
772: , 'Exception'

Line 770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

766: EXCEPTION
767: WHEN NO_DATA_FOUND THEN
768: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
769: THEN
770: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
771: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
772: , 'Exception'
773: );
774: END IF;

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

775: l_alternate_quantity := null;
776: RETURN (l_alternate_quantity);
777:
778: WHEN OTHERS THEN
779: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
780: THEN
781: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
782: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
783: , 'Exception'

Line 781: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

777:
778: WHEN OTHERS THEN
779: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
780: THEN
781: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
782: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
783: , 'Exception'
784: );
785: END IF;

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

806: IS
807: l_alt_uom_code VARCHAR2(50);
808: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Alternate_UOM';
809: BEGIN
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 || '.begin'
814: ,'enter procedure'

Line 812: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

808: l_procedure_name CONSTANT VARCHAR2(30) := 'Get_Alternate_UOM';
809: BEGIN
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 || '.begin'
814: ,'enter procedure'
815: );
816: END IF;

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

823: AND RS.category_set_id = p_category_set_id
824: AND RS.rule_set_type = 'ALTERNATE_UOM'
825: AND R.rule_set_code = p_alt_uom_rule_set_code;
826:
827: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
830: , G_MODULE_NAME || l_procedure_name || '.end'
831: ,'exit procedure'

Line 829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

825: AND R.rule_set_code = p_alt_uom_rule_set_code;
826:
827: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
828: THEN
829: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
830: , G_MODULE_NAME || l_procedure_name || '.end'
831: ,'exit procedure'
832: );
833: END IF;

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

835: RETURN l_alt_uom_code;
836:
837: EXCEPTION
838: WHEN NO_DATA_FOUND THEN
839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
840: THEN
841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
842: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
843: , 'Exception'

Line 841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

837: EXCEPTION
838: WHEN NO_DATA_FOUND THEN
839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
840: THEN
841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
842: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
843: , 'Exception'
844: );
845: END IF;

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

846: l_alt_uom_code := null;
847: RETURN (l_alt_uom_code);
848:
849: WHEN OTHERS THEN
850: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
851: THEN
852: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
853: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
854: , 'Exception'

Line 852: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

848:
849: WHEN OTHERS THEN
850: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
851: THEN
852: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
853: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
854: , 'Exception'
855: );
856: END IF;

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

897: RETURN(l_code);
898:
899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
902: THEN
903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
904: , G_MODULE_NAME ||'Convert_Territory_Code'||'.No data found exception'
905: , 'Exception'

Line 903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

899: EXCEPTION
900: WHEN NO_DATA_FOUND THEN
901: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
902: THEN
903: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
904: , G_MODULE_NAME ||'Convert_Territory_Code'||'.No data found exception'
905: , 'Exception'
906: );
907: END IF;

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

908: l_code := null;
909: RETURN(l_code);
910:
911: WHEN OTHERS THEN
912: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
913: THEN
914: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
915: , G_MODULE_NAME ||'Convert_Territory_Code'||'.Others exception'
916: , 'Exception'

Line 914: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

910:
911: WHEN OTHERS THEN
912: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
913: THEN
914: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
915: , G_MODULE_NAME ||'Convert_Territory_Code'||'.Others exception'
916: , 'Exception'
917: );
918: END IF;

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

953: AND si.organization_id = p_movement_Transaction.organization_id
954: AND sic.category_set_id = p_stat_typ_transaction.category_set_id;
955:
956: BEGIN
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
958: THEN
959: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
960: , G_MODULE_NAME || l_procedure_name || '.begin'
961: ,'enter procedure'

Line 959: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

955:
956: BEGIN
957: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
958: THEN
959: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
960: , G_MODULE_NAME || l_procedure_name || '.begin'
961: ,'enter procedure'
962: );
963: END IF;

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

973: END IF;
974:
975: CLOSE c_ccode;
976:
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
978: THEN
979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
980: , G_MODULE_NAME || l_procedure_name || '.end'
981: ,'exit procedure'

Line 979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

975: CLOSE c_ccode;
976:
977: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
978: THEN
979: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
980: , G_MODULE_NAME || l_procedure_name || '.end'
981: ,'exit procedure'
982: );
983: END IF;

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

985: RETURN(l_category_id);
986:
987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
990: THEN
991: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
992: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
993: , 'Exception'

Line 991: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

987: EXCEPTION
988: WHEN NO_DATA_FOUND THEN
989: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
990: THEN
991: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
992: , G_MODULE_NAME || l_procedure_name||'.No data found exception'
993: , 'Exception'
994: );
995: END IF;

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

997: RETURN(l_category_id);
998:
999: WHEN TOO_MANY_ROWS
1000: THEN
1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1002: THEN
1003: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1004: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
1005: , 'Exception'

Line 1003: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

999: WHEN TOO_MANY_ROWS
1000: THEN
1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1002: THEN
1003: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1004: , G_MODULE_NAME || l_procedure_name||'.too many rows exception'
1005: , 'Exception'
1006: );
1007: END IF;

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

1008: l_category_id := null;
1009: RETURN(l_category_id);
1010:
1011: WHEN OTHERS THEN
1012: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1013: THEN
1014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1015: , G_MODULE_NAME || l_procedure_name||'.Others exception'
1016: , 'Exception'

Line 1014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1010:
1011: WHEN OTHERS THEN
1012: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1013: THEN
1014: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1015: , G_MODULE_NAME || l_procedure_name||'.Others exception'
1016: , 'Exception'
1017: );
1018: END IF;

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

1048: WHERE mic.category_id = mkv.category_id
1049: AND mic.category_id = x_movement_transaction.category_id;
1050:
1051: BEGIN
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1055: , G_MODULE_NAME || l_procedure_name || '.begin'
1056: ,'enter procedure'

Line 1054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1050:
1051: BEGIN
1052: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1053: THEN
1054: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1055: , G_MODULE_NAME || l_procedure_name || '.begin'
1056: ,'enter procedure'
1057: );
1058: END IF;

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

1065: x_movement_transaction.commodity_code
1066: , x_movement_transaction.commodity_description;
1067: CLOSE l_com;
1068:
1069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1070: THEN
1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1072: , G_MODULE_NAME || l_procedure_name || '.end'
1073: ,'exit procedure'

Line 1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1067: CLOSE l_com;
1068:
1069: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1070: THEN
1071: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1072: , G_MODULE_NAME || l_procedure_name || '.end'
1073: ,'exit procedure'
1074: );
1075: END IF;

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

1074: );
1075: END IF;
1076: EXCEPTION
1077: WHEN NO_DATA_FOUND THEN
1078: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1079: THEN
1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1081: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
1082: , 'Exception'

Line 1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1076: EXCEPTION
1077: WHEN NO_DATA_FOUND THEN
1078: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1079: THEN
1080: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1081: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
1082: , 'Exception'
1083: );
1084: END IF;

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

1084: END IF;
1085: x_movement_transaction := l_movement_transaction;
1086:
1087: WHEN OTHERS THEN
1088: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1089: THEN
1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1091: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
1092: , 'Exception'

Line 1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1086:
1087: WHEN OTHERS THEN
1088: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1089: THEN
1090: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1091: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
1092: , 'Exception'
1093: );
1094: END IF;

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

1120: OE_ORDER_HEADERS_ALL oh
1121: WHERE oh.header_id = x_movement_transaction.order_header_id;
1122:
1123: BEGIN
1124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1127: , G_MODULE_NAME || l_procedure_name || '.begin'
1128: ,'enter procedure'

Line 1126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1122:
1123: BEGIN
1124: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1125: THEN
1126: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1127: , G_MODULE_NAME || l_procedure_name || '.begin'
1128: ,'enter procedure'
1129: );
1130: END IF;

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

1137: x_movement_transaction.order_number
1138: , x_movement_transaction.org_id;
1139: CLOSE l_on;
1140:
1141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1142: THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1144: , G_MODULE_NAME || l_procedure_name || '.end'
1145: ,'exit procedure'

Line 1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

1139: CLOSE l_on;
1140:
1141: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1142: THEN
1143: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
1144: , G_MODULE_NAME || l_procedure_name || '.end'
1145: ,'exit procedure'
1146: );
1147: END IF;

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

1146: );
1147: END IF;
1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN
1150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1151: THEN
1152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1153: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
1154: , 'Exception'

Line 1152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1148: EXCEPTION
1149: WHEN NO_DATA_FOUND THEN
1150: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1151: THEN
1152: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1153: , G_MODULE_NAME ||l_procedure_name||'.No data found exception'
1154: , 'Exception'
1155: );
1156: END IF;

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

1155: );
1156: END IF;
1157: x_movement_transaction := l_movement_transaction;
1158: WHEN OTHERS THEN
1159: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1160: THEN
1161: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1162: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
1163: , 'Exception'

Line 1161: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1157: x_movement_transaction := l_movement_transaction;
1158: WHEN OTHERS THEN
1159: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1160: THEN
1161: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1162: , G_MODULE_NAME ||l_procedure_name||'.Others exception'
1163: , 'Exception'
1164: );
1165: END IF;

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

1225: RETURN l_site_location;
1226:
1227: EXCEPTION
1228: WHEN NO_DATA_FOUND THEN
1229: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1230: THEN
1231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1232: , G_MODULE_NAME ||'Get_Site_Location'||'.No data found exception'
1233: , 'Exception'

Line 1231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1227: EXCEPTION
1228: WHEN NO_DATA_FOUND THEN
1229: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1230: THEN
1231: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1232: , G_MODULE_NAME ||'Get_Site_Location'||'.No data found exception'
1233: , 'Exception'
1234: );
1235: END IF;

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

1235: END IF;
1236: RETURN null;
1237: WHEN TOO_MANY_ROWS
1238: THEN
1239: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1240: THEN
1241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1242: , G_MODULE_NAME ||'Get_Site_Location'||'.too many rows exception'
1243: , 'Exception'

Line 1241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1237: WHEN TOO_MANY_ROWS
1238: THEN
1239: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1240: THEN
1241: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1242: , G_MODULE_NAME ||'Get_Site_Location'||'.too many rows exception'
1243: , 'Exception'
1244: );
1245: END IF;

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

1244: );
1245: END IF;
1246: RETURN null;
1247: WHEN OTHERS THEN
1248: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1249: THEN
1250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1251: , G_MODULE_NAME ||'Get_Site_Location'||'.Others exception'
1252: , 'Exception'

Line 1250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1246: RETURN null;
1247: WHEN OTHERS THEN
1248: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1249: THEN
1250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1251: , G_MODULE_NAME ||'Get_Site_Location'||'.Others exception'
1252: , 'Exception'
1253: );
1254: END IF;

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

1308: RETURN l_org_location;
1309:
1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1313: THEN
1314: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1315: , G_MODULE_NAME ||'Get_Org_Location'||'.No data found exception'
1316: , 'Exception'

Line 1314: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1310: EXCEPTION
1311: WHEN NO_DATA_FOUND THEN
1312: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1313: THEN
1314: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1315: , G_MODULE_NAME ||'Get_Org_Location'||'.No data found exception'
1316: , 'Exception'
1317: );
1318: END IF;

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

1318: END IF;
1319: RETURN null;
1320: WHEN TOO_MANY_ROWS
1321: THEN
1322: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1323: THEN
1324: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1325: , G_MODULE_NAME ||'Get_Org_Location'||'.too many rows exception'
1326: , 'Exception'

Line 1324: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1320: WHEN TOO_MANY_ROWS
1321: THEN
1322: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1323: THEN
1324: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1325: , G_MODULE_NAME ||'Get_Org_Location'||'.too many rows exception'
1326: , 'Exception'
1327: );
1328: END IF;

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

1327: );
1328: END IF;
1329: RETURN null;
1330: WHEN OTHERS THEN
1331: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1332: THEN
1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1334: , G_MODULE_NAME ||'Get_Org_Location'||'.Others exception'
1335: , 'Exception'

Line 1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1329: RETURN null;
1330: WHEN OTHERS THEN
1331: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1332: THEN
1333: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1334: , G_MODULE_NAME ||'Get_Org_Location'||'.Others exception'
1335: , 'Exception'
1336: );
1337: END IF;

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

1399:
1400: RETURN l_subinv_location;
1401: EXCEPTION
1402: WHEN NO_DATA_FOUND THEN
1403: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1404: THEN
1405: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1406: , G_MODULE_NAME ||'Get_subinv_Location'||'.No data found exception'
1407: , 'Exception'

Line 1405: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1401: EXCEPTION
1402: WHEN NO_DATA_FOUND THEN
1403: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1404: THEN
1405: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1406: , G_MODULE_NAME ||'Get_subinv_Location'||'.No data found exception'
1407: , 'Exception'
1408: );
1409: END IF;

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

1409: END IF;
1410: RETURN null;
1411: WHEN TOO_MANY_ROWS
1412: THEN
1413: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1414: THEN
1415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1416: , G_MODULE_NAME ||'Get_subinv_Location'||'.too many rows exception'
1417: , 'Exception'

Line 1415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1411: WHEN TOO_MANY_ROWS
1412: THEN
1413: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1414: THEN
1415: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1416: , G_MODULE_NAME ||'Get_subinv_Location'||'.too many rows exception'
1417: , 'Exception'
1418: );
1419: END IF;

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

1418: );
1419: END IF;
1420: RETURN null;
1421: WHEN OTHERS THEN
1422: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1423: THEN
1424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1425: , G_MODULE_NAME ||'Get_subinv_Location'||'.Others exception'
1426: , 'Exception'

Line 1424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1420: RETURN null;
1421: WHEN OTHERS THEN
1422: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1423: THEN
1424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1425: , G_MODULE_NAME ||'Get_subinv_Location'||'.Others exception'
1426: , 'Exception'
1427: );
1428: END IF;

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

1461: RETURN l_vendor_location;
1462:
1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1466: THEN
1467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1468: , G_MODULE_NAME ||'Get_Vendor_Location'||'.No data found exception'
1469: , 'Exception'

Line 1467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1463: EXCEPTION
1464: WHEN NO_DATA_FOUND THEN
1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1466: THEN
1467: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1468: , G_MODULE_NAME ||'Get_Vendor_Location'||'.No data found exception'
1469: , 'Exception'
1470: );
1471: END IF;

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

1471: END IF;
1472: RETURN null;
1473: WHEN TOO_MANY_ROWS
1474: THEN
1475: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1476: THEN
1477: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1478: , G_MODULE_NAME ||'Get_Vendor_Location'||'.too many rows exception'
1479: , 'Exception'

Line 1477: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1473: WHEN TOO_MANY_ROWS
1474: THEN
1475: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1476: THEN
1477: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1478: , G_MODULE_NAME ||'Get_Vendor_Location'||'.too many rows exception'
1479: , 'Exception'
1480: );
1481: END IF;

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

1480: );
1481: END IF;
1482: RETURN null;
1483: WHEN OTHERS THEN
1484: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1485: THEN
1486: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1487: , G_MODULE_NAME ||'Get_Vendor_Location'||'.Others exception'
1488: , 'Exception'

Line 1486: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1482: RETURN null;
1483: WHEN OTHERS THEN
1484: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1485: THEN
1486: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1487: , G_MODULE_NAME ||'Get_Vendor_Location'||'.Others exception'
1488: , 'Exception'
1489: );
1490: END IF;

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

1537: RETURN l_zone_code;
1538:
1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1542: THEN
1543: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1544: , G_MODULE_NAME ||'Get_Zone_Code'||'.No data found exception'
1545: , 'Exception'

Line 1543: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1539: EXCEPTION
1540: WHEN NO_DATA_FOUND THEN
1541: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1542: THEN
1543: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1544: , G_MODULE_NAME ||'Get_Zone_Code'||'.No data found exception'
1545: , 'Exception'
1546: );
1547: END IF;

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

1547: END IF;
1548: RETURN null;
1549: WHEN TOO_MANY_ROWS
1550: THEN
1551: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1552: THEN
1553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1554: , G_MODULE_NAME ||'Get_Zone_Code'||'.too many rows exception'
1555: , 'Exception'

Line 1553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1549: WHEN TOO_MANY_ROWS
1550: THEN
1551: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1552: THEN
1553: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1554: , G_MODULE_NAME ||'Get_Zone_Code'||'.too many rows exception'
1555: , 'Exception'
1556: );
1557: END IF;

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

1556: );
1557: END IF;
1558: RETURN null;
1559: WHEN OTHERS THEN
1560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1561: THEN
1562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1563: , G_MODULE_NAME ||'Get_Zone_Code'||'.Others exception'
1564: , 'Exception'

Line 1562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1558: RETURN null;
1559: WHEN OTHERS THEN
1560: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1561: THEN
1562: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1563: , G_MODULE_NAME ||'Get_Zone_Code'||'.Others exception'
1564: , 'Exception'
1565: );
1566: END IF;

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

1612: CLOSE l_ven;
1613:
1614: EXCEPTION
1615: WHEN NO_DATA_FOUND THEN
1616: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1617: THEN
1618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1619: , G_MODULE_NAME ||'Get_Vendor_Info'||'.No data found exception'
1620: , 'Exception'

Line 1618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1614: EXCEPTION
1615: WHEN NO_DATA_FOUND THEN
1616: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1617: THEN
1618: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1619: , G_MODULE_NAME ||'Get_Vendor_Info'||'.No data found exception'
1620: , 'Exception'
1621: );
1622: END IF;

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

1622: END IF;
1623: x_movement_transaction := l_movement_transaction;
1624:
1625: WHEN OTHERS THEN
1626: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1627: THEN
1628: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1629: , G_MODULE_NAME ||'Get_Vendor_Info'||'.Others exception'
1630: , 'Exception'

Line 1628: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1624:
1625: WHEN OTHERS THEN
1626: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1627: THEN
1628: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1629: , G_MODULE_NAME ||'Get_Vendor_Info'||'.Others exception'
1630: , 'Exception'
1631: );
1632: END IF;

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

1665: RETURN l_vat_number;
1666:
1667: EXCEPTION
1668: WHEN NO_DATA_FOUND THEN
1669: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1670: THEN
1671: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1672: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.No data found exception'
1673: , 'Exception'

Line 1671: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1667: EXCEPTION
1668: WHEN NO_DATA_FOUND THEN
1669: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1670: THEN
1671: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1672: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.No data found exception'
1673: , 'Exception'
1674: );
1675: END IF;

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

1675: END IF;
1676: RETURN null;
1677: WHEN TOO_MANY_ROWS
1678: THEN
1679: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1680: THEN
1681: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1682: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.too many rows exception'
1683: , 'Exception'

Line 1681: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1677: WHEN TOO_MANY_ROWS
1678: THEN
1679: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1680: THEN
1681: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1682: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.too many rows exception'
1683: , 'Exception'
1684: );
1685: END IF;

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

1684: );
1685: END IF;
1686: RETURN null;
1687: WHEN OTHERS THEN
1688: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1689: THEN
1690: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1691: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.Others exception'
1692: , 'Exception'

Line 1690: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1686: RETURN null;
1687: WHEN OTHERS THEN
1688: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1689: THEN
1690: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1691: , G_MODULE_NAME ||'Get_Cust_VAT_Number'||'.Others exception'
1692: , 'Exception'
1693: );
1694: END IF;

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

1731: RETURN SUBSTR(l_vat_number,1,50);
1732:
1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN
1735: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1736: THEN
1737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1738: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.No data found exception'
1739: , 'Exception'

Line 1737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1733: EXCEPTION
1734: WHEN NO_DATA_FOUND THEN
1735: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1736: THEN
1737: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1738: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.No data found exception'
1739: , 'Exception'
1740: );
1741: END IF;

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

1741: END IF;
1742: RETURN null;
1743: WHEN TOO_MANY_ROWS
1744: THEN
1745: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1746: THEN
1747: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1748: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.too many rows exception'
1749: , 'Exception'

Line 1747: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1743: WHEN TOO_MANY_ROWS
1744: THEN
1745: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1746: THEN
1747: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1748: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.too many rows exception'
1749: , 'Exception'
1750: );
1751: END IF;

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

1750: );
1751: END IF;
1752: RETURN null;
1753: WHEN OTHERS THEN
1754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1755: THEN
1756: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1757: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.Others exception'
1758: , 'Exception'

Line 1756: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1752: RETURN null;
1753: WHEN OTHERS THEN
1754: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1755: THEN
1756: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1757: , G_MODULE_NAME ||'Get_Org_VAT_Number'||'.Others exception'
1758: , 'Exception'
1759: );
1760: END IF;

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

1825:
1826: RETURN l_so_le_id;
1827: EXCEPTION
1828: WHEN NO_DATA_FOUND THEN
1829: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1830: THEN
1831: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1832: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.No data found exception'
1833: , 'Exception'

Line 1831: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1827: EXCEPTION
1828: WHEN NO_DATA_FOUND THEN
1829: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1830: THEN
1831: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1832: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.No data found exception'
1833: , 'Exception'
1834: );
1835: END IF;

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

1835: END IF;
1836: RETURN null;
1837: WHEN TOO_MANY_ROWS
1838: THEN
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1840: THEN
1841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1842: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.too many rows exception'
1843: , 'Exception'

Line 1841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1837: WHEN TOO_MANY_ROWS
1838: THEN
1839: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1840: THEN
1841: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1842: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.too many rows exception'
1843: , 'Exception'
1844: );
1845: END IF;

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

1844: );
1845: END IF;
1846: RETURN null;
1847: WHEN OTHERS THEN
1848: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1849: THEN
1850: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1851: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.Others exception'
1852: , 'Exception'

Line 1850: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1846: RETURN null;
1847: WHEN OTHERS THEN
1848: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1849: THEN
1850: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1851: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.Others exception'
1852: , 'Exception'
1853: );
1854: END IF;

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

1894:
1895: RETURN l_shipping_le_id;
1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1899: THEN
1900: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1901: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.No data found exception'
1902: , 'Exception'

Line 1900: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1896: EXCEPTION
1897: WHEN NO_DATA_FOUND THEN
1898: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1899: THEN
1900: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1901: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.No data found exception'
1902: , 'Exception'
1903: );
1904: END IF;

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

1904: END IF;
1905: RETURN null;
1906: WHEN TOO_MANY_ROWS
1907: THEN
1908: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1909: THEN
1910: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1911: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.too many rows exception'
1912: , 'Exception'

Line 1910: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1906: WHEN TOO_MANY_ROWS
1907: THEN
1908: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1909: THEN
1910: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1911: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.too many rows exception'
1912: , 'Exception'
1913: );
1914: END IF;

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

1913: );
1914: END IF;
1915: RETURN null;
1916: WHEN OTHERS THEN
1917: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1918: THEN
1919: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1920: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.Others exception'
1921: , 'Exception'

Line 1919: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1915: RETURN null;
1916: WHEN OTHERS THEN
1917: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1918: THEN
1919: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1920: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.Others exception'
1921: , 'Exception'
1922: );
1923: END IF;

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

1963: RETURN l_currency_code;
1964:
1965: EXCEPTION
1966: WHEN NO_DATA_FOUND THEN
1967: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1968: THEN
1969: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1970: , G_MODULE_NAME ||'Get_LE_Currency'||'.No data found exception'
1971: , 'Exception'

Line 1969: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1965: EXCEPTION
1966: WHEN NO_DATA_FOUND THEN
1967: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1968: THEN
1969: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1970: , G_MODULE_NAME ||'Get_LE_Currency'||'.No data found exception'
1971: , 'Exception'
1972: );
1973: END IF;

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

1973: END IF;
1974: RETURN null;
1975: WHEN TOO_MANY_ROWS
1976: THEN
1977: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1978: THEN
1979: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1980: , G_MODULE_NAME ||'Get_LE_Currency'||'.too many rows exception'
1981: , 'Exception'

Line 1979: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1975: WHEN TOO_MANY_ROWS
1976: THEN
1977: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1978: THEN
1979: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1980: , G_MODULE_NAME ||'Get_LE_Currency'||'.too many rows exception'
1981: , 'Exception'
1982: );
1983: END IF;

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

1982: );
1983: END IF;
1984: RETURN null;
1985: WHEN OTHERS THEN
1986: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1987: THEN
1988: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1989: , G_MODULE_NAME ||'Get_LE_Currency'||'.Others exception'
1990: , 'Exception'

Line 1988: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1984: RETURN null;
1985: WHEN OTHERS THEN
1986: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1987: THEN
1988: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1989: , G_MODULE_NAME ||'Get_LE_Currency'||'.Others exception'
1990: , 'Exception'
1991: );
1992: END IF;

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

2045: RETURN l_country;
2046:
2047: EXCEPTION
2048: WHEN NO_DATA_FOUND THEN
2049: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2050: THEN
2051: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2052: , G_MODULE_NAME ||'Get_LE_Location'||'.No data found exception'
2053: , 'Exception'

Line 2051: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2047: EXCEPTION
2048: WHEN NO_DATA_FOUND THEN
2049: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2050: THEN
2051: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2052: , G_MODULE_NAME ||'Get_LE_Location'||'.No data found exception'
2053: , 'Exception'
2054: );
2055: END IF;

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

2055: END IF;
2056: RETURN null;
2057: WHEN TOO_MANY_ROWS
2058: THEN
2059: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2060: THEN
2061: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2062: , G_MODULE_NAME ||'Get_LE_Location'||'.too many rows exception'
2063: , 'Exception'

Line 2061: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2057: WHEN TOO_MANY_ROWS
2058: THEN
2059: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2060: THEN
2061: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2062: , G_MODULE_NAME ||'Get_LE_Location'||'.too many rows exception'
2063: , 'Exception'
2064: );
2065: END IF;

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

2064: );
2065: END IF;
2066: RETURN null;
2067: WHEN OTHERS THEN
2068: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2069: THEN
2070: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2071: , G_MODULE_NAME ||'Get_LE_Location'||'.Others exception'
2072: , 'Exception'

Line 2070: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2066: RETURN null;
2067: WHEN OTHERS THEN
2068: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2069: THEN
2070: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2071: , G_MODULE_NAME ||'Get_LE_Location'||'.Others exception'
2072: , 'Exception'
2073: );
2074: END IF;

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

2126: CLOSE l_prec_rounding;
2127:
2128: EXCEPTION
2129: WHEN NO_DATA_FOUND THEN
2130: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2131: THEN
2132: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2133: , G_MODULE_NAME ||'Get_Weight_Precision'||'.No data found exception'
2134: , 'Exception'

Line 2132: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2128: EXCEPTION
2129: WHEN NO_DATA_FOUND THEN
2130: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2131: THEN
2132: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2133: , G_MODULE_NAME ||'Get_Weight_Precision'||'.No data found exception'
2134: , 'Exception'
2135: );
2136: END IF;

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

2135: );
2136: END IF;
2137: WHEN TOO_MANY_ROWS
2138: THEN
2139: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2140: THEN
2141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2142: , G_MODULE_NAME ||'Get_Weight_Precision'||'.too many rows exception'
2143: , 'Exception'

Line 2141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2137: WHEN TOO_MANY_ROWS
2138: THEN
2139: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2140: THEN
2141: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2142: , G_MODULE_NAME ||'Get_Weight_Precision'||'.too many rows exception'
2143: , 'Exception'
2144: );
2145: END IF;

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

2143: , 'Exception'
2144: );
2145: END IF;
2146: WHEN OTHERS THEN
2147: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2148: THEN
2149: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2150: , G_MODULE_NAME ||'Get_Weight_Precision'||'.Others exception'
2151: , 'Exception'

Line 2149: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2145: END IF;
2146: WHEN OTHERS THEN
2147: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2148: THEN
2149: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2150: , G_MODULE_NAME ||'Get_Weight_Precision'||'.Others exception'
2151: , 'Exception'
2152: );
2153: END IF;

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

2190:
2191: RETURN l_NUMBER;
2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2195: THEN
2196: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2197: , G_MODULE_NAME ||'Round_Number'
2198: ||'.Others exception'

Line 2196: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2192: EXCEPTION
2193: WHEN OTHERS THEN
2194: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2195: THEN
2196: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2197: , G_MODULE_NAME ||'Round_Number'
2198: ||'.Others exception'
2199: , 'Exception'
2200: );

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

2244:
2245: RETURN l_organization_id;
2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2249: THEN
2250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2251: , G_MODULE_NAME ||'Get_Org_From_Le'
2252: ||'.Others exception'

Line 2250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2246: EXCEPTION
2247: WHEN OTHERS THEN
2248: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2249: THEN
2250: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2251: , G_MODULE_NAME ||'Get_Org_From_Le'
2252: ||'.Others exception'
2253: , 'Exception'
2254: );

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

2397: , x_no_of_rows => l_no_of_rows /* number of detail rows retrieved */
2398: );
2399:
2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2402: THEN
2403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2404: , G_MODULE_NAME || 'Get_Process_Item_Cost:'
2405: ,'Error in Get_Process_Item_Cost. Setting item_cost to zero.'

Line 2403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2399:
2400: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2401: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2402: THEN
2403: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2404: , G_MODULE_NAME || 'Get_Process_Item_Cost:'
2405: ,'Error in Get_Process_Item_Cost. Setting item_cost to zero.'
2406: );
2407: END IF;

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

2408:
2409: l_item_cost := 0;
2410: END IF;
2411:
2412: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2413: THEN
2414: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2415: , G_MODULE_NAME || 'Get_Process_Item_Cost:'
2416: ,'item_cost:' || l_item_cost

Line 2414: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE

2410: END IF;
2411:
2412: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2413: THEN
2414: FND_LOG.string(FND_LOG.LEVEL_PROCEDURE
2415: , G_MODULE_NAME || 'Get_Process_Item_Cost:'
2416: ,'item_cost:' || l_item_cost
2417: );
2418: END IF;

Line 2423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2419:
2420: RETURN l_item_cost ;
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2425: , G_MODULE_NAME ||'Get_Process_Item_Cost'
2426: ||'.Others exception'
2427: , 'Exception'

Line 2424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2420: RETURN l_item_cost ;
2421: EXCEPTION
2422: WHEN OTHERS THEN
2423: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2424: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2425: , G_MODULE_NAME ||'Get_Process_Item_Cost'
2426: ||'.Others exception'
2427: , 'Exception'
2428: );