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.CSP_PACKLIST_HEADERS_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 138: raise FND_API.G_EXC_ERROR;

134:
135: -- If there is an error in conversion precessing, raise an error.
136: IF l_any_errors
137: THEN
138: raise FND_API.G_EXC_ERROR;
139: END IF;
140:
141: END Convert_PLH_Values_To_Ids;
142: PROCEDURE Create_packlist_headers(

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

140:
141: END Convert_PLH_Values_To_Ids;
142: PROCEDURE Create_packlist_headers(
143: P_Api_Version_Number IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
145: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
146: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
147: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
148: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,

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

141: END Convert_PLH_Values_To_Ids;
142: PROCEDURE Create_packlist_headers(
143: P_Api_Version_Number IN NUMBER,
144: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
145: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
146: P_PLH_Rec IN PLH_Rec_Type := G_MISS_PLH_REC,
147: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
148: X_PACKLIST_HEADER_ID OUT NOCOPY NUMBER,
149: X_Return_Status OUT NOCOPY VARCHAR2,

Line 163: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

159: -- Standard Start of API savepoint
160: SAVEPOINT CREATE_Packlist_Headers_PUB;
161:
162: -- Standard call to check for call compatibility.
163: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
164: p_api_version_number,
165: l_api_name,
166: G_PKG_NAME)
167: THEN

Line 168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

164: p_api_version_number,
165: l_api_name,
166: G_PKG_NAME)
167: THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: END IF;
170:
171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 173: IF FND_API.to_Boolean( p_init_msg_list )

169: END IF;
170:
171:
172: -- Initialize message list if p_init_msg_list is set to TRUE.
173: IF FND_API.to_Boolean( p_init_msg_list )
174: THEN
175: FND_MSG_PUB.initialize;
176: END IF;
177:

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
181:
182:
183: -- Initialize API return status to SUCCESS
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185:
186: --
187: -- API body
188: --

Line 204: P_Init_Msg_List => FND_API.G_FALSE,

200: -- Calling Private package: Create_Packlist_Headers
201: -- Hint: Primary key needs to be returned
202: CSP_packlist_headers_PVT.Create_packlist_headers(
203: P_Api_Version_Number => 2.0,
204: P_Init_Msg_List => FND_API.G_FALSE,
205: P_Commit => FND_API.G_FALSE,
206: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
207: P_PLH_Rec => l_pvt_PLH_Rec ,
208: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 205: P_Commit => FND_API.G_FALSE,

201: -- Hint: Primary key needs to be returned
202: CSP_packlist_headers_PVT.Create_packlist_headers(
203: P_Api_Version_Number => 2.0,
204: P_Init_Msg_List => FND_API.G_FALSE,
205: P_Commit => FND_API.G_FALSE,
206: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
207: P_PLH_Rec => l_pvt_PLH_Rec ,
208: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
209: X_PACKLIST_HEADER_ID => x_PACKLIST_HEADER_ID,

Line 206: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

202: CSP_packlist_headers_PVT.Create_packlist_headers(
203: P_Api_Version_Number => 2.0,
204: P_Init_Msg_List => FND_API.G_FALSE,
205: P_Commit => FND_API.G_FALSE,
206: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
207: P_PLH_Rec => l_pvt_PLH_Rec ,
208: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
209: X_PACKLIST_HEADER_ID => x_PACKLIST_HEADER_ID,
210: X_Return_Status => x_return_status,

Line 217: IF x_return_status = FND_API.G_RET_STS_ERROR then

213:
214:
215:
216: -- Check return status from the above procedure call
217: IF x_return_status = FND_API.G_RET_STS_ERROR then
218: raise FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;

Line 218: raise FND_API.G_EXC_ERROR;

214:
215:
216: -- Check return status from the above procedure call
217: IF x_return_status = FND_API.G_RET_STS_ERROR then
218: raise FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:

Line 219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

215:
216: -- Check return status from the above procedure call
217: IF x_return_status = FND_API.G_RET_STS_ERROR then
218: raise FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: --

Line 220: raise FND_API.G_EXC_UNEXPECTED_ERROR;

216: -- Check return status from the above procedure call
217: IF x_return_status = FND_API.G_RET_STS_ERROR then
218: raise FND_API.G_EXC_ERROR;
219: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
220: raise FND_API.G_EXC_UNEXPECTED_ERROR;
221: END IF;
222:
223: --
224: -- End of API body.

Line 228: IF FND_API.to_Boolean( p_commit )

224: -- End of API body.
225: --
226:
227: -- Standard check for p_commit
228: IF FND_API.to_Boolean( p_commit )
229: THEN
230: COMMIT WORK;
231: END IF;
232:

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: p_data => x_msg_data
242: );
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
247: P_API_NAME => L_API_NAME
248: ,P_PKG_NAME => G_PKG_NAME
249: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

251: ,X_MSG_COUNT => X_MSG_COUNT
252: ,X_MSG_DATA => X_MSG_DATA
253: ,X_RETURN_STATUS => X_RETURN_STATUS);
254:
255: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
256: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
257: P_API_NAME => L_API_NAME
258: ,P_PKG_NAME => G_PKG_NAME
259: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

276:
277: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
278: PROCEDURE Update_packlist_headers(
279: P_Api_Version_Number IN NUMBER,
280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
282: P_Identity_Salesforce_Id IN NUMBER := NULL,
283: P_PLH_Rec IN PLH_Rec_Type,
284: X_Return_Status OUT NOCOPY VARCHAR2,

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

277: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
278: PROCEDURE Update_packlist_headers(
279: P_Api_Version_Number IN NUMBER,
280: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
281: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
282: P_Identity_Salesforce_Id IN NUMBER := NULL,
283: P_PLH_Rec IN PLH_Rec_Type,
284: X_Return_Status OUT NOCOPY VARCHAR2,
285: X_Msg_Count OUT NOCOPY NUMBER,

Line 298: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

294: -- Standard Start of API savepoint
295: SAVEPOINT UPDATE_Packlist_Headers_PUB;
296:
297: -- Standard call to check for call compatibility.
298: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
299: p_api_version_number,
300: l_api_name,
301: G_PKG_NAME)
302: THEN

Line 303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

299: p_api_version_number,
300: l_api_name,
301: G_PKG_NAME)
302: THEN
303: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
304: END IF;
305:
306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 308: IF FND_API.to_Boolean( p_init_msg_list )

304: END IF;
305:
306:
307: -- Initialize message list if p_init_msg_list is set to TRUE.
308: IF FND_API.to_Boolean( p_init_msg_list )
309: THEN
310: FND_MSG_PUB.initialize;
311: END IF;
312:

Line 319: x_return_status := FND_API.G_RET_STS_SUCCESS;

315: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
316:
317:
318: -- Initialize API return status to SUCCESS
319: x_return_status := FND_API.G_RET_STS_SUCCESS;
320:
321: --
322: -- API body
323: --

Line 337: P_Init_Msg_List => FND_API.G_FALSE,

333: );
334:
335: CSP_packlist_headers_PVT.Update_packlist_headers(
336: P_Api_Version_Number => 2.0,
337: P_Init_Msg_List => FND_API.G_FALSE,
338: P_Commit => p_commit,
339: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
340: P_Identity_Salesforce_Id => p_identity_salesforce_id,
341: P_PLH_Rec => l_pvt_PLH_Rec ,

Line 339: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

335: CSP_packlist_headers_PVT.Update_packlist_headers(
336: P_Api_Version_Number => 2.0,
337: P_Init_Msg_List => FND_API.G_FALSE,
338: P_Commit => p_commit,
339: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
340: P_Identity_Salesforce_Id => p_identity_salesforce_id,
341: P_PLH_Rec => l_pvt_PLH_Rec ,
342: X_Return_Status => x_return_status,
343: X_Msg_Count => x_msg_count,

Line 349: IF x_return_status = FND_API.G_RET_STS_ERROR then

345:
346:
347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;

Line 350: raise FND_API.G_EXC_ERROR;

346:
347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:

Line 351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

347:
348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: --

Line 352: raise FND_API.G_EXC_UNEXPECTED_ERROR;

348: -- Check return status from the above procedure call
349: IF x_return_status = FND_API.G_RET_STS_ERROR then
350: raise FND_API.G_EXC_ERROR;
351: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
352: raise FND_API.G_EXC_UNEXPECTED_ERROR;
353: END IF;
354:
355: --
356: -- End of API body

Line 360: IF FND_API.to_Boolean( p_commit )

356: -- End of API body
357: --
358:
359: -- Standard check for p_commit
360: IF FND_API.to_Boolean( p_commit )
361: THEN
362: COMMIT WORK;
363: END IF;
364:

Line 377: WHEN FND_API.G_EXC_ERROR THEN

373: p_data => x_msg_data
374: );
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
379: P_API_NAME => L_API_NAME
380: ,P_PKG_NAME => G_PKG_NAME
381: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

383: ,X_MSG_COUNT => X_MSG_COUNT
384: ,X_MSG_DATA => X_MSG_DATA
385: ,X_RETURN_STATUS => X_RETURN_STATUS);
386:
387: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
388: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
389: P_API_NAME => L_API_NAME
390: ,P_PKG_NAME => G_PKG_NAME
391: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

409: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
410: -- The Master delete procedure may not be needed depends on different business requirements.
411: PROCEDURE Delete_packlist_headers(
412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_identity_salesforce_id IN NUMBER := NULL,
416: P_PLH_Rec IN PLH_Rec_Type,
417: X_Return_Status OUT NOCOPY VARCHAR2,

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

410: -- The Master delete procedure may not be needed depends on different business requirements.
411: PROCEDURE Delete_packlist_headers(
412: P_Api_Version_Number IN NUMBER,
413: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
414: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
415: P_identity_salesforce_id IN NUMBER := NULL,
416: P_PLH_Rec IN PLH_Rec_Type,
417: X_Return_Status OUT NOCOPY VARCHAR2,
418: X_Msg_Count OUT NOCOPY NUMBER,

Line 431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

427: -- Standard Start of API savepoint
428: SAVEPOINT DELETE_Packlist_Headers_PUB;
429:
430: -- Standard call to check for call compatibility.
431: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
432: p_api_version_number,
433: l_api_name,
434: G_PKG_NAME)
435: THEN

Line 436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

432: p_api_version_number,
433: l_api_name,
434: G_PKG_NAME)
435: THEN
436: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
437: END IF;
438:
439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 441: IF FND_API.to_Boolean( p_init_msg_list )

437: END IF;
438:
439:
440: -- Initialize message list if p_init_msg_list is set to TRUE.
441: IF FND_API.to_Boolean( p_init_msg_list )
442: THEN
443: FND_MSG_PUB.initialize;
444: END IF;
445:

Line 452: x_return_status := FND_API.G_RET_STS_SUCCESS;

448: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
449:
450:
451: -- Initialize API return status to SUCCESS
452: x_return_status := FND_API.G_RET_STS_SUCCESS;
453:
454: --
455: -- API body
456: --

Line 470: P_Init_Msg_List => FND_API.G_FALSE,

466: );
467:
468: CSP_packlist_headers_PVT.Delete_packlist_headers(
469: P_Api_Version_Number => 2.0,
470: P_Init_Msg_List => FND_API.G_FALSE,
471: P_Commit => p_commit,
472: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
473: P_Identity_Salesforce_Id => p_identity_salesforce_id,
474: P_PLH_Rec => l_pvt_PLH_Rec,

Line 472: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

468: CSP_packlist_headers_PVT.Delete_packlist_headers(
469: P_Api_Version_Number => 2.0,
470: P_Init_Msg_List => FND_API.G_FALSE,
471: P_Commit => p_commit,
472: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
473: P_Identity_Salesforce_Id => p_identity_salesforce_id,
474: P_PLH_Rec => l_pvt_PLH_Rec,
475: X_Return_Status => x_return_status,
476: X_Msg_Count => x_msg_count,

Line 482: IF x_return_status = FND_API.G_RET_STS_ERROR then

478:
479:
480:
481: -- Check return status from the above procedure call
482: IF x_return_status = FND_API.G_RET_STS_ERROR then
483: raise FND_API.G_EXC_ERROR;
484: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;

Line 483: raise FND_API.G_EXC_ERROR;

479:
480:
481: -- Check return status from the above procedure call
482: IF x_return_status = FND_API.G_RET_STS_ERROR then
483: raise FND_API.G_EXC_ERROR;
484: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:

Line 484: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

480:
481: -- Check return status from the above procedure call
482: IF x_return_status = FND_API.G_RET_STS_ERROR then
483: raise FND_API.G_EXC_ERROR;
484: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488: --

Line 485: raise FND_API.G_EXC_UNEXPECTED_ERROR;

481: -- Check return status from the above procedure call
482: IF x_return_status = FND_API.G_RET_STS_ERROR then
483: raise FND_API.G_EXC_ERROR;
484: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
485: raise FND_API.G_EXC_UNEXPECTED_ERROR;
486: END IF;
487:
488: --
489: -- End of API body

Line 493: IF FND_API.to_Boolean( p_commit )

489: -- End of API body
490: --
491:
492: -- Standard check for p_commit
493: IF FND_API.to_Boolean( p_commit )
494: THEN
495: COMMIT WORK;
496: END IF;
497:

Line 510: WHEN FND_API.G_EXC_ERROR THEN

506: p_data => x_msg_data
507: );
508:
509: EXCEPTION
510: WHEN FND_API.G_EXC_ERROR THEN
511: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
512: P_API_NAME => L_API_NAME
513: ,P_PKG_NAME => G_PKG_NAME
514: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

516: ,X_MSG_COUNT => X_MSG_COUNT
517: ,X_MSG_DATA => X_MSG_DATA
518: ,X_RETURN_STATUS => X_RETURN_STATUS);
519:
520: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
521: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
522: P_API_NAME => L_API_NAME
523: ,P_PKG_NAME => G_PKG_NAME
524: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

540:
541:
542: PROCEDURE Get_packlist_headers(
543: P_Api_Version_Number IN NUMBER,
544: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
545: P_identity_salesforce_id IN NUMBER := NULL,
546: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
547: -- Hint: Add list of bind variables here
548: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

546: P_PLH_Rec IN CSP_packlist_headers_PUB.PLH_Rec_Type,
547: -- Hint: Add list of bind variables here
548: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
549: p_start_rec_prt IN NUMBER := 1,
550: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
551: -- Hint: user defined record type
552: p_order_by_rec IN CSP_packlist_headers_PUB.PLH_sort_rec_type,
553: x_return_status OUT NOCOPY VARCHAR2,
554: x_msg_count OUT NOCOPY NUMBER,

Line 572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

568: -- Standard Start of API savepoint
569: SAVEPOINT GET_Packlist_Headers_PUB;
570:
571: -- Standard call to check for call compatibility.
572: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
576: THEN

Line 577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

573: p_api_version_number,
574: l_api_name,
575: G_PKG_NAME)
576: THEN
577: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
578: END IF;
579:
580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 582: IF FND_API.to_Boolean( p_init_msg_list )

578: END IF;
579:
580:
581: -- Initialize message list if p_init_msg_list is set to TRUE.
582: IF FND_API.to_Boolean( p_init_msg_list )
583: THEN
584: FND_MSG_PUB.initialize;
585: END IF;
586:

Line 593: x_return_status := FND_API.G_RET_STS_SUCCESS;

589: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
590:
591:
592: -- Initialize API return status to SUCCESS
593: x_return_status := FND_API.G_RET_STS_SUCCESS;
594:
595: --
596: -- API body
597: --

Line 603: P_Init_Msg_List => FND_API.G_FALSE,

599: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Packlist_Headers');
600: /*
601: CSP_packlist_headers_PVT.Get_packlist_headers(
602: P_Api_Version_Number => 2.0,
603: P_Init_Msg_List => FND_API.G_FALSE,
604: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
605: P_Identity_Salesforce_id => p_identity_salesforce_id,
606: P_PLH_Rec => P_PLH_Rec,
607: p_rec_requested => p_rec_requested,

Line 604: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

600: /*
601: CSP_packlist_headers_PVT.Get_packlist_headers(
602: P_Api_Version_Number => 2.0,
603: P_Init_Msg_List => FND_API.G_FALSE,
604: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
605: P_Identity_Salesforce_id => p_identity_salesforce_id,
606: P_PLH_Rec => P_PLH_Rec,
607: p_rec_requested => p_rec_requested,
608: p_start_rec_prt => p_start_rec_prt,

Line 626: IF x_return_status = FND_API.G_RET_STS_ERROR then

622:
623:
624:
625: -- Check return status from the above procedure call
626: IF x_return_status = FND_API.G_RET_STS_ERROR then
627: raise FND_API.G_EXC_ERROR;
628: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;

Line 627: raise FND_API.G_EXC_ERROR;

623:
624:
625: -- Check return status from the above procedure call
626: IF x_return_status = FND_API.G_RET_STS_ERROR then
627: raise FND_API.G_EXC_ERROR;
628: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631: */

Line 628: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

624:
625: -- Check return status from the above procedure call
626: IF x_return_status = FND_API.G_RET_STS_ERROR then
627: raise FND_API.G_EXC_ERROR;
628: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631: */
632: --

Line 629: raise FND_API.G_EXC_UNEXPECTED_ERROR;

625: -- Check return status from the above procedure call
626: IF x_return_status = FND_API.G_RET_STS_ERROR then
627: raise FND_API.G_EXC_ERROR;
628: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
629: raise FND_API.G_EXC_UNEXPECTED_ERROR;
630: END IF;
631: */
632: --
633: -- End of API body

Line 647: WHEN FND_API.G_EXC_ERROR THEN

643: p_data => x_msg_data
644: );
645:
646: EXCEPTION
647: WHEN FND_API.G_EXC_ERROR THEN
648: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
649: P_API_NAME => L_API_NAME
650: ,P_PKG_NAME => G_PKG_NAME
651: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

653: ,X_MSG_COUNT => X_MSG_COUNT
654: ,X_MSG_DATA => X_MSG_DATA
655: ,X_RETURN_STATUS => X_RETURN_STATUS);
656:
657: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
658: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
659: P_API_NAME => L_API_NAME
660: ,P_PKG_NAME => G_PKG_NAME
661: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR