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:
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;
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:
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
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);
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);
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:
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;
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;
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;
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
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;
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:
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
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);
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);
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;
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:
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);
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);
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
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:
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);
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);
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
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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:
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
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: