DBA Data[Home] [Help]

APPS.AS_FORECAST_ACTUAL_PKG dependencies on FND_MESSAGE

Line 147: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');

143: OPEN C;
144: FETCH C INTO Recinfo;
145: If (C%NOTFOUND) then
146: CLOSE C;
147: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
148: APP_EXCEPTION.RAISE_EXCEPTION;
149: End If;
150: CLOSE C;
151: if (

Line 204: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');

200: AND ( p_SECURITY_GROUP_ID IS NULL )))
201: ) then
202: return;
203: else
204: FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
205: APP_EXCEPTION.RAISE_EXCEPTION;
206: End If;
207: END Lock_Row;
208:

Line 261: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_PERIOD');

257: , x_end_date => l_period_end_date );
258:
259: IF NOT l_errflag THEN
260: l_errcnt := l_errcnt + 1;
261: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_PERIOD');
262: fnd_message.set_token('PERIOD_NAME',p_period_name);
263: l_log_msg := l_log_msg || fnd_message.get ;
264: END IF;
265:

Line 262: fnd_message.set_token('PERIOD_NAME',p_period_name);

258:
259: IF NOT l_errflag THEN
260: l_errcnt := l_errcnt + 1;
261: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_PERIOD');
262: fnd_message.set_token('PERIOD_NAME',p_period_name);
263: l_log_msg := l_log_msg || fnd_message.get ;
264: END IF;
265:
266: EXCEPTION

Line 263: l_log_msg := l_log_msg || fnd_message.get ;

259: IF NOT l_errflag THEN
260: l_errcnt := l_errcnt + 1;
261: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_PERIOD');
262: fnd_message.set_token('PERIOD_NAME',p_period_name);
263: l_log_msg := l_log_msg || fnd_message.get ;
264: END IF;
265:
266: EXCEPTION
267: WHEN OTHERS THEN

Line 282: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FRCSTCAT');

278: , x_forecast_category_id => l_forecast_category_id ) ;
279:
280: IF NVL(l_forecast_category_id,0) = 0 THEN
281: l_errcnt := l_errcnt + 1;
282: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FRCSTCAT');
283: fnd_message.set_token('FORECASTCATEGORY',p_forecast_category_name);
284: l_log_msg := l_log_msg || fnd_message.get ;
285: END IF;
286:

Line 283: fnd_message.set_token('FORECASTCATEGORY',p_forecast_category_name);

279:
280: IF NVL(l_forecast_category_id,0) = 0 THEN
281: l_errcnt := l_errcnt + 1;
282: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FRCSTCAT');
283: fnd_message.set_token('FORECASTCATEGORY',p_forecast_category_name);
284: l_log_msg := l_log_msg || fnd_message.get ;
285: END IF;
286:
287: EXCEPTION

Line 284: l_log_msg := l_log_msg || fnd_message.get ;

280: IF NVL(l_forecast_category_id,0) = 0 THEN
281: l_errcnt := l_errcnt + 1;
282: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FRCSTCAT');
283: fnd_message.set_token('FORECASTCATEGORY',p_forecast_category_name);
284: l_log_msg := l_log_msg || fnd_message.get ;
285: END IF;
286:
287: EXCEPTION
288: WHEN OTHERS THEN

Line 301: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CREDITTYPE');

297: , x_credit_type_id => l_credit_type_id );
298:
299: IF NVL(l_credit_type_id,0) = 0 THEN
300: l_errcnt := l_errcnt + 1;
301: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CREDITTYPE');
302: fnd_message.set_token('CREDITTYPE',p_credit_type_name);
303: l_log_msg := l_log_msg || fnd_message.get ;
304: END IF;
305:

Line 302: fnd_message.set_token('CREDITTYPE',p_credit_type_name);

298:
299: IF NVL(l_credit_type_id,0) = 0 THEN
300: l_errcnt := l_errcnt + 1;
301: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CREDITTYPE');
302: fnd_message.set_token('CREDITTYPE',p_credit_type_name);
303: l_log_msg := l_log_msg || fnd_message.get ;
304: END IF;
305:
306: EXCEPTION

Line 303: l_log_msg := l_log_msg || fnd_message.get ;

299: IF NVL(l_credit_type_id,0) = 0 THEN
300: l_errcnt := l_errcnt + 1;
301: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CREDITTYPE');
302: fnd_message.set_token('CREDITTYPE',p_credit_type_name);
303: l_log_msg := l_log_msg || fnd_message.get ;
304: END IF;
305:
306: EXCEPTION
307: WHEN OTHERS THEN

Line 323: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSGRP');

319: ) ;
320:
321: IF NVL(l_sales_group_id,0) = 0 THEN
322: l_errcnt := l_errcnt + 1;
323: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSGRP');
324: fnd_message.set_token('SALESGROUP',p_sales_group_number);
325: l_log_msg := l_log_msg || fnd_message.get ;
326: END IF;
327:

Line 324: fnd_message.set_token('SALESGROUP',p_sales_group_number);

320:
321: IF NVL(l_sales_group_id,0) = 0 THEN
322: l_errcnt := l_errcnt + 1;
323: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSGRP');
324: fnd_message.set_token('SALESGROUP',p_sales_group_number);
325: l_log_msg := l_log_msg || fnd_message.get ;
326: END IF;
327:
328: EXCEPTION

Line 325: l_log_msg := l_log_msg || fnd_message.get ;

321: IF NVL(l_sales_group_id,0) = 0 THEN
322: l_errcnt := l_errcnt + 1;
323: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSGRP');
324: fnd_message.set_token('SALESGROUP',p_sales_group_number);
325: l_log_msg := l_log_msg || fnd_message.get ;
326: END IF;
327:
328: EXCEPTION
329: WHEN OTHERS THEN

Line 350: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSPERSON');

346: ) ;
347:
348: IF NVL(l_salesforce_id,0) = 0 THEN
349: l_errcnt := l_errcnt + 1;
350: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSPERSON');
351: fnd_message.set_token('SALESPERSON',p_salesforce_number);
352: l_log_msg := l_log_msg || fnd_message.get ;
353: END IF;
354: END IF; -- sales group

Line 351: fnd_message.set_token('SALESPERSON',p_salesforce_number);

347:
348: IF NVL(l_salesforce_id,0) = 0 THEN
349: l_errcnt := l_errcnt + 1;
350: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSPERSON');
351: fnd_message.set_token('SALESPERSON',p_salesforce_number);
352: l_log_msg := l_log_msg || fnd_message.get ;
353: END IF;
354: END IF; -- sales group
355: END IF;

Line 352: l_log_msg := l_log_msg || fnd_message.get ;

348: IF NVL(l_salesforce_id,0) = 0 THEN
349: l_errcnt := l_errcnt + 1;
350: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_SLSPERSON');
351: fnd_message.set_token('SALESPERSON',p_salesforce_number);
352: l_log_msg := l_log_msg || fnd_message.get ;
353: END IF;
354: END IF; -- sales group
355: END IF;
356: EXCEPTION

Line 370: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CURR');

366: , x_currency_flag => l_errflag);
367:
368: IF NOT l_errflag THEN
369: l_errcnt := l_errcnt + 1;
370: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CURR');
371: fnd_message.set_token('CURRENCY',p_currency_code);
372: l_log_msg := l_log_msg || fnd_message.get ;
373: END IF;
374:

Line 371: fnd_message.set_token('CURRENCY',p_currency_code);

367:
368: IF NOT l_errflag THEN
369: l_errcnt := l_errcnt + 1;
370: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CURR');
371: fnd_message.set_token('CURRENCY',p_currency_code);
372: l_log_msg := l_log_msg || fnd_message.get ;
373: END IF;
374:
375: EXCEPTION

Line 372: l_log_msg := l_log_msg || fnd_message.get ;

368: IF NOT l_errflag THEN
369: l_errcnt := l_errcnt + 1;
370: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_CURR');
371: fnd_message.set_token('CURRENCY',p_currency_code);
372: l_log_msg := l_log_msg || fnd_message.get ;
373: END IF;
374:
375: EXCEPTION
376: WHEN OTHERS THEN

Line 451: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');

447:
448: END IF; -- if forecast actual ID is obtained
449:
450: ELSE -- error in validating IDs
451: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
452: fnd_message.set_token('LINE',p_line_number);
453: l_log_msg := fnd_message.get||l_log_msg;
454: UTL_FILE.PUT_LINE(p_filehandle, l_log_msg) ;
455: l_log_msg := l_log_msg;

Line 452: fnd_message.set_token('LINE',p_line_number);

448: END IF; -- if forecast actual ID is obtained
449:
450: ELSE -- error in validating IDs
451: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
452: fnd_message.set_token('LINE',p_line_number);
453: l_log_msg := fnd_message.get||l_log_msg;
454: UTL_FILE.PUT_LINE(p_filehandle, l_log_msg) ;
455: l_log_msg := l_log_msg;
456: create_loglob(l_log_msg

Line 453: l_log_msg := fnd_message.get||l_log_msg;

449:
450: ELSE -- error in validating IDs
451: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
452: fnd_message.set_token('LINE',p_line_number);
453: l_log_msg := fnd_message.get||l_log_msg;
454: UTL_FILE.PUT_LINE(p_filehandle, l_log_msg) ;
455: l_log_msg := l_log_msg;
456: create_loglob(l_log_msg
457: ,null

Line 796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');

792: ,p_file_id
793: ,'W'
794: ,FALSE);
795: end;
796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');
797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
798: fnd_message.set_token('USER',p_created_by);
799: fnd_message.set_token('FILENAME', l_file_name);
800: l_header := fnd_message.get;

Line 797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));

793: ,'W'
794: ,FALSE);
795: end;
796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');
797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
798: fnd_message.set_token('USER',p_created_by);
799: fnd_message.set_token('FILENAME', l_file_name);
800: l_header := fnd_message.get;
801: UTL_FILE.PUT_LINE(l_file_handle, l_header);

Line 798: fnd_message.set_token('USER',p_created_by);

794: ,FALSE);
795: end;
796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');
797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
798: fnd_message.set_token('USER',p_created_by);
799: fnd_message.set_token('FILENAME', l_file_name);
800: l_header := fnd_message.get;
801: UTL_FILE.PUT_LINE(l_file_handle, l_header);
802: UTL_FILE.NEW_LINE(l_file_handle, 1);

Line 799: fnd_message.set_token('FILENAME', l_file_name);

795: end;
796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');
797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
798: fnd_message.set_token('USER',p_created_by);
799: fnd_message.set_token('FILENAME', l_file_name);
800: l_header := fnd_message.get;
801: UTL_FILE.PUT_LINE(l_file_handle, l_header);
802: UTL_FILE.NEW_LINE(l_file_handle, 1);
803:

Line 800: l_header := fnd_message.get;

796: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_HDR');
797: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
798: fnd_message.set_token('USER',p_created_by);
799: fnd_message.set_token('FILENAME', l_file_name);
800: l_header := fnd_message.get;
801: UTL_FILE.PUT_LINE(l_file_handle, l_header);
802: UTL_FILE.NEW_LINE(l_file_handle, 1);
803:
804: create_loglob(l_header

Line 929: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');

925:
926: end if;
927: exception
928: when others then
929: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
930: fnd_message.set_token('LINE',l_line_number);
931: UTL_FILE.PUT_LINE(l_file_handle, fnd_message.get||sqlerrm) ;
932: l_exception := fnd_message.get||sqlerrm;
933: create_loglob(l_exception

Line 930: fnd_message.set_token('LINE',l_line_number);

926: end if;
927: exception
928: when others then
929: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
930: fnd_message.set_token('LINE',l_line_number);
931: UTL_FILE.PUT_LINE(l_file_handle, fnd_message.get||sqlerrm) ;
932: l_exception := fnd_message.get||sqlerrm;
933: create_loglob(l_exception
934: ,null

Line 931: UTL_FILE.PUT_LINE(l_file_handle, fnd_message.get||sqlerrm) ;

927: exception
928: when others then
929: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
930: fnd_message.set_token('LINE',l_line_number);
931: UTL_FILE.PUT_LINE(l_file_handle, fnd_message.get||sqlerrm) ;
932: l_exception := fnd_message.get||sqlerrm;
933: create_loglob(l_exception
934: ,null
935: ,'W'

Line 932: l_exception := fnd_message.get||sqlerrm;

928: when others then
929: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_LINE');
930: fnd_message.set_token('LINE',l_line_number);
931: UTL_FILE.PUT_LINE(l_file_handle, fnd_message.get||sqlerrm) ;
932: l_exception := fnd_message.get||sqlerrm;
933: create_loglob(l_exception
934: ,null
935: ,'W'
936: ,FALSE);

Line 990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');

986: lv_amount_var := l_lob_len;
987: End if;
988: l_lob_data := '';
989: END LOOP;
990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');
991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
992: fnd_message.set_token('LINE',l_line_number);
993: fnd_message.set_token('ERROR',g_line_error);
994: l_footer := fnd_message.get;

Line 991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));

987: End if;
988: l_lob_data := '';
989: END LOOP;
990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');
991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
992: fnd_message.set_token('LINE',l_line_number);
993: fnd_message.set_token('ERROR',g_line_error);
994: l_footer := fnd_message.get;
995: UTL_FILE.NEW_LINE(l_file_handle, 1);

Line 992: fnd_message.set_token('LINE',l_line_number);

988: l_lob_data := '';
989: END LOOP;
990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');
991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
992: fnd_message.set_token('LINE',l_line_number);
993: fnd_message.set_token('ERROR',g_line_error);
994: l_footer := fnd_message.get;
995: UTL_FILE.NEW_LINE(l_file_handle, 1);
996: UTL_FILE.PUT_LINE(l_file_handle, l_footer ) ;

Line 993: fnd_message.set_token('ERROR',g_line_error);

989: END LOOP;
990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');
991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
992: fnd_message.set_token('LINE',l_line_number);
993: fnd_message.set_token('ERROR',g_line_error);
994: l_footer := fnd_message.get;
995: UTL_FILE.NEW_LINE(l_file_handle, 1);
996: UTL_FILE.PUT_LINE(l_file_handle, l_footer ) ;
997: l_footer := l_footer;

Line 994: l_footer := fnd_message.get;

990: fnd_message.set_name('ASF','ASF_FRCSTACT_LOG_FOOTER');
991: fnd_message.set_token('DATETIME',to_Char(sysdate, 'DD-MON-RR HH24:MI:SS'));
992: fnd_message.set_token('LINE',l_line_number);
993: fnd_message.set_token('ERROR',g_line_error);
994: l_footer := fnd_message.get;
995: UTL_FILE.NEW_LINE(l_file_handle, 1);
996: UTL_FILE.PUT_LINE(l_file_handle, l_footer ) ;
997: l_footer := l_footer;
998: create_loglob(l_footer