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.AST_GRP_CAMP_PUB dependencies on FND_API

Line 51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)

47: -- Value based parameters should be converted to their equivalent ids.
48: -- Each value should resolve into one and only one id.
49: -- If this condition is not satisfied, API must report an error and assign l_any_errors to TRUE.
50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN

Line 54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

50: -- Example: Process Lead Source/Lead Source Code
51: -- If(p_opp_rec.lead_source_code is NOT NULL and p_opp_rec.lead_source_code <> FND_API.G_MISS_CHAR)
52: -- THEN
53: -- p_pvt_opp_rec.lead_source_code := p_opp_rec.lead_source_code;
54: -- IF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
55: -- THEN
56: -- IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_SUCCESS)
57: -- THEN
58: -- FND_MESSAGE.Set_Name('AS','API_ATTRIBUTE_IGNORED');

Line 63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)

59: -- FND_MESSAGE.Set_Token('COLUMN','LEAD_SOURCE',FALSE);
60: -- FND_MSG_PUB.Add;
61: -- END IF;
62: -- END IF;
63: -- ELSIF(p_opp_rec.lead_source is NOT NULL and p_opp_rec.lead_source <> FND_API.G_MISS_CHAR)
64: -- THEN
65: -- OPEN C_Get_Lookup_Code('LEAD_SOURCE', p_opp_rec.lead_source);
66: -- FETCH C_Get_Lookup_Code INTO l_val;
67: -- CLOSE C_Get_Lookup_Code;

Line 106: raise FND_API.G_EXC_ERROR;

102:
103: -- If there is an error in conversion precessing, raise an error.
104: IF l_any_errors
105: THEN
106: raise FND_API.G_EXC_ERROR;
107: END IF;
108:
109: END Convert_grp_camp_Values_To_Ids;
110: PROCEDURE Create_grp_camp(

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

108:
109: END Convert_grp_camp_Values_To_Ids;
110: PROCEDURE Create_grp_camp(
111: P_Api_Version_Number IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
113: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
114: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
115: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
116: X_GROUP_CAMPAIGN_ID OUT NUMBER,

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

109: END Convert_grp_camp_Values_To_Ids;
110: PROCEDURE Create_grp_camp(
111: P_Api_Version_Number IN NUMBER,
112: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
113: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
114: P_grp_camp_Rec IN grp_camp_Rec_Type := G_MISS_grp_camp_REC,
115: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
116: X_GROUP_CAMPAIGN_ID OUT NUMBER,
117: X_Return_Status OUT VARCHAR2,

Line 131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

127: -- Standard Start of API savepoint
128: SAVEPOINT CREATE_grp_camp_PUB;
129:
130: -- Standard call to check for call compatibility.
131: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
132: p_api_version_number,
133: l_api_name,
134: G_PKG_NAME)
135: THEN

Line 136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

132: p_api_version_number,
133: l_api_name,
134: G_PKG_NAME)
135: THEN
136: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
137: END IF;
138:
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 141: IF FND_API.to_Boolean( p_init_msg_list )

137: END IF;
138:
139:
140: -- Initialize message list if p_init_msg_list is set to TRUE.
141: IF FND_API.to_Boolean( p_init_msg_list )
142: THEN
143: FND_MSG_PUB.initialize;
144: END IF;
145:

Line 152: x_return_status := FND_API.G_RET_STS_SUCCESS;

148: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: ' || l_api_name || 'start');
149:
150:
151: -- Initialize API return status to SUCCESS
152: x_return_status := FND_API.G_RET_STS_SUCCESS;
153:
154: --
155: -- API body
156: --

Line 172: P_Init_Msg_List => FND_API.G_FALSE,

168: -- Calling Private package: Create_grp_camp
169: -- Hint: Primary key needs to be returned
170: ast_grp_camp_PVT.Create_grp_camp(
171: P_Api_Version_Number => 2.0,
172: P_Init_Msg_List => FND_API.G_FALSE,
173: P_Commit => FND_API.G_FALSE,
174: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
175: P_grp_camp_Rec => l_pvt_grp_camp_Rec ,
176: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 173: P_Commit => FND_API.G_FALSE,

169: -- Hint: Primary key needs to be returned
170: ast_grp_camp_PVT.Create_grp_camp(
171: P_Api_Version_Number => 2.0,
172: P_Init_Msg_List => FND_API.G_FALSE,
173: P_Commit => FND_API.G_FALSE,
174: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
175: P_grp_camp_Rec => l_pvt_grp_camp_Rec ,
176: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
177: X_GROUP_CAMPAIGN_ID => x_GROUP_CAMPAIGN_ID,

Line 174: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

170: ast_grp_camp_PVT.Create_grp_camp(
171: P_Api_Version_Number => 2.0,
172: P_Init_Msg_List => FND_API.G_FALSE,
173: P_Commit => FND_API.G_FALSE,
174: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
175: P_grp_camp_Rec => l_pvt_grp_camp_Rec ,
176: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
177: X_GROUP_CAMPAIGN_ID => x_GROUP_CAMPAIGN_ID,
178: X_Return_Status => x_return_status,

Line 185: IF x_return_status = FND_API.G_RET_STS_ERROR then

181:
182:
183:
184: -- Check return status from the above procedure call
185: IF x_return_status = FND_API.G_RET_STS_ERROR then
186: raise FND_API.G_EXC_ERROR;
187: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;

Line 186: raise FND_API.G_EXC_ERROR;

182:
183:
184: -- Check return status from the above procedure call
185: IF x_return_status = FND_API.G_RET_STS_ERROR then
186: raise FND_API.G_EXC_ERROR;
187: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:

Line 187: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

183:
184: -- Check return status from the above procedure call
185: IF x_return_status = FND_API.G_RET_STS_ERROR then
186: raise FND_API.G_EXC_ERROR;
187: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: --

Line 188: raise FND_API.G_EXC_UNEXPECTED_ERROR;

184: -- Check return status from the above procedure call
185: IF x_return_status = FND_API.G_RET_STS_ERROR then
186: raise FND_API.G_EXC_ERROR;
187: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
188: raise FND_API.G_EXC_UNEXPECTED_ERROR;
189: END IF;
190:
191: --
192: -- End of API body.

Line 196: IF FND_API.to_Boolean( p_commit )

192: -- End of API body.
193: --
194:
195: -- Standard check for p_commit
196: IF FND_API.to_Boolean( p_commit )
197: THEN
198: COMMIT WORK;
199: END IF;
200:

Line 213: WHEN FND_API.G_EXC_ERROR THEN

209: p_data => x_msg_data
210: );
211:
212: EXCEPTION
213: WHEN FND_API.G_EXC_ERROR THEN
214: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
215: P_API_NAME => L_API_NAME
216: ,P_PKG_NAME => G_PKG_NAME
217: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

219: ,X_MSG_COUNT => X_MSG_COUNT
220: ,X_MSG_DATA => X_MSG_DATA
221: ,X_RETURN_STATUS => X_RETURN_STATUS);
222:
223: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
224: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
225: P_API_NAME => L_API_NAME
226: ,P_PKG_NAME => G_PKG_NAME
227: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

244:
245: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
246: PROCEDURE Update_grp_camp(
247: P_Api_Version_Number IN NUMBER,
248: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
250: P_Identity_Salesforce_Id IN NUMBER := NULL,
251: P_grp_camp_Rec IN grp_camp_Rec_Type,
252: X_Return_Status OUT VARCHAR2,

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

245: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
246: PROCEDURE Update_grp_camp(
247: P_Api_Version_Number IN NUMBER,
248: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
249: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
250: P_Identity_Salesforce_Id IN NUMBER := NULL,
251: P_grp_camp_Rec IN grp_camp_Rec_Type,
252: X_Return_Status OUT VARCHAR2,
253: X_Msg_Count OUT NUMBER,

Line 266: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

262: -- Standard Start of API savepoint
263: SAVEPOINT UPDATE_grp_camp_PUB;
264:
265: -- Standard call to check for call compatibility.
266: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
267: p_api_version_number,
268: l_api_name,
269: G_PKG_NAME)
270: THEN

Line 271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

267: p_api_version_number,
268: l_api_name,
269: G_PKG_NAME)
270: THEN
271: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
272: END IF;
273:
274:
275: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 276: IF FND_API.to_Boolean( p_init_msg_list )

272: END IF;
273:
274:
275: -- Initialize message list if p_init_msg_list is set to TRUE.
276: IF FND_API.to_Boolean( p_init_msg_list )
277: THEN
278: FND_MSG_PUB.initialize;
279: END IF;
280:

Line 287: x_return_status := FND_API.G_RET_STS_SUCCESS;

283: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: ' || l_api_name || 'start');
284:
285:
286: -- Initialize API return status to SUCCESS
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288:
289: --
290: -- API body
291: --

Line 305: P_Init_Msg_List => FND_API.G_FALSE,

301: );
302:
303: ast_grp_camp_PVT.Update_grp_camp(
304: P_Api_Version_Number => 2.0,
305: P_Init_Msg_List => FND_API.G_FALSE,
306: P_Commit => p_commit,
307: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
308: P_Identity_Salesforce_Id => p_identity_salesforce_id,
309: P_grp_camp_Rec => l_pvt_grp_camp_Rec ,

Line 307: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

303: ast_grp_camp_PVT.Update_grp_camp(
304: P_Api_Version_Number => 2.0,
305: P_Init_Msg_List => FND_API.G_FALSE,
306: P_Commit => p_commit,
307: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
308: P_Identity_Salesforce_Id => p_identity_salesforce_id,
309: P_grp_camp_Rec => l_pvt_grp_camp_Rec ,
310: X_Return_Status => x_return_status,
311: X_Msg_Count => x_msg_count,

Line 317: IF x_return_status = FND_API.G_RET_STS_ERROR then

313:
314:
315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: raise FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: raise FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;

Line 318: raise FND_API.G_EXC_ERROR;

314:
315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: raise FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: raise FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:

Line 319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

315:
316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: raise FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: raise FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323: --

Line 320: raise FND_API.G_EXC_UNEXPECTED_ERROR;

316: -- Check return status from the above procedure call
317: IF x_return_status = FND_API.G_RET_STS_ERROR then
318: raise FND_API.G_EXC_ERROR;
319: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
320: raise FND_API.G_EXC_UNEXPECTED_ERROR;
321: END IF;
322:
323: --
324: -- End of API body

Line 328: IF FND_API.to_Boolean( p_commit )

324: -- End of API body
325: --
326:
327: -- Standard check for p_commit
328: IF FND_API.to_Boolean( p_commit )
329: THEN
330: COMMIT WORK;
331: END IF;
332:

Line 345: WHEN FND_API.G_EXC_ERROR THEN

341: p_data => x_msg_data
342: );
343:
344: EXCEPTION
345: WHEN FND_API.G_EXC_ERROR THEN
346: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
347: P_API_NAME => L_API_NAME
348: ,P_PKG_NAME => G_PKG_NAME
349: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

351: ,X_MSG_COUNT => X_MSG_COUNT
352: ,X_MSG_DATA => X_MSG_DATA
353: ,X_RETURN_STATUS => X_RETURN_STATUS);
354:
355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
357: P_API_NAME => L_API_NAME
358: ,P_PKG_NAME => G_PKG_NAME
359: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

377: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
378: -- The Master delete procedure may not be needed depends on different business requirements.
379: PROCEDURE Delete_grp_camp(
380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: P_identity_salesforce_id IN NUMBER := NULL,
384: P_grp_camp_Rec IN grp_camp_Rec_Type,
385: X_Return_Status OUT VARCHAR2,

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

378: -- The Master delete procedure may not be needed depends on different business requirements.
379: PROCEDURE Delete_grp_camp(
380: P_Api_Version_Number IN NUMBER,
381: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383: P_identity_salesforce_id IN NUMBER := NULL,
384: P_grp_camp_Rec IN grp_camp_Rec_Type,
385: X_Return_Status OUT VARCHAR2,
386: X_Msg_Count OUT NUMBER,

Line 399: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

395: -- Standard Start of API savepoint
396: SAVEPOINT DELETE_grp_camp_PUB;
397:
398: -- Standard call to check for call compatibility.
399: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME)
403: THEN

Line 404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

400: p_api_version_number,
401: l_api_name,
402: G_PKG_NAME)
403: THEN
404: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
405: END IF;
406:
407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 409: IF FND_API.to_Boolean( p_init_msg_list )

405: END IF;
406:
407:
408: -- Initialize message list if p_init_msg_list is set to TRUE.
409: IF FND_API.to_Boolean( p_init_msg_list )
410: THEN
411: FND_MSG_PUB.initialize;
412: END IF;
413:

Line 420: x_return_status := FND_API.G_RET_STS_SUCCESS;

416: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: ' || l_api_name || 'start');
417:
418:
419: -- Initialize API return status to SUCCESS
420: x_return_status := FND_API.G_RET_STS_SUCCESS;
421:
422: --
423: -- API body
424: --

Line 438: P_Init_Msg_List => FND_API.G_FALSE,

434: );
435:
436: ast_grp_camp_PVT.Delete_grp_camp(
437: P_Api_Version_Number => 2.0,
438: P_Init_Msg_List => FND_API.G_FALSE,
439: P_Commit => p_commit,
440: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
441: P_Identity_Salesforce_Id => p_identity_salesforce_id,
442: P_grp_camp_Rec => l_pvt_grp_camp_Rec,

Line 440: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

436: ast_grp_camp_PVT.Delete_grp_camp(
437: P_Api_Version_Number => 2.0,
438: P_Init_Msg_List => FND_API.G_FALSE,
439: P_Commit => p_commit,
440: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
441: P_Identity_Salesforce_Id => p_identity_salesforce_id,
442: P_grp_camp_Rec => l_pvt_grp_camp_Rec,
443: X_Return_Status => x_return_status,
444: X_Msg_Count => x_msg_count,

Line 450: IF x_return_status = FND_API.G_RET_STS_ERROR then

446:
447:
448:
449: -- Check return status from the above procedure call
450: IF x_return_status = FND_API.G_RET_STS_ERROR then
451: raise FND_API.G_EXC_ERROR;
452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
453: raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;

Line 451: raise FND_API.G_EXC_ERROR;

447:
448:
449: -- Check return status from the above procedure call
450: IF x_return_status = FND_API.G_RET_STS_ERROR then
451: raise FND_API.G_EXC_ERROR;
452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
453: raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:

Line 452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

448:
449: -- Check return status from the above procedure call
450: IF x_return_status = FND_API.G_RET_STS_ERROR then
451: raise FND_API.G_EXC_ERROR;
452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
453: raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: --

Line 453: raise FND_API.G_EXC_UNEXPECTED_ERROR;

449: -- Check return status from the above procedure call
450: IF x_return_status = FND_API.G_RET_STS_ERROR then
451: raise FND_API.G_EXC_ERROR;
452: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
453: raise FND_API.G_EXC_UNEXPECTED_ERROR;
454: END IF;
455:
456: --
457: -- End of API body

Line 461: IF FND_API.to_Boolean( p_commit )

457: -- End of API body
458: --
459:
460: -- Standard check for p_commit
461: IF FND_API.to_Boolean( p_commit )
462: THEN
463: COMMIT WORK;
464: END IF;
465:

Line 478: WHEN FND_API.G_EXC_ERROR THEN

474: p_data => x_msg_data
475: );
476:
477: EXCEPTION
478: WHEN FND_API.G_EXC_ERROR THEN
479: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
480: P_API_NAME => L_API_NAME
481: ,P_PKG_NAME => G_PKG_NAME
482: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

484: ,X_MSG_COUNT => X_MSG_COUNT
485: ,X_MSG_DATA => X_MSG_DATA
486: ,X_RETURN_STATUS => X_RETURN_STATUS);
487:
488: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
489: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
490: P_API_NAME => L_API_NAME
491: ,P_PKG_NAME => G_PKG_NAME
492: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

508:
509:
510: PROCEDURE Get_grp_camp(
511: P_Api_Version_Number IN NUMBER,
512: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
513: P_identity_salesforce_id IN NUMBER := NULL,
514: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
515: -- Hint: Add list of bind variables here
516: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

Line 518: p_return_tot_count IN NUMBER := FND_API.G_FALSE,

514: P_grp_camp_Rec IN ast_grp_camp_PUB.grp_camp_Rec_Type,
515: -- Hint: Add list of bind variables here
516: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
517: p_start_rec_prt IN NUMBER := 1,
518: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
519: -- Hint: user defined record type
520: p_order_by_rec IN ast_grp_camp_PUB.grp_camp_sort_rec_type,
521: x_return_status OUT VARCHAR2,
522: x_msg_count OUT NUMBER,

Line 540: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

536: -- Standard Start of API savepoint
537: SAVEPOINT GET_grp_camp_PUB;
538:
539: -- Standard call to check for call compatibility.
540: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
541: p_api_version_number,
542: l_api_name,
543: G_PKG_NAME)
544: THEN

Line 545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

541: p_api_version_number,
542: l_api_name,
543: G_PKG_NAME)
544: THEN
545: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
546: END IF;
547:
548:
549: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 550: IF FND_API.to_Boolean( p_init_msg_list )

546: END IF;
547:
548:
549: -- Initialize message list if p_init_msg_list is set to TRUE.
550: IF FND_API.to_Boolean( p_init_msg_list )
551: THEN
552: FND_MSG_PUB.initialize;
553: END IF;
554:

Line 561: x_return_status := FND_API.G_RET_STS_SUCCESS;

557: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: ' || l_api_name || 'start');
558:
559:
560: -- Initialize API return status to SUCCESS
561: x_return_status := FND_API.G_RET_STS_SUCCESS;
562:
563: --
564: -- API body
565: --

Line 570: P_Init_Msg_List => FND_API.G_FALSE,

566: -- Debug Message
567: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: - Calling PVT.Get_grp_camp');
568: ast_grp_camp_PVT.Get_grp_camp(
569: P_Api_Version_Number => 2.0,
570: P_Init_Msg_List => FND_API.G_FALSE,
571: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
572: P_Identity_Salesforce_id => p_identity_salesforce_id,
573: P_grp_camp_Rec => P_grp_camp_Rec,
574: p_rec_requested => p_rec_requested,

Line 571: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

567: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Public API: - Calling PVT.Get_grp_camp');
568: ast_grp_camp_PVT.Get_grp_camp(
569: P_Api_Version_Number => 2.0,
570: P_Init_Msg_List => FND_API.G_FALSE,
571: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
572: P_Identity_Salesforce_id => p_identity_salesforce_id,
573: P_grp_camp_Rec => P_grp_camp_Rec,
574: p_rec_requested => p_rec_requested,
575: p_start_rec_prt => p_start_rec_prt,

Line 593: IF x_return_status = FND_API.G_RET_STS_ERROR then

589:
590:
591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;

Line 594: raise FND_API.G_EXC_ERROR;

590:
591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:

Line 595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

591:
592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: --

Line 596: raise FND_API.G_EXC_UNEXPECTED_ERROR;

592: -- Check return status from the above procedure call
593: IF x_return_status = FND_API.G_RET_STS_ERROR then
594: raise FND_API.G_EXC_ERROR;
595: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
596: raise FND_API.G_EXC_UNEXPECTED_ERROR;
597: END IF;
598:
599: --
600: -- End of API body

Line 614: WHEN FND_API.G_EXC_ERROR THEN

610: p_data => x_msg_data
611: );
612:
613: EXCEPTION
614: WHEN FND_API.G_EXC_ERROR THEN
615: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
616: P_API_NAME => L_API_NAME
617: ,P_PKG_NAME => G_PKG_NAME
618: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

620: ,X_MSG_COUNT => X_MSG_COUNT
621: ,X_MSG_DATA => X_MSG_DATA
622: ,X_RETURN_STATUS => X_RETURN_STATUS);
623:
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
626: P_API_NAME => L_API_NAME
627: ,P_PKG_NAME => G_PKG_NAME
628: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR