eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_TAX_INT dependencies on ASO_UTILITY_PVT

Line 170: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

166: );
167:
168: EXCEPTION
169: WHEN FND_API.G_EXC_ERROR THEN
170: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
171: P_API_NAME => L_API_NAME
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
174: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 174: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

170: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
171: P_API_NAME => L_API_NAME
172: ,P_PKG_NAME => G_PKG_NAME
173: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
174: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
175: ,X_MSG_COUNT => X_MSG_COUNT
176: ,X_MSG_DATA => X_MSG_DATA
177: ,X_RETURN_STATUS => X_RETURN_STATUS);
178:

Line 180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

176: ,X_MSG_DATA => X_MSG_DATA
177: ,X_RETURN_STATUS => X_RETURN_STATUS);
178:
179: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

180: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
181: P_API_NAME => L_API_NAME
182: ,P_PKG_NAME => G_PKG_NAME
183: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
184: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
185: ,X_MSG_COUNT => X_MSG_COUNT
186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188:

Line 190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

186: ,X_MSG_DATA => X_MSG_DATA
187: ,X_RETURN_STATUS => X_RETURN_STATUS);
188:
189: WHEN OTHERS THEN
190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
191: P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
194: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 193: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

189: WHEN OTHERS THEN
190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
191: P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
194: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
195: ,P_SQLCODE => SQLCODE
196: ,P_SQLERRM => SQLERRM
197: ,X_MSG_COUNT => X_MSG_COUNT

Line 194: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

190: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
191: P_API_NAME => L_API_NAME
192: ,P_PKG_NAME => G_PKG_NAME
193: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
194: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
195: ,P_SQLCODE => SQLCODE
196: ,P_SQLERRM => SQLERRM
197: ,X_MSG_COUNT => X_MSG_COUNT
198: ,X_MSG_DATA => X_MSG_DATA

Line 436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

432: );
433:
434: EXCEPTION
435: WHEN FND_API.G_EXC_ERROR THEN
436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
437: P_API_NAME => L_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

436: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
437: P_API_NAME => L_API_NAME
438: ,P_PKG_NAME => G_PKG_NAME
439: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
440: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
441: ,X_MSG_COUNT => X_MSG_COUNT
442: ,X_MSG_DATA => X_MSG_DATA
443: ,X_RETURN_STATUS => X_RETURN_STATUS);
444:

Line 446: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

442: ,X_MSG_DATA => X_MSG_DATA
443: ,X_RETURN_STATUS => X_RETURN_STATUS);
444:
445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
447: P_API_NAME => L_API_NAME
448: ,P_PKG_NAME => G_PKG_NAME
449: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
450: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 450: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

446: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
447: P_API_NAME => L_API_NAME
448: ,P_PKG_NAME => G_PKG_NAME
449: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
450: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
451: ,X_MSG_COUNT => X_MSG_COUNT
452: ,X_MSG_DATA => X_MSG_DATA
453: ,X_RETURN_STATUS => X_RETURN_STATUS);
454:

Line 456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

452: ,X_MSG_DATA => X_MSG_DATA
453: ,X_RETURN_STATUS => X_RETURN_STATUS);
454:
455: WHEN OTHERS THEN
456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
457: P_API_NAME => L_API_NAME
458: ,P_PKG_NAME => G_PKG_NAME
459: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
460: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

Line 459: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

455: WHEN OTHERS THEN
456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
457: P_API_NAME => L_API_NAME
458: ,P_PKG_NAME => G_PKG_NAME
459: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
460: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
461: ,P_SQLCODE => SQLCODE
462: ,P_SQLERRM => SQLERRM
463: ,X_MSG_COUNT => X_MSG_COUNT

Line 460: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB

456: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
457: P_API_NAME => L_API_NAME
458: ,P_PKG_NAME => G_PKG_NAME
459: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
460: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PUB
461: ,P_SQLCODE => SQLCODE
462: ,P_SQLERRM => SQLERRM
463: ,X_MSG_COUNT => X_MSG_COUNT
464: ,X_MSG_DATA => X_MSG_DATA

Line 827: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

823:
824: END IF;
825:
826: -- Retrieve Quote header and line information from database
827: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
828:
829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');
831: END IF;

Line 830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');

826: -- Retrieve Quote header and line information from database
827: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
828:
829: IF aso_debug_pub.g_debug_flag = 'Y' THEN
830: aso_debug_pub.add('ASO_TAX_INT: ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Header_Row', 1, 'Y');
831: END IF;
832:
833: If p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM then
834:

Line 835: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);

831: END IF;
832:
833: If p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM then
834:
835: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
836:
837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
838: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
839: END IF;

Line 838: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');

834:
835: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
836:
837: IF aso_debug_pub.g_debug_flag = 'Y' THEN
838: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
839: END IF;
840:
841: else
842:

Line 843: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);

839: END IF;
840:
841: else
842:
843: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
844: l_qte_line_tbl(1) := l_qte_line_rec;
845:
846: IF aso_debug_pub.g_debug_flag = 'Y' THEN
847: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

Line 847: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

843: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
844: l_qte_line_tbl(1) := l_qte_line_rec;
845:
846: IF aso_debug_pub.g_debug_flag = 'Y' THEN
847: aso_debug_pub.add('ASO_TAX_LINE: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
848: END IF;
849:
850: end if;
851:

Line 932: l_shipment_tbl := aso_utility_pvt.query_shipment_rows( p_qte_header_id,

928:
929: FOR i IN 1..l_qte_line_tbl.count LOOP
930:
931:
932: l_shipment_tbl := aso_utility_pvt.query_shipment_rows( p_qte_header_id,
933: l_qte_line_tbl(i).quote_line_id);
934:
935: IF aso_debug_pub.g_debug_flag = 'Y' THEN
936: aso_debug_pub.add('ASO_TAX_LINE: l_shipment_tbl.count: '|| l_shipment_tbl.count, 1, 'Y');

Line 1015: l_tax_detail_tbl := aso_utility_pvt.query_tax_detail_Rows( p_qte_header_id,

1011: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1012: aso_debug_pub.add('After call: l_payment_term_id: '|| l_payment_term_id, 1, 'Y');
1013: END IF;
1014:
1015: l_tax_detail_tbl := aso_utility_pvt.query_tax_detail_Rows( p_qte_header_id,
1016: l_qte_line_tbl(i).quote_line_id,
1017: l_shipment_tbl);
1018:
1019: l_hdr_tax_detail_tbl := aso_utility_pvt.query_tax_detail_rows( p_qte_header_id, null,

Line 1019: l_hdr_tax_detail_tbl := aso_utility_pvt.query_tax_detail_rows( p_qte_header_id, null,

1015: l_tax_detail_tbl := aso_utility_pvt.query_tax_detail_Rows( p_qte_header_id,
1016: l_qte_line_tbl(i).quote_line_id,
1017: l_shipment_tbl);
1018:
1019: l_hdr_tax_detail_tbl := aso_utility_pvt.query_tax_detail_rows( p_qte_header_id, null,
1020: l_shipment_tbl);
1021:
1022: IF aso_debug_pub.g_debug_flag = 'Y' THEN
1023: aso_debug_pub.add('ASO_TAX_LINE: l_tax_detail_tbl.count: '||l_tax_detail_tbl.count, 1, 'Y');

Line 2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

2352: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2353: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2354: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2357: IF aso_debug_pub.g_debug_flag = 'Y'
2358: THEN
2359: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2360: END IF;

Line 2359: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');

2355: END IF;
2356: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2357: IF aso_debug_pub.g_debug_flag = 'Y'
2358: THEN
2359: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2360: END IF;
2361:
2362: l_currency_code := l_qte_header_rec.currency_code;
2363: IF aso_debug_pub.g_debug_flag = 'Y'

Line 2368: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);

2364: THEN
2365: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_currency_code: '|| l_currency_code, 1, 'Y');
2366: END IF;
2367:
2368: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2372: END IF;

Line 2371: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');

2367:
2368: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2369: IF aso_debug_pub.g_debug_flag = 'Y'
2370: THEN
2371: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2372: END IF;
2373:
2374: --Condition added on 20/09/05 by anrajan
2375: IF l_Shipment_header_tbl.count > 0

Line 2413: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);

2409: END IF;
2410:
2411: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2412: THEN
2413: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2414: IF
2415: aso_debug_pub.g_debug_flag = 'Y'
2416: THEN
2417: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');

Line 2417: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');

2413: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2414: IF
2415: aso_debug_pub.g_debug_flag = 'Y'
2416: THEN
2417: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2418: END IF;
2419: ELSE
2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2421: IF

Line 2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);

2416: THEN
2417: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2418: END IF;
2419: ELSE
2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2421: IF
2422: aso_debug_pub.g_debug_flag = 'Y'
2423: THEN
2424: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

Line 2424: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

2420: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2421: IF
2422: aso_debug_pub.g_debug_flag = 'Y'
2423: THEN
2424: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2425: END IF;
2426: l_qte_line_tbl(1) := l_qte_line_rec;
2427: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2428: END IF;

Line 2680: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');

2676: LOOP
2677: l_qte_line_rec:=l_qte_line_tbl(i);
2678: IF aso_debug_pub.g_debug_flag ='Y' THEN
2679: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP : QUOTE LINE ID :'||l_qte_line_rec.QUOTE_LINE_ID, 1, 'Y');
2680: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2681: END IF;
2682: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2683:
2684: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728

Line 2682: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);

2678: IF aso_debug_pub.g_debug_flag ='Y' THEN
2679: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP : QUOTE LINE ID :'||l_qte_line_rec.QUOTE_LINE_ID, 1, 'Y');
2680: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :BEFORE THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2681: END IF;
2682: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2683:
2684: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728
2685: IF l_Shipment_tbl.count>0
2686: THEN

Line 2691: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');

2687: l_Shipment_Rec:=l_shipment_tbl(1);
2688: END IF;
2689:
2690: IF aso_debug_pub.g_debug_flag ='Y' THEN
2691: aso_debug_pub.add('ASO_TAX_INT :CALCULATE_TAX_WITH_GTT: WITHIN THE QUOTE LINES LOOP :AFTER THE CALL TO aso_utility_pvt.query_shipment_rows', 1, 'Y');
2692: END IF;
2693:
2694: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2695: (p_qte_header_id,

Line 3130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3126: );
3127:
3128: EXCEPTION
3129: WHEN FND_API.G_EXC_ERROR THEN
3130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3131: P_API_NAME => L_API_NAME
3132: ,P_PKG_NAME => G_PKG_NAME
3133: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3130: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3131: P_API_NAME => L_API_NAME
3132: ,P_PKG_NAME => G_PKG_NAME
3133: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3134: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3135: ,X_MSG_COUNT => X_MSG_COUNT
3136: ,X_MSG_DATA => X_MSG_DATA
3137: ,X_RETURN_STATUS => X_RETURN_STATUS);
3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3139: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3135: ,X_MSG_COUNT => X_MSG_COUNT
3136: ,X_MSG_DATA => X_MSG_DATA
3137: ,X_RETURN_STATUS => X_RETURN_STATUS);
3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3139: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3140: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3141: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3142: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3143: ,X_MSG_COUNT => X_MSG_COUNT

Line 3142: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3138: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3139: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3140: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3141: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3142: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3143: ,X_MSG_COUNT => X_MSG_COUNT
3144: ,X_MSG_DATA => X_MSG_DATA
3145: ,X_RETURN_STATUS => X_RETURN_STATUS);
3146:

Line 3148: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3144: ,X_MSG_DATA => X_MSG_DATA
3145: ,X_RETURN_STATUS => X_RETURN_STATUS);
3146:
3147: WHEN OTHERS THEN
3148: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3149: P_API_NAME => L_API_NAME
3150: ,P_PKG_NAME => G_PKG_NAME
3151: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3152: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3151: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3147: WHEN OTHERS THEN
3148: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3149: P_API_NAME => L_API_NAME
3150: ,P_PKG_NAME => G_PKG_NAME
3151: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3152: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3153: ,P_SQLCODE => SQLCODE
3154: ,P_SQLERRM => SQLERRM
3155: ,X_MSG_COUNT => X_MSG_COUNT

Line 3152: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3148: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3149: P_API_NAME => L_API_NAME
3150: ,P_PKG_NAME => G_PKG_NAME
3151: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3152: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3153: ,P_SQLCODE => SQLCODE
3154: ,P_SQLERRM => SQLERRM
3155: ,X_MSG_COUNT => X_MSG_COUNT
3156: ,X_MSG_DATA => X_MSG_DATA

Line 3403: l_order_type_id := to_number(ASO_UTILITY_PVT.get_ou_attribute_value(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));

3399: -- Changes Done by : Girish
3400: -- Comments : Changed to use HR EIT in place of org striped profile.
3401:
3402: --l_order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
3403: l_order_type_id := to_number(ASO_UTILITY_PVT.get_ou_attribute_value(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
3404:
3405: -- Change END
3406:
3407: IF aso_debug_pub.g_debug_flag = 'Y' THEN