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

Line 51: RAISE Fnd_Api.G_Exc_Unexpected_Error;

47: p_pkg_name => G_PKG_NAME,
48: p_procedure_name => l_api_name
49: );
50:
51: RAISE Fnd_Api.G_Exc_Unexpected_Error;
52:
53: END Check_Lock;
54:
55: ---------------------------------------------------------------------------

Line 100: RAISE Fnd_Api.G_Exc_Unexpected_Error;

96: p_pkg_name => G_PKG_NAME,
97: p_procedure_name => l_api_name||' : '||p_lookup_type
98: );
99:
100: RAISE Fnd_Api.G_Exc_Unexpected_Error;
101:
102: END Get_Gms_Lookup_Code;
103:
104: ---------------------------------------------------------------------------

Line 108: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

104: ---------------------------------------------------------------------------
105:
106: PROCEDURE Create_Installment
107: (
108: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
109: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
110: p_commit IN VARCHAR2 := Fnd_Api.G_False,
111: x_rowid OUT NOCOPY VARCHAR2,
112: x_proposal_installment_id OUT NOCOPY NUMBER,

Line 109: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

105:
106: PROCEDURE Create_Installment
107: (
108: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
109: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
110: p_commit IN VARCHAR2 := Fnd_Api.G_False,
111: x_rowid OUT NOCOPY VARCHAR2,
112: x_proposal_installment_id OUT NOCOPY NUMBER,
113: p_proposal_award_id IN NUMBER,

Line 110: p_commit IN VARCHAR2 := Fnd_Api.G_False,

106: PROCEDURE Create_Installment
107: (
108: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
109: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
110: p_commit IN VARCHAR2 := Fnd_Api.G_False,
111: x_rowid OUT NOCOPY VARCHAR2,
112: x_proposal_installment_id OUT NOCOPY NUMBER,
113: p_proposal_award_id IN NUMBER,
114: p_installment_id IN NUMBER,

Line 151: x_return_status := Fnd_Api.G_Ret_Sts_Success;

147: /*
148: ** Initialize
149: */
150:
151: x_return_status := Fnd_Api.G_Ret_Sts_Success;
152:
153: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
154:
155: Fnd_Msg_Pub.Initialize;

Line 153: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

149: */
150:
151: x_return_status := Fnd_Api.G_Ret_Sts_Success;
152:
153: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
154:
155: Fnd_Msg_Pub.Initialize;
156:
157: END IF;

Line 179: RAISE Fnd_Api.G_Exc_Error;

175:
176:
177: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
178:
179: RAISE Fnd_Api.G_Exc_Error;
180:
181: END IF;
182:
183:

Line 188: IF Fnd_Api.To_Boolean(p_validate_only) THEN

184: /*
185: ** Discontinue processing if API invoked in validation mode
186: */
187:
188: IF Fnd_Api.To_Boolean(p_validate_only) THEN
189:
190: RETURN;
191:
192: END IF;

Line 221: IF Fnd_Api.To_Boolean(p_commit) THEN

217: /*
218: ** Commit data if API invoked in commit mode
219: */
220:
221: IF Fnd_Api.To_Boolean(p_commit) THEN
222:
223: COMMIT;
224:
225: END IF;

Line 230: WHEN Fnd_Api.G_Exc_Error THEN

226:
227:
228: EXCEPTION
229:
230: WHEN Fnd_Api.G_Exc_Error THEN
231:
232: ROLLBACK TO Create_Installment_Pvt;
233:
234: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 234: x_return_status := Fnd_Api.G_Ret_Sts_Error;

230: WHEN Fnd_Api.G_Exc_Error THEN
231:
232: ROLLBACK TO Create_Installment_Pvt;
233:
234: x_return_status := Fnd_Api.G_Ret_Sts_Error;
235:
236: Fnd_Msg_Pub.Count_And_Get
237: (
238: p_count => x_msg_count,

Line 242: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

238: p_count => x_msg_count,
239: p_data => x_msg_data
240: );
241:
242: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
243:
244: ROLLBACK TO Create_Installment_Pvt;
245:
246: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 246: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

242: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
243:
244: ROLLBACK TO Create_Installment_Pvt;
245:
246: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
247:
248: Fnd_Msg_Pub.Count_And_Get
249: (
250: p_count => x_msg_count,

Line 258: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

254: WHEN others THEN
255:
256: ROLLBACK TO Create_Installment_Pvt;
257:
258: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
259:
260: Fnd_Msg_Pub.Add_Exc_Msg
261: (
262: p_pkg_name => G_PKG_NAME,

Line 278: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

274: ---------------------------------------------------------------------------
275:
276: PROCEDURE Update_Installment
277: (
278: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
279: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
280: p_commit IN VARCHAR2 := Fnd_Api.G_False,
281: p_rowid IN VARCHAR2,
282: p_proposal_installment_id IN NUMBER,

Line 279: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

275:
276: PROCEDURE Update_Installment
277: (
278: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
279: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
280: p_commit IN VARCHAR2 := Fnd_Api.G_False,
281: p_rowid IN VARCHAR2,
282: p_proposal_installment_id IN NUMBER,
283: p_record_version_number IN NUMBER,

Line 280: p_commit IN VARCHAR2 := Fnd_Api.G_False,

276: PROCEDURE Update_Installment
277: (
278: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
279: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
280: p_commit IN VARCHAR2 := Fnd_Api.G_False,
281: p_rowid IN VARCHAR2,
282: p_proposal_installment_id IN NUMBER,
283: p_record_version_number IN NUMBER,
284: p_proposal_award_id IN NUMBER,

Line 322: x_return_status := Fnd_Api.G_Ret_Sts_Success;

318: /*
319: ** Initialize
320: */
321:
322: x_return_status := Fnd_Api.G_Ret_Sts_Success;
323:
324: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
325:
326: Fnd_Msg_Pub.Initialize;

Line 324: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

320: */
321:
322: x_return_status := Fnd_Api.G_Ret_Sts_Success;
323:
324: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
325:
326: Fnd_Msg_Pub.Initialize;
327:
328: END IF;

Line 350: RAISE Fnd_Api.G_Exc_Error;

346:
347:
348: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
349:
350: RAISE Fnd_Api.G_Exc_Error;
351:
352: END IF;
353:
354: l_installment_type_code := Get_Gms_Lookup_Code('INSTALLMENT_TYPE',p_installment_type_desc);

Line 373: RAISE Fnd_Api.G_Exc_Error;

369:
370:
371: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
372:
373: RAISE Fnd_Api.G_Exc_Error;
374:
375: END IF;
376:
377: /*

Line 381: IF Fnd_Api.To_Boolean(p_validate_only) THEN

377: /*
378: ** Discontinue processing if API invoked in validation mode
379: */
380:
381: IF Fnd_Api.To_Boolean(p_validate_only) THEN
382:
383: RETURN;
384:
385: END IF;

Line 416: IF Fnd_Api.To_Boolean(p_commit) THEN

412: /*
413: ** Commit data if API invoked in commit mode
414: */
415:
416: IF Fnd_Api.To_Boolean(p_commit) THEN
417:
418: COMMIT;
419:
420: END IF;

Line 425: WHEN Fnd_Api.G_Exc_Error THEN

421:
422:
423: EXCEPTION
424:
425: WHEN Fnd_Api.G_Exc_Error THEN
426:
427: ROLLBACK TO Update_Installment_Pvt;
428:
429: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 429: x_return_status := Fnd_Api.G_Ret_Sts_Error;

425: WHEN Fnd_Api.G_Exc_Error THEN
426:
427: ROLLBACK TO Update_Installment_Pvt;
428:
429: x_return_status := Fnd_Api.G_Ret_Sts_Error;
430:
431: Fnd_Msg_Pub.Count_And_Get
432: (
433: p_count => x_msg_count,

Line 437: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

433: p_count => x_msg_count,
434: p_data => x_msg_data
435: );
436:
437: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
438:
439: ROLLBACK TO Update_Installment_Pvt;
440:
441: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 441: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

437: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
438:
439: ROLLBACK TO Update_Installment_Pvt;
440:
441: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
442:
443: Fnd_Msg_Pub.Count_And_Get
444: (
445: p_count => x_msg_count,

Line 453: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

449: WHEN others THEN
450:
451: ROLLBACK TO Update_Installment_Pvt;
452:
453: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
454:
455: Fnd_Msg_Pub.Add_Exc_Msg
456: (
457: p_pkg_name => G_PKG_NAME,

Line 473: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,

469: ---------------------------------------------------------------------------
470:
471: PROCEDURE Delete_Installment
472: (
473: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
474: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
475: p_commit IN VARCHAR2 := Fnd_Api.G_False,
476: p_rowid IN VARCHAR2,
477: p_record_version_number IN NUMBER,

Line 474: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,

470:
471: PROCEDURE Delete_Installment
472: (
473: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
474: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
475: p_commit IN VARCHAR2 := Fnd_Api.G_False,
476: p_rowid IN VARCHAR2,
477: p_record_version_number IN NUMBER,
478: x_return_status OUT NOCOPY VARCHAR2,

Line 475: p_commit IN VARCHAR2 := Fnd_Api.G_False,

471: PROCEDURE Delete_Installment
472: (
473: p_init_msg_list IN VARCHAR2 := Fnd_Api.G_False,
474: p_validate_only IN VARCHAR2 := Fnd_Api.G_False,
475: p_commit IN VARCHAR2 := Fnd_Api.G_False,
476: p_rowid IN VARCHAR2,
477: p_record_version_number IN NUMBER,
478: x_return_status OUT NOCOPY VARCHAR2,
479: x_msg_count OUT NOCOPY NUMBER,

Line 500: x_return_status := Fnd_Api.G_Ret_Sts_Success;

496: /*
497: ** Initialize
498: */
499:
500: x_return_status := Fnd_Api.G_Ret_Sts_Success;
501:
502: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
503:
504: Fnd_Msg_Pub.Initialize;

Line 502: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN

498: */
499:
500: x_return_status := Fnd_Api.G_Ret_Sts_Success;
501:
502: IF Fnd_Api.To_Boolean(p_init_msg_list) THEN
503:
504: Fnd_Msg_Pub.Initialize;
505:
506: END IF;

Line 526: RAISE Fnd_Api.G_Exc_Error;

522: */
523:
524: IF Fnd_Msg_Pub.Count_Msg > 0 THEN
525:
526: RAISE Fnd_Api.G_Exc_Error;
527:
528: END IF;
529:
530:

Line 535: IF Fnd_Api.To_Boolean(p_validate_only) THEN

531: /*
532: ** Discontinue processing if API invoked in validation mode
533: */
534:
535: IF Fnd_Api.To_Boolean(p_validate_only) THEN
536:
537: RETURN;
538:
539: END IF;

Line 557: IF Fnd_Api.To_Boolean(p_commit) THEN

553: /*
554: ** Commit data if API invoked in commit mode
555: */
556:
557: IF Fnd_Api.To_Boolean(p_commit) THEN
558:
559: COMMIT;
560:
561: END IF;

Line 566: WHEN Fnd_Api.G_Exc_Error THEN

562:
563:
564: EXCEPTION
565:
566: WHEN Fnd_Api.G_Exc_Error THEN
567:
568: ROLLBACK TO Delete_Installment_Pvt;
569:
570: x_return_status := Fnd_Api.G_Ret_Sts_Error;

Line 570: x_return_status := Fnd_Api.G_Ret_Sts_Error;

566: WHEN Fnd_Api.G_Exc_Error THEN
567:
568: ROLLBACK TO Delete_Installment_Pvt;
569:
570: x_return_status := Fnd_Api.G_Ret_Sts_Error;
571:
572: Fnd_Msg_Pub.Count_And_Get
573: (
574: p_count => x_msg_count,

Line 578: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN

574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );
577:
578: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
579:
580: ROLLBACK TO Delete_Installment_Pvt;
581:
582: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

Line 582: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

578: WHEN Fnd_Api.G_Exc_Unexpected_Error THEN
579:
580: ROLLBACK TO Delete_Installment_Pvt;
581:
582: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
583:
584: Fnd_Msg_Pub.Count_And_Get
585: (
586: p_count => x_msg_count,

Line 594: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;

590: WHEN others THEN
591:
592: ROLLBACK TO Delete_Installment_Pvt;
593:
594: x_return_status := Fnd_Api.G_Ret_Sts_Unexp_Error;
595:
596: Fnd_Msg_Pub.Add_Exc_Msg
597: (
598: p_pkg_name => G_PKG_NAME,