103: END IF;
104: */
105: /*Attempt to locate allocation parms specific to this customer
106: =============================================================*/
107: GMI_reservation_Util.PrintLn('p_org_id '||p_org_id);
108: GMI_reservation_Util.PrintLn('p_of_cust_id '||p_of_cust_id);
109: GMI_reservation_Util.PrintLn('p_ship_to_org_id '||p_ship_to_org_id);
110: GMI_reservation_Util.PrintLn('p_alloc_class '||p_alloc_class);
111: OPEN op_alot_prm_c1;
104: */
105: /*Attempt to locate allocation parms specific to this customer
106: =============================================================*/
107: GMI_reservation_Util.PrintLn('p_org_id '||p_org_id);
108: GMI_reservation_Util.PrintLn('p_of_cust_id '||p_of_cust_id);
109: GMI_reservation_Util.PrintLn('p_ship_to_org_id '||p_ship_to_org_id);
110: GMI_reservation_Util.PrintLn('p_alloc_class '||p_alloc_class);
111: OPEN op_alot_prm_c1;
112: FETCH op_alot_prm_c1 INTO x_op_alot_prm;
105: /*Attempt to locate allocation parms specific to this customer
106: =============================================================*/
107: GMI_reservation_Util.PrintLn('p_org_id '||p_org_id);
108: GMI_reservation_Util.PrintLn('p_of_cust_id '||p_of_cust_id);
109: GMI_reservation_Util.PrintLn('p_ship_to_org_id '||p_ship_to_org_id);
110: GMI_reservation_Util.PrintLn('p_alloc_class '||p_alloc_class);
111: OPEN op_alot_prm_c1;
112: FETCH op_alot_prm_c1 INTO x_op_alot_prm;
113:
106: =============================================================*/
107: GMI_reservation_Util.PrintLn('p_org_id '||p_org_id);
108: GMI_reservation_Util.PrintLn('p_of_cust_id '||p_of_cust_id);
109: GMI_reservation_Util.PrintLn('p_ship_to_org_id '||p_ship_to_org_id);
110: GMI_reservation_Util.PrintLn('p_alloc_class '||p_alloc_class);
111: OPEN op_alot_prm_c1;
112: FETCH op_alot_prm_c1 INTO x_op_alot_prm;
113:
114: /* No allocation rule located specific to our customer so look for a
126: /* =================================================================*/
127: GMI_ALLOCATION_RULES_PVT.GET_DEFAULT_PARMS
128: (x_op_alot_prm => l_op_alot_prm);
129: x_op_alot_prm := l_op_alot_prm;
130: GMI_reservation_Util.PrintLn('no rules in op_alot_prm, use default ');
131: ELSE
132: GMI_reservation_Util.PrintLn('op_alot_prm is found for all cust ');
133: END IF;
134: CLOSE op_alot_prm_c2;
128: (x_op_alot_prm => l_op_alot_prm);
129: x_op_alot_prm := l_op_alot_prm;
130: GMI_reservation_Util.PrintLn('no rules in op_alot_prm, use default ');
131: ELSE
132: GMI_reservation_Util.PrintLn('op_alot_prm is found for all cust ');
133: END IF;
134: CLOSE op_alot_prm_c2;
135: ELSE
136: GMI_reservation_Util.PrintLn('op_alot_prm is found for cust '||p_of_cust_id);
132: GMI_reservation_Util.PrintLn('op_alot_prm is found for all cust ');
133: END IF;
134: CLOSE op_alot_prm_c2;
135: ELSE
136: GMI_reservation_Util.PrintLn('op_alot_prm is found for cust '||p_of_cust_id);
137: CLOSE op_alot_prm_c1;
138: END IF;
139:
140: /* EXCEPTION HANDLING