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_PACK_SERIAL_LOTS_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 107: raise FND_API.G_EXC_ERROR;

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

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

109:
110: END Convert_plsl_Values_To_Ids;
111: PROCEDURE Create_pack_serial_lots(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115: P_plsl_Rec IN plsl_Rec_Type := G_MISS_plsl_REC,
116: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
117: X_PACKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,

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

110: END Convert_plsl_Values_To_Ids;
111: PROCEDURE Create_pack_serial_lots(
112: P_Api_Version_Number IN NUMBER,
113: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
114: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
115: P_plsl_Rec IN plsl_Rec_Type := G_MISS_plsl_REC,
116: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
117: X_PACKLIST_SERIAL_LOT_ID OUT NOCOPY NUMBER,
118: X_Return_Status OUT NOCOPY VARCHAR2,

Line 132: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 142: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 153: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 173: P_Init_Msg_List => FND_API.G_FALSE,

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

Line 174: P_Commit => FND_API.G_FALSE,

170: -- Hint: Primary key needs to be returned
171: CSP_pack_serial_lots_PVT.Create_pack_serial_lots(
172: P_Api_Version_Number => 2.0,
173: P_Init_Msg_List => FND_API.G_FALSE,
174: P_Commit => FND_API.G_FALSE,
175: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
176: P_plsl_Rec => l_pvt_plsl_Rec ,
177: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
178: X_PACKLIST_SERIAL_LOT_ID => x_PACKLIST_SERIAL_LOT_ID,

Line 175: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

171: CSP_pack_serial_lots_PVT.Create_pack_serial_lots(
172: P_Api_Version_Number => 2.0,
173: P_Init_Msg_List => FND_API.G_FALSE,
174: P_Commit => FND_API.G_FALSE,
175: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
176: P_plsl_Rec => l_pvt_plsl_Rec ,
177: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
178: X_PACKLIST_SERIAL_LOT_ID => x_PACKLIST_SERIAL_LOT_ID,
179: X_Return_Status => x_return_status,

Line 186: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 187: raise FND_API.G_EXC_ERROR;

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

Line 188: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 189: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 197: IF FND_API.to_Boolean( p_commit )

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

Line 214: WHEN FND_API.G_EXC_ERROR THEN

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

Line 224: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 267: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 277: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 288: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 306: P_Init_Msg_List => FND_API.G_FALSE,

302: );
303:
304: CSP_pack_serial_lots_PVT.Update_pack_serial_lots(
305: P_Api_Version_Number => 2.0,
306: P_Init_Msg_List => FND_API.G_FALSE,
307: P_Commit => p_commit,
308: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
309: P_Identity_Salesforce_Id => p_identity_salesforce_id,
310: P_plsl_Rec => l_pvt_plsl_Rec ,

Line 308: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

304: CSP_pack_serial_lots_PVT.Update_pack_serial_lots(
305: P_Api_Version_Number => 2.0,
306: P_Init_Msg_List => FND_API.G_FALSE,
307: P_Commit => p_commit,
308: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
309: P_Identity_Salesforce_Id => p_identity_salesforce_id,
310: P_plsl_Rec => l_pvt_plsl_Rec ,
311: X_Return_Status => x_return_status,
312: X_Msg_Count => x_msg_count,

Line 318: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 319: raise FND_API.G_EXC_ERROR;

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

Line 320: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 321: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 329: IF FND_API.to_Boolean( p_commit )

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

Line 346: WHEN FND_API.G_EXC_ERROR THEN

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

Line 356: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

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

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

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

Line 400: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 405: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 410: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 421: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 439: P_Init_Msg_List => FND_API.G_FALSE,

435: );
436:
437: CSP_pack_serial_lots_PVT.Delete_pack_serial_lots(
438: P_Api_Version_Number => 2.0,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => p_commit,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
442: P_Identity_Salesforce_Id => p_identity_salesforce_id,
443: P_plsl_Rec => l_pvt_plsl_Rec,

Line 441: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

437: CSP_pack_serial_lots_PVT.Delete_pack_serial_lots(
438: P_Api_Version_Number => 2.0,
439: P_Init_Msg_List => FND_API.G_FALSE,
440: P_Commit => p_commit,
441: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
442: P_Identity_Salesforce_Id => p_identity_salesforce_id,
443: P_plsl_Rec => l_pvt_plsl_Rec,
444: X_Return_Status => x_return_status,
445: X_Msg_Count => x_msg_count,

Line 451: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 452: raise FND_API.G_EXC_ERROR;

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

Line 453: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 454: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 462: IF FND_API.to_Boolean( p_commit )

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

Line 479: WHEN FND_API.G_EXC_ERROR THEN

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

Line 489: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

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

509:
510:
511: PROCEDURE Get_pack_serial_lots(
512: P_Api_Version_Number IN NUMBER,
513: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
514: P_identity_salesforce_id IN NUMBER := NULL,
515: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,
516: -- Hint: Add list of bind variables here
517: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

515: P_plsl_Rec IN CSP_pack_serial_lots_PUB.plsl_Rec_Type,
516: -- Hint: Add list of bind variables here
517: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
518: p_start_rec_prt IN NUMBER := 1,
519: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
520: -- Hint: user defined record type
521: p_order_by_rec IN CSP_pack_serial_lots_PUB.plsl_sort_rec_type,
522: x_return_status OUT NOCOPY VARCHAR2,
523: x_msg_count OUT NOCOPY NUMBER,

Line 541: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

Line 546: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 551: IF FND_API.to_Boolean( p_init_msg_list )

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

Line 562: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 572: P_Init_Msg_List => FND_API.G_FALSE,

568: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_Pack_Serial_Lots');
569: /*
570: CSP_pack_serial_lots_PVT.Get_pack_serial_lots(
571: P_Api_Version_Number => 2.0,
572: P_Init_Msg_List => FND_API.G_FALSE,
573: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
574: P_Identity_Salesforce_id => p_identity_salesforce_id,
575: P_plsl_Rec => P_plsl_Rec,
576: p_rec_requested => p_rec_requested,

Line 573: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

569: /*
570: CSP_pack_serial_lots_PVT.Get_pack_serial_lots(
571: P_Api_Version_Number => 2.0,
572: P_Init_Msg_List => FND_API.G_FALSE,
573: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
574: P_Identity_Salesforce_id => p_identity_salesforce_id,
575: P_plsl_Rec => P_plsl_Rec,
576: p_rec_requested => p_rec_requested,
577: p_start_rec_prt => p_start_rec_prt,

Line 595: IF x_return_status = FND_API.G_RET_STS_ERROR then

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

Line 596: raise FND_API.G_EXC_ERROR;

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

Line 597: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 598: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 616: WHEN FND_API.G_EXC_ERROR THEN

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

Line 626: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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