DBA Data[Home] [Help]

APPS.IGS_FI_AD_HOC_WAV dependencies on FND_MESSAGE

Line 132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');

128: --Who When What
129: -------------------------------------------------------------------
130: BEGIN
131:
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
133: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
134: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
135: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
136:

Line 133: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);

129: -------------------------------------------------------------------
130: BEGIN
131:
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
133: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
134: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
135: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
136:
137: END log_messages ;

Line 134: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;

130: BEGIN
131:
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
133: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
134: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
135: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
136:
137: END log_messages ;
138:

Line 135: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

131:
132: FND_MESSAGE.SET_NAME('IGS','IGS_FI_CAL_BALANCES_LOG');
133: FND_MESSAGE.SET_TOKEN('PARAMETER_NAME',p_msg_name);
134: FND_MESSAGE.SET_TOKEN('PARAMETER_VAL' ,p_msg_val) ;
135: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
136:
137: END log_messages ;
138:
139: /* Removed the function sub_name as a part of Subaccount removal Build. Bug # 2564643 */

Line 393: fnd_message.set_name ( 'IGS', l_v_message_name );

389: -- If its NULL or OTHER then this process should error out by logging message.
390: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
391: p_v_message_name => l_v_message_name );
392: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
393: fnd_message.set_name ( 'IGS', l_v_message_name );
394: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
395: RAISE l_validation_exp;
396: END IF;
397:

Line 394: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );

390: igs_fi_com_rec_interface.chk_manage_account ( p_v_manage_acc => l_v_manage_accounts,
391: p_v_message_name => l_v_message_name );
392: IF l_v_manage_accounts IS NULL OR l_v_manage_accounts = 'OTHER' THEN
393: fnd_message.set_name ( 'IGS', l_v_message_name );
394: fnd_file.put_line ( fnd_file.LOG, fnd_message.get );
395: RAISE l_validation_exp;
396: END IF;
397:
398: /** Only person id or group id should be passed to the process

Line 402: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');

398: /** Only person id or group id should be passed to the process
399: If both are passed as parameter then the process errors out NOCOPY **/
400:
401: IF (p_n_person_id IS NOT NULL AND p_n_pers_id_grp_id IS NOT NULL) THEN
402: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');
403: IGS_GE_MSG_STACK.ADD;
404: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
405: l_valid := FALSE;
406: END IF;

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

400:
401: IF (p_n_person_id IS NOT NULL AND p_n_pers_id_grp_id IS NOT NULL) THEN
402: FND_MESSAGE.SET_NAME('IGS','IGS_FI_NO_PERS_PGRP');
403: IGS_GE_MSG_STACK.ADD;
404: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
405: l_valid := FALSE;
406: END IF;
407:
408: -- Bug# 5018036, Either of the two parameters must be specified.

Line 410: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;

406: END IF;
407:
408: -- Bug# 5018036, Either of the two parameters must be specified.
409: IF (p_n_person_id IS NULL AND p_n_pers_id_grp_id IS NULL) THEN
410: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
411: igs_ge_msg_stack.ADD;
412: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
413: l_valid := FALSE;
414: END IF;

Line 412: fnd_file.put_line(fnd_file.LOG, fnd_message.get);

408: -- Bug# 5018036, Either of the two parameters must be specified.
409: IF (p_n_person_id IS NULL AND p_n_pers_id_grp_id IS NULL) THEN
410: fnd_message.set_name ( 'IGS', 'IGS_FI_PRS_PRSIDGRP_NULL') ;
411: igs_ge_msg_stack.ADD;
412: fnd_file.put_line(fnd_file.LOG, fnd_message.get);
413: l_valid := FALSE;
414: END IF;
415:
416: /** Validating whether the Person Id Group passed to parameter p_n_pers_id_grp_id

Line 425: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVPERS_ID_GRP');

421: FETCH c_grp_id INTO l_v_grp_id;
422:
423: IF c_grp_id%NOTFOUND THEN
424: CLOSE c_grp_id;
425: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVPERS_ID_GRP');
426: IGS_GE_MSG_STACK.ADD;
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
428: l_valid := FALSE;
429: END IF;

Line 427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

423: IF c_grp_id%NOTFOUND THEN
424: CLOSE c_grp_id;
425: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVPERS_ID_GRP');
426: IGS_GE_MSG_STACK.ADD;
427: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
428: l_valid := FALSE;
429: END IF;
430: CLOSE c_grp_id;
431:

Line 444: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON_ID');

440: FETCH c_per_id INTO l_v_per_id;
441:
442: IF c_per_id%NOTFOUND THEN
443: CLOSE c_per_id;
444: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON_ID');
445: IGS_GE_MSG_STACK.ADD;
446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
447: l_valid := FALSE;
448: END IF;

Line 446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

442: IF c_per_id%NOTFOUND THEN
443: CLOSE c_per_id;
444: FND_MESSAGE.SET_NAME('IGS','IGS_FI_INVALID_PERSON_ID');
445: IGS_GE_MSG_STACK.ADD;
446: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
447: l_valid := FALSE;
448: END IF;
449: CLOSE c_per_id;
450:

Line 457: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

453: /** Validating whether the value passed to parameter p_c_action
454: is either WAIVE OR RELEASE **/
455:
456: IF p_c_action NOT IN ('WAIVE','RELEASE') THEN
457: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
458: IGS_GE_MSG_STACK.ADD;
459: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
460: l_valid := FALSE;
461: END IF;

Line 459: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

455:
456: IF p_c_action NOT IN ('WAIVE','RELEASE') THEN
457: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
458: IGS_GE_MSG_STACK.ADD;
459: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
460: l_valid := FALSE;
461: END IF;
462:
463: /** Validating whether the start date has been provided in case the action is 'WAIVE'

Line 468: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WV_STRT_DT');

464: Also if the start date has been provided,it should be greater than or equal sysdate **/
465:
466: IF p_c_action = 'WAIVE' THEN
467: IF l_start_dt IS NULL THEN
468: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WV_STRT_DT');
469: IGS_GE_MSG_STACK.ADD;
470: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
471: l_valid := FALSE;
472: ELSIF TRUNC(l_start_dt) < TRUNC(SYSDATE) THEN

Line 470: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

466: IF p_c_action = 'WAIVE' THEN
467: IF l_start_dt IS NULL THEN
468: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WV_STRT_DT');
469: IGS_GE_MSG_STACK.ADD;
470: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
471: l_valid := FALSE;
472: ELSIF TRUNC(l_start_dt) < TRUNC(SYSDATE) THEN
473: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_NOT_LT_CURRDT');
474: IGS_GE_MSG_STACK.ADD;

Line 473: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_NOT_LT_CURRDT');

469: IGS_GE_MSG_STACK.ADD;
470: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
471: l_valid := FALSE;
472: ELSIF TRUNC(l_start_dt) < TRUNC(SYSDATE) THEN
473: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_NOT_LT_CURRDT');
474: IGS_GE_MSG_STACK.ADD;
475: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
476: l_valid := FALSE;
477: END IF;

Line 475: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

471: l_valid := FALSE;
472: ELSIF TRUNC(l_start_dt) < TRUNC(SYSDATE) THEN
473: FND_MESSAGE.SET_NAME('IGS','IGS_FI_ST_NOT_LT_CURRDT');
474: IGS_GE_MSG_STACK.ADD;
475: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
476: l_valid := FALSE;
477: END IF;
478:
479: --Added the If Condtion to log a message when Waiver Release date is mentioned

Line 482: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RL_DT_NR');

478:
479: --Added the If Condtion to log a message when Waiver Release date is mentioned
480: --and the Action Type is WAIVE.
481: IF l_release_dt IS NOT NULL THEN
482: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RL_DT_NR');
483: IGS_GE_MSG_STACK.ADD;
484: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
485: END IF;
486:

Line 484: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

480: --and the Action Type is WAIVE.
481: IF l_release_dt IS NOT NULL THEN
482: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RL_DT_NR');
483: IGS_GE_MSG_STACK.ADD;
484: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
485: END IF;
486:
487:
488: END IF;

Line 495: FND_MESSAGE.SET_NAME('IGS','IGS_GE_END_DT_GE_ST_DATE');

491: in case the action is 'WAIVE' **/
492:
493: IF p_c_action = 'WAIVE' THEN
494: IF l_end_dt IS NOT NULL AND l_end_dt < l_start_dt THEN
495: FND_MESSAGE.SET_NAME('IGS','IGS_GE_END_DT_GE_ST_DATE');
496: IGS_GE_MSG_STACK.ADD;
497: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
498: l_valid := FALSE;
499: END IF;

Line 497: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

493: IF p_c_action = 'WAIVE' THEN
494: IF l_end_dt IS NOT NULL AND l_end_dt < l_start_dt THEN
495: FND_MESSAGE.SET_NAME('IGS','IGS_GE_END_DT_GE_ST_DATE');
496: IGS_GE_MSG_STACK.ADD;
497: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
498: l_valid := FALSE;
499: END IF;
500: END IF;
501:

Line 510: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WR_DTS_NR');

506: --Added the If condition to check whether l_end_dt or
507: --l_start_dt is Null if Not Log the ErrorMessage to the Log File.
508:
509: IF l_end_dt IS NOT NULL OR l_start_dt IS NOT NULL THEN
510: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WR_DTS_NR');
511: IGS_GE_MSG_STACK.ADD;
512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
513: END IF;
514:

Line 512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

508:
509: IF l_end_dt IS NOT NULL OR l_start_dt IS NOT NULL THEN
510: FND_MESSAGE.SET_NAME('IGS','IGS_FI_WR_DTS_NR');
511: IGS_GE_MSG_STACK.ADD;
512: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
513: END IF;
514:
515: IF l_release_dt IS NULL THEN
516: --Removed the Default Intiallization to Sysdate

Line 518: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_DT');

514:
515: IF l_release_dt IS NULL THEN
516: --Removed the Default Intiallization to Sysdate
517: --and Logged the Error Message and Errored Out
518: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_DT');
519: IGS_GE_MSG_STACK.ADD;
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: l_valid := FALSE;
522: ELSIF TRUNC(l_release_dt) < TRUNC(SYSDATE) THEN

Line 520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

516: --Removed the Default Intiallization to Sysdate
517: --and Logged the Error Message and Errored Out
518: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_DT');
519: IGS_GE_MSG_STACK.ADD;
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: l_valid := FALSE;
522: ELSIF TRUNC(l_release_dt) < TRUNC(SYSDATE) THEN
523: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_CRR_DT');
524: IGS_GE_MSG_STACK.ADD;

Line 523: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_CRR_DT');

519: IGS_GE_MSG_STACK.ADD;
520: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
521: l_valid := FALSE;
522: ELSIF TRUNC(l_release_dt) < TRUNC(SYSDATE) THEN
523: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_CRR_DT');
524: IGS_GE_MSG_STACK.ADD;
525: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
526: l_valid := FALSE;
527: END IF;

Line 525: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

521: l_valid := FALSE;
522: ELSIF TRUNC(l_release_dt) < TRUNC(SYSDATE) THEN
523: FND_MESSAGE.SET_NAME('IGS','IGS_FI_RLS_CRR_DT');
524: IGS_GE_MSG_STACK.ADD;
525: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
526: l_valid := FALSE;
527: END IF;
528: END IF;
529:

Line 540: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

536: FETCH c_cal_per INTO l_v_cal_per;
537:
538: IF c_cal_per%NOTFOUND THEN
539: CLOSE c_cal_per;
540: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
541: IGS_GE_MSG_STACK.ADD;
542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
543: l_valid := FALSE;
544: END IF;

Line 542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

538: IF c_cal_per%NOTFOUND THEN
539: CLOSE c_cal_per;
540: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
541: IGS_GE_MSG_STACK.ADD;
542: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
543: l_valid := FALSE;
544: END IF;
545: CLOSE c_cal_per;
546:

Line 551: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');

547: -- Validation added as part of Bug#2412433
548: /** Validating that the Balance Type is not a STANDARD Balance **/
549:
550: IF p_c_bal_type = 'STANDARD' THEN
551: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
552: IGS_GE_MSG_STACK.ADD;
553: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
554: l_valid := FALSE;
555: END IF;

Line 553: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

549:
550: IF p_c_bal_type = 'STANDARD' THEN
551: FND_MESSAGE.SET_NAME('IGS','IGS_GE_INVALID_VALUE');
552: IGS_GE_MSG_STACK.ADD;
553: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
554: l_valid := FALSE;
555: END IF;
556:
557: --if any of the parameter validation fails,process logs the error messages and error out.

Line 586: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PROC_PERSON');

582: OPEN c_per_id(l_n_party_id);
583: FETCH c_per_id INTO l_v_per_id;
584:
585:
586: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PROC_PERSON');
587: FND_MESSAGE.SET_TOKEN('NUMBER',l_v_per_id.person_number);
588: FND_MESSAGE.SET_TOKEN('NAME',l_v_per_id.full_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590:

Line 587: FND_MESSAGE.SET_TOKEN('NUMBER',l_v_per_id.person_number);

583: FETCH c_per_id INTO l_v_per_id;
584:
585:
586: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PROC_PERSON');
587: FND_MESSAGE.SET_TOKEN('NUMBER',l_v_per_id.person_number);
588: FND_MESSAGE.SET_TOKEN('NAME',l_v_per_id.full_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590:
591: CLOSE c_per_id;

Line 588: FND_MESSAGE.SET_TOKEN('NAME',l_v_per_id.full_name);

584:
585:
586: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PROC_PERSON');
587: FND_MESSAGE.SET_TOKEN('NUMBER',l_v_per_id.person_number);
588: FND_MESSAGE.SET_TOKEN('NAME',l_v_per_id.full_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590:
591: CLOSE c_per_id;
592: /* Removed the logging of subaccount related information, as a part of Bug # 2564643 */

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

585:
586: FND_MESSAGE.SET_NAME('IGS','IGS_FI_PROC_PERSON');
587: FND_MESSAGE.SET_TOKEN('NUMBER',l_v_per_id.person_number);
588: FND_MESSAGE.SET_TOKEN('NAME',l_v_per_id.full_name);
589: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
590:
591: CLOSE c_per_id;
592: /* Removed the logging of subaccount related information, as a part of Bug # 2564643 */
593: l_msg_str := RPAD(lookup_desc('IGS_FI_LOCKBOX','INVOICE_NUMBER'),62) ||

Line 655: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

651: END IF;
652:
653: EXCEPTION
654: WHEN OTHERS THEN
655: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
656: END ;
657:
658: ELSIF p_c_action = 'RELEASE' THEN
659:

Line 727: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;

723: WHEN l_validation_exp THEN
724: retcode := 2;
725: WHEN OTHERS THEN
726: retcode := 2;
727: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION') || ' : ' || SQLERRM;
728: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL ;
729:
730: END group_waiver_proc ; /** procedure ends here **/
731: