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 1814: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1810:
1811: RETURN l_so_le_id;
1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN
1814: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1815: THEN
1816: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1817: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.No data found exception'
1818: , 'Exception'

Line 1816: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1812: EXCEPTION
1813: WHEN NO_DATA_FOUND THEN
1814: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1815: THEN
1816: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1817: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.No data found exception'
1818: , 'Exception'
1819: );
1820: END IF;

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

1820: END IF;
1821: RETURN null;
1822: WHEN TOO_MANY_ROWS
1823: THEN
1824: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1825: THEN
1826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1827: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.too many rows exception'
1828: , 'Exception'

Line 1826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1822: WHEN TOO_MANY_ROWS
1823: THEN
1824: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1825: THEN
1826: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1827: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.too many rows exception'
1828: , 'Exception'
1829: );
1830: END IF;

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

1829: );
1830: END IF;
1831: RETURN null;
1832: WHEN OTHERS THEN
1833: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1834: THEN
1835: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1836: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.Others exception'
1837: , 'Exception'

Line 1835: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1831: RETURN null;
1832: WHEN OTHERS THEN
1833: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1834: THEN
1835: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1836: , G_MODULE_NAME ||'Get_SO_Legal_Entity'||'.Others exception'
1837: , 'Exception'
1838: );
1839: END IF;

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

1879:
1880: RETURN l_shipping_le_id;
1881: EXCEPTION
1882: WHEN NO_DATA_FOUND THEN
1883: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1884: THEN
1885: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1886: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.No data found exception'
1887: , 'Exception'

Line 1885: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1881: EXCEPTION
1882: WHEN NO_DATA_FOUND THEN
1883: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1884: THEN
1885: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1886: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.No data found exception'
1887: , 'Exception'
1888: );
1889: END IF;

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

1889: END IF;
1890: RETURN null;
1891: WHEN TOO_MANY_ROWS
1892: THEN
1893: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1894: THEN
1895: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1896: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.too many rows exception'
1897: , 'Exception'

Line 1895: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1891: WHEN TOO_MANY_ROWS
1892: THEN
1893: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1894: THEN
1895: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1896: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.too many rows exception'
1897: , 'Exception'
1898: );
1899: END IF;

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

1898: );
1899: END IF;
1900: RETURN null;
1901: WHEN OTHERS THEN
1902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1903: THEN
1904: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1905: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.Others exception'
1906: , 'Exception'

Line 1904: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1900: RETURN null;
1901: WHEN OTHERS THEN
1902: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1903: THEN
1904: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1905: , G_MODULE_NAME ||'Get_Shipping_Legal_Entity'||'.Others exception'
1906: , 'Exception'
1907: );
1908: END IF;

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

1948: RETURN l_currency_code;
1949:
1950: EXCEPTION
1951: WHEN NO_DATA_FOUND THEN
1952: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1953: THEN
1954: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1955: , G_MODULE_NAME ||'Get_LE_Currency'||'.No data found exception'
1956: , 'Exception'

Line 1954: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1950: EXCEPTION
1951: WHEN NO_DATA_FOUND THEN
1952: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1953: THEN
1954: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1955: , G_MODULE_NAME ||'Get_LE_Currency'||'.No data found exception'
1956: , 'Exception'
1957: );
1958: END IF;

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

1958: END IF;
1959: RETURN null;
1960: WHEN TOO_MANY_ROWS
1961: THEN
1962: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1963: THEN
1964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1965: , G_MODULE_NAME ||'Get_LE_Currency'||'.too many rows exception'
1966: , 'Exception'

Line 1964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1960: WHEN TOO_MANY_ROWS
1961: THEN
1962: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1963: THEN
1964: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1965: , G_MODULE_NAME ||'Get_LE_Currency'||'.too many rows exception'
1966: , 'Exception'
1967: );
1968: END IF;

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

1967: );
1968: END IF;
1969: RETURN null;
1970: WHEN OTHERS THEN
1971: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1972: THEN
1973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1974: , G_MODULE_NAME ||'Get_LE_Currency'||'.Others exception'
1975: , 'Exception'

Line 1973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

1969: RETURN null;
1970: WHEN OTHERS THEN
1971: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1972: THEN
1973: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
1974: , G_MODULE_NAME ||'Get_LE_Currency'||'.Others exception'
1975: , 'Exception'
1976: );
1977: END IF;

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

2030: RETURN l_country;
2031:
2032: EXCEPTION
2033: WHEN NO_DATA_FOUND THEN
2034: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2035: THEN
2036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2037: , G_MODULE_NAME ||'Get_LE_Location'||'.No data found exception'
2038: , 'Exception'

Line 2036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2032: EXCEPTION
2033: WHEN NO_DATA_FOUND THEN
2034: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2035: THEN
2036: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2037: , G_MODULE_NAME ||'Get_LE_Location'||'.No data found exception'
2038: , 'Exception'
2039: );
2040: END IF;

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

2040: END IF;
2041: RETURN null;
2042: WHEN TOO_MANY_ROWS
2043: THEN
2044: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2045: THEN
2046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2047: , G_MODULE_NAME ||'Get_LE_Location'||'.too many rows exception'
2048: , 'Exception'

Line 2046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2042: WHEN TOO_MANY_ROWS
2043: THEN
2044: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2045: THEN
2046: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2047: , G_MODULE_NAME ||'Get_LE_Location'||'.too many rows exception'
2048: , 'Exception'
2049: );
2050: END IF;

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

2049: );
2050: END IF;
2051: RETURN null;
2052: WHEN OTHERS THEN
2053: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2054: THEN
2055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2056: , G_MODULE_NAME ||'Get_LE_Location'||'.Others exception'
2057: , 'Exception'

Line 2055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2051: RETURN null;
2052: WHEN OTHERS THEN
2053: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2054: THEN
2055: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2056: , G_MODULE_NAME ||'Get_LE_Location'||'.Others exception'
2057: , 'Exception'
2058: );
2059: END IF;

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

2111: CLOSE l_prec_rounding;
2112:
2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2116: THEN
2117: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2118: , G_MODULE_NAME ||'Get_Weight_Precision'||'.No data found exception'
2119: , 'Exception'

Line 2117: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2113: EXCEPTION
2114: WHEN NO_DATA_FOUND THEN
2115: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2116: THEN
2117: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2118: , G_MODULE_NAME ||'Get_Weight_Precision'||'.No data found exception'
2119: , 'Exception'
2120: );
2121: END IF;

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

2120: );
2121: END IF;
2122: WHEN TOO_MANY_ROWS
2123: THEN
2124: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2125: THEN
2126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2127: , G_MODULE_NAME ||'Get_Weight_Precision'||'.too many rows exception'
2128: , 'Exception'

Line 2126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2122: WHEN TOO_MANY_ROWS
2123: THEN
2124: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2125: THEN
2126: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2127: , G_MODULE_NAME ||'Get_Weight_Precision'||'.too many rows exception'
2128: , 'Exception'
2129: );
2130: END IF;

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

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

Line 2134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2130: END IF;
2131: WHEN OTHERS THEN
2132: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2133: THEN
2134: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2135: , G_MODULE_NAME ||'Get_Weight_Precision'||'.Others exception'
2136: , 'Exception'
2137: );
2138: END IF;

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

2175:
2176: RETURN l_NUMBER;
2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2180: THEN
2181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2182: , G_MODULE_NAME ||'Round_Number'
2183: ||'.Others exception'

Line 2181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2177: EXCEPTION
2178: WHEN OTHERS THEN
2179: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2180: THEN
2181: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2182: , G_MODULE_NAME ||'Round_Number'
2183: ||'.Others exception'
2184: , 'Exception'
2185: );

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

2224:
2225: RETURN l_organization_id;
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2229: THEN
2230: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2231: , G_MODULE_NAME ||'Get_Org_From_Le'
2232: ||'.Others exception'

Line 2230: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED

2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2229: THEN
2230: FND_LOG.string(FND_LOG.LEVEL_UNEXPECTED
2231: , G_MODULE_NAME ||'Get_Org_From_Le'
2232: ||'.Others exception'
2233: , 'Exception'
2234: );