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 2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);

2371: aso_debug_pub.add('ASO_TAX_INT: Begin CALCULATE_TAX_WITH_GTT', 1, 'Y');
2372: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_header_id: '|| p_qte_header_id, 1, 'Y');
2373: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: p_qte_line_id: '|| p_qte_line_id, 1, 'Y');
2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2376: IF aso_debug_pub.g_debug_flag = 'Y'
2377: THEN
2378: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2379: END IF;

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

2374: END IF;
2375: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_id);
2376: IF aso_debug_pub.g_debug_flag = 'Y'
2377: THEN
2378: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Header_Row ', 1, 'Y');
2379: END IF;
2380:
2381: l_currency_code := l_qte_header_rec.currency_code;
2382: IF aso_debug_pub.g_debug_flag = 'Y'

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

2383: THEN
2384: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: l_currency_code: '|| l_currency_code, 1, 'Y');
2385: END IF;
2386:
2387: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2388: IF aso_debug_pub.g_debug_flag = 'Y'
2389: THEN
2390: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2391: END IF;

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

2386:
2387: l_Shipment_header_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,null);
2388: IF aso_debug_pub.g_debug_flag = 'Y'
2389: THEN
2390: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.query_shipment_rows ', 1, 'Y');
2391: END IF;
2392:
2393: --Condition added on 20/09/05 by anrajan
2394: IF l_Shipment_header_tbl.count > 0

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

2428: END IF;
2429:
2430: IF p_qte_line_id is null or p_qte_line_id = FND_API.G_MISS_NUM
2431: THEN
2432: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2433: IF
2434: aso_debug_pub.g_debug_flag = 'Y'
2435: THEN
2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');

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

2432: l_qte_line_tbl := ASO_UTILITY_PVT.Query_Qte_Line_Rows(p_qte_header_id);
2433: IF
2434: aso_debug_pub.g_debug_flag = 'Y'
2435: THEN
2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2437: END IF;
2438: ELSE
2439: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2440: IF

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

2435: THEN
2436: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Rows', 1, 'Y');
2437: END IF;
2438: ELSE
2439: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2440: IF
2441: aso_debug_pub.g_debug_flag = 'Y'
2442: THEN
2443: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');

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

2439: l_qte_line_rec := ASO_UTILITY_PVT.Query_Qte_Line_Row(p_qte_line_id);
2440: IF
2441: aso_debug_pub.g_debug_flag = 'Y'
2442: THEN
2443: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: After call to ASO_UTILITY_PVT.Query_Qte_Line_Row', 1, 'Y');
2444: END IF;
2445: l_qte_line_tbl(1) := l_qte_line_rec;
2446: aso_debug_pub.add('ASO_TAX_INT: CALCULATE_TAX_WITH_GTT: Quote Line Id : '||p_qte_line_id, 1, 'Y');
2447: END IF;

Line 2762: 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');

2758: LOOP
2759: l_qte_line_rec:=l_qte_line_tbl(i);
2760: IF aso_debug_pub.g_debug_flag ='Y' THEN
2761: 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');
2762: 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');
2763: END IF;
2764: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2765:
2766: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728

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

2760: IF aso_debug_pub.g_debug_flag ='Y' THEN
2761: 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');
2762: 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');
2763: END IF;
2764: l_Shipment_tbl:=aso_utility_pvt.query_shipment_rows( p_qte_header_id,l_qte_line_rec.quote_line_id);
2765:
2766: --Condition added by anrajan on 06/10/2005 for Bug Number :4656728
2767: IF l_Shipment_tbl.count>0
2768: THEN

Line 2773: 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');

2769: l_Shipment_Rec:=l_shipment_tbl(1);
2770: END IF;
2771:
2772: IF aso_debug_pub.g_debug_flag ='Y' THEN
2773: 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');
2774: END IF;
2775:
2776: l_site_use_id_bill_lines:=aso_shipment_pvt.get_cust_to_party_site_id
2777: (p_qte_header_id,

Line 3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3224: );
3225:
3226: EXCEPTION
3227: WHEN FND_API.G_EXC_ERROR THEN
3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3228: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3229: P_API_NAME => L_API_NAME
3230: ,P_PKG_NAME => G_PKG_NAME
3231: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
3232: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3233: ,X_MSG_COUNT => X_MSG_COUNT
3234: ,X_MSG_DATA => X_MSG_DATA
3235: ,X_RETURN_STATUS => X_RETURN_STATUS);
3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3233: ,X_MSG_COUNT => X_MSG_COUNT
3234: ,X_MSG_DATA => X_MSG_DATA
3235: ,X_RETURN_STATUS => X_RETURN_STATUS);
3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3238: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3240: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3241: ,X_MSG_COUNT => X_MSG_COUNT

Line 3240: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3237: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3238: P_API_NAME => L_API_NAME ,P_PKG_NAME => G_PKG_NAME
3239: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
3240: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3241: ,X_MSG_COUNT => X_MSG_COUNT
3242: ,X_MSG_DATA => X_MSG_DATA
3243: ,X_RETURN_STATUS => X_RETURN_STATUS);
3244:

Line 3246: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

3242: ,X_MSG_DATA => X_MSG_DATA
3243: ,X_RETURN_STATUS => X_RETURN_STATUS);
3244:
3245: WHEN OTHERS THEN
3246: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3247: P_API_NAME => L_API_NAME
3248: ,P_PKG_NAME => G_PKG_NAME
3249: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3250: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

Line 3249: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

3245: WHEN OTHERS THEN
3246: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3247: P_API_NAME => L_API_NAME
3248: ,P_PKG_NAME => G_PKG_NAME
3249: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3250: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3251: ,P_SQLCODE => SQLCODE
3252: ,P_SQLERRM => SQLERRM
3253: ,X_MSG_COUNT => X_MSG_COUNT

Line 3250: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT

3246: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
3247: P_API_NAME => L_API_NAME
3248: ,P_PKG_NAME => G_PKG_NAME
3249: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
3250: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_INT
3251: ,P_SQLCODE => SQLCODE
3252: ,P_SQLERRM => SQLERRM
3253: ,X_MSG_COUNT => X_MSG_COUNT
3254: ,X_MSG_DATA => X_MSG_DATA

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

3497: -- Changes Done by : Girish
3498: -- Comments : Changed to use HR EIT in place of org striped profile.
3499:
3500: --l_order_type_id := to_number(fnd_profile.value('ASO_ORDER_TYPE_ID'));
3501: l_order_type_id := to_number(ASO_UTILITY_PVT.get_ou_attribute_value(ASO_UTILITY_PVT.G_DEFAULT_ORDER_TYPE));
3502:
3503: -- Change END
3504:
3505: IF aso_debug_pub.g_debug_flag = 'Y' THEN