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.GML_BATCH_OM_UTIL dependencies on GMI_RESERVATION_UTIL

Line 43: GMI_RESERVATION_UTIL.Println(' In query reservation');

39: ) IS
40: l_res_rec gml_batch_so_reservations%rowtype;
41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);
45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);
46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);
47: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is not null THEN

Line 44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);

40: l_res_rec gml_batch_so_reservations%rowtype;
41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);
45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);
46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);
47: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is not null THEN
48: Select *

Line 45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);

41: BEGIN
42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);
45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);
46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);
47: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is not null THEN
48: Select *
49: Into l_res_rec

Line 46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);

42: x_return_status := FND_API.G_RET_STS_SUCCESS;
43: GMI_RESERVATION_UTIL.Println(' In query reservation');
44: GMI_RESERVATION_UTIL.Println(' In query reservation, so_line_id '|| p_so_line_rec.so_line_id);
45: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_line_id '|| p_batch_line_rec.batch_line_id);
46: GMI_RESERVATION_UTIL.Println(' In query reservation, batch_res '|| p_gme_om_reservation_rec.batch_res_id);
47: IF p_so_line_rec.so_line_id is not null AND p_batch_line_rec.batch_line_id is not null THEN
48: Select *
49: Into l_res_rec
50: From gml_batch_so_reservations

Line 98: GMI_RESERVATION_UTIL.Println(' In insert reservations');

94: ) IS
95: l_batch_res_id NUMBER;
96: BEGIN
97: x_return_status := FND_API.G_RET_STS_SUCCESS;
98: GMI_RESERVATION_UTIL.Println(' In insert reservations');
99: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
100: select gml_so_reservation_s.nextval
101: into l_batch_res_id
102: from dual;

Line 153: GMI_RESERVATION_UTIL.Println(' In insert reservations, new batch_res_id '||l_batch_res_id);

149: , sysdate
150: , fnd_global.user_id
151: , sysdate
152: );
153: GMI_RESERVATION_UTIL.Println(' In insert reservations, new batch_res_id '||l_batch_res_id);
154: EXCEPTION
155: WHEN FND_API.G_EXC_ERROR THEN
156: /* Get message count and data*/
157: FND_MSG_PUB.count_and_get

Line 161: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

157: FND_MSG_PUB.count_and_get
158: ( p_count => x_msg_cont
159: , p_data => x_msg_data
160: );
161: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
162: WHEN OTHERS THEN
163: --FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
164: -- , 'check_reservations'
165: -- );

Line 171: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

167: --FND_MSG_PUB.count_and_get
168: -- ( p_count => x_msg_cont
169: -- , p_data => x_msg_data
170: -- );
171: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
172:
173: END insert_reservation;
174:
175: PROCEDURE update_reservation

Line 282: GMI_RESERVATION_UTIL.println('inserting alloc history');

278: l_alloc_rec_id NUMBER;
279: BEGIN
280: x_return_status := FND_API.G_RET_STS_SUCCESS;
281: /* insert gme_om_reservation_rec into gml_batch_so_reservations table */
282: GMI_RESERVATION_UTIL.println('inserting alloc history');
283: select gml_so_alloc_history_s.nextval
284: into l_alloc_rec_id
285: from dual;
286: Insert Into gml_batch_so_alloc_history

Line 325: GMI_RESERVATION_UTIL.println(' alloc_rec_id '|| l_alloc_rec_id);

321: , fnd_global.user_id
322: , sysdate
323: , fnd_global.user_id
324: );
325: GMI_RESERVATION_UTIL.println(' alloc_rec_id '|| l_alloc_rec_id);
326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

Line 329: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

325: GMI_RESERVATION_UTIL.println(' alloc_rec_id '|| l_alloc_rec_id);
326:
327: EXCEPTION
328: WHEN OTHERS THEN
329: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
330:
331: END insert_alloc_history;
332:
333: FUNCTION check_reservation

Line 349: GMI_reservation_Util.PrintLn('Check reservation ');

345: l_exist Number; -- default := 0;
346:
347: BEGIN
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);
353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);

Line 350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);

346:
347: BEGIN
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);
353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);
354:

Line 351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);

347: BEGIN
348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);
353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);
354:
355: l_exist := 0;

Line 352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);

348: x_return_status := FND_API.G_RET_STS_SUCCESS;
349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);
353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);
354:
355: l_exist := 0;
356: IF p_batch_id is not null then

Line 353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);

349: GMI_reservation_Util.PrintLn('Check reservation ');
350: GMI_reservation_Util.PrintLn(' p_batch_res_id '||p_batch_res_id);
351: GMI_reservation_Util.PrintLn(' p_batch_line_id '||p_batch_line_id);
352: GMI_reservation_Util.PrintLn(' p_batch_id '||p_batch_id);
353: GMI_reservation_Util.PrintLn(' p_so_line_id '||p_so_line_id);
354:
355: l_exist := 0;
356: IF p_batch_id is not null then
357: Select count(*)

Line 365: --GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

361: and delete_mark = 0
362: and (reserved_qty > 0 or allocated_ind = 1)
363: ;
364: IF SQL%NOTFOUND or (sqlcode=1403) or l_exist = 0 THEN
365: --GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
366: return false;
367: END IF;
368: End if;
369: IF p_batch_line_id is not null then

Line 377: GMI_reservation_Util.PrintLn(' exist ? '||l_exist);

373: Where batch_line_id = p_batch_line_id
374: and delete_mark = 0
375: and (reserved_qty > 0 or allocated_ind = 1)
376: ;
377: GMI_reservation_Util.PrintLn(' exist ? '||l_exist);
378: IF SQL%NOTFOUND or (sqlcode=1403) or l_exist = 0 THEN
379: return false;
380: END IF;
381: End if;

Line 416: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

412: FND_MSG_PUB.count_and_get
413: ( p_count => x_msg_cont
414: , p_data => x_msg_data
415: );
416: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
417: WHEN OTHERS THEN
418: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
419: , 'check_reservations'
420: );

Line 426: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

422: --FND_MSG_PUB.count_and_get
423: -- ( p_count => x_msg_cont
424: -- , p_data => x_msg_data
425: -- );
426: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
427: return false;
428: END check_reservation;
429:
430: PROCEDURE check_rules

Line 478: GMI_reservation_Util.PrintLn('IN check Rule');

474:
475: BEGIN
476: x_return_status := FND_API.G_RET_STS_SUCCESS;
477: /* get the most suitable rule first */
478: GMI_reservation_Util.PrintLn('IN check Rule');
479: Open get_the_rule;
480: Fetch get_the_rule
481: Into l_rule_assign_rec.site_use_id
482: , l_rule_assign_rec.customer_id

Line 516: GMI_reservation_Util.PrintLn('check Rule, rule_id '||l_rule_id);

512: , item_id desc
513: , allocation_class desc
514: ;*/
515:
516: GMI_reservation_Util.PrintLn('check Rule, rule_id '||l_rule_id);
517: /*IF get_the_rule%Notfound Then
518: GMI_reservation_Util.PrintLn('Rule is not found');
519: x_count := 0;
520: x_rule_id := null;

Line 518: GMI_reservation_Util.PrintLn('Rule is not found');

514: ;*/
515:
516: GMI_reservation_Util.PrintLn('check Rule, rule_id '||l_rule_id);
517: /*IF get_the_rule%Notfound Then
518: GMI_reservation_Util.PrintLn('Rule is not found');
519: x_count := 0;
520: x_rule_id := null;
521: return;
522: END IF;*/

Line 569: GMI_reservation_Util.PrintLn('check Rule, to check_rule_assign');

565: else
566: l_where_clause := l_where_clause || ' And site_use_id is null ';
567: End If;
568:
569: GMI_reservation_Util.PrintLn('check Rule, to check_rule_assign');
570: GMI_reservation_Util.PrintLn('check Rule,where clause '||l_where_clause);
571: OPEN check_rule_assign for
572: 'SELECT count(*) FROM gml_batch_so_rule_assignments WHERE '
573: || l_where_clause ;

Line 570: GMI_reservation_Util.PrintLn('check Rule,where clause '||l_where_clause);

566: l_where_clause := l_where_clause || ' And site_use_id is null ';
567: End If;
568:
569: GMI_reservation_Util.PrintLn('check Rule, to check_rule_assign');
570: GMI_reservation_Util.PrintLn('check Rule,where clause '||l_where_clause);
571: OPEN check_rule_assign for
572: 'SELECT count(*) FROM gml_batch_so_rule_assignments WHERE '
573: || l_where_clause ;
574: Fetch check_rule_assign Into l_rule_count;

Line 577: GMI_reservation_Util.PrintLn('check Rule, l_rule_count '||l_rule_count);

573: || l_where_clause ;
574: Fetch check_rule_assign Into l_rule_count;
575: Close check_rule_assign;
576:
577: GMI_reservation_Util.PrintLn('check Rule, l_rule_count '||l_rule_count);
578: x_count := l_rule_count;
579: x_rule_id := l_rule_id;
580:
581: END check_rules;

Line 650: GMI_reservation_Util.PrintLn('get_rule: batch line passed');

646: */
647: l_cust_site.delete;
648: IF p_batch_line_rec.batch_line_id is not null THEN -- batch line is passed
649: /* get all the so_line_id from batch reservation record */
650: GMI_reservation_Util.PrintLn('get_rule: batch line passed');
651: i:= 1;
652: for so_line_ids in get_so_line_ids (p_batch_line_rec.batch_line_id ) loop
653: l_so_line_id := so_line_ids.so_line_id;
654: GMI_reservation_Util.PrintLn('get_rule: so_line_id '||l_so_line_id);

Line 654: GMI_reservation_Util.PrintLn('get_rule: so_line_id '||l_so_line_id);

650: GMI_reservation_Util.PrintLn('get_rule: batch line passed');
651: i:= 1;
652: for so_line_ids in get_so_line_ids (p_batch_line_rec.batch_line_id ) loop
653: l_so_line_id := so_line_ids.so_line_id;
654: GMI_reservation_Util.PrintLn('get_rule: so_line_id '||l_so_line_id);
655: Open get_line_info(l_so_line_id) ;
656: Fetch get_line_info
657: Into
658: l_cust_site(i).customer_id

Line 664: GMI_reservation_Util.PrintLn('get_rule: batch line customer_id '||l_cust_site(i).customer_id);

660: , l_inventory_item_id
661: , l_cust_site(i).organization_id
662: ;
663: Close get_line_info;
664: GMI_reservation_Util.PrintLn('get_rule: batch line customer_id '||l_cust_site(i).customer_id);
665: i := i+1;
666: end loop;
667: i :=1;
668: j := 1;

Line 672: GMI_reservation_Util.PrintLn('get_rule: cust_site count '|| l_cust_site.count);

668: j := 1;
669: l_cust_diff := 0;
670: l_site_diff := 0;
671: l_org_diff := 0;
672: GMI_reservation_Util.PrintLn('get_rule: cust_site count '|| l_cust_site.count);
673: for i in 1..l_cust_site.count Loop
674: for j in (i+1)..l_cust_site.count Loop
675: GMI_reservation_Util.PrintLn('get_rule: j '|| j);
676: if nvl(l_cust_site(i).customer_id,0) <> nvl(l_cust_site(j).customer_id,0) Then

Line 675: GMI_reservation_Util.PrintLn('get_rule: j '|| j);

671: l_org_diff := 0;
672: GMI_reservation_Util.PrintLn('get_rule: cust_site count '|| l_cust_site.count);
673: for i in 1..l_cust_site.count Loop
674: for j in (i+1)..l_cust_site.count Loop
675: GMI_reservation_Util.PrintLn('get_rule: j '|| j);
676: if nvl(l_cust_site(i).customer_id,0) <> nvl(l_cust_site(j).customer_id,0) Then
677: l_cust_diff := 1;
678: END IF;
679: if l_cust_site(i).site_use_id <> l_cust_site(j).site_use_id Then

Line 695: /* GMI_reservation_Util.PrintLn('org is different ');

691: l_gme_om_config_assign.customer_id := null;
692: END IF;
693: IF l_org_diff = 1 THEN
694: null;
695: /* GMI_reservation_Util.PrintLn('org is different ');
696: */
697: END IF;
698: l_gme_om_config_assign.customer_id := l_cust_site(1).customer_id;
699: l_gme_om_config_assign.site_use_id := l_cust_site(1).site_use_id;

Line 705: GMI_reservation_Util.PrintLn('get_rule: so_line_rec so_line_id is not null '||p_so_line_rec.so_line_id);

701: END IF;
702:
703: /* if so line is passed, use this so line */
704: IF p_so_line_rec.so_line_id is not null THEN
705: GMI_reservation_Util.PrintLn('get_rule: so_line_rec so_line_id is not null '||p_so_line_rec.so_line_id);
706: l_so_line_id := p_so_line_rec.so_line_id;
707: Open get_line_info(l_so_line_id);
708: Fetch get_line_info
709: Into l_gme_om_config_assign.customer_id

Line 728: GMI_reservation_Util.PrintLn('get_rule: customer_id '||l_gme_om_config_assign.customer_id);

724: IF l_so_line_rec.inventory_item_id is not null THEN
725: l_inventory_item_id := l_so_line_rec.inventory_item_id;
726: END IF;
727:
728: GMI_reservation_Util.PrintLn('get_rule: customer_id '||l_gme_om_config_assign.customer_id);
729: GMI_reservation_Util.PrintLn('get_rule: site_use_id '||l_gme_om_config_assign.site_use_id);
730: GMI_reservation_Util.PrintLn('get_rule: l_organization_id '||l_organization_id);
731: GMI_reservation_Util.PrintLn('get_rule: l_inventory_item_id '||l_inventory_item_id);
732:

Line 729: GMI_reservation_Util.PrintLn('get_rule: site_use_id '||l_gme_om_config_assign.site_use_id);

725: l_inventory_item_id := l_so_line_rec.inventory_item_id;
726: END IF;
727:
728: GMI_reservation_Util.PrintLn('get_rule: customer_id '||l_gme_om_config_assign.customer_id);
729: GMI_reservation_Util.PrintLn('get_rule: site_use_id '||l_gme_om_config_assign.site_use_id);
730: GMI_reservation_Util.PrintLn('get_rule: l_organization_id '||l_organization_id);
731: GMI_reservation_Util.PrintLn('get_rule: l_inventory_item_id '||l_inventory_item_id);
732:
733: Open get_alloc_class(l_inventory_item_id

Line 730: GMI_reservation_Util.PrintLn('get_rule: l_organization_id '||l_organization_id);

726: END IF;
727:
728: GMI_reservation_Util.PrintLn('get_rule: customer_id '||l_gme_om_config_assign.customer_id);
729: GMI_reservation_Util.PrintLn('get_rule: site_use_id '||l_gme_om_config_assign.site_use_id);
730: GMI_reservation_Util.PrintLn('get_rule: l_organization_id '||l_organization_id);
731: GMI_reservation_Util.PrintLn('get_rule: l_inventory_item_id '||l_inventory_item_id);
732:
733: Open get_alloc_class(l_inventory_item_id
734: , l_organization_id)

Line 731: GMI_reservation_Util.PrintLn('get_rule: l_inventory_item_id '||l_inventory_item_id);

727:
728: GMI_reservation_Util.PrintLn('get_rule: customer_id '||l_gme_om_config_assign.customer_id);
729: GMI_reservation_Util.PrintLn('get_rule: site_use_id '||l_gme_om_config_assign.site_use_id);
730: GMI_reservation_Util.PrintLn('get_rule: l_organization_id '||l_organization_id);
731: GMI_reservation_Util.PrintLn('get_rule: l_inventory_item_id '||l_inventory_item_id);
732:
733: Open get_alloc_class(l_inventory_item_id
734: , l_organization_id)
735: ;

Line 747: GMI_reservation_Util.PrintLn('get_rule: allocation_class '||l_gme_om_config_assign.allocation_class);

743: Close get_whse_code;
744: ELSE
745: l_gme_om_config_assign.whse_code := l_so_line_rec.whse_code;
746: END IF;
747: GMI_reservation_Util.PrintLn('get_rule: allocation_class '||l_gme_om_config_assign.allocation_class);
748: GMI_reservation_Util.PrintLn('get_rule: item_id '||l_gme_om_config_assign.item_id);
749: GMI_reservation_Util.PrintLn('get_rule: whse_code '||l_gme_om_config_assign.whse_code);
750:
751: /* check rules first to see the uniqueness, if not, error */

Line 748: GMI_reservation_Util.PrintLn('get_rule: item_id '||l_gme_om_config_assign.item_id);

744: ELSE
745: l_gme_om_config_assign.whse_code := l_so_line_rec.whse_code;
746: END IF;
747: GMI_reservation_Util.PrintLn('get_rule: allocation_class '||l_gme_om_config_assign.allocation_class);
748: GMI_reservation_Util.PrintLn('get_rule: item_id '||l_gme_om_config_assign.item_id);
749: GMI_reservation_Util.PrintLn('get_rule: whse_code '||l_gme_om_config_assign.whse_code);
750:
751: /* check rules first to see the uniqueness, if not, error */
752: GML_BATCH_OM_UTIL.check_rules

Line 749: GMI_reservation_Util.PrintLn('get_rule: whse_code '||l_gme_om_config_assign.whse_code);

745: l_gme_om_config_assign.whse_code := l_so_line_rec.whse_code;
746: END IF;
747: GMI_reservation_Util.PrintLn('get_rule: allocation_class '||l_gme_om_config_assign.allocation_class);
748: GMI_reservation_Util.PrintLn('get_rule: item_id '||l_gme_om_config_assign.item_id);
749: GMI_reservation_Util.PrintLn('get_rule: whse_code '||l_gme_om_config_assign.whse_code);
750:
751: /* check rules first to see the uniqueness, if not, error */
752: GML_BATCH_OM_UTIL.check_rules
753: (

Line 763: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');

759: , X_msg_data => x_msg_data
760: );
761:
762: IF x_return_status <> fnd_api.g_ret_sts_success Then
763: GMI_reservation_Util.PrintLn('OM_UTIL, checking rule failure');
764: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
765: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
766: --FND_MSG_PUB.ADD;
767: RAISE FND_API.G_EXC_ERROR;

Line 770: GMI_reservation_Util.PrintLn('OM_UTIL, No rule found');

766: --FND_MSG_PUB.ADD;
767: RAISE FND_API.G_EXC_ERROR;
768: END IF;
769: IF l_rule_count = 0 Then
770: GMI_reservation_Util.PrintLn('OM_UTIL, No rule found');
771: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
772: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
773: --FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;

Line 777: GMI_reservation_Util.PrintLn('OM_UTIL, Multiple rules found');

773: --FND_MSG_PUB.ADD;
774: RAISE FND_API.G_EXC_ERROR;
775: END IF;
776: IF l_rule_count > 1 Then
777: GMI_reservation_Util.PrintLn('OM_UTIL, Multiple rules found');
778: --FND_MESSAGE.SET_NAME('GMI','GMI_QTY_RSV_NOT_FOUND');
779: --FND_MESSAGE.Set_Token('WHERE', 'Check rules');
780: --FND_MSG_PUB.ADD;
781: RAISE FND_API.G_EXC_ERROR;

Line 811: GMI_reservation_Util.PrintLn('get_rule: rule name '|| x_gme_om_rule_rec.rule_name);

807: x_gme_om_rule_rec.copy_attachments := l_rule_rec.copy_attachments;
808: x_gme_om_rule_rec.sales_order_attachment := l_rule_rec.sales_order_attachment;
809: x_gme_om_rule_rec.batch_attachment := l_rule_rec.batch_attachment;
810: x_gme_om_rule_rec.batch_creation_notification := l_rule_rec.batch_creation_notification;
811: GMI_reservation_Util.PrintLn('get_rule: rule name '|| x_gme_om_rule_rec.rule_name);
812:
813: x_return_status := FND_API.G_RET_STS_SUCCESS;
814:
815: EXCEPTION

Line 823: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');

819: FND_MSG_PUB.count_and_get
820: ( p_count => x_msg_cont
821: , p_data => x_msg_data
822: );
823: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Expected');
824: WHEN OTHERS THEN
825: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
826:
827: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 835: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');

831: FND_MSG_PUB.count_and_get
832: ( p_count => x_msg_cont
833: , p_data => x_msg_data
834: );
835: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');
836: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
837:
838: END get_Rule;
839:

Line 836: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));

832: ( p_count => x_msg_cont
833: , p_data => x_msg_data
834: );
835: GMI_reservation_Util.PrintLn('(opm_dbg) in PVT u EXCEPTION: Others');
836: GMI_RESERVATION_UTIL.println('sqlerror'|| SUBSTRB(SQLERRM, 1, 100));
837:
838: END get_Rule;
839:
840: END GML_BATCH_OM_UTIL;