DBA Data[Home] [Help]

APPS.GMI_ALLOCATION_RULES_PVT dependencies on GMI_RESERVATION_UTIL

Line 107: GMI_reservation_Util.PrintLn('p_org_id '||p_org_id);

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;

Line 108: GMI_reservation_Util.PrintLn('p_of_cust_id '||p_of_cust_id);

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;

Line 109: GMI_reservation_Util.PrintLn('p_ship_to_org_id '||p_ship_to_org_id);

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:

Line 110: GMI_reservation_Util.PrintLn('p_alloc_class '||p_alloc_class);

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

Line 130: GMI_reservation_Util.PrintLn('no rules in op_alot_prm, use default ');

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;

Line 132: GMI_reservation_Util.PrintLn('op_alot_prm is found for all cust ');

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);

Line 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