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.GME_BATCH_WKFL_PKG dependencies on GME_DEBUG

Line 97: IF g_debug <= gme_debug.g_log_procedure THEN

93: From mtl_parameters
94: Where organization_id = p_organization_id;
95:
96: BEGIN
97: IF g_debug <= gme_debug.g_log_procedure THEN
98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);

Line 98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);

94: Where organization_id = p_organization_id;
95:
96: BEGIN
97: IF g_debug <= gme_debug.g_log_procedure THEN
98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);

Line 99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');

95:
96: BEGIN
97: IF g_debug <= gme_debug.g_log_procedure THEN
98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);

Line 100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);

96: BEGIN
97: IF g_debug <= gme_debug.g_log_procedure THEN
98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);

Line 101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);

97: IF g_debug <= gme_debug.g_log_procedure THEN
98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);

Line 102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);

98: gme_debug.put_line ('Entering api ' || g_pkg_name || '.' || l_api_name);
99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);

Line 103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);

99: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Input Parameters......');
100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);
107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);

Line 104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);

100: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemkey = '||p_itemkey);
101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);
107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);
108:

Line 105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);

101: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': P_itemtype = '||p_itemtype);
102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);
107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);
108:
109: END IF;

Line 106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);

102: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_so_line_id = '||p_so_line_id);
103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);
107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);
108:
109: END IF;
110: wf_log_pkg.wf_debug_flag:=TRUE;

Line 107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);

103: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_action_code = '||p_action_code);
104: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_id = ' ||p_batch_id);
105: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_batch_line_id = '|| p_batch_line_id);
106: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_organization_id = '|| p_organization_id);
107: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': p_lot_no = '|| p_lot_no);
108:
109: END IF;
110: wf_log_pkg.wf_debug_flag:=TRUE;
111:

Line 115: IF g_debug <= gme_debug.g_log_procedure THEN

111:
112: Open get_org_code(p_organization_id);
113: Fetch get_org_code Into l_organization_code;
114: Close get_org_code;
115: IF g_debug <= gme_debug.g_log_procedure THEN
116: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': l_organization_code = '|| l_organization_code);
117: END IF;
118:
119: /* Get the User Name */

Line 116: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': l_organization_code = '|| l_organization_code);

112: Open get_org_code(p_organization_id);
113: Fetch get_org_code Into l_organization_code;
114: Close get_org_code;
115: IF g_debug <= gme_debug.g_log_procedure THEN
116: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': l_organization_code = '|| l_organization_code);
117: END IF;
118:
119: /* Get the User Name */
120: OPEN Get_user_name(p_approver);

Line 123: IF g_debug <= gme_debug.g_log_procedure THEN

119: /* Get the User Name */
120: OPEN Get_user_name(p_approver);
121: FETCH Get_user_name INTO l_approver_name;
122: IF(Get_user_name%NOTFOUND) THEN
123: IF g_debug <= gme_debug.g_log_procedure THEN
124: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Get_user_name%NOTFOUND');
125: END IF;
126: CLOSE Get_user_name;
127: RETURN;

Line 124: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Get_user_name%NOTFOUND');

120: OPEN Get_user_name(p_approver);
121: FETCH Get_user_name INTO l_approver_name;
122: IF(Get_user_name%NOTFOUND) THEN
123: IF g_debug <= gme_debug.g_log_procedure THEN
124: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| ': Get_user_name%NOTFOUND');
125: END IF;
126: CLOSE Get_user_name;
127: RETURN;
128: END IF;

Line 130: IF g_debug <= gme_debug.g_log_procedure THEN

126: CLOSE Get_user_name;
127: RETURN;
128: END IF;
129: CLOSE Get_user_name;
130: IF g_debug <= gme_debug.g_log_procedure THEN
131: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| 'after get_user_name');
132: END IF;
133:
134: /* Get the Order and Line Information */

Line 131: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| 'after get_user_name');

127: RETURN;
128: END IF;
129: CLOSE Get_user_name;
130: IF g_debug <= gme_debug.g_log_procedure THEN
131: gme_debug.put_line(g_pkg_name||'.'||l_api_name|| 'after get_user_name');
132: END IF;
133:
134: /* Get the Order and Line Information */
135: OPEN Get_order_info(p_so_line_id);

Line 139: IF g_debug <= gme_debug.g_log_procedure THEN

135: OPEN Get_order_info(p_so_line_id);
136: FETCH Get_order_info INTO l_so_line_no,l_item_no,
137: l_order_type,l_order_no;
138: IF(Get_order_info%NOTFOUND) THEN
139: IF g_debug <= gme_debug.g_log_procedure THEN
140: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');
141: END IF;
142: CLOSE Get_order_info;
143: RETURN;

Line 140: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');

136: FETCH Get_order_info INTO l_so_line_no,l_item_no,
137: l_order_type,l_order_no;
138: IF(Get_order_info%NOTFOUND) THEN
139: IF g_debug <= gme_debug.g_log_procedure THEN
140: gme_debug.put_line(g_pkg_name||'.'||l_api_name ||'Get_order_info%NOTFOUND');
141: END IF;
142: CLOSE Get_order_info;
143: RETURN;
144: END IF;

Line 148: IF g_debug <= gme_debug.g_log_procedure THEN

144: END IF;
145:
146: CLOSE Get_order_info;
147:
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);

Line 149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');

145:
146: CLOSE Get_order_info;
147:
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);

Line 150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);

146: CLOSE Get_order_info;
147:
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);
154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');

Line 151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);

147:
148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);
154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');
155: END IF;

Line 152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);

148: IF g_debug <= gme_debug.g_log_procedure THEN
149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);
154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');
155: END IF;
156:

Line 153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);

149: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order/Line Information......');
150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);
154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');
155: END IF;
156:
157: /* Get the batch Information */

Line 154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');

150: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_type = '|| l_order_type);
151: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Order_no = '|| l_order_no);
152: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Line_no = '|| l_so_line_no);
153: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Item_no = '|| l_item_no);
154: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after get_order_info');
155: END IF;
156:
157: /* Get the batch Information */
158: OPEN Get_batch_info(p_batch_id);

Line 161: IF g_debug <= gme_debug.g_log_procedure THEN

157: /* Get the batch Information */
158: OPEN Get_batch_info(p_batch_id);
159: FETCH Get_batch_info INTO l_batch_no, l_plant_code,l_plan_complt_date;
160: IF(Get_batch_info%NOTFOUND) THEN
161: IF g_debug <= gme_debug.g_log_procedure THEN
162: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');
163: END IF;
164: CLOSE Get_batch_info;
165: --RETURN;

Line 162: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');

158: OPEN Get_batch_info(p_batch_id);
159: FETCH Get_batch_info INTO l_batch_no, l_plant_code,l_plan_complt_date;
160: IF(Get_batch_info%NOTFOUND) THEN
161: IF g_debug <= gme_debug.g_log_procedure THEN
162: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');
163: END IF;
164: CLOSE Get_batch_info;
165: --RETURN;
166: END IF;

Line 174: IF g_debug <= gme_debug.g_log_procedure THEN

170: if p_batch_line_id is not null then
171: OPEN Get_batch_line_info(p_batch_line_id);
172: FETCH Get_batch_line_info INTO l_batch_line_no;
173: IF(Get_batch_line_info%NOTFOUND) THEN
174: IF g_debug <= gme_debug.g_log_procedure THEN
175: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_line_info%NOTFOUND');
176: END IF;
177: CLOSE Get_batch_line_info;
178: --RETURN;

Line 175: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_line_info%NOTFOUND');

171: OPEN Get_batch_line_info(p_batch_line_id);
172: FETCH Get_batch_line_info INTO l_batch_line_no;
173: IF(Get_batch_line_info%NOTFOUND) THEN
174: IF g_debug <= gme_debug.g_log_procedure THEN
175: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_line_info%NOTFOUND');
176: END IF;
177: CLOSE Get_batch_line_info;
178: --RETURN;
179: END IF;

Line 187: IF g_debug <= gme_debug.g_log_procedure THEN

183: if p_fpo_id is not null then
184: OPEN Get_batch_info(p_fpo_id);
185: FETCH Get_batch_info INTO l_fpo_no, l_plant_code,l_plan_complt_date;
186: IF(Get_batch_info%NOTFOUND) THEN
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');
189: END IF;
190: CLOSE Get_batch_info;
191: --RETURN;

Line 188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');

184: OPEN Get_batch_info(p_fpo_id);
185: FETCH Get_batch_info INTO l_fpo_no, l_plant_code,l_plan_complt_date;
186: IF(Get_batch_info%NOTFOUND) THEN
187: IF g_debug <= gme_debug.g_log_procedure THEN
188: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Get_batch_info%NOTFOUND');
189: END IF;
190: CLOSE Get_batch_info;
191: --RETURN;
192: END IF;

Line 197: IF g_debug <= gme_debug.g_log_procedure THEN

193: CLOSE Get_batch_info;
194: end if;
195:
196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);

Line 198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');

194: end if;
195:
196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);

Line 199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);

195:
196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);

Line 200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);

196:
197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);
204: END IF;

Line 201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);

197: IF g_debug <= gme_debug.g_log_procedure THEN
198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);
204: END IF;
205: /* Increment the itemkey global variable */

Line 202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);

198: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch Information......');
199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);
204: END IF;
205: /* Increment the itemkey global variable */
206: g_itemkey_num := g_itemkey_num+1;

Line 203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);

199: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_no = '|| l_batch_no);
200: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Batch_line_no = '|| l_batch_line_no);
201: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; FPO_no = '|| l_FPO_no);
202: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Plant_code = '|| l_plant_code);
203: gme_debug.put_line(g_pkg_name||'.'||l_api_name || '; Planned Completion Date = '|| l_plan_complt_date);
204: END IF;
205: /* Increment the itemkey global variable */
206: g_itemkey_num := g_itemkey_num+1;
207: l_itemkey := l_itemkey||'-'||to_char(g_itemkey_num);

Line 210: /*IF g_debug <= gme_debug.g_log_procedure THEN

206: g_itemkey_num := g_itemkey_num+1;
207: l_itemkey := l_itemkey||'-'||to_char(g_itemkey_num);
208:
209: /* create the process*/
210: /*IF g_debug <= gme_debug.g_log_procedure THEN
211: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Init_wf before CreateProcess');
212: END IF;
213: WF_ENGINE.CREATEPROCESS(
214: itemtype => l_itemtype

Line 211: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Init_wf before CreateProcess');

207: l_itemkey := l_itemkey||'-'||to_char(g_itemkey_num);
208:
209: /* create the process*/
210: /*IF g_debug <= gme_debug.g_log_procedure THEN
211: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Init_wf before CreateProcess');
212: END IF;
213: WF_ENGINE.CREATEPROCESS(
214: itemtype => l_itemtype
215: , itemkey => l_itemkey

Line 219: IF g_debug <= gme_debug.g_log_procedure THEN

215: , itemkey => l_itemkey
216: , process => l_WorkflowProcess) ;
217: */
218: /* make sure that process runs with background engine */
219: IF g_debug <= gme_debug.g_log_procedure THEN
220: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after CreateProcess');
221: END IF;
222:
223: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;

Line 220: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after CreateProcess');

216: , process => l_WorkflowProcess) ;
217: */
218: /* make sure that process runs with background engine */
219: IF g_debug <= gme_debug.g_log_procedure THEN
220: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after CreateProcess');
221: END IF;
222:
223: -- WF_ENGINE.THRESHOLD := l_run_wf_in_background ;
224: --WF_ENGINE.THRESHOLD := -1 ;

Line 234: IF g_debug <= gme_debug.g_log_procedure THEN

230: itemtype => l_itemtype
231: , itemkey =>l_itemkey
232: , aname => 'APPROVER'
233: , avalue => l_approver_name);
234: IF g_debug <= gme_debug.g_log_procedure THEN
235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Approver Name');
236: END IF;
237: WF_ENGINE.SETITEMATTRTEXT(
238: itemtype => l_itemtype

Line 235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Approver Name');

231: , itemkey =>l_itemkey
232: , aname => 'APPROVER'
233: , avalue => l_approver_name);
234: IF g_debug <= gme_debug.g_log_procedure THEN
235: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Approver Name');
236: END IF;
237: WF_ENGINE.SETITEMATTRTEXT(
238: itemtype => l_itemtype
239: , itemkey => l_itemkey

Line 243: IF g_debug <= gme_debug.g_log_procedure THEN

239: , itemkey => l_itemkey
240: , aname => 'ACTION_CODE'
241: , avalue => p_action_code );
242:
243: IF g_debug <= gme_debug.g_log_procedure THEN
244: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Action Code ');
245: END IF;
246: WF_ENGINE.SETITEMATTRTEXT(
247: itemtype => l_itemtype

Line 244: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Action Code ');

240: , aname => 'ACTION_CODE'
241: , avalue => p_action_code );
242:
243: IF g_debug <= gme_debug.g_log_procedure THEN
244: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Action Code ');
245: END IF;
246: WF_ENGINE.SETITEMATTRTEXT(
247: itemtype => l_itemtype
248: , itemkey => l_itemkey

Line 252: IF g_debug <= gme_debug.g_log_procedure THEN

248: , itemkey => l_itemkey
249: , aname => 'ORDER_NO'
250: , avalue => to_char(l_order_no) );
251:
252: IF g_debug <= gme_debug.g_log_procedure THEN
253: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Number ');
254: END IF;
255: WF_ENGINE.SETITEMATTRTEXT(
256: itemtype => l_itemtype

Line 253: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Number ');

249: , aname => 'ORDER_NO'
250: , avalue => to_char(l_order_no) );
251:
252: IF g_debug <= gme_debug.g_log_procedure THEN
253: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Number ');
254: END IF;
255: WF_ENGINE.SETITEMATTRTEXT(
256: itemtype => l_itemtype
257: , itemkey => l_itemkey

Line 261: IF g_debug <= gme_debug.g_log_procedure THEN

257: , itemkey => l_itemkey
258: , aname => 'ORDER_TYPE'
259: , avalue => l_order_type );
260:
261: IF g_debug <= gme_debug.g_log_procedure THEN
262: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Type ');
263: END IF;
264: WF_ENGINE.SETITEMATTRTEXT(
265: itemtype => l_itemtype

Line 262: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Type ');

258: , aname => 'ORDER_TYPE'
259: , avalue => l_order_type );
260:
261: IF g_debug <= gme_debug.g_log_procedure THEN
262: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Order Type ');
263: END IF;
264: WF_ENGINE.SETITEMATTRTEXT(
265: itemtype => l_itemtype
266: , itemkey => l_itemkey

Line 270: IF g_debug <= gme_debug.g_log_procedure THEN

266: , itemkey => l_itemkey
267: , aname => 'SO_LINE_NO'
268: , avalue => to_char(l_so_line_no) );
269:
270: IF g_debug <= gme_debug.g_log_procedure THEN
271: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set so_line_no ');
272: END IF;
273: WF_ENGINE.SETITEMATTRTEXT(
274: itemtype => l_itemtype

Line 271: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set so_line_no ');

267: , aname => 'SO_LINE_NO'
268: , avalue => to_char(l_so_line_no) );
269:
270: IF g_debug <= gme_debug.g_log_procedure THEN
271: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set so_line_no ');
272: END IF;
273: WF_ENGINE.SETITEMATTRTEXT(
274: itemtype => l_itemtype
275: , itemkey => l_itemkey

Line 284: IF g_debug <= gme_debug.g_log_procedure THEN

280: itemtype => l_itemtype
281: , itemkey => l_itemkey
282: , aname => 'ORG_CODE'
283: , avalue => l_organization_code);
284: IF g_debug <= gme_debug.g_log_procedure THEN
285: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Number ');
286: END IF;
287: WF_ENGINE.SETITEMATTRTEXT(
288: itemtype => l_itemtype

Line 285: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Number ');

281: , itemkey => l_itemkey
282: , aname => 'ORG_CODE'
283: , avalue => l_organization_code);
284: IF g_debug <= gme_debug.g_log_procedure THEN
285: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Number ');
286: END IF;
287: WF_ENGINE.SETITEMATTRTEXT(
288: itemtype => l_itemtype
289: , itemkey => l_itemkey

Line 293: IF g_debug <= gme_debug.g_log_procedure THEN

289: , itemkey => l_itemkey
290: , aname => 'BATCH_NO'
291: , avalue => l_batch_no );
292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Line Number ');
295: END IF;
296: WF_ENGINE.SETITEMATTRTEXT(
297: itemtype => l_itemtype

Line 294: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Line Number ');

290: , aname => 'BATCH_NO'
291: , avalue => l_batch_no );
292:
293: IF g_debug <= gme_debug.g_log_procedure THEN
294: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set Batch Line Number ');
295: END IF;
296: WF_ENGINE.SETITEMATTRTEXT(
297: itemtype => l_itemtype
298: , itemkey => l_itemkey

Line 303: IF g_debug <= gme_debug.g_log_procedure THEN

299: , aname => 'BATCH_LINE_NO'
300: , avalue => l_batch_line_no );
301:
302: IF (p_lot_no is NOT NULL) THEN
303: IF g_debug <= gme_debug.g_log_procedure THEN
304: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set lot_no ');
305: END IF;
306: WF_ENGINE.SETITEMATTRTEXT(
307: itemtype => l_itemtype

Line 304: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set lot_no ');

300: , avalue => l_batch_line_no );
301:
302: IF (p_lot_no is NOT NULL) THEN
303: IF g_debug <= gme_debug.g_log_procedure THEN
304: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set lot_no ');
305: END IF;
306: WF_ENGINE.SETITEMATTRTEXT(
307: itemtype => l_itemtype
308: , itemkey => l_itemkey

Line 312: IF g_debug <= gme_debug.g_log_procedure THEN

308: , itemkey => l_itemkey
309: , aname => 'LOT_NO'
310: , avalue => p_lot_no );
311: END IF;
312: IF g_debug <= gme_debug.g_log_procedure THEN
313: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set FPO Number ');
314: END IF;
315: WF_ENGINE.SETITEMATTRTEXT(
316: itemtype => l_itemtype

Line 313: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set FPO Number ');

309: , aname => 'LOT_NO'
310: , avalue => p_lot_no );
311: END IF;
312: IF g_debug <= gme_debug.g_log_procedure THEN
313: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Set FPO Number ');
314: END IF;
315: WF_ENGINE.SETITEMATTRTEXT(
316: itemtype => l_itemtype
317: , itemkey => l_itemkey

Line 320: IF g_debug <= gme_debug.g_log_procedure THEN

316: itemtype => l_itemtype
317: , itemkey => l_itemkey
318: , aname => 'FPO_NO'
319: , avalue => l_fpo_no );
320: IF g_debug <= gme_debug.g_log_procedure THEN
321: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after Setting the Attributes');
322: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Before Start Process');
323: END IF;
324: /*WF_ENGINE.STARTPROCESS (

Line 321: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after Setting the Attributes');

317: , itemkey => l_itemkey
318: , aname => 'FPO_NO'
319: , avalue => l_fpo_no );
320: IF g_debug <= gme_debug.g_log_procedure THEN
321: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after Setting the Attributes');
322: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Before Start Process');
323: END IF;
324: /*WF_ENGINE.STARTPROCESS (
325: itemtype => l_itemtype

Line 322: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Before Start Process');

318: , aname => 'FPO_NO'
319: , avalue => l_fpo_no );
320: IF g_debug <= gme_debug.g_log_procedure THEN
321: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'after Setting the Attributes');
322: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'Before Start Process');
323: END IF;
324: /*WF_ENGINE.STARTPROCESS (
325: itemtype => l_itemtype
326: , itemkey => l_itemkey );

Line 328: IF g_debug <= gme_debug.g_log_procedure THEN

324: /*WF_ENGINE.STARTPROCESS (
325: itemtype => l_itemtype
326: , itemkey => l_itemkey );
327: */
328: IF g_debug <= gme_debug.g_log_procedure THEN
329: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'After Start Process');
330: END IF;
331:
332: EXCEPTION

Line 329: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'After Start Process');

325: itemtype => l_itemtype
326: , itemkey => l_itemkey );
327: */
328: IF g_debug <= gme_debug.g_log_procedure THEN
329: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'After Start Process');
330: END IF;
331:
332: EXCEPTION
333:

Line 336: IF g_debug <= gme_debug.g_log_procedure THEN

332: EXCEPTION
333:
334: WHEN OTHERS THEN
335: NULL;
336: IF g_debug <= gme_debug.g_log_procedure THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING! In GME_BATCH_WORKFLOW_PKG. Init_wf Others Exception');
338: END IF;
339:
340: WF_CORE.CONTEXT ('GME_BATCH_WORKFLOW','init_wf'

Line 337: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING! In GME_BATCH_WORKFLOW_PKG. Init_wf Others Exception');

333:
334: WHEN OTHERS THEN
335: NULL;
336: IF g_debug <= gme_debug.g_log_procedure THEN
337: gme_debug.put_line(g_pkg_name||'.'||l_api_name || 'WARNING! In GME_BATCH_WORKFLOW_PKG. Init_wf Others Exception');
338: END IF;
339:
340: WF_CORE.CONTEXT ('GME_BATCH_WORKFLOW','init_wf'
341: ,l_itemtype,l_itemkey,'Initial' );

Line 368: IF g_debug <= gme_debug.g_log_procedure THEN

364: l_action_code varchar2(30) := wf_engine.getitemattrtext(p_itemtype, p_itemkey,'ACTION_CODE');
365: BEGIN
366:
367: wf_log_pkg.wf_debug_flag:=TRUE;
368: IF g_debug <= gme_debug.g_log_procedure THEN
369: gme_debug.put_line ('Entering check event ' );
370: End if;
371: init_wf (
372: p_itemtype => p_itemtype

Line 369: gme_debug.put_line ('Entering check event ' );

365: BEGIN
366:
367: wf_log_pkg.wf_debug_flag:=TRUE;
368: IF g_debug <= gme_debug.g_log_procedure THEN
369: gme_debug.put_line ('Entering check event ' );
370: End if;
371: init_wf (
372: p_itemtype => p_itemtype
373: , p_itemkey => p_itemkey