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.GMI_RESERVATION_PUB dependencies on GMI_RESERVATION_PUB

Line 1: PACKAGE BODY GMI_Reservation_PUB AS

1: PACKAGE BODY GMI_Reservation_PUB AS
2: /* $Header: GMIPRSVB.pls 120.0 2005/05/25 16:00:01 appldev noship $
3: +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 36: API Name : GMI_Reservation_PUB

32: | |
33: | |
34: | |
35: +=========================================================================+
36: API Name : GMI_Reservation_PUB
37: Type : Global - Package Body
38: Function : This package contains Global procedures used to
39: OPM reservation process.
40: -

Line 48: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_Reservation_PUB';

44: Current Vers : 1.0
45: */
46:
47: /* Global variables */
48: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_Reservation_PUB';
49:
50:
51: /* Api start of comments
52: +==========================================================================+

Line 113: GMI_Reservation_Util.PrintLn('(opm_dbg) in proc GMI_Reservation_PUB.query_reservation ');

109:
110: /* Initialize API return status to success */
111: x_return_status := FND_API.G_RET_STS_SUCCESS;
112:
113: GMI_Reservation_Util.PrintLn('(opm_dbg) in proc GMI_Reservation_PUB.query_reservation ');
114:
115: GMI_Reservation_Util.PrintLn('(opm_dbg) in QueryPub org_id='||p_query_input.organization_id);
116: GMI_Reservation_Util.PrintLn('(opm_dbg) in QueryPub header='||p_query_input.demand_source_header_id);
117: GMI_Reservation_Util.PrintLn('(opm_dbg) in QueryPub line_id='||p_query_input.demand_source_line_id);

Line 154: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.query_reservation before calling PVT');

150:
151: /* ==========================================================================
152: Call The private query_reservation
153: ============================================================================= */
154: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.query_reservation before calling PVT');
155:
156: GMI_Reservation_PVT.Query_Reservation(
157: x_return_status => x_return_status
158: , x_msg_count => x_msg_count

Line 182: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.query_reservation NO Error');

178:
179: /* ============================================================================
180: Set the return values
181: ========================================================================= */
182: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.query_reservation NO Error');
183:
184: EXCEPTION
185: WHEN FND_API.G_EXC_ERROR THEN
186: x_return_status := FND_API.G_RET_STS_ERROR;

Line 202: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.Query_Reservation Exp_Error count='||x_msg_count);

198: , p_msg_index_out => x_msg_count
199: );
200: END IF;
201: */
202: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.Query_Reservation Exp_Error count='||x_msg_count);
203:
204: WHEN OTHERS THEN
205: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
206:

Line 225: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Query_Reservation OTHERS count='||x_msg_count);

221: , p_msg_index_out => x_msg_count
222: );
223: END IF;
224: */
225: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Query_Reservation OTHERS count='||x_msg_count);
226:
227: END Query_Reservation;
228:
229: /* Api start of comments

Line 290: GMI_Reservation_Util.PrintLn('(opm_dbg) in proc GMI_Reservation_PUB.create_reservation ');

286: /* Initialize API return status to success */
287: x_return_status := FND_API.G_RET_STS_SUCCESS;
288: SAVEPOINT GMI_Create_Reservation_PUB;
289:
290: GMI_Reservation_Util.PrintLn('(opm_dbg) in proc GMI_Reservation_PUB.create_reservation ');
291:
292: /*======================================================================
293: Check the validation flag :
294: If validation flag is <>0, then check

Line 328: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.create_reservation before calling PVT');

324:
325: /* =====================================================================
326: Call The private create_reservation
327: ======================================================================= */
328: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.create_reservation before calling PVT');
329:
330: GMI_Reservation_PVT.Create_Reservation(
331: x_return_status => x_return_status
332: , x_msg_count => x_msg_count

Line 356: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.create_reservation : NO Error');

352:
353: /* ========================================================================
354: Set the return values
355: ========================================================================= */
356: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.create_reservation : NO Error');
357:
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN

Line 361: GMI_Reservation_Util.PrintLn('in end of GMI_Reservation_PUB.create_reservation : Error');

357:
358:
359: EXCEPTION
360: WHEN FND_API.G_EXC_ERROR THEN
361: GMI_Reservation_Util.PrintLn('in end of GMI_Reservation_PUB.create_reservation : Error');
362: ROLLBACK TO SAVEPOINT GMI_Create_Reservation_PUB;
363: x_return_status := FND_API.G_RET_STS_ERROR;
364:
365: /* Get message count and data */

Line 371: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Create_Reservation Exp_Error count='||x_msg_count);

367: ( p_count => x_msg_count
368: , p_data => x_msg_data
369: );
370:
371: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Create_Reservation Exp_Error count='||x_msg_count);
372:
373:
374: WHEN OTHERS THEN
375: GMI_Reservation_Util.PrintLn('in end of GMI_Reservation_PUB.create_reservation : ErrorOther');

Line 375: GMI_Reservation_Util.PrintLn('in end of GMI_Reservation_PUB.create_reservation : ErrorOther');

371: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Create_Reservation Exp_Error count='||x_msg_count);
372:
373:
374: WHEN OTHERS THEN
375: GMI_Reservation_Util.PrintLn('in end of GMI_Reservation_PUB.create_reservation : ErrorOther');
376: ROLLBACK TO SAVEPOINT GMI_Create_Reservation_PUB;
377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
378:
379: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 389: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Create_Reservation OTHERS count='||x_msg_count);

385: ( p_count => x_msg_count
386: , p_data => x_msg_data
387: );
388:
389: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_Pub.Create_Reservation OTHERS count='||x_msg_count);
390:
391: END Create_Reservation;
392:
393: /* Api start of comments

Line 485: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.update_reservation before calling PVT');

481:
482: /* =====================================================================
483: Call The private update_reservation_reservation
484: ====================================================================== */
485: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.update_reservation before calling PVT');
486:
487: GMI_Reservation_PVT.Update_Reservation(
488: x_return_status => x_return_status
489: , x_msg_count => x_msg_count

Line 512: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation NO Error');

508:
509: /* =============================================================================
510: Set the return values
511: ============================================================================= */
512: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation NO Error');
513:
514: EXCEPTION
515: WHEN FND_API.G_EXC_ERROR THEN
516: ROLLBACK TO SAVEPOINT GMI_Update_Reservation_PUB;

Line 525: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation Exp_Error count='||x_msg_count);

521: ( p_count => x_msg_count
522: , p_data => x_msg_data
523: );
524:
525: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation Exp_Error count='||x_msg_count);
526:
527:
528: WHEN OTHERS THEN
529: ROLLBACK TO SAVEPOINT GMI_Update_Reservation_PUB;

Line 542: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation OTHERS count='||x_msg_count);

538: ( p_count => x_msg_count
539: , p_data => x_msg_data
540: );
541:
542: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.update_reservation OTHERS count='||x_msg_count);
543:
544:
545:
546: END Update_Reservation;

Line 664: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.delete_reservation before calling PVT');

660:
661: /* ==========================================================================
662: Call The private delete_reservation_reservation
663: ======================================================================= */
664: GMI_Reservation_Util.PrintLn('(opm_dbg) in GMI_Reservation_PUB.delete_reservation before calling PVT');
665:
666: GMI_Reservation_PVT.Delete_Reservation(
667: x_return_status => x_return_status
668: , x_msg_count => x_msg_count

Line 689: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation NO Error');

685:
686: /* ===========================================================================
687: Set the return values
688: =========================================================================== */
689: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation NO Error');
690:
691:
692:
693: EXCEPTION

Line 703: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation Exp_Error count='||x_msg_count);

699: ( p_count => x_msg_count
700: , p_data => x_msg_data
701: );
702:
703: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation Exp_Error count='||x_msg_count);
704:
705: WHEN OTHERS THEN
706: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
707:

Line 718: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation OTHERS count='||x_msg_count);

714: ( p_count => x_msg_count
715: , p_data => x_msg_data
716: );
717:
718: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.delete_reservation OTHERS count='||x_msg_count);
719:
720:
721: END Delete_Reservation;
722:

Line 794: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.transfer_reservation Exp_Error count='||x_msg_count);

790: ( p_count => x_msg_count
791: , p_data => x_msg_data
792: );
793:
794: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.transfer_reservation Exp_Error count='||x_msg_count);
795:
796: WHEN OTHERS THEN
797: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
798:

Line 809: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.transfer_reservation OTHERS count='||x_msg_count);

805: ( p_count => x_msg_count
806: , p_data => x_msg_data
807: );
808:
809: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.transfer_reservation OTHERS count='||x_msg_count);
810:
811: END Transfer_Reservation;
812:
813: END GMI_Reservation_PUB;

Line 813: END GMI_Reservation_PUB;

809: GMI_Reservation_Util.PrintLn('(opm_dbg) in end of GMI_Reservation_PUB.transfer_reservation OTHERS count='||x_msg_count);
810:
811: END Transfer_Reservation;
812:
813: END GMI_Reservation_PUB;