eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ASO_RLTSHIP_PUB dependencies on FND_API

Line 23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

19: -- Pre-Req :
20: -- Parameters:
21: -- IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
26: -- Version : Current version 2.0
27: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters

Line 24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

20: -- Parameters:
21: -- IN
22: -- p_api_version_number IN NUMBER Required
23: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
24: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
25: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
26: -- Version : Current version 2.0
27: -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
28: -- and basic operation, developer must manually add parameters and business logic as necessary.

Line 34: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

30: -- End of Comments
31: --
32: PROCEDURE Create_Line_Relationship(
33: P_Api_Version_Number IN NUMBER,
34: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
35: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
36: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
37: X_line_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
38: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 35: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

31: --
32: PROCEDURE Create_Line_Relationship(
33: P_Api_Version_Number IN NUMBER,
34: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
35: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
36: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
37: X_line_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
38: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
39: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

46: -- Standard Start of API savepoint
47: SAVEPOINT CREATE_LINE_RELATIONSHIP_PUB;
48:
49: -- Standard call to check for call compatibility.
50: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN

Line 55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

51: p_api_version_number,
52: l_api_name,
53: G_PKG_NAME)
54: THEN
55: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 60: IF FND_API.to_Boolean( p_init_msg_list )

56: END IF;
57:
58:
59: -- Initialize message list if p_init_msg_list is set to TRUE.
60: IF FND_API.to_Boolean( p_init_msg_list )
61: THEN
62: FND_MSG_PUB.initialize;
63: END IF;
64:

Line 71: x_return_status := FND_API.G_RET_STS_SUCCESS;

67: --AS_UTILITY_PVT.Print(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: ' || l_api_name || 'start');
68:
69:
70: -- Initialize API return status to SUCCESS
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
73: --
74: -- API body
75: --

Line 87: RAISE FND_API.G_EXC_ERROR;

83: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
84: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
85: FND_MSG_PUB.ADD;
86: END IF;
87: RAISE FND_API.G_EXC_ERROR;
88: END IF;
89:
90:
91: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(

Line 93: P_Init_Msg_List => FND_API.G_FALSE ,

89:
90:
91: ASO_LINE_RLTSHIP_PVT.Create_line_rltship(
92: P_Api_Version_Number => 1.0,
93: P_Init_Msg_List => FND_API.G_FALSE ,
94: P_LINE_RLTSHIP_Rec => P_LINE_RLTSHIP_Rec ,
95: X_LINE_RELATIONSHIP_ID => X_LINE_RELATIONSHIP_ID ,
96: X_Return_Status => X_Return_Status ,
97: X_Msg_Count => X_Msg_Count,

Line 106: IF FND_API.to_Boolean( p_commit )

102: -- End of API body
103: --
104:
105: -- Standard check for p_commit
106: IF FND_API.to_Boolean( p_commit )
107: THEN
108: COMMIT WORK;
109: END IF;
110:

Line 120: WHEN FND_API.G_EXC_ERROR THEN

116: );
117:
118:
119: EXCEPTION
120: WHEN FND_API.G_EXC_ERROR THEN
121: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
122: P_API_NAME => L_API_NAME
123: ,P_PKG_NAME => G_PKG_NAME
124: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

126: ,X_MSG_COUNT => X_MSG_COUNT
127: ,X_MSG_DATA => X_MSG_DATA
128: ,X_RETURN_STATUS => X_RETURN_STATUS);
129:
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
132: P_API_NAME => L_API_NAME
133: ,P_PKG_NAME => G_PKG_NAME
134: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

160: -- Pre-Req :
161: -- Parameters:
162: -- IN
163: -- p_api_version_number IN NUMBER Required
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
165: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
166: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
167: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
168: -- Version : Current version 2.0

Line 165: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

161: -- Parameters:
162: -- IN
163: -- p_api_version_number IN NUMBER Required
164: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
165: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
166: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
167: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
168: -- Version : Current version 2.0
169: -- End of Comments

Line 173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

169: -- End of Comments
170:
171: PROCEDURE Update_Line_Relationship(
172: P_Api_Version_Number IN NUMBER,
173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
175: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

170:
171: PROCEDURE Update_Line_Relationship(
172: P_Api_Version_Number IN NUMBER,
173: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
174: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
175: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_REC,
176: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
177: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
178: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

185: -- Standard Start of API savepoint
186: SAVEPOINT UPDATE_LINE_RELATIONSHIP_PUB;
187:
188: -- Standard call to check for call compatibility.
189: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
190: p_api_version_number,
191: l_api_name,
192: G_PKG_NAME)
193: THEN

Line 194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

190: p_api_version_number,
191: l_api_name,
192: G_PKG_NAME)
193: THEN
194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
195: END IF;
196:
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 199: IF FND_API.to_Boolean( p_init_msg_list )

195: END IF;
196:
197:
198: -- Initialize message list if p_init_msg_list is set to TRUE.
199: IF FND_API.to_Boolean( p_init_msg_list )
200: THEN
201: FND_MSG_PUB.initialize;
202: END IF;
203:

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

203:
204:
205:
206: -- Initialize API return status to SUCCESS
207: x_return_status := FND_API.G_RET_STS_SUCCESS;
208: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
209: --
210: -- API body
211: --

Line 224: RAISE FND_API.G_EXC_ERROR;

220: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
221: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
222: FND_MSG_PUB.ADD;
223: END IF;
224: RAISE FND_API.G_EXC_ERROR;
225: END IF;
226:
227:
228: ASO_LINE_RLTSHIP_PVT.Update_line_rltship(

Line 230: P_Init_Msg_List => FND_API.G_FALSE,

226:
227:
228: ASO_LINE_RLTSHIP_PVT.Update_line_rltship(
229: P_Api_Version_Number => 1.0,
230: P_Init_Msg_List => FND_API.G_FALSE,
231: P_LINE_RLTSHIP_Rec => P_LINE_RLTSHIP_Rec,
232: X_Return_Status => X_Return_Status ,
233: X_Msg_Count => X_Msg_Count,
234: X_Msg_Data => X_Msg_Data

Line 243: IF FND_API.to_Boolean( p_commit )

239: -- End of API body
240: --
241:
242: -- Standard check for p_commit
243: IF FND_API.to_Boolean( p_commit )
244: THEN
245: COMMIT WORK;
246: END IF;
247:

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: );
253:
254:
255: EXCEPTION
256: WHEN FND_API.G_EXC_ERROR THEN
257: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
258: P_API_NAME => L_API_NAME
259: ,P_PKG_NAME => G_PKG_NAME
260: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

262: ,X_MSG_COUNT => X_MSG_COUNT
263: ,X_MSG_DATA => X_MSG_DATA
264: ,X_RETURN_STATUS => X_RETURN_STATUS);
265:
266: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
267: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
268: P_API_NAME => L_API_NAME
269: ,P_PKG_NAME => G_PKG_NAME
270: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

296: -- Pre-Req :
297: -- Parameters:
298: -- IN
299: -- p_api_version_number IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
302: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
303: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
304: -- End of Comments

Line 301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

297: -- Parameters:
298: -- IN
299: -- p_api_version_number IN NUMBER Required
300: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
301: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
302: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
303: -- P_Line_Rltship_Tbl IN Line_Rltship_Tbl_Type
304: -- End of Comments
305: --

Line 309: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

305: --
306:
307: PROCEDURE Delete_Line_Relationship(
308: P_Api_Version_Number IN NUMBER,
309: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
310: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
311: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
312: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_rec,
313: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 310: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

306:
307: PROCEDURE Delete_Line_Relationship(
308: P_Api_Version_Number IN NUMBER,
309: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
310: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
311: p_control_rec IN ASO_QUOTE_PUB.control_rec_type := ASO_QUOTE_PUB.G_MISS_Control_Rec,
312: P_Line_Rltship_Rec IN ASO_QUOTE_PUB.Line_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_line_rltship_rec,
313: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
314: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

322: -- Standard Start of API savepoint
323: SAVEPOINT DELETE_LINE_RELATIONSHIP_PUB;
324:
325: -- Standard call to check for call compatibility.
326: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)
330: THEN

Line 331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

327: p_api_version_number,
328: l_api_name,
329: G_PKG_NAME)
330: THEN
331: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
332: END IF;
333:
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 336: IF FND_API.to_Boolean( p_init_msg_list )

332: END IF;
333:
334:
335: -- Initialize message list if p_init_msg_list is set to TRUE.
336: IF FND_API.to_Boolean( p_init_msg_list )
337: THEN
338: FND_MSG_PUB.initialize;
339: END IF;
340:

Line 343: x_return_status := FND_API.G_RET_STS_SUCCESS;

339: END IF;
340:
341:
342: -- Initialize API return status to SUCCESS
343: x_return_status := FND_API.G_RET_STS_SUCCESS;
344: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
345: --
346: -- API body
347: --

Line 360: RAISE FND_API.G_EXC_ERROR;

356: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
357: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
358: FND_MSG_PUB.ADD;
359: END IF;
360: RAISE FND_API.G_EXC_ERROR;
361: END IF;
362:
363: ASO_LINE_RLTSHIP_PVT.Delete_line_rltship(
364: P_Api_Version_Number => 1.0,

Line 365: P_Init_Msg_List => FND_API.G_FALSE,

361: END IF;
362:
363: ASO_LINE_RLTSHIP_PVT.Delete_line_rltship(
364: P_Api_Version_Number => 1.0,
365: P_Init_Msg_List => FND_API.G_FALSE,
366: p_control_rec => p_control_rec,
367: P_LINE_RLTSHIP_Rec => P_LINE_RLTSHIP_Rec,
368: X_Return_Status => X_Return_Status ,
369: X_Msg_Count => X_Msg_Count,

Line 380: IF FND_API.to_Boolean( p_commit )

376: -- End of API body
377: --
378:
379: -- Standard check for p_commit
380: IF FND_API.to_Boolean( p_commit )
381: THEN
382: COMMIT WORK;
383: END IF;
384:

Line 394: WHEN FND_API.G_EXC_ERROR THEN

390: );
391:
392:
393: EXCEPTION
394: WHEN FND_API.G_EXC_ERROR THEN
395: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
396: P_API_NAME => L_API_NAME
397: ,P_PKG_NAME => G_PKG_NAME
398: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

402: ,X_MSG_COUNT => X_MSG_COUNT
403: ,X_MSG_DATA => X_MSG_DATA
404: ,X_RETURN_STATUS => X_RETURN_STATUS);
405:
406: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
407: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
408: P_API_NAME => L_API_NAME
409: ,P_PKG_NAME => G_PKG_NAME
410: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 443: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

439: -- Pre-Req :
440: -- Parameters:
441: -- IN
442: -- p_api_version_number IN NUMBER Required
443: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
444: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
445: -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
446: --
447:

Line 444: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

440: -- Parameters:
441: -- IN
442: -- p_api_version_number IN NUMBER Required
443: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
444: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
445: -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
446: --
447:
448: PROCEDURE Create_Header_Relationship(

Line 450: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

446: --
447:
448: PROCEDURE Create_Header_Relationship(
449: P_Api_Version_Number IN NUMBER,
450: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
451: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
452: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_header_rltship_REC,
453: X_Header_rltship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
454: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 451: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

447:
448: PROCEDURE Create_Header_Relationship(
449: P_Api_Version_Number IN NUMBER,
450: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
451: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
452: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_header_rltship_REC,
453: X_Header_rltship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
454: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
455: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

464: -- Standard Start of API savepoint
465: SAVEPOINT CREATE_HEADER_RELATIONSHIP_PUB;
466:
467: -- Standard call to check for call compatibility.
468: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN

Line 473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

469: p_api_version_number,
470: l_api_name,
471: G_PKG_NAME)
472: THEN
473: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
474: END IF;
475:
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 478: IF FND_API.to_Boolean( p_init_msg_list )

474: END IF;
475:
476:
477: -- Initialize message list if p_init_msg_list is set to TRUE.
478: IF FND_API.to_Boolean( p_init_msg_list )
479: THEN
480: FND_MSG_PUB.initialize;
481: END IF;
482:

Line 484: x_return_status := FND_API.G_RET_STS_SUCCESS;

480: FND_MSG_PUB.initialize;
481: END IF;
482:
483: -- Initialize API return status to SUCCESS
484: x_return_status := FND_API.G_RET_STS_SUCCESS;
485: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
486: --
487: -- API body
488: --

Line 501: RAISE FND_API.G_EXC_ERROR;

497: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
498: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
499: FND_MSG_PUB.ADD;
500: END IF;
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:
504:
505:

Line 508: P_Init_Msg_List => FND_API.G_FALSE ,

504:
505:
506: ASO_HEADER_RLTSHIP_PVT.Create_header_rltship(
507: P_Api_Version_Number => 1.0,
508: P_Init_Msg_List => FND_API.G_FALSE ,
509: P_HEADER_RLTSHIP_Rec => P_HEADER_RLTSHIP_Rec ,
510: X_HEADER_RELATIONSHIP_ID => X_HEADER_RLTSHIP_ID ,
511: X_Return_Status => X_Return_Status ,
512: X_Msg_Count => X_Msg_Count,

Line 521: IF FND_API.to_Boolean( p_commit )

517: -- End of API body
518: --
519:
520: -- Standard check for p_commit
521: IF FND_API.to_Boolean( p_commit )
522: THEN
523: COMMIT WORK;
524: END IF;
525:

Line 533: WHEN FND_API.G_EXC_ERROR THEN

529: );
530:
531:
532: EXCEPTION
533: WHEN FND_API.G_EXC_ERROR THEN
534: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
535: P_API_NAME => L_API_NAME
536: ,P_PKG_NAME => G_PKG_NAME
537: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

541: ,X_MSG_COUNT => X_MSG_COUNT
542: ,X_MSG_DATA => X_MSG_DATA
543: ,X_RETURN_STATUS => X_RETURN_STATUS);
544:
545: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
546: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
547: P_API_NAME => L_API_NAME
548: ,P_PKG_NAME => G_PKG_NAME
549: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 581: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

577: -- Pre-Req :
578: -- Parameters:
579: -- IN
580: -- p_api_version_number IN NUMBER Required
581: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
582: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
583: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
584: -- End of Comments
585: --

Line 582: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

578: -- Parameters:
579: -- IN
580: -- p_api_version_number IN NUMBER Required
581: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
582: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
583: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
584: -- End of Comments
585: --
586: PROCEDURE Update_Header_Relationship(

Line 588: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

584: -- End of Comments
585: --
586: PROCEDURE Update_Header_Relationship(
587: P_Api_Version_Number IN NUMBER,
588: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
589: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
590: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
591: G_MISS_header_rltship_REC,
592: X_header_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 589: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

585: --
586: PROCEDURE Update_Header_Relationship(
587: P_Api_Version_Number IN NUMBER,
588: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
589: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
590: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
591: G_MISS_header_rltship_REC,
592: X_header_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
593: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

602: -- Standard Start of API savepoint
603: SAVEPOINT UPDATE_HEADER_RELATIONSHIP_PUB;
604:
605: -- Standard call to check for call compatibility.
606: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
607: p_api_version_number,
608: l_api_name,
609: G_PKG_NAME)
610: THEN

Line 611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

607: p_api_version_number,
608: l_api_name,
609: G_PKG_NAME)
610: THEN
611: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
612: END IF;
613:
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 616: IF FND_API.to_Boolean( p_init_msg_list )

612: END IF;
613:
614:
615: -- Initialize message list if p_init_msg_list is set to TRUE.
616: IF FND_API.to_Boolean( p_init_msg_list )
617: THEN
618: FND_MSG_PUB.initialize;
619: END IF;
620:

Line 623: x_return_status := FND_API.G_RET_STS_SUCCESS;

619: END IF;
620:
621:
622: -- Initialize API return status to SUCCESS
623: x_return_status := FND_API.G_RET_STS_SUCCESS;
624: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
625: --
626: -- API body
627: --

Line 640: RAISE FND_API.G_EXC_ERROR;

636: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
637: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
638: FND_MSG_PUB.ADD;
639: END IF;
640: RAISE FND_API.G_EXC_ERROR;
641: END IF;
642:
643:
644:

Line 647: P_Init_Msg_List => FND_API.G_FALSE ,

643:
644:
645: ASO_HEADER_RLTSHIP_PVT.Update_header_rltship(
646: P_Api_Version_Number => 1.0,
647: P_Init_Msg_List => FND_API.G_FALSE ,
648: P_HEADER_RLTSHIP_Rec => P_HEADER_RLTSHIP_Rec ,
649: X_Return_Status => X_Return_Status ,
650: X_Msg_Count => X_Msg_Count,
651: X_Msg_Data => X_Msg_Data

Line 660: IF FND_API.to_Boolean( p_commit )

656: -- End of API body
657: --
658:
659: -- Standard check for p_commit
660: IF FND_API.to_Boolean( p_commit )
661: THEN
662: COMMIT WORK;
663: END IF;
664:

Line 674: WHEN FND_API.G_EXC_ERROR THEN

670: p_data => x_msg_data
671: );
672:
673: EXCEPTION
674: WHEN FND_API.G_EXC_ERROR THEN
675: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
676: P_API_NAME => L_API_NAME
677: ,P_PKG_NAME => G_PKG_NAME
678: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

682: ,X_MSG_COUNT => X_MSG_COUNT
683: ,X_MSG_DATA => X_MSG_DATA
684: ,X_RETURN_STATUS => X_RETURN_STATUS);
685:
686: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
687: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
688: P_API_NAME => L_API_NAME
689: ,P_PKG_NAME => G_PKG_NAME
690: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 723: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

719: -- Pre-Req :
720: -- Parameters:
721: -- IN
722: -- p_api_version_number IN NUMBER Required
723: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
724: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
725: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
726: -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
727: -- End of Comments

Line 724: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

720: -- Parameters:
721: -- IN
722: -- p_api_version_number IN NUMBER Required
723: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
724: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
725: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
726: -- P_Header_Relationship_Rec IN Header_Relationship_Rec_Type
727: -- End of Comments
728: --

Line 731: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

727: -- End of Comments
728: --
729: PROCEDURE Delete_Header_Relationship(
730: P_Api_Version_Number IN NUMBER,
731: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
732: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
733: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
734: G_MISS_header_rltship_REC,
735: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 732: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

728: --
729: PROCEDURE Delete_Header_Relationship(
730: P_Api_Version_Number IN NUMBER,
731: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
732: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
733: P_Header_Rltship_Rec IN ASO_QUOTE_PUB.Header_Rltship_Rec_Type := ASO_QUOTE_PUB.
734: G_MISS_header_rltship_REC,
735: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
736: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

745: -- Standard Start of API savepoint
746: SAVEPOINT DELETE_HEADER_RELATIONSHIP_PUB;
747:
748: -- Standard call to check for call compatibility.
749: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
750: p_api_version_number,
751: l_api_name,
752: G_PKG_NAME)
753: THEN

Line 754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

750: p_api_version_number,
751: l_api_name,
752: G_PKG_NAME)
753: THEN
754: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
755: END IF;
756:
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 759: IF FND_API.to_Boolean( p_init_msg_list )

755: END IF;
756:
757:
758: -- Initialize message list if p_init_msg_list is set to TRUE.
759: IF FND_API.to_Boolean( p_init_msg_list )
760: THEN
761: FND_MSG_PUB.initialize;
762: END IF;
763:

Line 767: x_return_status := FND_API.G_RET_STS_SUCCESS;

763:
764:
765:
766: -- Initialize API return status to SUCCESS
767: x_return_status := FND_API.G_RET_STS_SUCCESS;
768: --
769: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
770: -- API body
771: --

Line 784: RAISE FND_API.G_EXC_ERROR;

780: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
781: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
782: FND_MSG_PUB.ADD;
783: END IF;
784: RAISE FND_API.G_EXC_ERROR;
785: END IF;
786:
787:
788:

Line 792: P_Init_Msg_List => FND_API.G_FALSE ,

788:
789:
790: ASO_HEADER_RLTSHIP_PVT.Delete_header_rltship(
791: P_Api_Version_Number => 1.0,
792: P_Init_Msg_List => FND_API.G_FALSE ,
793: P_HEADER_RLTSHIP_id => P_HEADER_RLTSHIP_Rec.header_relationship_id ,
794: X_Return_Status => X_Return_Status ,
795: X_Msg_Count => X_Msg_Count,
796: X_Msg_Data => X_Msg_Data

Line 804: IF FND_API.to_Boolean( p_commit )

800: -- End of API body
801: --
802:
803: -- Standard check for p_commit
804: IF FND_API.to_Boolean( p_commit )
805: THEN
806: COMMIT WORK;
807: END IF;
808:

Line 817: WHEN FND_API.G_EXC_ERROR THEN

813: p_data => x_msg_data
814: );
815:
816: EXCEPTION
817: WHEN FND_API.G_EXC_ERROR THEN
818: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
819: P_API_NAME => L_API_NAME
820: ,P_PKG_NAME => G_PKG_NAME
821: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

823: ,X_MSG_COUNT => X_MSG_COUNT
824: ,X_MSG_DATA => X_MSG_DATA
825: ,X_RETURN_STATUS => X_RETURN_STATUS);
826:
827: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
828: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
829: P_API_NAME => L_API_NAME
830: ,P_PKG_NAME => G_PKG_NAME
831: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 860: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

856: -- Pre-Req :
857: -- Parameters:
858: -- IN
859: -- p_api_version_number IN NUMBER Required
860: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
861: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
862: -- End of Comments
863: --
864: PROCEDURE Create_Party_Relationship(

Line 861: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

857: -- Parameters:
858: -- IN
859: -- p_api_version_number IN NUMBER Required
860: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
861: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
862: -- End of Comments
863: --
864: PROCEDURE Create_Party_Relationship(
865: P_Api_Version_Number IN NUMBER,

Line 866: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

862: -- End of Comments
863: --
864: PROCEDURE Create_Party_Relationship(
865: P_Api_Version_Number IN NUMBER,
866: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
867: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
868: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
869: X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
870: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 867: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

863: --
864: PROCEDURE Create_Party_Relationship(
865: P_Api_Version_Number IN NUMBER,
866: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
867: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
868: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
869: X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
870: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
871: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 881: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN

877: BEGIN
878:
879: SAVEPOINT CREATE_PARTY_RELATIONSHIP_PUB;
880:
881: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884:
885:

Line 882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

878:
879: SAVEPOINT CREATE_PARTY_RELATIONSHIP_PUB;
880:
881: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,p_api_version_number,l_api_name,G_PKG_NAME) THEN
882: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
883: END IF;
884:
885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 887: IF FND_API.to_Boolean( p_init_msg_list ) THEN

883: END IF;
884:
885:
886: -- Initialize message list if p_init_msg_list is set to TRUE.
887: IF FND_API.to_Boolean( p_init_msg_list ) THEN
888: FND_MSG_PUB.initialize;
889: END IF;
890:
891:

Line 893: x_return_status := FND_API.G_RET_STS_SUCCESS;

889: END IF;
890:
891:
892: -- Initialize API return status to SUCCESS
893: x_return_status := FND_API.G_RET_STS_SUCCESS;
894: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
895:
896: --
897: -- API body

Line 907: RAISE FND_API.G_EXC_ERROR;

903: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
904: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
905: FND_MSG_PUB.ADD;
906: END IF;
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910:
911:

Line 914: P_Init_Msg_List => FND_API.G_FALSE ,

910:
911:
912: ASO_PARTY_RLTSHIP_PVT.Create_party_rltship(
913: P_Api_Version_Number => 1.0,
914: P_Init_Msg_List => FND_API.G_FALSE ,
915: P_PARTY_RLTSHIP_Rec => P_PARTY_RLTSHIP_Rec ,
916: X_PARTY_RELATIONSHIP_ID => X_PARTY_RELATIONSHIP_ID ,
917: X_Return_Status => X_Return_Status ,
918: X_Msg_Count => X_Msg_Count,

Line 927: IF FND_API.to_Boolean( p_commit ) THEN

923: -- End of API body
924: --
925:
926: -- Standard check for p_commit
927: IF FND_API.to_Boolean( p_commit ) THEN
928: COMMIT WORK;
929: END IF;
930:
931:

Line 940: WHEN FND_API.G_EXC_ERROR THEN

936: p_data => x_msg_data
937: );
938:
939: EXCEPTION
940: WHEN FND_API.G_EXC_ERROR THEN
941: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
942: P_API_NAME => L_API_NAME
943: ,P_PKG_NAME => G_PKG_NAME
944: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

946: ,X_MSG_COUNT => X_MSG_COUNT
947: ,X_MSG_DATA => X_MSG_DATA
948: ,X_RETURN_STATUS => X_RETURN_STATUS);
949:
950: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
951: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
952: P_API_NAME => L_API_NAME
953: ,P_PKG_NAME => G_PKG_NAME
954: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 983: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

979: -- Pre-Req :
980: -- Parameters:
981: -- IN
982: -- p_api_version_number IN NUMBER Required
983: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
984: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
985: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
986: -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
987: -- Version : Current version 2.0

Line 984: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

980: -- Parameters:
981: -- IN
982: -- p_api_version_number IN NUMBER Required
983: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
984: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
985: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
986: -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
987: -- Version : Current version 2.0
988: --

Line 993: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

989: -- End of Comments
990: --
991: PROCEDURE Update_Party_Relationship(
992: P_Api_Version_Number IN NUMBER,
993: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
994: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
995: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
996: X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
997: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 994: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

990: --
991: PROCEDURE Update_Party_Relationship(
992: P_Api_Version_Number IN NUMBER,
993: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
994: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
995: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
996: X_party_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
997: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
998: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1009: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN

1005:
1006: -- Standard Start of API savepoint
1007: SAVEPOINT UPDATE_PARTY_RELATIONSHIP_PUB;
1008:
1009: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END IF;
1012:
1013:

Line 1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1006: -- Standard Start of API savepoint
1007: SAVEPOINT UPDATE_PARTY_RELATIONSHIP_PUB;
1008:
1009: IF NOT FND_API.Compatible_API_Call ( l_api_version_number, p_api_version_number,l_api_name,G_PKG_NAME) THEN
1010: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1011: END IF;
1012:
1013:
1014: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1011: END IF;
1012:
1013:
1014: -- Initialize message list if p_init_msg_list is set to TRUE.
1015: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1016: FND_MSG_PUB.initialize;
1017: END IF;
1018:
1019:

Line 1022: x_return_status := FND_API.G_RET_STS_SUCCESS;

1018:
1019:
1020:
1021: -- Initialize API return status to SUCCESS
1022: x_return_status := FND_API.G_RET_STS_SUCCESS;
1023: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1024: --
1025: -- API body
1026: --

Line 1035: RAISE FND_API.G_EXC_ERROR;

1031: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1032: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1033: FND_MSG_PUB.ADD;
1034: END IF;
1035: RAISE FND_API.G_EXC_ERROR;
1036: END IF;
1037:
1038: ASO_PARTY_RLTSHIP_PVT.Update_party_rltship(
1039: P_Api_Version_Number => 1.0,

Line 1040: P_Init_Msg_List => FND_API.G_FALSE ,

1036: END IF;
1037:
1038: ASO_PARTY_RLTSHIP_PVT.Update_party_rltship(
1039: P_Api_Version_Number => 1.0,
1040: P_Init_Msg_List => FND_API.G_FALSE ,
1041: P_PARTY_RLTSHIP_Rec => P_PARTY_RLTSHIP_Rec ,
1042: X_Return_Status => X_Return_Status ,
1043: X_Msg_Count => X_Msg_Count,
1044: X_Msg_Data => X_Msg_Data

Line 1052: IF FND_API.to_Boolean( p_commit )

1048: -- End of API body
1049: --
1050:
1051: -- Standard check for p_commit
1052: IF FND_API.to_Boolean( p_commit )
1053: THEN
1054: COMMIT WORK;
1055: END IF;
1056:

Line 1069: WHEN FND_API.G_EXC_ERROR THEN

1065: p_data => x_msg_data
1066: );
1067:
1068: EXCEPTION
1069: WHEN FND_API.G_EXC_ERROR THEN
1070: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1071: P_API_NAME => L_API_NAME
1072: ,P_PKG_NAME => G_PKG_NAME
1073: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1075: ,X_MSG_COUNT => X_MSG_COUNT
1076: ,X_MSG_DATA => X_MSG_DATA
1077: ,X_RETURN_STATUS => X_RETURN_STATUS);
1078:
1079: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1080: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1081: P_API_NAME => L_API_NAME
1082: ,P_PKG_NAME => G_PKG_NAME
1083: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1109: -- Pre-Req :
1110: -- Parameters:
1111: -- IN
1112: -- p_api_version_number IN NUMBER Required
1113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1115: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1116: -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
1117: --

Line 1114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1110: -- Parameters:
1111: -- IN
1112: -- p_api_version_number IN NUMBER Required
1113: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1114: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1115: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1116: -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
1117: --
1118: PROCEDURE Delete_Party_Relationship(

Line 1120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1116: -- P_Party_Relationship_Rec IN Party_Relationship_Rec_Type
1117: --
1118: PROCEDURE Delete_Party_Relationship(
1119: P_Api_Version_Number IN NUMBER,
1120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1122: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
1123: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1124: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1117: --
1118: PROCEDURE Delete_Party_Relationship(
1119: P_Api_Version_Number IN NUMBER,
1120: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1121: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1122: P_Party_Rltship_Rec IN ASO_QUOTE_PUB.Party_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_party_rltship_REC,
1123: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1124: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1125: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1132: -- Standard Start of API savepoint
1133: SAVEPOINT DELETE_PARTY_RELATIONSHIP_PUB;
1134:
1135: -- Standard call to check for call compatibility.
1136: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1137: p_api_version_number,
1138: l_api_name,
1139: G_PKG_NAME)
1140: THEN

Line 1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1137: p_api_version_number,
1138: l_api_name,
1139: G_PKG_NAME)
1140: THEN
1141: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1142: END IF;
1143:
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1146: IF FND_API.to_Boolean( p_init_msg_list )

1142: END IF;
1143:
1144:
1145: -- Initialize message list if p_init_msg_list is set to TRUE.
1146: IF FND_API.to_Boolean( p_init_msg_list )
1147: THEN
1148: FND_MSG_PUB.initialize;
1149: END IF;
1150:

Line 1153: x_return_status := FND_API.G_RET_STS_SUCCESS;

1149: END IF;
1150:
1151:
1152: -- Initialize API return status to SUCCESS
1153: x_return_status := FND_API.G_RET_STS_SUCCESS;
1154: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1155: --
1156: -- API body
1157: --

Line 1168: RAISE FND_API.G_EXC_ERROR;

1164: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1165: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1166: FND_MSG_PUB.ADD;
1167: END IF;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170:
1171: ASO_PARTY_RLTSHIP_PVT.Delete_party_rltship(
1172: P_Api_Version_Number => 1.0,

Line 1173: P_Init_Msg_List => FND_API.G_FALSE ,

1169: END IF;
1170:
1171: ASO_PARTY_RLTSHIP_PVT.Delete_party_rltship(
1172: P_Api_Version_Number => 1.0,
1173: P_Init_Msg_List => FND_API.G_FALSE ,
1174: P_PARTY_RLTSHIP_Rec => P_PARTY_RLTSHIP_Rec ,
1175: X_Return_Status => X_Return_Status ,
1176: X_Msg_Count => X_Msg_Count,
1177: X_Msg_Data => X_Msg_Data

Line 1185: IF FND_API.to_Boolean( p_commit )

1181: -- End of API body
1182: --
1183:
1184: -- Standard check for p_commit
1185: IF FND_API.to_Boolean( p_commit )
1186: THEN
1187: COMMIT WORK;
1188: END IF;
1189:

Line 1200: WHEN FND_API.G_EXC_ERROR THEN

1196: p_data => x_msg_data
1197: );
1198:
1199: EXCEPTION
1200: WHEN FND_API.G_EXC_ERROR THEN
1201: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1202: P_API_NAME => L_API_NAME
1203: ,P_PKG_NAME => G_PKG_NAME
1204: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1206: ,X_MSG_COUNT => X_MSG_COUNT
1207: ,X_MSG_DATA => X_MSG_DATA
1208: ,X_RETURN_STATUS => X_RETURN_STATUS);
1209:
1210: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1211: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1212: P_API_NAME => L_API_NAME
1213: ,P_PKG_NAME => G_PKG_NAME
1214: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1240: -- Pre-Req :
1241: -- Parameters:
1242: -- IN
1243: -- p_api_version_number IN NUMBER Required
1244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1246: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1247: -- Version : Current version 2.0
1248: -- End of Comments

Line 1245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1241: -- Parameters:
1242: -- IN
1243: -- p_api_version_number IN NUMBER Required
1244: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1245: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1246: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1247: -- Version : Current version 2.0
1248: -- End of Comments
1249:

Line 1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1248: -- End of Comments
1249:
1250: PROCEDURE Create_Object_Relationship(
1251: P_Api_Version_Number IN NUMBER,
1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1255: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
1256: X_related_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1249:
1250: PROCEDURE Create_Object_Relationship(
1251: P_Api_Version_Number IN NUMBER,
1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1255: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
1256: X_related_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1257: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1250: PROCEDURE Create_Object_Relationship(
1251: P_Api_Version_Number IN NUMBER,
1252: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1253: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1254: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1255: P_RELATED_OBJ_Rec IN ASO_quote_PUB.RELATED_OBJ_Rec_Type := ASO_quote_PUB.G_MISS_RELATED_OBJ_REC,
1256: X_related_object_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1257: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1258: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1267: -- Standard Start of API savepoint
1268: SAVEPOINT CREATE_OBJECT_RELATIONSHIP_PUB;
1269:
1270: -- Standard call to check for call compatibility.
1271: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1272: p_api_version_number,
1273: l_api_name,
1274: G_PKG_NAME)
1275: THEN

Line 1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1272: p_api_version_number,
1273: l_api_name,
1274: G_PKG_NAME)
1275: THEN
1276: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1277: END IF;
1278:
1279:
1280: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1281: IF FND_API.to_Boolean( p_init_msg_list )

1277: END IF;
1278:
1279:
1280: -- Initialize message list if p_init_msg_list is set to TRUE.
1281: IF FND_API.to_Boolean( p_init_msg_list )
1282: THEN
1283: FND_MSG_PUB.initialize;
1284: END IF;
1285:

Line 1287: x_return_status := FND_API.G_RET_STS_SUCCESS;

1283: FND_MSG_PUB.initialize;
1284: END IF;
1285:
1286: -- Initialize API return status to SUCCESS
1287: x_return_status := FND_API.G_RET_STS_SUCCESS;
1288: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1289: -- API body
1290:
1291:

Line 1301: RAISE FND_API.G_EXC_ERROR;

1297: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1298: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1299: FND_MSG_PUB.ADD;
1300: END IF;
1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303: ASO_RELATED_OBJ_PVT.Create_related_obj(
1304: P_Api_Version_Number => 1.0,
1305: P_Init_Msg_List => FND_API.G_FALSE ,

Line 1305: P_Init_Msg_List => FND_API.G_FALSE ,

1301: RAISE FND_API.G_EXC_ERROR;
1302: END IF;
1303: ASO_RELATED_OBJ_PVT.Create_related_obj(
1304: P_Api_Version_Number => 1.0,
1305: P_Init_Msg_List => FND_API.G_FALSE ,
1306: P_commit => P_commit,
1307: p_validation_level => p_validation_level,
1308: P_RELATED_OBJ_Rec => P_RELATED_OBJ_Rec ,
1309: X_RELATED_OBJECT_ID => X_RELATED_OBJECT_ID ,

Line 1320: IF FND_API.to_Boolean( p_commit )

1316:
1317: -- End of API body
1318:
1319: -- Standard check for p_commit
1320: IF FND_API.to_Boolean( p_commit )
1321: THEN
1322: COMMIT WORK;
1323: END IF;
1324:

Line 1336: WHEN FND_API.G_EXC_ERROR THEN

1332: );
1333:
1334:
1335: EXCEPTION
1336: WHEN FND_API.G_EXC_ERROR THEN
1337: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1338: P_API_NAME => L_API_NAME
1339: ,P_PKG_NAME => G_PKG_NAME
1340: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1344: ,X_MSG_COUNT => X_MSG_COUNT
1345: ,X_MSG_DATA => X_MSG_DATA
1346: ,X_RETURN_STATUS => X_RETURN_STATUS);
1347:
1348: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1349: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1350: P_API_NAME => L_API_NAME
1351: ,P_PKG_NAME => G_PKG_NAME
1352: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1386: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1382: -- Pre-Req :
1383: -- Parameters:
1384: -- IN
1385: -- p_api_version_number IN NUMBER Required
1386: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1387: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1388: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1389: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1390: -- Version : Current version 2.0

Line 1387: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1383: -- Parameters:
1384: -- IN
1385: -- p_api_version_number IN NUMBER Required
1386: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1387: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1388: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1389: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1390: -- Version : Current version 2.0
1391:

Line 1397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1393: -- End of Comments
1394: --
1395: PROCEDURE Update_Object_Relationship(
1396: P_Api_Version_Number IN NUMBER,
1397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1398: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1400: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1401: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1398: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1394: --
1395: PROCEDURE Update_Object_Relationship(
1396: P_Api_Version_Number IN NUMBER,
1397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1398: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1400: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1401: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1402: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1395: PROCEDURE Update_Object_Relationship(
1396: P_Api_Version_Number IN NUMBER,
1397: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1398: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1399: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1400: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1401: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1402: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1403: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1411: -- Standard Start of API savepoint
1412: SAVEPOINT UPDATE_OBJECT_RELATIONSHIP_PUB;
1413:
1414: -- Standard call to check for call compatibility.
1415: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1416: p_api_version_number,
1417: l_api_name,
1418: G_PKG_NAME)
1419: THEN

Line 1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1416: p_api_version_number,
1417: l_api_name,
1418: G_PKG_NAME)
1419: THEN
1420: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1421: END IF;
1422:
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1425: IF FND_API.to_Boolean( p_init_msg_list )

1421: END IF;
1422:
1423:
1424: -- Initialize message list if p_init_msg_list is set to TRUE.
1425: IF FND_API.to_Boolean( p_init_msg_list )
1426: THEN
1427: FND_MSG_PUB.initialize;
1428: END IF;
1429:

Line 1432: x_return_status := FND_API.G_RET_STS_SUCCESS;

1428: END IF;
1429:
1430:
1431: -- Initialize API return status to SUCCESS
1432: x_return_status := FND_API.G_RET_STS_SUCCESS;
1433: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1434: --
1435: -- API body
1436: --

Line 1450: RAISE FND_API.G_EXC_ERROR;

1446: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1447: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1448: FND_MSG_PUB.ADD;
1449: END IF;
1450: RAISE FND_API.G_EXC_ERROR;
1451: END IF;
1452:
1453:
1454:

Line 1457: P_Init_Msg_List => FND_API.G_FALSE ,

1453:
1454:
1455: ASO_RELATED_OBJ_PVT.Update_related_obj(
1456: P_Api_Version_Number => 1.0,
1457: P_Init_Msg_List => FND_API.G_FALSE ,
1458: P_commit => P_commit,
1459: p_validation_level => p_validation_level,
1460: P_RELATED_OBJ_Rec => P_RELATED_OBJ_Rec,
1461: X_Return_Status => X_Return_Status ,

Line 1472: IF FND_API.to_Boolean( p_commit )

1468: -- End of API body
1469: --
1470:
1471: -- Standard check for p_commit
1472: IF FND_API.to_Boolean( p_commit )
1473: THEN
1474: COMMIT WORK;
1475: END IF;
1476:

Line 1486: WHEN FND_API.G_EXC_ERROR THEN

1482: );
1483:
1484:
1485: EXCEPTION
1486: WHEN FND_API.G_EXC_ERROR THEN
1487: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1488: P_API_NAME => L_API_NAME
1489: ,P_PKG_NAME => G_PKG_NAME
1490: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1494: ,X_MSG_COUNT => X_MSG_COUNT
1495: ,X_MSG_DATA => X_MSG_DATA
1496: ,X_RETURN_STATUS => X_RETURN_STATUS);
1497:
1498: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1499: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1500: P_API_NAME => L_API_NAME
1501: ,P_PKG_NAME => G_PKG_NAME
1502: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1535: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1531: -- Pre-Req :
1532: -- Parameters:
1533: -- IN
1534: -- p_api_version_number IN NUMBER Required
1535: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1536: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1537: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1538: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1539: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1536: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1532: -- Parameters:
1533: -- IN
1534: -- p_api_version_number IN NUMBER Required
1535: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1536: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1537: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1538: -- P_Object_Relationship_Rec IN Object_Relationship_Rec_Type
1539: -- x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1540: -- Version : Current version 2.0

Line 1546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1542: -- End of Comments
1543: --
1544: PROCEDURE DELETE_OBJECT_RELATIONSHIP(
1545: P_Api_Version_Number IN NUMBER,
1546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1549: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1550: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1543: --
1544: PROCEDURE DELETE_OBJECT_RELATIONSHIP(
1545: P_Api_Version_Number IN NUMBER,
1546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1549: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1550: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1551: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1544: PROCEDURE DELETE_OBJECT_RELATIONSHIP(
1545: P_Api_Version_Number IN NUMBER,
1546: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1547: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1548: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1549: P_RELATED_OBJ_Rec IN ASO_QUOTE_PUB.RELATED_OBJ_Rec_Type,
1550: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1551: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1552: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1563: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1559: -- Standard Start of API savepoint
1560: SAVEPOINT DELETE_OBJECT_RELATIONSHIP_PUB;
1561:
1562: -- Standard call to check for call compatibility.
1563: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1564: p_api_version_number,
1565: l_api_name,
1566: G_PKG_NAME)
1567: THEN

Line 1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1564: p_api_version_number,
1565: l_api_name,
1566: G_PKG_NAME)
1567: THEN
1568: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1569: END IF;
1570:
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1573: IF FND_API.to_Boolean( p_init_msg_list )

1569: END IF;
1570:
1571:
1572: -- Initialize message list if p_init_msg_list is set to TRUE.
1573: IF FND_API.to_Boolean( p_init_msg_list )
1574: THEN
1575: FND_MSG_PUB.initialize;
1576: END IF;
1577:

Line 1580: x_return_status := FND_API.G_RET_STS_SUCCESS;

1576: END IF;
1577:
1578:
1579: -- Initialize API return status to SUCCESS
1580: x_return_status := FND_API.G_RET_STS_SUCCESS;
1581: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1582: --
1583: -- API body
1584: --

Line 1597: RAISE FND_API.G_EXC_ERROR;

1593: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1594: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1595: FND_MSG_PUB.ADD;
1596: END IF;
1597: RAISE FND_API.G_EXC_ERROR;
1598: END IF;
1599:
1600:
1601:

Line 1604: P_Init_Msg_List => FND_API.G_FALSE ,

1600:
1601:
1602: ASO_RELATED_OBJ_PVT.Delete_related_obj(
1603: P_Api_Version_Number => 1.0,
1604: P_Init_Msg_List => FND_API.G_FALSE ,
1605: P_commit => P_commit,
1606: p_validation_level => p_validation_level,
1607: P_RELATED_OBJ_Rec => P_RELATED_OBJ_Rec ,
1608: X_Return_Status => X_Return_Status ,

Line 1618: IF FND_API.to_Boolean( p_commit )

1614: -- End of API body
1615: --
1616:
1617: -- Standard check for p_commit
1618: IF FND_API.to_Boolean( p_commit )
1619: THEN
1620: COMMIT WORK;
1621: END IF;
1622:

Line 1632: WHEN FND_API.G_EXC_ERROR THEN

1628: ( p_count => x_msg_count,
1629: p_data => x_msg_data);
1630:
1631: EXCEPTION
1632: WHEN FND_API.G_EXC_ERROR THEN
1633: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1634: P_API_NAME => L_API_NAME
1635: ,P_PKG_NAME => G_PKG_NAME
1636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1640: ,X_MSG_COUNT => X_MSG_COUNT
1641: ,X_MSG_DATA => X_MSG_DATA
1642: ,X_RETURN_STATUS => X_RETURN_STATUS);
1643:
1644: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1645: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1646: P_API_NAME => L_API_NAME
1647: ,P_PKG_NAME => G_PKG_NAME
1648: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1676: -- Pre-Req :
1677: -- Parameters:
1678: -- IN
1679: -- p_api_version_number IN NUMBER Required
1680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1682: -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
1683: -- Version : Current version 2.0
1684: -- End of Comments

Line 1681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1677: -- Parameters:
1678: -- IN
1679: -- p_api_version_number IN NUMBER Required
1680: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1681: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1682: -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
1683: -- Version : Current version 2.0
1684: -- End of Comments
1685: --

Line 1688: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1684: -- End of Comments
1685: --
1686: PROCEDURE Create_Price_Adj_Rltship(
1687: P_Api_Version_Number IN NUMBER,
1688: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1689: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1690: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1691: X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1692: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1689: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1685: --
1686: PROCEDURE Create_Price_Adj_Rltship(
1687: P_Api_Version_Number IN NUMBER,
1688: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1689: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1690: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1691: X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1692: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1693: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1705: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1701: -- Standard Start of API savepoint
1702: SAVEPOINT CREATE_PRICE_ADJ_RLTSHIP_PUB;
1703:
1704: -- Standard call to check for call compatibility.
1705: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1706: p_api_version_number,
1707: l_api_name,
1708: G_PKG_NAME)
1709: THEN

Line 1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1706: p_api_version_number,
1707: l_api_name,
1708: G_PKG_NAME)
1709: THEN
1710: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1711: END IF;
1712:
1713:
1714: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1715: IF FND_API.to_Boolean( p_init_msg_list )

1711: END IF;
1712:
1713:
1714: -- Initialize message list if p_init_msg_list is set to TRUE.
1715: IF FND_API.to_Boolean( p_init_msg_list )
1716: THEN
1717: FND_MSG_PUB.initialize;
1718: END IF;
1719:

Line 1722: x_return_status := FND_API.G_RET_STS_SUCCESS;

1718: END IF;
1719:
1720:
1721: -- Initialize API return status to SUCCESS
1722: x_return_status := FND_API.G_RET_STS_SUCCESS;
1723: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1724: --
1725: -- API body
1726: --

Line 1739: RAISE FND_API.G_EXC_ERROR;

1735: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1736: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1737: FND_MSG_PUB.ADD;
1738: END IF;
1739: RAISE FND_API.G_EXC_ERROR;
1740: END IF;
1741:
1742:
1743: ASO_PRICE_ADJ_RLTSHIP_PVT.Create_price_adj_rltship(

Line 1745: P_Init_Msg_List => FND_API.G_FALSE ,

1741:
1742:
1743: ASO_PRICE_ADJ_RLTSHIP_PVT.Create_price_adj_rltship(
1744: P_Api_Version_Number => 1.0,
1745: P_Init_Msg_List => FND_API.G_FALSE ,
1746: p_commit => p_commit,
1747: P_PRICE_ADJ_RLTSHIP_Rec => P_PRICE_ADJ_RLTSHIP_Rec ,
1748: X_ADJ_RELATIONSHIP_ID => X_ADJ_RELATIONSHIP_ID ,
1749: X_Return_Status => X_Return_Status ,

Line 1759: IF FND_API.to_Boolean( p_commit )

1755: -- End of API body
1756: --
1757:
1758: -- Standard check for p_commit
1759: IF FND_API.to_Boolean( p_commit )
1760: THEN
1761: COMMIT WORK;
1762: END IF;
1763:

Line 1773: WHEN FND_API.G_EXC_ERROR THEN

1769: );
1770:
1771:
1772: EXCEPTION
1773: WHEN FND_API.G_EXC_ERROR THEN
1774: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1775: P_API_NAME => L_API_NAME
1776: ,P_PKG_NAME => G_PKG_NAME
1777: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1779: ,X_MSG_COUNT => X_MSG_COUNT
1780: ,X_MSG_DATA => X_MSG_DATA
1781: ,X_RETURN_STATUS => X_RETURN_STATUS);
1782:
1783: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1784: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1785: P_API_NAME => L_API_NAME
1786: ,P_PKG_NAME => G_PKG_NAME
1787: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1817: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1813: -- Pre-Req :
1814: -- Parameters:
1815: -- IN
1816: -- p_api_version_number IN NUMBER Required
1817: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1818: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1819: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1820: --
1821: PROCEDURE Update_Price_Adj_Rltship(

Line 1818: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1814: -- Parameters:
1815: -- IN
1816: -- p_api_version_number IN NUMBER Required
1817: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1818: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1819: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1820: --
1821: PROCEDURE Update_Price_Adj_Rltship(
1822: P_Api_Version_Number IN NUMBER,

Line 1823: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1819: -- p_identity_salesforce_id IN NUMBER Optional Default = NULL
1820: --
1821: PROCEDURE Update_Price_Adj_Rltship(
1822: P_Api_Version_Number IN NUMBER,
1823: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1824: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1825: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1826: X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1827: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 1824: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1820: --
1821: PROCEDURE Update_Price_Adj_Rltship(
1822: P_Api_Version_Number IN NUMBER,
1823: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1824: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1825: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1826: X_adj_relationship_id OUT NOCOPY /* file.sql.39 change */ NUMBER,
1827: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1828: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1835: -- Standard Start of API savepoint
1836: SAVEPOINT UPdate_PRICE_ADJ_RLTSHIP_PUB;
1837:
1838: -- Standard call to check for call compatibility.
1839: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1840: p_api_version_number,
1841: l_api_name,
1842: G_PKG_NAME)
1843: THEN

Line 1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1840: p_api_version_number,
1841: l_api_name,
1842: G_PKG_NAME)
1843: THEN
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: END IF;
1846:
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1849: IF FND_API.to_Boolean( p_init_msg_list )

1845: END IF;
1846:
1847:
1848: -- Initialize message list if p_init_msg_list is set to TRUE.
1849: IF FND_API.to_Boolean( p_init_msg_list )
1850: THEN
1851: FND_MSG_PUB.initialize;
1852: END IF;
1853:

Line 1856: x_return_status := FND_API.G_RET_STS_SUCCESS;

1852: END IF;
1853:
1854:
1855: -- Initialize API return status to SUCCESS
1856: x_return_status := FND_API.G_RET_STS_SUCCESS;
1857: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1858: --
1859: -- API body
1860: --

Line 1873: RAISE FND_API.G_EXC_ERROR;

1869: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
1870: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
1871: FND_MSG_PUB.ADD;
1872: END IF;
1873: RAISE FND_API.G_EXC_ERROR;
1874: END IF;
1875:
1876:
1877: ASO_PRICE_ADJ_RLTSHIP_PVT.Update_price_adj_rltship(

Line 1879: P_Init_Msg_List => FND_API.G_FALSE ,

1875:
1876:
1877: ASO_PRICE_ADJ_RLTSHIP_PVT.Update_price_adj_rltship(
1878: P_Api_Version_Number => 1.0,
1879: P_Init_Msg_List => FND_API.G_FALSE ,
1880: p_commit => p_commit,
1881: P_PRICE_ADJ_RLTSHIP_Rec => P_PRICE_ADJ_RLTSHIP_Rec ,
1882: X_Return_Status => X_Return_Status ,
1883: X_Msg_Count => X_Msg_Count,

Line 1892: IF FND_API.to_Boolean( p_commit )

1888: -- End of API body
1889: --
1890:
1891: -- Standard check for p_commit
1892: IF FND_API.to_Boolean( p_commit )
1893: THEN
1894: COMMIT WORK;
1895: END IF;
1896:

Line 1906: WHEN FND_API.G_EXC_ERROR THEN

1902: );
1903:
1904:
1905: EXCEPTION
1906: WHEN FND_API.G_EXC_ERROR THEN
1907: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1908: P_API_NAME => L_API_NAME
1909: ,P_PKG_NAME => G_PKG_NAME
1910: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1912: ,X_MSG_COUNT => X_MSG_COUNT
1913: ,X_MSG_DATA => X_MSG_DATA
1914: ,X_RETURN_STATUS => X_RETURN_STATUS);
1915:
1916: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1917: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
1918: P_API_NAME => L_API_NAME
1919: ,P_PKG_NAME => G_PKG_NAME
1920: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

Line 1949: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

1945: -- Pre-Req :
1946: -- Parameters:
1947: -- IN
1948: -- p_api_version_number IN NUMBER Required
1949: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1950: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1951: -- p_identity_salesforce_id IN NUMBER Optional Default = NUL
1952: -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
1953: -- End of Comments

Line 1950: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

1946: -- Parameters:
1947: -- IN
1948: -- p_api_version_number IN NUMBER Required
1949: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
1950: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
1951: -- p_identity_salesforce_id IN NUMBER Optional Default = NUL
1952: -- P_Price_Adj_Rltship_Rec IN Price_Adj_Rltship_Rec_Type
1953: -- End of Comments
1954: --

Line 1957: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

1953: -- End of Comments
1954: --
1955: PROCEDURE Delete_Price_Adj_Rltship(
1956: P_Api_Version_Number IN NUMBER,
1957: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1958: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1959: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1960: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1961: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,

Line 1958: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

1954: --
1955: PROCEDURE Delete_Price_Adj_Rltship(
1956: P_Api_Version_Number IN NUMBER,
1957: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
1958: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
1959: P_Price_Adj_Rltship_Rec IN ASO_QUOTE_PUB.Price_Adj_Rltship_Rec_Type := ASO_QUOTE_PUB.G_MISS_Price_Adj_Rltship_REC,
1960: X_Return_Status OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1961: X_Msg_Count OUT NOCOPY /* file.sql.39 change */ NUMBER,
1962: X_Msg_Data OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 1973: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

1969: -- Standard Start of API savepoint
1970: SAVEPOINT DELETE_PRICE_ADJ_RLTSHIP_PUB;
1971:
1972: -- Standard call to check for call compatibility.
1973: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1974: p_api_version_number,
1975: l_api_name,
1976: G_PKG_NAME)
1977: THEN

Line 1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1974: p_api_version_number,
1975: l_api_name,
1976: G_PKG_NAME)
1977: THEN
1978: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1979: END IF;
1980:
1981:
1982: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1983: IF FND_API.to_Boolean( p_init_msg_list )

1979: END IF;
1980:
1981:
1982: -- Initialize message list if p_init_msg_list is set to TRUE.
1983: IF FND_API.to_Boolean( p_init_msg_list )
1984: THEN
1985: FND_MSG_PUB.initialize;
1986: END IF;
1987:

Line 1989: x_return_status := FND_API.G_RET_STS_SUCCESS;

1985: FND_MSG_PUB.initialize;
1986: END IF;
1987:
1988: -- Initialize API return status to SUCCESS
1989: x_return_status := FND_API.G_RET_STS_SUCCESS;
1990: aso_debug_pub.g_debug_flag := nvl(fnd_profile.value('ASO_ENABLE_DEBUG'),'N');
1991: --
1992: -- API body
1993: --

Line 2006: RAISE FND_API.G_EXC_ERROR;

2002: FND_MESSAGE.Set_Name(' + appShortName +', 'UT_CANNOT_GET_PROFILE_VALUE');
2003: FND_MESSAGE.Set_Token('PROFILE', 'USER_ID', FALSE);
2004: FND_MSG_PUB.ADD;
2005: END IF;
2006: RAISE FND_API.G_EXC_ERROR;
2007: END IF;
2008:
2009:
2010: ASO_PRICE_ADJ_RLTSHIP_PVT.Delete_price_adj_rltship(

Line 2012: P_Init_Msg_List => FND_API.G_FALSE ,

2008:
2009:
2010: ASO_PRICE_ADJ_RLTSHIP_PVT.Delete_price_adj_rltship(
2011: P_Api_Version_Number => 1.0,
2012: P_Init_Msg_List => FND_API.G_FALSE ,
2013: p_commit => p_commit,
2014: P_PRICE_ADJ_RLTSHIP_Rec => P_PRICE_ADJ_RLTSHIP_Rec ,
2015: X_Return_Status => X_Return_Status ,
2016: X_Msg_Count => X_Msg_Count,

Line 2025: IF FND_API.to_Boolean( p_commit )

2021: -- End of API body
2022: --
2023:
2024: -- Standard check for p_commit
2025: IF FND_API.to_Boolean( p_commit )
2026: THEN
2027: COMMIT WORK;
2028: END IF;
2029:

Line 2039: WHEN FND_API.G_EXC_ERROR THEN

2035: );
2036:
2037:
2038: EXCEPTION
2039: WHEN FND_API.G_EXC_ERROR THEN
2040: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2041: P_API_NAME => L_API_NAME
2042: ,P_PKG_NAME => G_PKG_NAME
2043: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2045: ,X_MSG_COUNT => X_MSG_COUNT
2046: ,X_MSG_DATA => X_MSG_DATA
2047: ,X_RETURN_STATUS => X_RETURN_STATUS);
2048:
2049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2050: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS(
2051: P_API_NAME => L_API_NAME
2052: ,P_PKG_NAME => G_PKG_NAME
2053: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR