DBA Data[Home] [Help]

APPS.ASO_PRICE_ADJ_RLTSHIP_PVT dependencies on ASO_UTILITY_PVT

Line 125: P_Validation_mode => ASO_UTILITY_PVT.G_CREATE,

121: THEN
122:
123: Validate_PRICE_ADJ_RLTSHIP(
124: P_Validation_level => p_validation_level,
125: P_Validation_mode => ASO_UTILITY_PVT.G_CREATE,
126: P_PRICE_ADJ_RLTSHIP_Rec => P_PRICE_ADJ_RLTSHIP_rec,
127: x_return_status => x_return_status,
128: x_msg_count => x_msg_count,
129: x_msg_data => x_msg_data);

Line 199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

195: END IF;
196: */
197: EXCEPTION
198: WHEN FND_API.G_EXC_ERROR THEN
199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
200: P_API_NAME => L_API_NAME
201: ,P_PKG_NAME => G_PKG_NAME
202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

199: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
200: P_API_NAME => L_API_NAME
201: ,P_PKG_NAME => G_PKG_NAME
202: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
203: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
204: ,X_MSG_COUNT => X_MSG_COUNT
205: ,X_MSG_DATA => X_MSG_DATA
206: ,X_RETURN_STATUS => X_RETURN_STATUS);
207:

Line 209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

205: ,X_MSG_DATA => X_MSG_DATA
206: ,X_RETURN_STATUS => X_RETURN_STATUS);
207:
208: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

209: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
210: P_API_NAME => L_API_NAME
211: ,P_PKG_NAME => G_PKG_NAME
212: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
213: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
214: ,X_MSG_COUNT => X_MSG_COUNT
215: ,X_MSG_DATA => X_MSG_DATA
216: ,X_RETURN_STATUS => X_RETURN_STATUS);
217:

Line 219: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

215: ,X_MSG_DATA => X_MSG_DATA
216: ,X_RETURN_STATUS => X_RETURN_STATUS);
217:
218: WHEN OTHERS THEN
219: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME
221: ,P_PKG_NAME => G_PKG_NAME
222: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
223: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 222: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

218: WHEN OTHERS THEN
219: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME
221: ,P_PKG_NAME => G_PKG_NAME
222: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
223: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
224: ,X_MSG_COUNT => X_MSG_COUNT
225: ,X_MSG_DATA => X_MSG_DATA
226: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 223: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

219: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
220: P_API_NAME => L_API_NAME
221: ,P_PKG_NAME => G_PKG_NAME
222: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
223: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
224: ,X_MSG_COUNT => X_MSG_COUNT
225: ,X_MSG_DATA => X_MSG_DATA
226: ,X_RETURN_STATUS => X_RETURN_STATUS);
227:

Line 370: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');

366: END IF;
367: raise FND_API.G_EXC_ERROR;
368: END IF;
369: -- Debug Message
370: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW,'Private API: - Close Cursor');
371: Close C_Get_price_rltship;
372:
373:
374:

Line 402: P_Validation_mode => ASO_UTILITY_PVT.G_CREATE,

398:
399: -- Invoke validation procedures
400: Validate_PRICE_ADJ_RLTSHIP(
401: P_Validation_level => p_validation_level,
402: P_Validation_mode => ASO_UTILITY_PVT.G_CREATE,
403: P_PRICE_ADJ_RLTSHIP_Rec => P_PRICE_ADJ_RLTSHIP_rec,
404: x_return_status => x_return_status,
405: x_msg_count => x_msg_count,
406: x_msg_data => x_msg_data);

Line 417: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');

413:
414: -- Hint: Add corresponding Master-Detail business logic here if necessary.
415:
416: -- Debug Message
417: -- ASO_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
418:
419: -- Invoke table handler
420: ASO_PRICE_RLTSHIPS_PKG.Update_row
421: (

Line 476: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

472: END IF;
473: */
474: EXCEPTION
475: WHEN FND_API.G_EXC_ERROR THEN
476: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
477: P_API_NAME => L_API_NAME
478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
480: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 480: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

476: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
477: P_API_NAME => L_API_NAME
478: ,P_PKG_NAME => G_PKG_NAME
479: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
480: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
481: ,X_MSG_COUNT => X_MSG_COUNT
482: ,X_MSG_DATA => X_MSG_DATA
483: ,X_RETURN_STATUS => X_RETURN_STATUS);
484:

Line 486: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

482: ,X_MSG_DATA => X_MSG_DATA
483: ,X_RETURN_STATUS => X_RETURN_STATUS);
484:
485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
486: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
487: P_API_NAME => L_API_NAME
488: ,P_PKG_NAME => G_PKG_NAME
489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
490: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 490: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

486: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
487: P_API_NAME => L_API_NAME
488: ,P_PKG_NAME => G_PKG_NAME
489: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
490: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
491: ,X_MSG_COUNT => X_MSG_COUNT
492: ,X_MSG_DATA => X_MSG_DATA
493: ,X_RETURN_STATUS => X_RETURN_STATUS);
494:

Line 496: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

492: ,X_MSG_DATA => X_MSG_DATA
493: ,X_RETURN_STATUS => X_RETURN_STATUS);
494:
495: WHEN OTHERS THEN
496: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
500: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 499: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

495: WHEN OTHERS THEN
496: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
500: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
501: ,X_MSG_COUNT => X_MSG_COUNT
502: ,X_MSG_DATA => X_MSG_DATA
503: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 500: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

496: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
500: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
501: ,X_MSG_COUNT => X_MSG_COUNT
502: ,X_MSG_DATA => X_MSG_DATA
503: ,X_RETURN_STATUS => X_RETURN_STATUS);
504: End Update_price_adj_rltship;

Line 662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

658: END IF;
659: */
660: EXCEPTION
661: WHEN FND_API.G_EXC_ERROR THEN
662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

662: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
663: P_API_NAME => L_API_NAME
664: ,P_PKG_NAME => G_PKG_NAME
665: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
666: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
667: ,X_MSG_COUNT => X_MSG_COUNT
668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);
670:

Line 672: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

668: ,X_MSG_DATA => X_MSG_DATA
669: ,X_RETURN_STATUS => X_RETURN_STATUS);
670:
671: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
672: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
676: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 676: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

672: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
673: P_API_NAME => L_API_NAME
674: ,P_PKG_NAME => G_PKG_NAME
675: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
676: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
677: ,X_MSG_COUNT => X_MSG_COUNT
678: ,X_MSG_DATA => X_MSG_DATA
679: ,X_RETURN_STATUS => X_RETURN_STATUS);
680:

Line 682: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

678: ,X_MSG_DATA => X_MSG_DATA
679: ,X_RETURN_STATUS => X_RETURN_STATUS);
680:
681: WHEN OTHERS THEN
682: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
683: P_API_NAME => L_API_NAME
684: ,P_PKG_NAME => G_PKG_NAME
685: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
686: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 685: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

681: WHEN OTHERS THEN
682: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
683: P_API_NAME => L_API_NAME
684: ,P_PKG_NAME => G_PKG_NAME
685: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
686: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
687: ,X_MSG_COUNT => X_MSG_COUNT
688: ,X_MSG_DATA => X_MSG_DATA
689: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 686: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

682: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
683: P_API_NAME => L_API_NAME
684: ,P_PKG_NAME => G_PKG_NAME
685: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
686: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
687: ,X_MSG_COUNT => X_MSG_COUNT
688: ,X_MSG_DATA => X_MSG_DATA
689: ,X_RETURN_STATUS => X_RETURN_STATUS);
690: