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_ORDERHEADERS_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 134: raise FND_API.G_EXC_ERROR;

130:
131: -- If there is an error in conversion precessing, raise an error.
132: IF l_any_errors
133: THEN
134: raise FND_API.G_EXC_ERROR;
135: END IF;
136:
137: END Convert_MOH_Values_To_Ids;
138: PROCEDURE Create_orderheaders(

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

136:
137: END Convert_MOH_Values_To_Ids;
138: PROCEDURE Create_orderheaders(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
143: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
144: X_HEADER_ID OUT NOCOPY NUMBER,

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

137: END Convert_MOH_Values_To_Ids;
138: PROCEDURE Create_orderheaders(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
142: P_MOH_Rec IN MOH_Rec_Type := G_MISS_MOH_REC,
143: --Hint: Add detail tables as parameter lists if it's master-detail relationship.
144: X_HEADER_ID OUT NOCOPY NUMBER,
145: X_Return_Status OUT NOCOPY VARCHAR2,

Line 159: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

155: -- Standard Start of API savepoint
156: SAVEPOINT CREATE_ORDERHEADERS_PUB;
157:
158: -- Standard call to check for call compatibility.
159: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
160: p_api_version_number,
161: l_api_name,
162: G_PKG_NAME)
163: THEN

Line 164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

160: p_api_version_number,
161: l_api_name,
162: G_PKG_NAME)
163: THEN
164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
165: END IF;
166:
167:
168: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 169: IF FND_API.to_Boolean( p_init_msg_list )

165: END IF;
166:
167:
168: -- Initialize message list if p_init_msg_list is set to TRUE.
169: IF FND_API.to_Boolean( p_init_msg_list )
170: THEN
171: FND_MSG_PUB.initialize;
172: END IF;
173:

Line 180: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 200: P_Init_Msg_List => FND_API.G_FALSE,

196: -- Calling Private package: Create_ORDERHEADERS
197: -- Hint: Primary key needs to be returned
198: CSP_orderheaders_PVT.Create_orderheaders(
199: P_Api_Version_Number => 2.0,
200: P_Init_Msg_List => FND_API.G_FALSE,
201: P_Commit => FND_API.G_FALSE,
202: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
203: P_MOH_Rec => l_pvt_MOH_Rec ,
204: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.

Line 201: P_Commit => FND_API.G_FALSE,

197: -- Hint: Primary key needs to be returned
198: CSP_orderheaders_PVT.Create_orderheaders(
199: P_Api_Version_Number => 2.0,
200: P_Init_Msg_List => FND_API.G_FALSE,
201: P_Commit => FND_API.G_FALSE,
202: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
203: P_MOH_Rec => l_pvt_MOH_Rec ,
204: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
205: X_HEADER_ID => x_HEADER_ID,

Line 202: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

198: CSP_orderheaders_PVT.Create_orderheaders(
199: P_Api_Version_Number => 2.0,
200: P_Init_Msg_List => FND_API.G_FALSE,
201: P_Commit => FND_API.G_FALSE,
202: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
203: P_MOH_Rec => l_pvt_MOH_Rec ,
204: -- Hint: Add detail tables as parameter lists if it's master-detail relationship.
205: X_HEADER_ID => x_HEADER_ID,
206: X_Return_Status => x_return_status,

Line 213: IF x_return_status = FND_API.G_RET_STS_ERROR then

209:
210:
211:
212: -- Check return status from the above procedure call
213: IF x_return_status = FND_API.G_RET_STS_ERROR then
214: raise FND_API.G_EXC_ERROR;
215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
216: raise FND_API.G_EXC_UNEXPECTED_ERROR;
217: END IF;

Line 214: raise FND_API.G_EXC_ERROR;

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

Line 215: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 216: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 224: IF FND_API.to_Boolean( p_commit )

220: -- End of API body.
221: --
222:
223: -- Standard check for p_commit
224: IF FND_API.to_Boolean( p_commit )
225: THEN
226: COMMIT WORK;
227: END IF;
228:

Line 241: WHEN FND_API.G_EXC_ERROR THEN

237: p_data => x_msg_data
238: );
239:
240: EXCEPTION
241: WHEN FND_API.G_EXC_ERROR THEN
242: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
243: P_API_NAME => L_API_NAME
244: ,P_PKG_NAME => G_PKG_NAME
245: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

247: ,X_MSG_COUNT => X_MSG_COUNT
248: ,X_MSG_DATA => X_MSG_DATA
249: ,X_RETURN_STATUS => X_RETURN_STATUS);
250:
251: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
252: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
253: P_API_NAME => L_API_NAME
254: ,P_PKG_NAME => G_PKG_NAME
255: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

272:
273: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
274: PROCEDURE Update_orderheaders(
275: P_Api_Version_Number IN NUMBER,
276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
278: P_Identity_Salesforce_Id IN NUMBER := NULL,
279: P_MOH_Rec IN MOH_Rec_Type,
280: X_Return_Status OUT NOCOPY VARCHAR2,

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

273: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
274: PROCEDURE Update_orderheaders(
275: P_Api_Version_Number IN NUMBER,
276: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
278: P_Identity_Salesforce_Id IN NUMBER := NULL,
279: P_MOH_Rec IN MOH_Rec_Type,
280: X_Return_Status OUT NOCOPY VARCHAR2,
281: X_Msg_Count OUT NOCOPY NUMBER,

Line 294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

290: -- Standard Start of API savepoint
291: SAVEPOINT UPDATE_ORDERHEADERS_PUB;
292:
293: -- Standard call to check for call compatibility.
294: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
295: p_api_version_number,
296: l_api_name,
297: G_PKG_NAME)
298: THEN

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: p_api_version_number,
296: l_api_name,
297: G_PKG_NAME)
298: THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: END IF;
301:
302:
303: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 304: IF FND_API.to_Boolean( p_init_msg_list )

300: END IF;
301:
302:
303: -- Initialize message list if p_init_msg_list is set to TRUE.
304: IF FND_API.to_Boolean( p_init_msg_list )
305: THEN
306: FND_MSG_PUB.initialize;
307: END IF;
308:

Line 315: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 333: P_Init_Msg_List => FND_API.G_FALSE,

329: );
330:
331: CSP_orderheaders_PVT.Update_orderheaders(
332: P_Api_Version_Number => 2.0,
333: P_Init_Msg_List => FND_API.G_FALSE,
334: P_Commit => p_commit,
335: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
336: P_Identity_Salesforce_Id => p_identity_salesforce_id,
337: P_MOH_Rec => l_pvt_MOH_Rec ,

Line 335: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

331: CSP_orderheaders_PVT.Update_orderheaders(
332: P_Api_Version_Number => 2.0,
333: P_Init_Msg_List => FND_API.G_FALSE,
334: P_Commit => p_commit,
335: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
336: P_Identity_Salesforce_Id => p_identity_salesforce_id,
337: P_MOH_Rec => l_pvt_MOH_Rec ,
338: X_Return_Status => x_return_status,
339: X_Msg_Count => x_msg_count,

Line 345: IF x_return_status = FND_API.G_RET_STS_ERROR then

341:
342:
343:
344: -- Check return status from the above procedure call
345: IF x_return_status = FND_API.G_RET_STS_ERROR then
346: raise FND_API.G_EXC_ERROR;
347: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
348: raise FND_API.G_EXC_UNEXPECTED_ERROR;
349: END IF;

Line 346: raise FND_API.G_EXC_ERROR;

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

Line 347: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 348: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 356: IF FND_API.to_Boolean( p_commit )

352: -- End of API body
353: --
354:
355: -- Standard check for p_commit
356: IF FND_API.to_Boolean( p_commit )
357: THEN
358: COMMIT WORK;
359: END IF;
360:

Line 373: WHEN FND_API.G_EXC_ERROR THEN

369: p_data => x_msg_data
370: );
371:
372: EXCEPTION
373: WHEN FND_API.G_EXC_ERROR THEN
374: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
375: P_API_NAME => L_API_NAME
376: ,P_PKG_NAME => G_PKG_NAME
377: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

379: ,X_MSG_COUNT => X_MSG_COUNT
380: ,X_MSG_DATA => X_MSG_DATA
381: ,X_RETURN_STATUS => X_RETURN_STATUS);
382:
383: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
384: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
385: P_API_NAME => L_API_NAME
386: ,P_PKG_NAME => G_PKG_NAME
387: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

405: -- Hint: Add corresponding delete detail table procedures if it's master-detail relationship.
406: -- The Master delete procedure may not be needed depends on different business requirements.
407: PROCEDURE Delete_orderheaders(
408: P_Api_Version_Number IN NUMBER,
409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
410: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
411: P_identity_salesforce_id IN NUMBER := NULL,
412: P_MOH_Rec IN MOH_Rec_Type,
413: X_Return_Status OUT NOCOPY VARCHAR2,

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

406: -- The Master delete procedure may not be needed depends on different business requirements.
407: PROCEDURE Delete_orderheaders(
408: P_Api_Version_Number IN NUMBER,
409: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
410: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
411: P_identity_salesforce_id IN NUMBER := NULL,
412: P_MOH_Rec IN MOH_Rec_Type,
413: X_Return_Status OUT NOCOPY VARCHAR2,
414: X_Msg_Count OUT NOCOPY NUMBER,

Line 427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

423: -- Standard Start of API savepoint
424: SAVEPOINT DELETE_ORDERHEADERS_PUB;
425:
426: -- Standard call to check for call compatibility.
427: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
428: p_api_version_number,
429: l_api_name,
430: G_PKG_NAME)
431: THEN

Line 432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

428: p_api_version_number,
429: l_api_name,
430: G_PKG_NAME)
431: THEN
432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
433: END IF;
434:
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 437: IF FND_API.to_Boolean( p_init_msg_list )

433: END IF;
434:
435:
436: -- Initialize message list if p_init_msg_list is set to TRUE.
437: IF FND_API.to_Boolean( p_init_msg_list )
438: THEN
439: FND_MSG_PUB.initialize;
440: END IF;
441:

Line 448: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 466: P_Init_Msg_List => FND_API.G_FALSE,

462: );
463:
464: CSP_orderheaders_PVT.Delete_orderheaders(
465: P_Api_Version_Number => 2.0,
466: P_Init_Msg_List => FND_API.G_FALSE,
467: P_Commit => p_commit,
468: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
469: P_Identity_Salesforce_Id => p_identity_salesforce_id,
470: P_MOH_Rec => l_pvt_MOH_Rec,

Line 468: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,

464: CSP_orderheaders_PVT.Delete_orderheaders(
465: P_Api_Version_Number => 2.0,
466: P_Init_Msg_List => FND_API.G_FALSE,
467: P_Commit => p_commit,
468: P_Validation_Level => FND_API.G_VALID_LEVEL_FULL,
469: P_Identity_Salesforce_Id => p_identity_salesforce_id,
470: P_MOH_Rec => l_pvt_MOH_Rec,
471: X_Return_Status => x_return_status,
472: X_Msg_Count => x_msg_count,

Line 478: IF x_return_status = FND_API.G_RET_STS_ERROR then

474:
475:
476:
477: -- Check return status from the above procedure call
478: IF x_return_status = FND_API.G_RET_STS_ERROR then
479: raise FND_API.G_EXC_ERROR;
480: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
481: raise FND_API.G_EXC_UNEXPECTED_ERROR;
482: END IF;

Line 479: raise FND_API.G_EXC_ERROR;

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

Line 480: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

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

Line 481: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 489: IF FND_API.to_Boolean( p_commit )

485: -- End of API body
486: --
487:
488: -- Standard check for p_commit
489: IF FND_API.to_Boolean( p_commit )
490: THEN
491: COMMIT WORK;
492: END IF;
493:

Line 506: WHEN FND_API.G_EXC_ERROR THEN

502: p_data => x_msg_data
503: );
504:
505: EXCEPTION
506: WHEN FND_API.G_EXC_ERROR THEN
507: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
508: P_API_NAME => L_API_NAME
509: ,P_PKG_NAME => G_PKG_NAME
510: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

512: ,X_MSG_COUNT => X_MSG_COUNT
513: ,X_MSG_DATA => X_MSG_DATA
514: ,X_RETURN_STATUS => X_RETURN_STATUS);
515:
516: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
517: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
518: P_API_NAME => L_API_NAME
519: ,P_PKG_NAME => G_PKG_NAME
520: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

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

536:
537:
538: PROCEDURE Get_orderheaders(
539: P_Api_Version_Number IN NUMBER,
540: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
541: P_identity_salesforce_id IN NUMBER := NULL,
542: P_MOH_Rec IN CSP_orderheaders_PUB.MOH_Rec_Type,
543: -- Hint: Add list of bind variables here
544: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,

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

542: P_MOH_Rec IN CSP_orderheaders_PUB.MOH_Rec_Type,
543: -- Hint: Add list of bind variables here
544: p_rec_requested IN NUMBER := G_DEFAULT_NUM_REC_FETCH,
545: p_start_rec_prt IN NUMBER := 1,
546: p_return_tot_count IN NUMBER := FND_API.G_FALSE,
547: -- Hint: user defined record type
548: p_order_by_rec IN CSP_orderheaders_PUB.MOH_sort_rec_type,
549: x_return_status OUT NOCOPY VARCHAR2,
550: x_msg_count OUT NOCOPY NUMBER,

Line 568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

564: -- Standard Start of API savepoint
565: SAVEPOINT GET_ORDERHEADERS_PUB;
566:
567: -- Standard call to check for call compatibility.
568: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN

Line 573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

569: p_api_version_number,
570: l_api_name,
571: G_PKG_NAME)
572: THEN
573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 578: IF FND_API.to_Boolean( p_init_msg_list )

574: END IF;
575:
576:
577: -- Initialize message list if p_init_msg_list is set to TRUE.
578: IF FND_API.to_Boolean( p_init_msg_list )
579: THEN
580: FND_MSG_PUB.initialize;
581: END IF;
582:

Line 589: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 599: P_Init_Msg_List => FND_API.G_FALSE,

595: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'CSP', 'Public API: - Calling PVT.Get_ORDERHEADERS');
596: /*
597: CSP_orderheaders_PVT.Get_orderheaders(
598: P_Api_Version_Number => 1.0,
599: P_Init_Msg_List => FND_API.G_FALSE,
600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
601: P_Identity_Salesforce_id => p_identity_salesforce_id,
602: P_MOH_Rec => P_MOH_Rec,
603: p_rec_requested => p_rec_requested,

Line 600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

596: /*
597: CSP_orderheaders_PVT.Get_orderheaders(
598: P_Api_Version_Number => 1.0,
599: P_Init_Msg_List => FND_API.G_FALSE,
600: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
601: P_Identity_Salesforce_id => p_identity_salesforce_id,
602: P_MOH_Rec => P_MOH_Rec,
603: p_rec_requested => p_rec_requested,
604: p_start_rec_prt => p_start_rec_prt,

Line 619: IF x_return_status = FND_API.G_RET_STS_ERROR then

615:
616:
617:
618: -- Check return status from the above procedure call
619: IF x_return_status = FND_API.G_RET_STS_ERROR then
620: raise FND_API.G_EXC_ERROR;
621: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;

Line 620: raise FND_API.G_EXC_ERROR;

616:
617:
618: -- Check return status from the above procedure call
619: IF x_return_status = FND_API.G_RET_STS_ERROR then
620: raise FND_API.G_EXC_ERROR;
621: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624: */

Line 621: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then

617:
618: -- Check return status from the above procedure call
619: IF x_return_status = FND_API.G_RET_STS_ERROR then
620: raise FND_API.G_EXC_ERROR;
621: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624: */
625: --

Line 622: raise FND_API.G_EXC_UNEXPECTED_ERROR;

618: -- Check return status from the above procedure call
619: IF x_return_status = FND_API.G_RET_STS_ERROR then
620: raise FND_API.G_EXC_ERROR;
621: elsif x_return_status = FND_API.G_RET_STS_UNEXP_ERROR then
622: raise FND_API.G_EXC_UNEXPECTED_ERROR;
623: END IF;
624: */
625: --
626: -- End of API body

Line 640: WHEN FND_API.G_EXC_ERROR THEN

636: p_data => x_msg_data
637: );
638:
639: EXCEPTION
640: WHEN FND_API.G_EXC_ERROR THEN
641: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
642: P_API_NAME => L_API_NAME
643: ,P_PKG_NAME => G_PKG_NAME
644: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

Line 650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

646: ,X_MSG_COUNT => X_MSG_COUNT
647: ,X_MSG_DATA => X_MSG_DATA
648: ,X_RETURN_STATUS => X_RETURN_STATUS);
649:
650: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
651: JTF_PLSQL_API.HANDLE_EXCEPTIONS(
652: P_API_NAME => L_API_NAME
653: ,P_PKG_NAME => G_PKG_NAME
654: ,P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR