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.GMPMPACT dependencies on FND_FILE

Line 149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');

145: G_critical_indicator := V_critical_indicator;
146: G_template := V_template;
147: G_template_locale := V_template_locale;
148:
149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');
150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);

Line 150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));

146: G_template := V_template;
147: G_template_locale := V_template_locale;
148:
149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');
150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));

Line 151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));

147: G_template_locale := V_template_locale;
148:
149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');
150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));

Line 152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));

148:
149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');
150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);

Line 153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);

149: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');
150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);

Line 154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));

150: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_orgnanization_id '||to_char(G_orgnanization_id));
151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);

Line 155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));

151: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule '||to_char(G_schedule));
152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);

Line 156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);

152: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_schedule_id '||to_char(G_schedule_id));
153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);

Line 157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);

153: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set '||G_category_set);
154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);

Line 158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);

154: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_structure_id '||to_char(G_structure_id));
155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);

Line 159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);

155: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_category_set_id '||to_char(G_category_set_id));
156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);

Line 160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);

156: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fcategory '||G_fcategory);
157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);

Line 161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);

157: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tcategory '||G_tcategory);
158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);

Line 162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);

158: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fbuyer '||G_fbuyer);
159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));

Line 163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);

159: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tbuyer '||G_tbuyer);
160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));

Line 164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);

160: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fplanner '||G_fplanner);
161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);

Line 165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);

161: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_tplanner '||G_tplanner);
162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
169:

Line 166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));

162: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_forg '||G_forg);
163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
169:
170: --Insert data in PS_MATL_HDR.

Line 167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));

163: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_torg '||G_torg);
164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
169:
170: --Insert data in PS_MATL_HDR.
171: insert_header_data;

Line 168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);

164: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_fitem '||G_fitem);
165: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_titem '||G_titem);
166: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ftrans_date '||TO_CHAR(G_ftrans_date,'DD-MON-YYYY'));
167: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_ttrans_date '||TO_CHAR(G_ttrans_date,'DD-MON-YYYY'));
168: FND_FILE.PUT_LINE ( FND_FILE.LOG, ' G_critical_indicator '||G_critical_indicator);
169:
170: --Insert data in PS_MATL_HDR.
171: insert_header_data;
172:

Line 200: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req '||sqlerrm);

196: UPPER(V_user_print_style),
197: V_number_of_copies, TRUE, 'N');
198: END IF;
199: -- request is submitted to the concurrent manager
200: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitting the Req '||sqlerrm);
201:
202: -- B3679023 niyadav changed 'TO_CHAR(G_user_id)' to 'TO_CHAR(G_Buyer_plnr_id)' .
203: X_conc_id := FND_REQUEST.SUBMIT_REQUEST('GMP','RIPS1USR','',
204: TO_CHAR(V_run_date,'YYYY/MM/DD HH24:MI:SS'),

Line 218: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);

214: '','','','','','','','','','',
215: '','','','','','','','','','',
216: '','','','','','','','','','');
217:
218: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);
219:
220: IF X_conc_id = 0 THEN
221: G_log_text := FND_MESSAGE.GET;
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

Line 222: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

218: FND_FILE.PUT_LINE ( FND_FILE.LOG,' Submitted the Req '||sqlerrm);
219:
220: IF X_conc_id = 0 THEN
221: G_log_text := FND_MESSAGE.GET;
222: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
223: retcode:=2;
224: exit;
225: ELSE
226: COMMIT ;

Line 237: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print mps Activity'||sqlerrm);

233: CLOSE Cur_buyer_plnr;
234: */
235: EXCEPTION
236: WHEN OTHERS THEN
237: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Print mps Activity'||sqlerrm);
238:
239: END print_mps_activity;
240:
241: /*************** END OF PROCEDURE **********************************/

Line 433: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);

429: dbms_sql.close_cursor (cur_item);
430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);
435: /* b3668927 nsinghi : Closing cursors in exception block. */
436: IF dbms_sql.is_open (cur_item) THEN
437: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');

Line 434: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);

430:
431: EXCEPTION
432: WHEN OTHERS THEN
433: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);
435: /* b3668927 nsinghi : Closing cursors in exception block. */
436: IF dbms_sql.is_open (cur_item) THEN
437: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
438: dbms_sql.close_cursor (cur_item);

Line 437: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');

433: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm);
434: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Header'||sqlerrm);
435: /* b3668927 nsinghi : Closing cursors in exception block. */
436: IF dbms_sql.is_open (cur_item) THEN
437: FND_FILE.PUT_LINE(FND_FILE.LOG,'EXCEPTION cur_item is Open');
438: dbms_sql.close_cursor (cur_item);
439: END IF;
440: END insert_header_data;
441:

Line 485: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

481:
482: IF (X_ret = 0) THEN
483: FND_MESSAGE.SET_NAME('GMP','PS_NO_TRANS');
484: G_log_text := FND_MESSAGE.GET;
485: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
486: ROLLBACK;
487: END IF;
488:
489: EXCEPTION

Line 491: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);

487: END IF;
488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);
492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);
493: /* b3668927 nsinghi : Closing cursors in exception block. */
494: IF Cur_check_dtl%ISOPEN THEN
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_check_dtl Is Open');

Line 492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);

488:
489: EXCEPTION
490: WHEN OTHERS THEN
491: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);
492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);
493: /* b3668927 nsinghi : Closing cursors in exception block. */
494: IF Cur_check_dtl%ISOPEN THEN
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_check_dtl Is Open');
496: CLOSE Cur_check_dtl;

Line 495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_check_dtl Is Open');

491: FND_FILE.PUT_LINE (FND_FILE.LOG, sqlerrm);
492: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to Unbucket'||sqlerrm);
493: /* b3668927 nsinghi : Closing cursors in exception block. */
494: IF Cur_check_dtl%ISOPEN THEN
495: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_check_dtl Is Open');
496: CLOSE Cur_check_dtl;
497: END IF;
498:
499: End rips1usr_unbucket_report;

Line 1295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);

1291:
1292: EXCEPTION
1293: WHEN OTHERS THEN
1294: -- X_WHSE_LIST:=SQLERRM;
1295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1296:
1297: /* b3668927 nsinghi : Closing cursors in exception block. */
1298: IF dbms_sql.is_open(X_doc) THEN
1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');

Line 1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');

1295: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1296:
1297: /* b3668927 nsinghi : Closing cursors in exception block. */
1298: IF dbms_sql.is_open(X_doc) THEN
1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1300: dbms_sql.close_cursor(X_doc);
1301: END IF;
1302: IF dbms_sql.is_open(X_doc1) THEN
1303: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');

Line 1303: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');

1299: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1300: dbms_sql.close_cursor(X_doc);
1301: END IF;
1302: IF dbms_sql.is_open(X_doc1) THEN
1303: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');
1304: dbms_sql.close_cursor(X_doc1);
1305: END IF;
1306: IF Cur_fpo_doc_no%ISOPEN THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');

Line 1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');

1303: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');
1304: dbms_sql.close_cursor(X_doc1);
1305: END IF;
1306: IF Cur_fpo_doc_no%ISOPEN THEN
1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');
1308: CLOSE Cur_fpo_doc_no;
1309: END IF;
1310: IF Cur_prod_doc_no%ISOPEN THEN
1311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_prod_doc_no Is Open');

Line 1311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_prod_doc_no Is Open');

1307: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');
1308: CLOSE Cur_fpo_doc_no;
1309: END IF;
1310: IF Cur_prod_doc_no%ISOPEN THEN
1311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_prod_doc_no Is Open');
1312: CLOSE Cur_prod_doc_no;
1313: END IF;
1314: IF Cur_requisition_details%ISOPEN THEN
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_requisition_details Is Open');

Line 1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_requisition_details Is Open');

1311: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_prod_doc_no Is Open');
1312: CLOSE Cur_prod_doc_no;
1313: END IF;
1314: IF Cur_requisition_details%ISOPEN THEN
1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_requisition_details Is Open');
1316: CLOSE Cur_requisition_details;
1317: END IF;
1318: IF Cur_receiving_details%ISOPEN THEN
1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_receiving_details Is Open');

Line 1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_receiving_details Is Open');

1315: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_requisition_details Is Open');
1316: CLOSE Cur_requisition_details;
1317: END IF;
1318: IF Cur_receiving_details%ISOPEN THEN
1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_receiving_details Is Open');
1320: CLOSE Cur_receiving_details;
1321: END IF;
1322: IF Cur_shipment_details%ISOPEN THEN
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_shipment_details Is Open');

Line 1323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_shipment_details Is Open');

1319: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_receiving_details Is Open');
1320: CLOSE Cur_receiving_details;
1321: END IF;
1322: IF Cur_shipment_details%ISOPEN THEN
1323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_shipment_details Is Open');
1324: CLOSE Cur_shipment_details;
1325: END IF;
1326: IF Cur_po_doc_no%ISOPEN THEN
1327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_po_doc_no Is Open');

Line 1327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_po_doc_no Is Open');

1323: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_shipment_details Is Open');
1324: CLOSE Cur_shipment_details;
1325: END IF;
1326: IF Cur_po_doc_no%ISOPEN THEN
1327: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_po_doc_no Is Open');
1328: CLOSE Cur_po_doc_no;
1329: END IF;
1330: /*
1331: IF Cur_opso_doc_no%ISOPEN THEN

Line 1332: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_opso_doc_no Is Open');

1328: CLOSE Cur_po_doc_no;
1329: END IF;
1330: /*
1331: IF Cur_opso_doc_no%ISOPEN THEN
1332: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_opso_doc_no Is Open');
1333: CLOSE Cur_opso_doc_no;
1334: END IF;
1335: */
1336: IF Cur_omso_doc_no%ISOPEN THEN

Line 1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_omso_doc_no Is Open');

1333: CLOSE Cur_opso_doc_no;
1334: END IF;
1335: */
1336: IF Cur_omso_doc_no%ISOPEN THEN
1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_omso_doc_no Is Open');
1338: CLOSE Cur_omso_doc_no;
1339: END IF;
1340: /* IF Cur_transfer_doc_no%ISOPEN THEN
1341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_transfer_doc_no Is Open');

Line 1341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_transfer_doc_no Is Open');

1337: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_omso_doc_no Is Open');
1338: CLOSE Cur_omso_doc_no;
1339: END IF;
1340: /* IF Cur_transfer_doc_no%ISOPEN THEN
1341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_transfer_doc_no Is Open');
1342: CLOSE Cur_transfer_doc_no;
1343: END IF; */
1344: IF get_order_ind_cur%ISOPEN THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_order_ind_cur Is Open');

Line 1345: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_order_ind_cur Is Open');

1341: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_transfer_doc_no Is Open');
1342: CLOSE Cur_transfer_doc_no;
1343: END IF; */
1344: IF get_order_ind_cur%ISOPEN THEN
1345: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_order_ind_cur Is Open');
1346: CLOSE get_order_ind_cur;
1347: END IF;
1348:
1349: END ps_data_retrieval;

Line 1481: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'pscommon_safety_stock');

1477: dbms_sql.close_cursor (x_doc);
1478:
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'pscommon_safety_stock');
1482: IF dbms_sql.is_open(X_doc) THEN
1483: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1484: dbms_sql.close_cursor(X_doc);
1485: END IF;

Line 1483: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');

1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'pscommon_safety_stock');
1482: IF dbms_sql.is_open(X_doc) THEN
1483: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1484: dbms_sql.close_cursor(X_doc);
1485: END IF;
1486:
1487: END pscommon_safety_stock;

Line 1728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);

1724: G_cust_vend := X_workfield3;
1725:
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);
1729: /* b3668927 nsinghi : Closing cursors in exception block. */
1730: /* IF Cur_order_details%ISOPEN THEN
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_order_details Is Open');
1732: CLOSE Cur_order_details;

Line 1731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_order_details Is Open');

1727: WHEN OTHERS THEN
1728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);
1729: /* b3668927 nsinghi : Closing cursors in exception block. */
1730: /* IF Cur_order_details%ISOPEN THEN
1731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_order_details Is Open');
1732: CLOSE Cur_order_details;
1733: END IF;
1734: */
1735: IF Cur_om_order_details%ISOPEN THEN

Line 1736: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_om_order_details Is Open');

1732: CLOSE Cur_order_details;
1733: END IF;
1734: */
1735: IF Cur_om_order_details%ISOPEN THEN
1736: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_om_order_details Is Open');
1737: CLOSE Cur_om_order_details;
1738: END IF;
1739: IF Cur_purchase_details%ISOPEN THEN
1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');

Line 1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');

1736: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_om_order_details Is Open');
1737: CLOSE Cur_om_order_details;
1738: END IF;
1739: IF Cur_purchase_details%ISOPEN THEN
1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');
1741: CLOSE Cur_purchase_details;
1742: END IF;
1743: IF Cur_receiving_details%ISOPEN THEN
1744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');

Line 1744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');

1740: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');
1741: CLOSE Cur_purchase_details;
1742: END IF;
1743: IF Cur_receiving_details%ISOPEN THEN
1744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');
1745: CLOSE Cur_receiving_details;
1746: END IF;
1747: IF Cur_shipment_details%ISOPEN THEN
1748: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');

Line 1748: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');

1744: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');
1745: CLOSE Cur_receiving_details;
1746: END IF;
1747: IF Cur_shipment_details%ISOPEN THEN
1748: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');
1749: CLOSE Cur_shipment_details;
1750: END IF;
1751: IF Cur_requisition_details%ISOPEN THEN
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_requisition_details Is Open');

Line 1752: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_requisition_details Is Open');

1748: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');
1749: CLOSE Cur_shipment_details;
1750: END IF;
1751: IF Cur_requisition_details%ISOPEN THEN
1752: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_requisition_details Is Open');
1753: CLOSE Cur_requisition_details;
1754: END IF;
1755:
1756: END cleanup_details;

Line 1847: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_xml :'||SQLERRM);

1843: ps_generate_output(x_seq_num);
1844:
1845: EXCEPTION
1846: WHEN OTHERS THEN
1847: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_xml :'||SQLERRM);
1848:
1849: END ps_generate_xml;
1850:
1851: /* ***************************************************************

Line 1875: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function schedule '||SQLERRM);

1871: RETURN v_schedule_name;
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function schedule '||SQLERRM);
1876: END schedule;
1877:
1878: /* ***************************************************************
1879: * NAME

Line 1902: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category_set '||SQLERRM);

1898: RETURN v_category_set_name;
1899:
1900: EXCEPTION
1901: WHEN OTHERS THEN
1902: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category_set '||SQLERRM);
1903: END category_set;
1904:
1905: /* ***************************************************************
1906: * NAME

Line 1931: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function item_name '||SQLERRM);

1927: RETURN v_item_name;
1928:
1929: EXCEPTION
1930: WHEN OTHERS THEN
1931: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function item_name '||SQLERRM);
1932: END item_name;
1933:
1934: /* ***************************************************************
1935: * NAME

Line 1958: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function organization_code '||SQLERRM);

1954: RETURN v_org_code;
1955:
1956: EXCEPTION
1957: WHEN OTHERS THEN
1958: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function organization_code '||SQLERRM);
1959: END organization_code;
1960:
1961: /* ***************************************************************
1962: * NAME

Line 1988: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function planner_code '||SQLERRM);

1984:
1985: EXCEPTION
1986: WHEN NO_DATA_FOUND THEN RETURN NULL;
1987: WHEN OTHERS THEN
1988: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function planner_code '||SQLERRM);
1989: END planner_code;
1990:
1991: /* ***************************************************************
1992: * NAME

Line 2019: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function buyer_name '||SQLERRM);

2015:
2016: EXCEPTION
2017: WHEN NO_DATA_FOUND THEN RETURN NULL;
2018: WHEN OTHERS THEN
2019: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function buyer_name '||SQLERRM);
2020: END buyer_name;
2021:
2022: /* ***************************************************************
2023: * NAME

Line 2060: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function onhand_qty '||SQLERRM);

2056: RETURN v_onhand_qty;
2057:
2058: EXCEPTION
2059: WHEN OTHERS THEN
2060: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function onhand_qty '||SQLERRM);
2061: END onhand_qty;
2062:
2063: /* ***************************************************************
2064: * NAME

Line 2089: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function unit_of_measure '||SQLERRM);

2085: RETURN v_uom_code;
2086:
2087: EXCEPTION
2088: WHEN OTHERS THEN
2089: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function unit_of_measure '||SQLERRM);
2090: END unit_of_measure;
2091:
2092: /* ***************************************************************
2093: * NAME

Line 2117: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category '||SQLERRM);

2113:
2114: EXCEPTION
2115: WHEN NO_DATA_FOUND THEN RETURN NULL;
2116: WHEN OTHERS THEN
2117: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category '||SQLERRM);
2118: END category;
2119:
2120: /* ***************************************************************
2121: * NAME

Line 2160: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);

2156: '','','','','','','','','','');
2157:
2158: IF l_conc_id = 0 THEN
2159: G_log_text := FND_MESSAGE.GET;
2160: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
2161: ELSE
2162: COMMIT ;
2163: END IF;
2164:

Line 2197: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);

2193: END IF;
2194:
2195: EXCEPTION
2196: WHEN OTHERS THEN
2197: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);
2198: END ps_generate_output;
2199:
2200: /* ***************************************************************
2201: * NAME

Line 2232: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);

2228: l_len := DBMS_LOB.GETLENGTH (l_file);
2229: LOOP
2230: IF l_len > l_limit THEN
2231: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2232: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2233: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2234: file_varchar2 := NULL;
2235: l_limit:= l_limit + 10;
2236: ELSE

Line 2233: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);

2229: LOOP
2230: IF l_len > l_limit THEN
2231: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2232: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2233: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2234: file_varchar2 := NULL;
2235: l_limit:= l_limit + 10;
2236: ELSE
2237: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

Line 2238: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);

2234: file_varchar2 := NULL;
2235: l_limit:= l_limit + 10;
2236: ELSE
2237: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2238: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2239: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2240: file_varchar2 := NULL;
2241: EXIT;
2242: END IF;

Line 2239: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);

2235: l_limit:= l_limit + 10;
2236: ELSE
2237: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2238: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2239: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2240: file_varchar2 := NULL;
2241: EXIT;
2242: END IF;
2243: END LOOP;

Line 2246: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);

2242: END IF;
2243: END LOOP;
2244: EXCEPTION
2245: WHEN OTHERS THEN
2246: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
2247: END;
2248:
2249: END GMPMPACT;