DBA Data[Home] [Help]

APPS.ASO_HEADER_RLTSHIP_PVT dependencies on FND_MSG_PUB

Line 48: FND_MSG_PUB.initialize;

44:
45: -- Initialize message list if p_init_msg_list is set to TRUE.
46: IF FND_API.to_Boolean( p_init_msg_list )
47: THEN
48: FND_MSG_PUB.initialize;
49: END IF;
50:
51:
52:

Line 65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

61: -- Validate Environment
62: -- ******************************************************************
63: IF FND_GLOBAL.User_Id IS NULL
64: THEN
65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
66: THEN
67: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
68: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
69: FND_MSG_PUB.ADD;

Line 69: FND_MSG_PUB.ADD;

65: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
66: THEN
67: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
68: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
69: FND_MSG_PUB.ADD;
70: END IF;
71: RAISE FND_API.G_EXC_ERROR;
72: END IF;
73:

Line 131: FND_MSG_PUB.Count_And_Get

127: END IF;
128:
129:
130: -- Standard call to get message count and if count is 1, get message info.
131: FND_MSG_PUB.Count_And_Get
132: ( p_count => x_msg_count,
133: p_data => x_msg_data
134: );
135: EXCEPTION

Line 140: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
142: ,X_MSG_COUNT => X_MSG_COUNT
143: ,X_MSG_DATA => X_MSG_DATA
144: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 150: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
152: ,X_MSG_COUNT => X_MSG_COUNT
153: ,X_MSG_DATA => X_MSG_DATA
154: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 225: FND_MSG_PUB.initialize;

221:
222: -- Initialize message list if p_init_msg_list is set to TRUE.
223: IF FND_API.to_Boolean( p_init_msg_list )
224: THEN
225: FND_MSG_PUB.initialize;
226: END IF;
227:
228:
229:

Line 258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

254: l_ref_HEADER_RLTSHIP_rec.RELATIONAL_TYPE_CODE,
255: l_ref_HEADER_RLTSHIP_rec.RECIPROCAL_FLAG;
256:
257: If ( C_Get_header_rltship%NOTFOUND) Then
258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
259: THEN
260: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
261: FND_MESSAGE.Set_Token ('INFO', 'header_rltship', FALSE);
262: FND_MSG_PUB.Add;

Line 262: FND_MSG_PUB.Add;

258: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
259: THEN
260: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_UPDATE_TARGET');
261: FND_MESSAGE.Set_Token ('INFO', 'header_rltship', FALSE);
262: FND_MSG_PUB.Add;
263: END IF;
264: raise FND_API.G_EXC_ERROR;
265: END IF;
266: Close C_Get_header_rltship;

Line 270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

266: Close C_Get_header_rltship;
267:
268: If (l_tar_HEADER_RLTSHIP_rec.last_update_date is NULL or
269: l_tar_HEADER_RLTSHIP_rec.last_update_date = FND_API.G_MISS_Date ) Then
270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
271: THEN
272: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
273: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
274: FND_MSG_PUB.ADD;

Line 274: FND_MSG_PUB.ADD;

270: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
271: THEN
272: FND_MESSAGE.Set_Name('ASO', 'API_MISSING_ID');
273: FND_MESSAGE.Set_Token('COLUMN', 'Last_Update_Date', FALSE);
274: FND_MSG_PUB.ADD;
275: END IF;
276: raise FND_API.G_EXC_ERROR;
277: End if;
278: -- Check Whether record has been changed by someone else

Line 280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)

276: raise FND_API.G_EXC_ERROR;
277: End if;
278: -- Check Whether record has been changed by someone else
279: If (l_tar_HEADER_RLTSHIP_rec.last_update_date <> l_ref_HEADER_RLTSHIP_rec.last_update_date) Then
280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
283: FND_MESSAGE.Set_Token('INFO', 'header_rltship', FALSE);
284: FND_MSG_PUB.ADD;

Line 284: FND_MSG_PUB.ADD;

280: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
281: THEN
282: FND_MESSAGE.Set_Name('ASO', 'API_RECORD_CHANGED');
283: FND_MESSAGE.Set_Token('INFO', 'header_rltship', FALSE);
284: FND_MSG_PUB.ADD;
285: END IF;
286: raise FND_API.G_EXC_ERROR;
287: End if;
288:

Line 320: FND_MSG_PUB.Count_And_Get

316:
317:
318:
319: -- Standard call to get message count and if count is 1, get message info.
320: FND_MSG_PUB.Count_And_Get
321: ( p_count => x_msg_count,
322: p_data => x_msg_data
323: );
324: EXCEPTION

Line 329: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
331: ,X_MSG_COUNT => X_MSG_COUNT
332: ,X_MSG_DATA => X_MSG_DATA
333: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 339: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
341: ,X_MSG_COUNT => X_MSG_COUNT
342: ,X_MSG_DATA => X_MSG_DATA
343: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 407: FND_MSG_PUB.initialize;

403:
404: -- Initialize message list if p_init_msg_list is set to TRUE.
405: IF FND_API.to_Boolean( p_init_msg_list )
406: THEN
407: FND_MSG_PUB.initialize;
408: END IF;
409:
410: -- Initialize API return status to SUCCESS
411: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 433: FND_MSG_PUB.Count_And_Get

429:
430:
431:
432: -- Standard call to get message count and if count is 1, get message info.
433: FND_MSG_PUB.Count_And_Get
434: ( p_count => x_msg_count,
435: p_data => x_msg_data
436: );
437:

Line 444: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
446: ,X_MSG_COUNT => X_MSG_COUNT
447: ,X_MSG_DATA => X_MSG_DATA
448: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 454: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
456: ,X_MSG_COUNT => X_MSG_COUNT
457: ,X_MSG_DATA => X_MSG_DATA
458: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 508: FND_MSG_PUB.initialize;

504:
505: -- Initialize message list if p_init_msg_list is set to TRUE.
506: IF FND_API.to_Boolean( p_init_msg_list )
507: THEN
508: FND_MSG_PUB.initialize;
509: END IF;
510:
511:
512: -- Initialize API return status to SUCCESS

Line 540: FND_MSG_PUB.Count_And_Get

536: END IF;
537:
538:
539: -- Standard call to get message count and if count is 1, get message info.
540: FND_MSG_PUB.Count_And_Get
541: ( p_count => x_msg_count,
542: p_data => x_msg_data
543: );
544:

Line 550: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

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
552: ,X_MSG_COUNT => X_MSG_COUNT
553: ,X_MSG_DATA => X_MSG_DATA
554: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 560: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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
562: ,X_MSG_COUNT => X_MSG_COUNT
563: ,X_MSG_DATA => X_MSG_DATA
564: ,X_RETURN_STATUS => X_RETURN_STATUS);

Line 592: FND_MSG_PUB.initialize;

588:
589: -- Initialize message list if p_init_msg_list is set to TRUE.
590: IF FND_API.to_Boolean( p_init_msg_list )
591: THEN
592: FND_MSG_PUB.initialize;
593: END IF;
594:
595:
596: -- Initialize API return status to SUCCESS

Line 607: FND_MSG_PUB.Count_And_Get

603: END IF;
604:
605:
606: -- Standard call to get message count and if count is 1, get message info.
607: FND_MSG_PUB.Count_And_Get
608: ( p_count => x_msg_count,
609: p_data => x_msg_data
610: );
611:

Line 628: FND_MSG_PUB.initialize;

624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:
631:
632: -- Initialize API return status to SUCCESS

Line 636: FND_MSG_PUB.Count_And_Get

632: -- Initialize API return status to SUCCESS
633: x_return_status := FND_API.G_RET_STS_SUCCESS;
634:
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get
637: ( p_count => x_msg_count,
638: p_data => x_msg_data
639: );
640:

Line 658: FND_MSG_PUB.initialize;

654:
655: -- Initialize message list if p_init_msg_list is set to TRUE.
656: IF FND_API.to_Boolean( p_init_msg_list )
657: THEN
658: FND_MSG_PUB.initialize;
659: END IF;
660:
661:
662: -- Initialize API return status to SUCCESS

Line 666: FND_MSG_PUB.Count_And_Get

662: -- Initialize API return status to SUCCESS
663: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: -- Standard call to get message count and if count is 1, get message info.
666: FND_MSG_PUB.Count_And_Get
667: ( p_count => x_msg_count,
668: p_data => x_msg_data
669: );
670:

Line 687: FND_MSG_PUB.initialize;

683:
684: -- Initialize message list if p_init_msg_list is set to TRUE.
685: IF FND_API.to_Boolean( p_init_msg_list )
686: THEN
687: FND_MSG_PUB.initialize;
688: END IF;
689:
690:
691: -- Initialize API return status to SUCCESS

Line 695: FND_MSG_PUB.Count_And_Get

691: -- Initialize API return status to SUCCESS
692: x_return_status := FND_API.G_RET_STS_SUCCESS;
693:
694: -- Standard call to get message count and if count is 1, get message info.
695: FND_MSG_PUB.Count_And_Get
696: ( p_count => x_msg_count,
697: p_data => x_msg_data
698: );
699:

Line 716: FND_MSG_PUB.initialize;

712:
713: -- Initialize message list if p_init_msg_list is set to TRUE.
714: IF FND_API.to_Boolean( p_init_msg_list )
715: THEN
716: FND_MSG_PUB.initialize;
717: END IF;
718:
719:
720: -- Initialize API return status to SUCCESS

Line 725: FND_MSG_PUB.Count_And_Get

721: x_return_status := FND_API.G_RET_STS_SUCCESS;
722:
723:
724: -- Standard call to get message count and if count is 1, get message info.
725: FND_MSG_PUB.Count_And_Get
726: ( p_count => x_msg_count,
727: p_data => x_msg_data
728: );
729:

Line 747: FND_MSG_PUB.initialize;

743:
744: -- Initialize message list if p_init_msg_list is set to TRUE.
745: IF FND_API.to_Boolean( p_init_msg_list )
746: THEN
747: FND_MSG_PUB.initialize;
748: END IF;
749:
750:
751: -- Initialize API return status to SUCCESS

Line 755: FND_MSG_PUB.Count_And_Get

751: -- Initialize API return status to SUCCESS
752: x_return_status := FND_API.G_RET_STS_SUCCESS;
753:
754: -- Standard call to get message count and if count is 1, get message info.
755: FND_MSG_PUB.Count_And_Get
756: ( p_count => x_msg_count,
757: p_data => x_msg_data
758: );
759:

Line 777: FND_MSG_PUB.initialize;

773:
774: -- Initialize message list if p_init_msg_list is set to TRUE.
775: IF FND_API.to_Boolean( p_init_msg_list )
776: THEN
777: FND_MSG_PUB.initialize;
778: END IF;
779:
780:
781: -- Initialize API return status to SUCCESS

Line 783: FND_MSG_PUB.Count_And_Get

779:
780:
781: -- Initialize API return status to SUCCESS
782: x_return_status := FND_API.G_RET_STS_SUCCESS;
783: FND_MSG_PUB.Count_And_Get
784: ( p_count => x_msg_count,
785: p_data => x_msg_data
786: );
787:

Line 807: FND_MSG_PUB.initialize;

803:
804: -- Initialize message list if p_init_msg_list is set to TRUE.
805: IF FND_API.to_Boolean( p_init_msg_list )
806: THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:
810:
811: -- Initialize API return status to SUCCESS

Line 839: FND_MSG_PUB.Count_And_Get

835: x_return_status := FND_API.G_RET_STS_ERROR;
836: end if;
837: END IF;
838: -- Standard call to get message count and if count is 1, get message info.
839: FND_MSG_PUB.Count_And_Get
840: ( p_count => x_msg_count,
841: p_data => x_msg_data
842: );
843:

Line 860: FND_MSG_PUB.initialize;

856:
857: -- Initialize message list if p_init_msg_list is set to TRUE.
858: IF FND_API.to_Boolean( p_init_msg_list )
859: THEN
860: FND_MSG_PUB.initialize;
861: END IF;
862:
863:
864: -- Initialize API return status to SUCCESS

Line 868: FND_MSG_PUB.Count_And_Get

864: -- Initialize API return status to SUCCESS
865: x_return_status := FND_API.G_RET_STS_SUCCESS;
866:
867: -- Standard call to get message count and if count is 1, get message info.
868: FND_MSG_PUB.Count_And_Get
869: ( p_count => x_msg_count,
870: p_data => x_msg_data
871: );
872:

Line 889: FND_MSG_PUB.initialize;

885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.
887: IF FND_API.to_Boolean( p_init_msg_list )
888: THEN
889: FND_MSG_PUB.initialize;
890: END IF;
891:
892:
893: -- Initialize API return status to SUCCESS

Line 898: FND_MSG_PUB.Count_And_Get

894: x_return_status := FND_API.G_RET_STS_SUCCESS;
895:
896:
897: -- Standard call to get message count and if count is 1, get message info.
898: FND_MSG_PUB.Count_And_Get
899: ( p_count => x_msg_count,
900: p_data => x_msg_data
901: );
902: