DBA Data[Home] [Help]

APPS.IGS_SC_BULK_ASSIGN dependencies on FND_MESSAGE

Line 386: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');

382: fnd_log.string_with_context( fnd_log.level_statement,l_label,l_debug_str, NULL,NULL,NULL,NULL,NULL,NULL);
383: END IF;
384:
385: IF l_status <> 'S' THEN
386: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
387: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
388: RAISE NO_DATA_FOUND;
389: END IF;
390:

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

383: END IF;
384:
385: IF l_status <> 'S' THEN
386: FND_MESSAGE.SET_NAME('IGF','IGF_AW_NO_QUERY');
387: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
388: RAISE NO_DATA_FOUND;
389: END IF;
390:
391: --skpandey, Bug#4937960: Added logic as a part of Literal Fix

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

459: P_Rep_Alumni => null,
460: p_directional_flag => 'F');
461:
462: IF l_return_status IN ('E' , 'U') THEN
463: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
464: RAISE NO_DATA_FOUND;
465: END IF;
466:
467: END IF; -- DUP_ORGUNIT_CHECK_C%NOTFOUND

Line 558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');

554: IF Fnd_User_Check_C%FOUND THEN
555: OPEN get_person_num (r_rec_query.Person_Id);
556: FETCH get_person_num INTO l_person_num;
557: CLOSE get_person_num;
558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');
559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
561: ELSE
562:

Line 559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);

555: OPEN get_person_num (r_rec_query.Person_Id);
556: FETCH get_person_num INTO l_person_num;
557: CLOSE get_person_num;
558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');
559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
561: ELSE
562:
563: /*Now iterate through UserRoles array to insert record into wf_local_user_roles */

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

556: FETCH get_person_num INTO l_person_num;
557: CLOSE get_person_num;
558: FND_MESSAGE.SET_NAME('IGS','IGS_SC_MUL_FND_USER');
559: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
560: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
561: ELSE
562:
563: /*Now iterate through UserRoles array to insert record into wf_local_user_roles */
564: FOR i IN 1..l_usrroles_array.COUNT

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

617: x_return_status => l_return_status,
618: x_return_message => l_return_message);
619: IF l_return_status IN ('E' , 'U') THEN
620:
621: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
622:
623: END IF;
624:
625: ELSE

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

639: x_return_message => l_return_message);
640:
641: IF l_return_status IN ('E' , 'U') THEN
642:
643: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
644: --RAISE NO_DATA_FOUND;
645: END IF;
646: END IF; -- DUP_ROLES_CHK_C%FOUND
647:

Line 657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');

653: ELSE -- Fnd_User_Check_C%FOUND
654: OPEN get_person_num (r_rec_query.Person_Id);
655: FETCH get_person_num INTO l_person_num;
656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;

Line 658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);

654: OPEN get_person_num (r_rec_query.Person_Id);
655: FETCH get_person_num INTO l_person_num;
656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;
662:

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

655: FETCH get_person_num INTO l_person_num;
656: CLOSE get_person_num;
657: FND_MESSAGE.SET_NAME('IGS','IGS_SC_NO_FND_USER');
658: FND_MESSAGE.SET_TOKEN('PERS_NUM',l_person_num);
659: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
660: END IF; /*END of IF of FND_USER */
661: CLOSE Fnd_User_Check_C;
662:
663: END LOOP; -- c_cur_query

Line 691: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

687: P_TURNOFF => 'N'
688: );
689: ROLLBACK;
690: retcode := 2;
691: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
692: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
693:
694: IF Fnd_User_Check_C%isopen then
695: CLOSE Fnd_User_Check_C;

Line 719: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');

715: P_TURNOFF => 'N'
716: );
717: ROLLBACK;
718: retcode := 2;
719: errbuf := FND_MESSAGE.GET_STRING('IGS','IGS_GE_UNHANDLED_EXCEPTION');
720: IGS_GE_MSG_STACK.CONC_EXCEPTION_HNDL;
721:
722: IF Fnd_User_Check_C%isopen then
723: CLOSE Fnd_User_Check_C;