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 151: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Calling gmp_print_mps with values ');

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

1297:
1298: EXCEPTION
1299: WHEN OTHERS THEN
1300: -- X_WHSE_LIST:=SQLERRM;
1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1302:
1303: /* b3668927 nsinghi : Closing cursors in exception block. */
1304: IF dbms_sql.is_open(X_doc) THEN
1305: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');

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

1301: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error writing to ps_ubkt_dtl'||sqlerrm);
1302:
1303: /* b3668927 nsinghi : Closing cursors in exception block. */
1304: IF dbms_sql.is_open(X_doc) THEN
1305: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1306: dbms_sql.close_cursor(X_doc);
1307: END IF;
1308: IF dbms_sql.is_open(X_doc1) THEN
1309: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');

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

1305: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1306: dbms_sql.close_cursor(X_doc);
1307: END IF;
1308: IF dbms_sql.is_open(X_doc1) THEN
1309: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');
1310: dbms_sql.close_cursor(X_doc1);
1311: END IF;
1312: IF Cur_fpo_doc_no%ISOPEN THEN
1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');

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

1309: FND_FILE.PUT_LINE(FND_FILE.LOG,'X_doc1 Is Open');
1310: dbms_sql.close_cursor(X_doc1);
1311: END IF;
1312: IF Cur_fpo_doc_no%ISOPEN THEN
1313: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_fpo_doc_no Is Open');
1314: CLOSE Cur_fpo_doc_no;
1315: END IF;
1316: IF Cur_prod_doc_no%ISOPEN THEN
1317: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_prod_doc_no Is Open');

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

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

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

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

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

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

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

1325: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_receiving_details Is Open');
1326: CLOSE Cur_receiving_details;
1327: END IF;
1328: IF Cur_shipment_details%ISOPEN THEN
1329: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_shipment_details Is Open');
1330: CLOSE Cur_shipment_details;
1331: END IF;
1332: IF Cur_po_doc_no%ISOPEN THEN
1333: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_po_doc_no Is Open');

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

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

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

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

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

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

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

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

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

1347: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cur_transfer_doc_no Is Open');
1348: CLOSE Cur_transfer_doc_no;
1349: END IF; */
1350: IF get_order_ind_cur%ISOPEN THEN
1351: FND_FILE.PUT_LINE(FND_FILE.LOG,'get_order_ind_cur Is Open');
1352: CLOSE get_order_ind_cur;
1353: END IF;
1354:
1355: END ps_data_retrieval;

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

1483: dbms_sql.close_cursor (x_doc);
1484:
1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'pscommon_safety_stock');
1488: IF dbms_sql.is_open(X_doc) THEN
1489: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1490: dbms_sql.close_cursor(X_doc);
1491: END IF;

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

1485: EXCEPTION
1486: WHEN OTHERS THEN
1487: FND_FILE.PUT_LINE ( FND_FILE.LOG, sqlerrm||'pscommon_safety_stock');
1488: IF dbms_sql.is_open(X_doc) THEN
1489: FND_FILE.PUT_LINE(FND_FILE.LOG,'cur_select Is Open');
1490: dbms_sql.close_cursor(X_doc);
1491: END IF;
1492:
1493: END pscommon_safety_stock;

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

1742: G_cust_vend := X_workfield3;
1743:
1744: EXCEPTION
1745: WHEN OTHERS THEN
1746: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);
1747: /* b3668927 nsinghi : Closing cursors in exception block. */
1748: /* IF Cur_order_details%ISOPEN THEN
1749: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_order_details Is Open');
1750: CLOSE Cur_order_details;

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

1745: WHEN OTHERS THEN
1746: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error in Cleanup details '||sqlerrm);
1747: /* b3668927 nsinghi : Closing cursors in exception block. */
1748: /* IF Cur_order_details%ISOPEN THEN
1749: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_order_details Is Open');
1750: CLOSE Cur_order_details;
1751: END IF;
1752: */
1753: IF Cur_om_order_details%ISOPEN THEN

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

1750: CLOSE Cur_order_details;
1751: END IF;
1752: */
1753: IF Cur_om_order_details%ISOPEN THEN
1754: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_om_order_details Is Open');
1755: CLOSE Cur_om_order_details;
1756: END IF;
1757: IF Cur_purchase_details%ISOPEN THEN
1758: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');

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

1754: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_om_order_details Is Open');
1755: CLOSE Cur_om_order_details;
1756: END IF;
1757: IF Cur_purchase_details%ISOPEN THEN
1758: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');
1759: CLOSE Cur_purchase_details;
1760: END IF;
1761: IF Cur_receiving_details%ISOPEN THEN
1762: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');

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

1758: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_purchase_details Is Open');
1759: CLOSE Cur_purchase_details;
1760: END IF;
1761: IF Cur_receiving_details%ISOPEN THEN
1762: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');
1763: CLOSE Cur_receiving_details;
1764: END IF;
1765: IF Cur_shipment_details%ISOPEN THEN
1766: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');

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

1762: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_receiving_details Is Open');
1763: CLOSE Cur_receiving_details;
1764: END IF;
1765: IF Cur_shipment_details%ISOPEN THEN
1766: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');
1767: CLOSE Cur_shipment_details;
1768: END IF;
1769: IF Cur_requisition_details%ISOPEN THEN
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_requisition_details Is Open');

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

1766: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_shipment_details Is Open');
1767: CLOSE Cur_shipment_details;
1768: END IF;
1769: IF Cur_requisition_details%ISOPEN THEN
1770: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cursor Cur_requisition_details Is Open');
1771: CLOSE Cur_requisition_details;
1772: END IF;
1773:
1774: END cleanup_details;

Line 1809: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_xml_header - '||l_xml_header);

1805: -- The following line of code ensures that XML data
1806: -- generated here uses the right encoding
1807: l_encoding := fnd_profile.value('ICX_CLIENT_IANA_ENCODING');
1808: l_xml_header := '';
1809: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_xml_header - '||l_xml_header);
1810: -- B7481907 Rajesh Patangya starts
1811:
1812:
1813: seq_stmt := NULL;

Line 1870: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);

1866: ' ) HEADER ' ||
1867: ' FROM DUAL ';
1868:
1869: -- DELETE FROM GMP_UNBUCKETED_XML_GTMP;
1870: -- FND_FILE.PUT_LINE ( FND_FILE.LOG, x_stmt);
1871:
1872: -- B7481907 Rajesh Patangya starts
1873: DBMS_LOB.createtemporary(temp_clob, TRUE);
1874: DBMS_LOB.createtemporary(result, TRUE);

Line 1884: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);

1880: l_offset := DBMS_LOB.INSTR (lob_loc => temp_clob,
1881: pattern => '>',
1882: offset => 1,
1883: nth => 1);
1884: FND_FILE.PUT_LINE ( FND_FILE.LOG,'l_offset - '||l_offset);
1885:
1886: -- Remove the header
1887: DBMS_LOB.erase (temp_clob, l_offset,1);
1888:

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

1905: ps_generate_output(x_seq_num);
1906:
1907: EXCEPTION
1908: WHEN OTHERS THEN
1909: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_xml :'||SQLERRM);
1910:
1911: END ps_generate_xml;
1912:
1913: /* ***************************************************************

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

1933: RETURN v_schedule_name;
1934:
1935: EXCEPTION
1936: WHEN OTHERS THEN
1937: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function schedule '||SQLERRM);
1938: END schedule;
1939:
1940: /* ***************************************************************
1941: * NAME

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

1960: RETURN v_category_set_name;
1961:
1962: EXCEPTION
1963: WHEN OTHERS THEN
1964: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category_set '||SQLERRM);
1965: END category_set;
1966:
1967: /* ***************************************************************
1968: * NAME

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

1989: RETURN v_item_name;
1990:
1991: EXCEPTION
1992: WHEN OTHERS THEN
1993: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function item_name '||SQLERRM);
1994: END item_name;
1995:
1996: /* ***************************************************************
1997: * NAME

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

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

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

2046:
2047: EXCEPTION
2048: WHEN NO_DATA_FOUND THEN RETURN NULL;
2049: WHEN OTHERS THEN
2050: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function planner_code '||SQLERRM);
2051: END planner_code;
2052:
2053: /* ***************************************************************
2054: * NAME

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

2077:
2078: EXCEPTION
2079: WHEN NO_DATA_FOUND THEN RETURN NULL;
2080: WHEN OTHERS THEN
2081: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function buyer_name '||SQLERRM);
2082: END buyer_name;
2083:
2084: /* ***************************************************************
2085: * NAME

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

2118: RETURN v_onhand_qty;
2119:
2120: EXCEPTION
2121: WHEN OTHERS THEN
2122: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function onhand_qty '||SQLERRM);
2123: END onhand_qty;
2124:
2125: /* ***************************************************************
2126: * NAME

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

2147: RETURN v_uom_code;
2148:
2149: EXCEPTION
2150: WHEN OTHERS THEN
2151: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function unit_of_measure '||SQLERRM);
2152: END unit_of_measure;
2153:
2154: /* ***************************************************************
2155: * NAME

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

2175:
2176: EXCEPTION
2177: WHEN NO_DATA_FOUND THEN RETURN NULL;
2178: WHEN OTHERS THEN
2179: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Error in function category '||SQLERRM);
2180: END category;
2181:
2182: /* ***************************************************************
2183: * NAME

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

2218: '','','','','','','','','','');
2219:
2220: IF l_conc_id = 0 THEN
2221: G_log_text := FND_MESSAGE.GET;
2222: FND_FILE.PUT_LINE ( FND_FILE.LOG,G_log_text);
2223: ELSE
2224: COMMIT ;
2225: END IF;
2226:

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

2255: END IF;
2256:
2257: EXCEPTION
2258: WHEN OTHERS THEN
2259: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure ps_generate_output '||SQLERRM);
2260: END ps_generate_output;
2261:
2262: /* ***************************************************************
2263: * NAME

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

2291: l_len := DBMS_LOB.GETLENGTH (l_file);
2292: LOOP
2293: IF l_len > l_limit THEN
2294: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2295: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2296: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2297: file_varchar2 := NULL;
2298: l_limit:= l_limit + 10;
2299: ELSE

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

2292: LOOP
2293: IF l_len > l_limit THEN
2294: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2295: FND_FILE.PUT(FND_FILE.OUTPUT,file_varchar2);
2296: FND_FILE.PUT(FND_FILE.LOG, file_varchar2);
2297: file_varchar2 := NULL;
2298: l_limit:= l_limit + 10;
2299: ELSE
2300: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);

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

2297: file_varchar2 := NULL;
2298: l_limit:= l_limit + 10;
2299: ELSE
2300: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2301: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2302: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2303: file_varchar2 := NULL;
2304: EXIT;
2305: END IF;

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

2298: l_limit:= l_limit + 10;
2299: ELSE
2300: file_varchar2 := DBMS_LOB.SUBSTR (l_file,10,l_limit);
2301: FND_FILE.PUT(FND_FILE.OUTPUT, file_varchar2);
2302: FND_FILE.PUT(FND_FILE.LOG,file_varchar2);
2303: file_varchar2 := NULL;
2304: EXIT;
2305: END IF;
2306: END LOOP;

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

2305: END IF;
2306: END LOOP;
2307: EXCEPTION
2308: WHEN OTHERS THEN
2309: FND_FILE.PUT_LINE ( FND_FILE.LOG, 'Exception in procedure xml_transfer '||SQLERRM);
2310: END;
2311:
2312: END GMPMPACT;