DBA Data[Home] [Help]

APPS.ASO_SALES_CREDIT_PVT dependencies on ASO_UTILITY_PVT

Line 137: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);

133: IF p_control_rec.submit_quote_flag = FND_API.G_TRUE AND l_auto_sales_cred_prof <> 'FULL' THEN
134: RAISE Leave_Proc;
135: END IF;
136:
137: l_qte_header_rec := ASO_UTILITY_PVT.Query_Header_Row(p_qte_header_rec.quote_header_id);
138:
139: -- Check Whether record has been changed
140: IF (l_qte_header_rec.last_update_date IS NULL OR
141: l_qte_header_rec.last_update_date = FND_API.G_MISS_DATE) THEN

Line 340: aso_debug_pub.add('ASO_SALES_CREDIT_PVT.Allocate_Sales_Credits : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_header_rec.Quote_Number, 1, 'Y');

336: -- Girish Sachdeva 8/30/2005
337: -- Adding the call to insert record in the ASO_CHANGED_QUOTES
338:
339: IF aso_debug_pub.g_debug_flag = 'Y' THEN
340: aso_debug_pub.add('ASO_SALES_CREDIT_PVT.Allocate_Sales_Credits : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_header_rec.Quote_Number, 1, 'Y');
341: END IF;
342:
343: -- Call to insert record in ASO_CHANGED_QUOTES
344: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_header_rec.Quote_Number);

Line 344: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_header_rec.Quote_Number);

340: aso_debug_pub.add('ASO_SALES_CREDIT_PVT.Allocate_Sales_Credits : Calling ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES, quote number : ' || l_qte_header_rec.Quote_Number, 1, 'Y');
341: END IF;
342:
343: -- Call to insert record in ASO_CHANGED_QUOTES
344: ASO_UTILITY_PVT.UPDATE_CHANGED_QUOTES(l_qte_header_rec.Quote_Number);
345:
346: -- Change END
347:
348:

Line 361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

357: WHEN Leave_Proc THEN
358: X_Qte_Header_Rec := P_Qte_Header_Rec;
359:
360: WHEN FND_API.G_EXC_ERROR THEN
361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
362: P_API_NAME => L_API_NAME,
363: P_PKG_NAME => G_PKG_NAME,
364: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
365: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 365: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

361: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
362: P_API_NAME => L_API_NAME,
363: P_PKG_NAME => G_PKG_NAME,
364: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
365: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
366: P_SQLCODE => SQLCODE,
367: P_SQLERRM => SQLERRM,
368: X_MSG_COUNT => X_MSG_COUNT,
369: X_MSG_DATA => X_MSG_DATA,

Line 374: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

370: X_RETURN_STATUS => X_RETURN_STATUS
371: );
372:
373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
374: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
377: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
378: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 378: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

374: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME,
376: P_PKG_NAME => G_PKG_NAME,
377: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
378: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
379: P_SQLCODE => SQLCODE,
380: P_SQLERRM => SQLERRM,
381: X_MSG_COUNT => X_MSG_COUNT,
382: X_MSG_DATA => X_MSG_DATA,

Line 387: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

383: X_RETURN_STATUS => X_RETURN_STATUS
384: );
385:
386: WHEN OTHERS THEN
387: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME,
389: P_PKG_NAME => G_PKG_NAME,
390: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
391: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 390: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

386: WHEN OTHERS THEN
387: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME,
389: P_PKG_NAME => G_PKG_NAME,
390: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
391: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
392: P_SQLCODE => SQLCODE,
393: P_SQLERRM => SQLERRM,
394: X_MSG_COUNT => X_MSG_COUNT,

Line 391: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

387: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
388: P_API_NAME => L_API_NAME,
389: P_PKG_NAME => G_PKG_NAME,
390: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
391: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
392: P_SQLCODE => SQLCODE,
393: P_SQLERRM => SQLERRM,
394: X_MSG_COUNT => X_MSG_COUNT,
395: X_MSG_DATA => X_MSG_DATA,

Line 762: aso_utility_pvt.print_login_info();

758: END IF;
759:
760: IF aso_debug_pub.g_debug_flag = 'Y' THEN
761: aso_debug_pub.add('Get_Credits: Before CN_SCA_CREDITS_ONLINE_PUB.Get_Sales_Credits ',1,'N');
762: aso_utility_pvt.print_login_info();
763: END IF;
764: -- Call CN API to get sales credits
765: CN_SCA_CREDITS_ONLINE_PUB.Get_Sales_Credits (
766: p_api_version => 1.0,

Line 776: aso_utility_pvt.print_login_info();

772: x_msg_data => x_msg_data );
773:
774: IF aso_debug_pub.g_debug_flag = 'Y' THEN
775: aso_debug_pub.add('Get_Credits: After CN_SCA_CREDITS_ONLINE_PUB.Get_Sales_Credits: '||x_return_status,1,'N');
776: aso_utility_pvt.print_login_info();
777: END IF;
778:
779: IF aso_debug_pub.g_debug_flag = 'Y' THEN
780: select count(*) into l_dumb from CN_SCA_LINES_OUTPUT_GTT;

Line 1077: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1073:
1074: EXCEPTION
1075:
1076: WHEN FND_API.G_EXC_ERROR THEN
1077: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME,
1079: P_PKG_NAME => G_PKG_NAME,
1080: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1081: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1081: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1077: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1078: P_API_NAME => L_API_NAME,
1079: P_PKG_NAME => G_PKG_NAME,
1080: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR,
1081: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1082: P_SQLCODE => SQLCODE,
1083: P_SQLERRM => SQLERRM,
1084: X_MSG_COUNT => X_MSG_COUNT,
1085: X_MSG_DATA => X_MSG_DATA,

Line 1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1086: X_RETURN_STATUS => X_RETURN_STATUS
1087: );
1088:
1089: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME,
1092: P_PKG_NAME => G_PKG_NAME,
1093: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1094: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1094: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1090: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1091: P_API_NAME => L_API_NAME,
1092: P_PKG_NAME => G_PKG_NAME,
1093: P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR,
1094: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1095: P_SQLCODE => SQLCODE,
1096: P_SQLERRM => SQLERRM,
1097: X_MSG_COUNT => X_MSG_COUNT,
1098: X_MSG_DATA => X_MSG_DATA,

Line 1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

1099: X_RETURN_STATUS => X_RETURN_STATUS
1100: );
1101:
1102: WHEN OTHERS THEN
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME,
1105: P_PKG_NAME => G_PKG_NAME,
1106: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

Line 1106: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,

1102: WHEN OTHERS THEN
1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME,
1105: P_PKG_NAME => G_PKG_NAME,
1106: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1108: P_SQLCODE => SQLCODE,
1109: P_SQLERRM => SQLERRM,
1110: X_MSG_COUNT => X_MSG_COUNT,

Line 1107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,

1103: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1104: P_API_NAME => L_API_NAME,
1105: P_PKG_NAME => G_PKG_NAME,
1106: P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS,
1107: P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT,
1108: P_SQLCODE => SQLCODE,
1109: P_SQLERRM => SQLERRM,
1110: X_MSG_COUNT => X_MSG_COUNT,
1111: X_MSG_DATA => X_MSG_DATA,