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.GMPRELAP dependencies on GME_BATCH_HEADER

Line 325: UPDATE GME_BATCH_HEADER

321: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Batch Id - '|| get_data_rec.batch_id);
322:
323: /* B5897392 Rajesh Patangya firm Flag */
324: IF get_data_rec.firmed_ind = 1 THEN
325: UPDATE GME_BATCH_HEADER
326: SET firmed_ind = get_data_rec.firmed_ind
327: WHERE batch_id = get_data_rec.batch_id ;
328: --batch id value passed directly
329: END IF;

Line 447: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

443: Cursor calendar_associated(l_organization_id NUMBER) IS
444: SELECT calendar_code,organization_code FROM mtl_parameters
445: WHERE organization_id = l_organization_id ;
446:
447: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
448: x_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
449: x_message_count NUMBER;
450: x_message_list VARCHAR2(2000);
451: x_return_status VARCHAR2(1);

Line 448: x_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;

444: SELECT calendar_code,organization_code FROM mtl_parameters
445: WHERE organization_id = l_organization_id ;
446:
447: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
448: x_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
449: x_message_count NUMBER;
450: x_message_list VARCHAR2(2000);
451: x_return_status VARCHAR2(1);
452: CREATE_BATCH_FAILED EXCEPTION;

Line 517: l_gme_batch_header.due_date := p_required_completion;

513: END IF;
514:
515: -- For R12.0
516: IF p_required_completion IS NOT NULL THEN
517: l_gme_batch_header.due_date := p_required_completion;
518: ELSE
519: l_gme_batch_header.due_date := p_end_date;
520: END IF;
521:

Line 519: l_gme_batch_header.due_date := p_end_date;

515: -- For R12.0
516: IF p_required_completion IS NOT NULL THEN
517: l_gme_batch_header.due_date := p_required_completion;
518: ELSE
519: l_gme_batch_header.due_date := p_end_date;
520: END IF;
521:
522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;

Line 522: l_gme_batch_header.organization_id := p_organization_id ;

518: ELSE
519: l_gme_batch_header.due_date := p_end_date;
520: END IF;
521:
522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;

Line 523: l_gme_batch_header.plan_cmplt_date := p_end_date;

519: l_gme_batch_header.due_date := p_end_date;
520: END IF;
521:
522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;

Line 524: l_gme_batch_header.batch_type := p_batch_type;

520: END IF;
521:
522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';

Line 525: l_gme_batch_header.laboratory_ind := 0 ;

521:
522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;

Line 526: l_gme_batch_header.update_inventory_ind := 0 ;

522: l_gme_batch_header.organization_id := p_organization_id ;
523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;
530: l_gme_batch_header.order_priority := p_order_priority ;

Line 527: l_gme_batch_header.gl_posted_ind := 0;

523: l_gme_batch_header.plan_cmplt_date := p_end_date;
524: l_gme_batch_header.batch_type := p_batch_type;
525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;
530: l_gme_batch_header.order_priority := p_order_priority ;
531: v_orig_plan_cmplt_date := p_end_date ;

Line 529: l_gme_batch_header.text_code := NULL;

525: l_gme_batch_header.laboratory_ind := 0 ;
526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;
530: l_gme_batch_header.order_priority := p_order_priority ;
531: v_orig_plan_cmplt_date := p_end_date ;
532: l_gme_batch_header.firmed_ind := p_firmed_ind ;
533:

Line 530: l_gme_batch_header.order_priority := p_order_priority ;

526: l_gme_batch_header.update_inventory_ind := 0 ;
527: l_gme_batch_header.gl_posted_ind := 0;
528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;
530: l_gme_batch_header.order_priority := p_order_priority ;
531: v_orig_plan_cmplt_date := p_end_date ;
532: l_gme_batch_header.firmed_ind := p_firmed_ind ;
533:
534: /* Assuming the fmeff_id is coming from APS Engine */

Line 532: l_gme_batch_header.firmed_ind := p_firmed_ind ;

528: l_action_code := 'PRODUCT';
529: l_gme_batch_header.text_code := NULL;
530: l_gme_batch_header.order_priority := p_order_priority ;
531: v_orig_plan_cmplt_date := p_end_date ;
532: l_gme_batch_header.firmed_ind := p_firmed_ind ;
533:
534: /* Assuming the fmeff_id is coming from APS Engine */
535: l_recipe_id := 0 ;
536: l_return := -1;

Line 546: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := p_effectivity_id;

542: p_start_date,p_end_date,
543: l_recipe_id,l_return
544: );
545: IF l_return <> 0 THEN
546: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := p_effectivity_id;
547: ELSE
548: RAISE GMP_CHECK_EFFECTIVITY;
549: END IF;
550:

Line 611: l_gme_batch_header.plan_cmplt_date := l_end_date;

607: x_return_status
608: ) ;
609:
610: IF x_return_status = 'S' THEN
611: l_gme_batch_header.plan_cmplt_date := l_end_date;
612: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
613: ELSE
614: RAISE GMP_SHOP_NON_WKG_END ;
615: END IF;

Line 637: ,p_batch_header_rec => l_gme_batch_header

633: ,x_message_count => x_message_count
634: ,x_message_list => x_message_list
635: ,x_return_status => x_return_status
636: ,p_org_code => l_org_code
637: ,p_batch_header_rec => l_gme_batch_header
638: ,x_batch_header_rec => x_gme_batch_header2
639: ,p_batch_size => p_plan_quantity -- Product Quantity
640: ,p_batch_size_uom => p_primary_uom_code -- 3 character UOM_code
641: ,p_creation_mode => l_action_code

Line 638: ,x_batch_header_rec => x_gme_batch_header2

634: ,x_message_list => x_message_list
635: ,x_return_status => x_return_status
636: ,p_org_code => l_org_code
637: ,p_batch_header_rec => l_gme_batch_header
638: ,x_batch_header_rec => x_gme_batch_header2
639: ,p_batch_size => p_plan_quantity -- Product Quantity
640: ,p_batch_size_uom => p_primary_uom_code -- 3 character UOM_code
641: ,p_creation_mode => l_action_code
642: ,p_ignore_qty_below_cap => 'T'

Line 666: ,p_batch_header_rec => l_gme_batch_header

662: ,x_message_count => x_message_count
663: ,x_message_list => x_message_list
664: ,x_return_status => x_return_status
665: ,p_org_code => l_org_code
666: ,p_batch_header_rec => l_gme_batch_header
667: ,x_batch_header_rec => x_gme_batch_header2
668: ,p_batch_size => p_plan_quantity -- Product Qty
669: ,p_batch_size_uom => p_primary_uom_code -- 3 char UOM
670: ,p_creation_mode => l_action_code

Line 667: ,x_batch_header_rec => x_gme_batch_header2

663: ,x_message_list => x_message_list
664: ,x_return_status => x_return_status
665: ,p_org_code => l_org_code
666: ,p_batch_header_rec => l_gme_batch_header
667: ,x_batch_header_rec => x_gme_batch_header2
668: ,p_batch_size => p_plan_quantity -- Product Qty
669: ,p_batch_size_uom => p_primary_uom_code -- 3 char UOM
670: ,p_creation_mode => l_action_code
671: ,p_ignore_qty_below_cap => 'T'

Line 683: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);

679: IF (x_return_Status NOT IN ('E','U')) THEN
680:
681: IF p_batch_type = 10 THEN
682: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');
683: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);
684: ELSE
685: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
687: END IF;

Line 686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);

682: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');
683: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);
684: ELSE
685: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
687: END IF;
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;

Line 689: v_batch_no := x_gme_batch_header2.batch_no;

685: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
687: END IF;
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;
693: v_batch_id := x_gme_batch_header2.batch_id;

Line 690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;

686: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
687: END IF;
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;
693: v_batch_id := x_gme_batch_header2.batch_id;
694: END IF;

Line 691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;

687: END IF;
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;
693: v_batch_id := x_gme_batch_header2.batch_id;
694: END IF;
695: IF (x_return_status in ('E','U')) THEN

Line 692: v_due_date := x_GME_BATCH_HEADER2.due_date;

688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Item Number '||l_item_no||' - '||FND_MESSAGE.GET);
689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;
693: v_batch_id := x_gme_batch_header2.batch_id;
694: END IF;
695: IF (x_return_status in ('E','U')) THEN
696: -- Errors

Line 693: v_batch_id := x_gme_batch_header2.batch_id;

689: v_batch_no := x_gme_batch_header2.batch_no;
690: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
691: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
692: v_due_date := x_GME_BATCH_HEADER2.due_date;
693: v_batch_id := x_gme_batch_header2.batch_id;
694: END IF;
695: IF (x_return_status in ('E','U')) THEN
696: -- Errors
697: RAISE ERROR_MESSAGE;

Line 700: v_batch_no := x_gme_batch_header2.batch_no;

696: -- Errors
697: RAISE ERROR_MESSAGE;
698: ELSIF (x_return_status = 'S') THEN
699: -- Production Batch was sucessfully inserted.
700: v_batch_no := x_gme_batch_header2.batch_no;
701: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
702: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
703: v_due_date := x_GME_BATCH_HEADER2.due_date;
704: IF p_batch_type = 10 THEN

Line 701: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;

697: RAISE ERROR_MESSAGE;
698: ELSIF (x_return_status = 'S') THEN
699: -- Production Batch was sucessfully inserted.
700: v_batch_no := x_gme_batch_header2.batch_no;
701: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
702: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
703: v_due_date := x_GME_BATCH_HEADER2.due_date;
704: IF p_batch_type = 10 THEN
705: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');

Line 702: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;

698: ELSIF (x_return_status = 'S') THEN
699: -- Production Batch was sucessfully inserted.
700: v_batch_no := x_gme_batch_header2.batch_no;
701: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
702: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
703: v_due_date := x_GME_BATCH_HEADER2.due_date;
704: IF p_batch_type = 10 THEN
705: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');
706:

Line 703: v_due_date := x_GME_BATCH_HEADER2.due_date;

699: -- Production Batch was sucessfully inserted.
700: v_batch_no := x_gme_batch_header2.batch_no;
701: v_start_date := x_GME_BATCH_HEADER2.plan_start_date;
702: v_end_date := x_GME_BATCH_HEADER2.PLAN_CMPLT_DATE;
703: v_due_date := x_GME_BATCH_HEADER2.due_date;
704: IF p_batch_type = 10 THEN
705: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');
706:
707: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);

Line 707: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);

703: v_due_date := x_GME_BATCH_HEADER2.due_date;
704: IF p_batch_type = 10 THEN
705: FND_MESSAGE.SET_NAME('GME','GME_FPO_CREATED');
706:
707: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);
708: ELSE
709:
710: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
711: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);

Line 711: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);

707: FND_MESSAGE.SET_TOKEN('FPO_NO',x_gme_batch_header2.batch_no);
708: ELSE
709:
710: FND_MESSAGE.SET_NAME('GME','GME_BATCH_CREATED');
711: FND_MESSAGE.SET_TOKEN('BATCH_NO',x_gme_batch_header2.batch_no);
712: END IF;
713: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
714:
715: ELSIF (x_return_status = 'V') THEN

Line 718: v_batch_no := x_gme_batch_header2.batch_no;

714:
715: ELSIF (x_return_status = 'V') THEN
716: -- Inventory shortage, Production Batch was sucessfully inserte.
717:
718: v_batch_no := x_gme_batch_header2.batch_no;
719: FND_MESSAGE.SET_NAME('GME','GME_INV_SHORTAGES');
720: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET||'-'||v_batch_no);
721: END IF;
722:

Line 965: FROM gme_batch_header a,

961: CURSOR Cur_get_batch_data IS
962: SELECT a.batch_no, a.batch_type, a.batch_status,
963: a.plan_start_date, a.plan_cmplt_date,
964: a.recipe_validity_rule_id, b.recipe_id
965: FROM gme_batch_header a,
966: gmd_recipe_validity_rules b
967: WHERE a.batch_id = p_batch_id
968: AND a.organization_id = p_organization_id
969: AND a.recipe_validity_rule_id = b.recipe_validity_rule_id

Line 981: x_batch_header gme_batch_header%ROWTYPE;

977:
978: x_message_count NUMBER;
979: x_message_list VARCHAR2(2000);
980: x_return_status VARCHAR2(2000);
981: x_batch_header gme_batch_header%ROWTYPE;
982: x_use_workday_cal VARCHAR2(1) ;
983: l_contiguity_override NUMBER ;
984: x_contiguity_override VARCHAR2(1) ;
985: l_return_status VARCHAR2(2000);

Line 986: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

982: x_use_workday_cal VARCHAR2(1) ;
983: l_contiguity_override NUMBER ;
984: x_contiguity_override VARCHAR2(1) ;
985: l_return_status VARCHAR2(2000);
986: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
987: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
988: t_ret_code NUMBER ;
989: x_decision NUMBER ;
990: c_batch_id NUMBER(10);

Line 987: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;

983: l_contiguity_override NUMBER ;
984: x_contiguity_override VARCHAR2(1) ;
985: l_return_status VARCHAR2(2000);
986: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
987: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
988: t_ret_code NUMBER ;
989: x_decision NUMBER ;
990: c_batch_id NUMBER(10);
991: l_cal_code VARCHAR2(10);

Line 1150: l_gme_batch_header.plan_cmplt_date := l_end_date;

1146: FND_MESSAGE.SET_TOKEN('PDATE',to_char(p_end_date,'MM/DD/YYYY HH24:MI:SS'));
1147: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1148:
1149: IF x_return_status = 'S' THEN
1150: l_gme_batch_header.plan_cmplt_date := l_end_date;
1151: FND_FILE.PUT_LINE ( FND_FILE.LOG,'Nearest End Date = '||to_char(l_end_date,'MM/DD/YYYY HH24:MI:SS'));
1152: ELSE
1153: RAISE GMP_SHOP_NON_WKG_END ;
1154: END IF;

Line 1168: l_gme_batch_header.batch_id := p_batch_id ;

1164: SELECT DECODE(l_profile,'N','F','Y','T') INTO x_use_workday_cal FROM dual;
1165: -- End of Contiguity Override changes
1166:
1167: -- Batch will be rescheduled via GME mechanism
1168: l_gme_batch_header.batch_id := p_batch_id ;
1169: l_gme_batch_header.organization_id := p_organization_id ;
1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1171: l_gme_batch_header.plan_start_date := p_start_date;
1172: l_gme_batch_header.plan_cmplt_date := p_end_date;

Line 1169: l_gme_batch_header.organization_id := p_organization_id ;

1165: -- End of Contiguity Override changes
1166:
1167: -- Batch will be rescheduled via GME mechanism
1168: l_gme_batch_header.batch_id := p_batch_id ;
1169: l_gme_batch_header.organization_id := p_organization_id ;
1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1171: l_gme_batch_header.plan_start_date := p_start_date;
1172: l_gme_batch_header.plan_cmplt_date := p_end_date;
1173:

Line 1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;

1166:
1167: -- Batch will be rescheduled via GME mechanism
1168: l_gme_batch_header.batch_id := p_batch_id ;
1169: l_gme_batch_header.organization_id := p_organization_id ;
1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1171: l_gme_batch_header.plan_start_date := p_start_date;
1172: l_gme_batch_header.plan_cmplt_date := p_end_date;
1173:
1174: gme_api_pub.reschedule_batch(

Line 1171: l_gme_batch_header.plan_start_date := p_start_date;

1167: -- Batch will be rescheduled via GME mechanism
1168: l_gme_batch_header.batch_id := p_batch_id ;
1169: l_gme_batch_header.organization_id := p_organization_id ;
1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1171: l_gme_batch_header.plan_start_date := p_start_date;
1172: l_gme_batch_header.plan_cmplt_date := p_end_date;
1173:
1174: gme_api_pub.reschedule_batch(
1175: p_api_version => 2

Line 1172: l_gme_batch_header.plan_cmplt_date := p_end_date;

1168: l_gme_batch_header.batch_id := p_batch_id ;
1169: l_gme_batch_header.organization_id := p_organization_id ;
1170: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_recipe_validity_rule_id;
1171: l_gme_batch_header.plan_start_date := p_start_date;
1172: l_gme_batch_header.plan_cmplt_date := p_end_date;
1173:
1174: gme_api_pub.reschedule_batch(
1175: p_api_version => 2
1176: ,p_validation_level => 100

Line 1185: ,p_batch_header_rec => l_gme_batch_header

1181: ,p_contiguity_override => x_contiguity_override
1182: ,x_message_count => x_message_count
1183: ,x_message_list => x_message_list
1184: ,x_return_status => x_return_status
1185: ,p_batch_header_rec => l_gme_batch_header
1186: ,x_batch_header_rec => l_gme_batch_header2 );
1187:
1188: IF x_return_status = 'C' THEN
1189:

Line 1186: ,x_batch_header_rec => l_gme_batch_header2 );

1182: ,x_message_count => x_message_count
1183: ,x_message_list => x_message_list
1184: ,x_return_status => x_return_status
1185: ,p_batch_header_rec => l_gme_batch_header
1186: ,x_batch_header_rec => l_gme_batch_header2 );
1187:
1188: IF x_return_status = 'C' THEN
1189:
1190: FND_MESSAGE.SET_NAME('GME','GME_SHOP_NOT_ONE_CONT');

Line 1204: ,p_batch_header_rec => l_gme_batch_header

1200: ,p_contiguity_override => 'T'
1201: ,x_message_count => x_message_count
1202: ,x_message_list => x_message_list
1203: ,x_return_status => x_return_status
1204: ,p_batch_header_rec => l_gme_batch_header
1205: ,x_batch_header_rec => x_batch_header );
1206:
1207: END IF; /* for return status C */
1208:

Line 1344: FROM gme_batch_header gbh, mtl_parameters mp

1340: CURSOR get_batch_status IS
1341: SELECT gbh.batch_no, gbh.batch_status,
1342: gbh.recipe_validity_rule_id,
1343: mp.organization_code
1344: FROM gme_batch_header gbh, mtl_parameters mp
1345: WHERE gbh.batch_id = p_batch_id
1346: AND gbh.organization_id = mp.organization_id
1347: AND mp.organization_id = p_organization_id;
1348:

Line 1353: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;

1349: x_message_count NUMBER;
1350: x_message_list VARCHAR2(2000);
1351: x_return_status VARCHAR2(2000);
1352: X_msg_count NUMBER;
1353: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
1354: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
1355: l_batch_status NUMBER(5);
1356: l_batch_no VARCHAR2(32);
1357: l_effectivity_id NUMBER(10) ;

Line 1354: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;

1350: x_message_list VARCHAR2(2000);
1351: x_return_status VARCHAR2(2000);
1352: X_msg_count NUMBER;
1353: l_gme_batch_header GME_BATCH_HEADER%ROWTYPE;
1354: l_gme_batch_header2 GME_BATCH_HEADER%ROWTYPE;
1355: l_batch_status NUMBER(5);
1356: l_batch_no VARCHAR2(32);
1357: l_effectivity_id NUMBER(10) ;
1358: l_org_code VARCHAR2(10);

Line 1375: l_gme_batch_header.batch_id := p_batch_id ;

1371: FND_MESSAGE.SET_TOKEN('BATCH_NO',l_batch_no);
1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1373: ELSE
1374: -- Batch will be rescheduled via GME mechanism
1375: l_gme_batch_header.batch_id := p_batch_id ;
1376: l_gme_batch_header.organization_id := p_organization_id;
1377: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_effectivity_id ;
1378:
1379: GME_API_PUB.cancel_batch

Line 1376: l_gme_batch_header.organization_id := p_organization_id;

1372: FND_FILE.PUT_LINE(FND_FILE.LOG,'-'||FND_MESSAGE.GET);
1373: ELSE
1374: -- Batch will be rescheduled via GME mechanism
1375: l_gme_batch_header.batch_id := p_batch_id ;
1376: l_gme_batch_header.organization_id := p_organization_id;
1377: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_effectivity_id ;
1378:
1379: GME_API_PUB.cancel_batch
1380: ( p_api_version => 2.0,

Line 1377: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_effectivity_id ;

1373: ELSE
1374: -- Batch will be rescheduled via GME mechanism
1375: l_gme_batch_header.batch_id := p_batch_id ;
1376: l_gme_batch_header.organization_id := p_organization_id;
1377: l_gme_batch_header.RECIPE_VALIDITY_RULE_ID := l_effectivity_id ;
1378:
1379: GME_API_PUB.cancel_batch
1380: ( p_api_version => 2.0,
1381: p_validation_level => 100,

Line 1388: p_batch_header_rec => l_gme_batch_header,

1384: x_message_count => x_message_count,
1385: x_message_list => x_message_list,
1386: x_return_status => X_return_status,
1387: p_org_code => l_org_code,
1388: p_batch_header_rec => l_gme_batch_header,
1389: x_batch_header_rec => l_gme_batch_header2);
1390:
1391: IF X_return_status <> 'S' THEN
1392: RAISE ERROR_MESSAGE;

Line 1389: x_batch_header_rec => l_gme_batch_header2);

1385: x_message_list => x_message_list,
1386: x_return_status => X_return_status,
1387: p_org_code => l_org_code,
1388: p_batch_header_rec => l_gme_batch_header,
1389: x_batch_header_rec => l_gme_batch_header2);
1390:
1391: IF X_return_status <> 'S' THEN
1392: RAISE ERROR_MESSAGE;
1393: ELSE