DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on ASO_UTILITY_PVT

Line 83: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,

79: -- Invoke validation procedures
80: Validate_header_rltship(
81: p_init_msg_list => FND_API.G_FALSE,
82: p_validation_level => p_validation_level,
83: p_validation_mode => ASO_UTILITY_PVT.G_CREATE,
84: P_HEADER_RLTSHIP_Rec => P_HEADER_RLTSHIP_Rec,
85: x_return_status => x_return_status,
86: x_msg_count => x_msg_count,
87: x_msg_data => x_msg_data);

Line 137: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

133: p_data => x_msg_data
134: );
135: EXCEPTION
136: WHEN FND_API.G_EXC_ERROR THEN
137: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
138: P_API_NAME => L_API_NAME
139: ,P_PKG_NAME => G_PKG_NAME
140: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
141: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 141: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

137: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
138: P_API_NAME => L_API_NAME
139: ,P_PKG_NAME => G_PKG_NAME
140: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
141: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
142: ,X_MSG_COUNT => X_MSG_COUNT
143: ,X_MSG_DATA => X_MSG_DATA
144: ,X_RETURN_STATUS => X_RETURN_STATUS);
145:

Line 147: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

143: ,X_MSG_DATA => X_MSG_DATA
144: ,X_RETURN_STATUS => X_RETURN_STATUS);
145:
146: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
147: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
148: P_API_NAME => L_API_NAME
149: ,P_PKG_NAME => G_PKG_NAME
150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
151: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 151: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

147: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
148: P_API_NAME => L_API_NAME
149: ,P_PKG_NAME => G_PKG_NAME
150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
151: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
152: ,X_MSG_COUNT => X_MSG_COUNT
153: ,X_MSG_DATA => X_MSG_DATA
154: ,X_RETURN_STATUS => X_RETURN_STATUS);
155:

Line 157: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

153: ,X_MSG_DATA => X_MSG_DATA
154: ,X_RETURN_STATUS => X_RETURN_STATUS);
155:
156: WHEN OTHERS THEN
157: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 160: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

156: WHEN OTHERS THEN
157: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
162: ,X_MSG_COUNT => X_MSG_COUNT
163: ,X_MSG_DATA => X_MSG_DATA
164: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 161: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

157: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
158: P_API_NAME => L_API_NAME
159: ,P_PKG_NAME => G_PKG_NAME
160: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
161: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
162: ,X_MSG_COUNT => X_MSG_COUNT
163: ,X_MSG_DATA => X_MSG_DATA
164: ,X_RETURN_STATUS => X_RETURN_STATUS);
165:

Line 326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

322: p_data => x_msg_data
323: );
324: EXCEPTION
325: WHEN FND_API.G_EXC_ERROR THEN
326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
327: P_API_NAME => L_API_NAME
328: ,P_PKG_NAME => G_PKG_NAME
329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

326: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
327: P_API_NAME => L_API_NAME
328: ,P_PKG_NAME => G_PKG_NAME
329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
330: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
331: ,X_MSG_COUNT => X_MSG_COUNT
332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);
334:

Line 336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);
334:
335: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
337: P_API_NAME => L_API_NAME
338: ,P_PKG_NAME => G_PKG_NAME
339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

336: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
337: P_API_NAME => L_API_NAME
338: ,P_PKG_NAME => G_PKG_NAME
339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
340: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
341: ,X_MSG_COUNT => X_MSG_COUNT
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);
344:

Line 346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);
344:
345: WHEN OTHERS THEN
346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

345: WHEN OTHERS THEN
346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
351: ,X_MSG_COUNT => X_MSG_COUNT
352: ,X_MSG_DATA => X_MSG_DATA
353: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

346: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
350: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
351: ,X_MSG_COUNT => X_MSG_COUNT
352: ,X_MSG_DATA => X_MSG_DATA
353: ,X_RETURN_STATUS => X_RETURN_STATUS);
354: End Update_header_rltship;

Line 441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

437:
438:
439: EXCEPTION
440: WHEN FND_API.G_EXC_ERROR THEN
441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

441: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
442: P_API_NAME => L_API_NAME
443: ,P_PKG_NAME => G_PKG_NAME
444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
445: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
446: ,X_MSG_COUNT => X_MSG_COUNT
447: ,X_MSG_DATA => X_MSG_DATA
448: ,X_RETURN_STATUS => X_RETURN_STATUS);
449:

Line 451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

447: ,X_MSG_DATA => X_MSG_DATA
448: ,X_RETURN_STATUS => X_RETURN_STATUS);
449:
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_API_NAME => L_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

451: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
452: P_API_NAME => L_API_NAME
453: ,P_PKG_NAME => G_PKG_NAME
454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
455: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459:

Line 461: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);
459:
460: WHEN OTHERS THEN
461: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
462: P_API_NAME => L_API_NAME
463: ,P_PKG_NAME => G_PKG_NAME
464: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
465: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 464: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

460: WHEN OTHERS THEN
461: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
462: P_API_NAME => L_API_NAME
463: ,P_PKG_NAME => G_PKG_NAME
464: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
465: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
466: ,X_MSG_COUNT => X_MSG_COUNT
467: ,X_MSG_DATA => X_MSG_DATA
468: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 465: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

461: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
462: P_API_NAME => L_API_NAME
463: ,P_PKG_NAME => G_PKG_NAME
464: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
465: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
466: ,X_MSG_COUNT => X_MSG_COUNT
467: ,X_MSG_DATA => X_MSG_DATA
468: ,X_RETURN_STATUS => X_RETURN_STATUS);
469: End Delete_header_rltship;

Line 547: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

543: );
544:
545: EXCEPTION
546: WHEN FND_API.G_EXC_ERROR THEN
547: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
548: P_API_NAME => L_API_NAME
549: ,P_PKG_NAME => G_PKG_NAME
550: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
551: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 551: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

547: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
548: P_API_NAME => L_API_NAME
549: ,P_PKG_NAME => G_PKG_NAME
550: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
551: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
552: ,X_MSG_COUNT => X_MSG_COUNT
553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);
555:

Line 557: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);
555:
556: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
557: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_API_NAME => L_API_NAME
559: ,P_PKG_NAME => G_PKG_NAME
560: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
561: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 561: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

557: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
558: P_API_NAME => L_API_NAME
559: ,P_PKG_NAME => G_PKG_NAME
560: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
561: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
562: ,X_MSG_COUNT => X_MSG_COUNT
563: ,X_MSG_DATA => X_MSG_DATA
564: ,X_RETURN_STATUS => X_RETURN_STATUS);
565:

Line 567: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(

563: ,X_MSG_DATA => X_MSG_DATA
564: ,X_RETURN_STATUS => X_RETURN_STATUS);
565:
566: WHEN OTHERS THEN
567: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
568: P_API_NAME => L_API_NAME
569: ,P_PKG_NAME => G_PKG_NAME
570: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
571: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

Line 570: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS

566: WHEN OTHERS THEN
567: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
568: P_API_NAME => L_API_NAME
569: ,P_PKG_NAME => G_PKG_NAME
570: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
571: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
572: ,X_MSG_COUNT => X_MSG_COUNT
573: ,X_MSG_DATA => X_MSG_DATA
574: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 571: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT

567: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
568: P_API_NAME => L_API_NAME
569: ,P_PKG_NAME => G_PKG_NAME
570: ,P_EXCEPTION_LEVEL => ASO_UTILITY_PVT.G_EXC_OTHERS
571: ,P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
572: ,X_MSG_COUNT => X_MSG_COUNT
573: ,X_MSG_DATA => X_MSG_DATA
574: ,X_RETURN_STATUS => X_RETURN_STATUS);
575: End Delete_header_rltship;

Line 820: IF((p_validation_mode = ASO_UTILITY_PVT.G_CREATE) OR (p_validation_mode = ASO_UTILITY_PVT.G_UPDATE and p_RELATIONSHIP_TYPE_CODE <> FND_API.G_MISS_CHAR))

816: THEN
817: x_return_status := FND_API.G_RET_STS_ERROR;
818: END IF;
819:
820: IF((p_validation_mode = ASO_UTILITY_PVT.G_CREATE) OR (p_validation_mode = ASO_UTILITY_PVT.G_UPDATE and p_RELATIONSHIP_TYPE_CODE <> FND_API.G_MISS_CHAR))
821: THEN
822: -- Hint: Validate data
823: -- IF p_RELATIONSHIP_TYPE_CODE is not NULL and p_RELATIONSHIP_TYPE_CODE <> G_MISS_CHAR
824: -- verify if data is valid