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_ORDERLINES_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 123: raise FND_API.G_EXC_ERROR;

119:
120: -- If there is an error in conversion precessing, raise an error.
121: IF l_any_errors
122: THEN
123: raise FND_API.G_EXC_ERROR;
124: END IF;
125:
126: END Convert_mol_Values_To_Ids;
127: PROCEDURE Create_orderlines(

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

125:
126: END Convert_mol_Values_To_Ids;
127: PROCEDURE Create_orderlines(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
132: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
133: X_LINE_ID OUT NOCOPY NUMBER,

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

126: END Convert_mol_Values_To_Ids;
127: PROCEDURE Create_orderlines(
128: P_Api_Version_Number IN NUMBER,
129: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
130: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
131: P_mol_Rec IN mol_Rec_Type := G_MISS_mol_REC,
132: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
133: X_LINE_ID OUT NOCOPY NUMBER,
134: X_Return_Status OUT NOCOPY VARCHAR2,

Line 148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

144: -- Standard Start of API savepoint
145: SAVEPOINT CREATE_ORDERLINES_PUB;
146:
147: -- Standard call to check for call compatibility.
148: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
152: THEN

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: p_api_version_number,
150: l_api_name,
151: G_PKG_NAME)
152: THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END IF;
155:
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 158: IF FND_API.to_Boolean( p_init_msg_list )

154: END IF;
155:
156:
157: -- Initialize message list if p_init_msg_list is set to TRUE.
158: IF FND_API.to_Boolean( p_init_msg_list )
159: THEN
160: FND_MSG_PUB.initialize;
161: END IF;
162:

Line 169: x_return_status := FND_API.G_RET_STS_SUCCESS;

165: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
166:
167:
168: -- Initialize API return status to SUCCESS
169: x_return_status := FND_API.G_RET_STS_SUCCESS;
170:
171: --
172: -- API body
173: --

Line 189: P_Init_Msg_List => FND_API.G_FALSE,

185: -- Calling Private package: Create_ORDERLINES
186: -- Hint: Primary key needs to be returned
187: CSP_orderlines_PVT.Create_orderlines(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_mol_Rec => l_pvt_mol_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 190: P_Commit => FND_API.G_FALSE,

186: -- Hint: Primary key needs to be returned
187: CSP_orderlines_PVT.Create_orderlines(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_mol_Rec => l_pvt_mol_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
194: X_LINE_ID => x_LINE_ID,

Line 191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

187: CSP_orderlines_PVT.Create_orderlines(
188: P_Api_Version_Number => 2.0,
189: P_Init_Msg_List => FND_API.G_FALSE,
190: P_Commit => FND_API.G_FALSE,
191: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
192: P_mol_Rec => l_pvt_mol_Rec ,
193: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
194: X_LINE_ID => x_LINE_ID,
195: X_Return_Status => x_return_status,

Line 202: IF x_return_status = FND_API.G_RET_STS_ERROR then

198:
199:
200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;

Line 203: raise FND_API.G_EXC_ERROR;

199:
200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:

Line 204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

200:
201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: --

Line 205: raise FND_API.G_EXC_UNEXPECTED_ERROR;

201: -- Check return status from the above procedure call
202: IF x_return_status = FND_API.G_RET_STS_ERROR then
203: raise FND_API.G_EXC_ERROR;
204: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
205: raise FND_API.G_EXC_UNEXPECTED_ERROR;
206: END IF;
207:
208: --
209: -- End of API body.

Line 213: IF FND_API.to_Boolean( p_commit )

209: -- End of API body.
210: --
211:
212: -- Standard check for p_commit
213: IF FND_API.to_Boolean( p_commit )
214: THEN
215: COMMIT WORK;
216: END IF;
217:

Line 230: WHEN FND_API.G_EXC_ERROR THEN

226: p_data => x_msg_data
227: );
228:
229: EXCEPTION
230: WHEN FND_API.G_EXC_ERROR THEN
231: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
232: P_API_NAME => L_API_NAME
233: ,P_PKG_NAME => G_PKG_NAME
234: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

236: ,X_MSG_COUNT => X_MSG_COUNT
237: ,X_MSG_DATA => X_MSG_DATA
238: ,X_RETURN_STATUS => X_RETURN_STATUS);
239:
240: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
242: P_API_NAME => L_API_NAME
243: ,P_PKG_NAME => G_PKG_NAME
244: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

261:
262: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
263: PROCEDURE Update_orderlines(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: P_Identity_Salesforce_Id IN NUMBER := NULL,
268: P_mol_Rec IN mol_Rec_Type,
269: X_Return_Status OUT NOCOPY VARCHAR2,

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

262: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
263: PROCEDURE Update_orderlines(
264: P_Api_Version_Number IN NUMBER,
265: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
266: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
267: P_Identity_Salesforce_Id IN NUMBER := NULL,
268: P_mol_Rec IN mol_Rec_Type,
269: X_Return_Status OUT NOCOPY VARCHAR2,
270: X_Msg_Count OUT NOCOPY NUMBER,

Line 283: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

279: -- Standard Start of API savepoint
280: SAVEPOINT UPDATE_ORDERLINES_PUB;
281:
282: -- Standard call to check for call compatibility.
283: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
284: p_api_version_number,
285: l_api_name,
286: G_PKG_NAME)
287: THEN

Line 288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

284: p_api_version_number,
285: l_api_name,
286: G_PKG_NAME)
287: THEN
288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
289: END IF;
290:
291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 293: IF FND_API.to_Boolean( p_init_msg_list )

289: END IF;
290:
291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean( p_init_msg_list )
294: THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:

Line 304: x_return_status := FND_API.G_RET_STS_SUCCESS;

300: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
301:
302:
303: -- Initialize API return status to SUCCESS
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: --
307: -- API body
308: --

Line 322: P_Init_Msg_List => FND_API.G_FALSE,

318: );
319:
320: CSP_orderlines_PVT.Update_orderlines(
321: P_Api_Version_Number => 2.0,
322: P_Init_Msg_List => FND_API.G_FALSE,
323: P_Commit => p_commit,
324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
325: P_Identity_Salesforce_Id => p_identity_salesforce_id,
326: P_mol_Rec => l_pvt_mol_Rec ,

Line 324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

320: CSP_orderlines_PVT.Update_orderlines(
321: P_Api_Version_Number => 2.0,
322: P_Init_Msg_List => FND_API.G_FALSE,
323: P_Commit => p_commit,
324: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
325: P_Identity_Salesforce_Id => p_identity_salesforce_id,
326: P_mol_Rec => l_pvt_mol_Rec ,
327: X_Return_Status => x_return_status,
328: X_Msg_Count => x_msg_count,

Line 334: IF x_return_status = FND_API.G_RET_STS_ERROR then

330:
331:
332:
333: -- Check return status from the above procedure call
334: IF x_return_status = FND_API.G_RET_STS_ERROR then
335: raise FND_API.G_EXC_ERROR;
336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;

Line 335: raise FND_API.G_EXC_ERROR;

331:
332:
333: -- Check return status from the above procedure call
334: IF x_return_status = FND_API.G_RET_STS_ERROR then
335: raise FND_API.G_EXC_ERROR;
336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:

Line 336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

332:
333: -- Check return status from the above procedure call
334: IF x_return_status = FND_API.G_RET_STS_ERROR then
335: raise FND_API.G_EXC_ERROR;
336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: --

Line 337: raise FND_API.G_EXC_UNEXPECTED_ERROR;

333: -- Check return status from the above procedure call
334: IF x_return_status = FND_API.G_RET_STS_ERROR then
335: raise FND_API.G_EXC_ERROR;
336: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
337: raise FND_API.G_EXC_UNEXPECTED_ERROR;
338: END IF;
339:
340: --
341: -- End of API body

Line 345: IF FND_API.to_Boolean( p_commit )

341: -- End of API body
342: --
343:
344: -- Standard check for p_commit
345: IF FND_API.to_Boolean( p_commit )
346: THEN
347: COMMIT WORK;
348: END IF;
349:

Line 362: WHEN FND_API.G_EXC_ERROR THEN

358: p_data => x_msg_data
359: );
360:
361: EXCEPTION
362: WHEN FND_API.G_EXC_ERROR THEN
363: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
364: P_API_NAME => L_API_NAME
365: ,P_PKG_NAME => G_PKG_NAME
366: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

368: ,X_MSG_COUNT => X_MSG_COUNT
369: ,X_MSG_DATA => X_MSG_DATA
370: ,X_RETURN_STATUS => X_RETURN_STATUS);
371:
372: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
373: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
374: P_API_NAME => L_API_NAME
375: ,P_PKG_NAME => G_PKG_NAME
376: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

394: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
395: -- The Master delete procedure may not be needed depends on different business requirements.
396: PROCEDURE Delete_orderlines(
397: P_Api_Version_Number IN NUMBER,
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
400: P_identity_salesforce_id IN NUMBER := NULL,
401: P_mol_Rec IN mol_Rec_Type,
402: X_Return_Status OUT NOCOPY VARCHAR2,

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

395: -- The Master delete procedure may not be needed depends on different business requirements.
396: PROCEDURE Delete_orderlines(
397: P_Api_Version_Number IN NUMBER,
398: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
399: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
400: P_identity_salesforce_id IN NUMBER := NULL,
401: P_mol_Rec IN mol_Rec_Type,
402: X_Return_Status OUT NOCOPY VARCHAR2,
403: X_Msg_Count OUT NOCOPY NUMBER,

Line 416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

412: -- Standard Start of API savepoint
413: SAVEPOINT DELETE_ORDERLINES_PUB;
414:
415: -- Standard call to check for call compatibility.
416: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
417: p_api_version_number,
418: l_api_name,
419: G_PKG_NAME)
420: THEN

Line 421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

417: p_api_version_number,
418: l_api_name,
419: G_PKG_NAME)
420: THEN
421: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422: END IF;
423:
424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 426: IF FND_API.to_Boolean( p_init_msg_list )

422: END IF;
423:
424:
425: -- Initialize message list if p_init_msg_list is set to TRUE.
426: IF FND_API.to_Boolean( p_init_msg_list )
427: THEN
428: FND_MSG_PUB.initialize;
429: END IF;
430:

Line 437: x_return_status := FND_API.G_RET_STS_SUCCESS;

433: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
434:
435:
436: -- Initialize API return status to SUCCESS
437: x_return_status := FND_API.G_RET_STS_SUCCESS;
438:
439: --
440: -- API body
441: --

Line 455: P_Init_Msg_List => FND_API.G_FALSE,

451: );
452:
453: CSP_orderlines_PVT.Delete_orderlines(
454: P_Api_Version_Number => 2.0,
455: P_Init_Msg_List => FND_API.G_FALSE,
456: P_Commit => p_commit,
457: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
458: P_Identity_Salesforce_Id => p_identity_salesforce_id,
459: P_mol_Rec => l_pvt_mol_Rec,

Line 457: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

453: CSP_orderlines_PVT.Delete_orderlines(
454: P_Api_Version_Number => 2.0,
455: P_Init_Msg_List => FND_API.G_FALSE,
456: P_Commit => p_commit,
457: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
458: P_Identity_Salesforce_Id => p_identity_salesforce_id,
459: P_mol_Rec => l_pvt_mol_Rec,
460: X_Return_Status => x_return_status,
461: X_Msg_Count => x_msg_count,

Line 467: IF x_return_status = FND_API.G_RET_STS_ERROR then

463:
464:
465:
466: -- Check return status from the above procedure call
467: IF x_return_status = FND_API.G_RET_STS_ERROR then
468: raise FND_API.G_EXC_ERROR;
469: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;

Line 468: raise FND_API.G_EXC_ERROR;

464:
465:
466: -- Check return status from the above procedure call
467: IF x_return_status = FND_API.G_RET_STS_ERROR then
468: raise FND_API.G_EXC_ERROR;
469: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:

Line 469: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

465:
466: -- Check return status from the above procedure call
467: IF x_return_status = FND_API.G_RET_STS_ERROR then
468: raise FND_API.G_EXC_ERROR;
469: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: --

Line 470: raise FND_API.G_EXC_UNEXPECTED_ERROR;

466: -- Check return status from the above procedure call
467: IF x_return_status = FND_API.G_RET_STS_ERROR then
468: raise FND_API.G_EXC_ERROR;
469: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
470: raise FND_API.G_EXC_UNEXPECTED_ERROR;
471: END IF;
472:
473: --
474: -- End of API body

Line 478: IF FND_API.to_Boolean( p_commit )

474: -- End of API body
475: --
476:
477: -- Standard check for p_commit
478: IF FND_API.to_Boolean( p_commit )
479: THEN
480: COMMIT WORK;
481: END IF;
482:

Line 495: WHEN FND_API.G_EXC_ERROR THEN

491: p_data => x_msg_data
492: );
493:
494: EXCEPTION
495: WHEN FND_API.G_EXC_ERROR THEN
496: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
497: P_API_NAME => L_API_NAME
498: ,P_PKG_NAME => G_PKG_NAME
499: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

501: ,X_MSG_COUNT => X_MSG_COUNT
502: ,X_MSG_DATA => X_MSG_DATA
503: ,X_RETURN_STATUS => X_RETURN_STATUS);
504:
505: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
506: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
507: P_API_NAME => L_API_NAME
508: ,P_PKG_NAME => G_PKG_NAME
509: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

525:
526:
527: PROCEDURE Get_orderlines(
528: P_Api_Version_Number IN NUMBER,
529: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
530: P_identity_salesforce_id IN NUMBER := NULL,
531: P_mol_Rec IN CSP_orderlines_PUB.mol_Rec_Type,
532: -- Hint: Add list of bind variables here
533: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

531: P_mol_Rec IN CSP_orderlines_PUB.mol_Rec_Type,
532: -- Hint: Add list of bind variables here
533: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
534: p_start_rec_prt IN NUMBER := 1,
535: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
536: -- Hint: user defined record type
537: p_order_by_rec IN CSP_orderlines_PUB.mol_sort_rec_type,
538: x_return_status OUT NOCOPY VARCHAR2,
539: x_msg_count OUT NOCOPY NUMBER,

Line 557: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

553: -- Standard Start of API savepoint
554: SAVEPOINT GET_ORDERLINES_PUB;
555:
556: -- Standard call to check for call compatibility.
557: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
558: p_api_version_number,
559: l_api_name,
560: G_PKG_NAME)
561: THEN

Line 562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

558: p_api_version_number,
559: l_api_name,
560: G_PKG_NAME)
561: THEN
562: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
563: END IF;
564:
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 567: IF FND_API.to_Boolean( p_init_msg_list )

563: END IF;
564:
565:
566: -- Initialize message list if p_init_msg_list is set to TRUE.
567: IF FND_API.to_Boolean( p_init_msg_list )
568: THEN
569: FND_MSG_PUB.initialize;
570: END IF;
571:

Line 578: x_return_status := FND_API.G_RET_STS_SUCCESS;

574: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: ' || l_api_name || 'start');
575:
576:
577: -- Initialize API return status to SUCCESS
578: x_return_status := FND_API.G_RET_STS_SUCCESS;
579:
580: --
581: -- API body
582: --

Line 588: P_Init_Msg_List => FND_API.G_FALSE,

584: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_ORDERLINES');
585: /*
586: CSP_orderlines_PVT.Get_orderlines(
587: P_Api_Version_Number => 2.0,
588: P_Init_Msg_List => FND_API.G_FALSE,
589: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
590: P_Identity_Salesforce_id => p_identity_salesforce_id,
591: P_mol_Rec => P_mol_Rec,
592: p_rec_requested => p_rec_requested,

Line 589: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

585: /*
586: CSP_orderlines_PVT.Get_orderlines(
587: P_Api_Version_Number => 2.0,
588: P_Init_Msg_List => FND_API.G_FALSE,
589: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
590: P_Identity_Salesforce_id => p_identity_salesforce_id,
591: P_mol_Rec => P_mol_Rec,
592: p_rec_requested => p_rec_requested,
593: p_start_rec_prt => p_start_rec_prt,

Line 611: IF x_return_status = FND_API.G_RET_STS_ERROR then

607:
608:
609:
610: -- Check return status from the above procedure call
611: IF x_return_status = FND_API.G_RET_STS_ERROR then
612: raise FND_API.G_EXC_ERROR;
613: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: raise FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;

Line 612: raise FND_API.G_EXC_ERROR;

608:
609:
610: -- Check return status from the above procedure call
611: IF x_return_status = FND_API.G_RET_STS_ERROR then
612: raise FND_API.G_EXC_ERROR;
613: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: raise FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: */

Line 613: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

609:
610: -- Check return status from the above procedure call
611: IF x_return_status = FND_API.G_RET_STS_ERROR then
612: raise FND_API.G_EXC_ERROR;
613: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: raise FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: */
617: --

Line 614: raise FND_API.G_EXC_UNEXPECTED_ERROR;

610: -- Check return status from the above procedure call
611: IF x_return_status = FND_API.G_RET_STS_ERROR then
612: raise FND_API.G_EXC_ERROR;
613: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
614: raise FND_API.G_EXC_UNEXPECTED_ERROR;
615: END IF;
616: */
617: --
618: -- End of API body

Line 632: WHEN FND_API.G_EXC_ERROR THEN

628: p_data => x_msg_data
629: );
630:
631: EXCEPTION
632: WHEN FND_API.G_EXC_ERROR THEN
633: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
634: P_API_NAME => L_API_NAME
635: ,P_PKG_NAME => G_PKG_NAME
636: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

638: ,X_MSG_COUNT => X_MSG_COUNT
639: ,X_MSG_DATA => X_MSG_DATA
640: ,X_RETURN_STATUS => X_RETURN_STATUS);
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
644: P_API_NAME => L_API_NAME
645: ,P_PKG_NAME => G_PKG_NAME
646: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR