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.PV_PRGM_APPROVAL_PVT dependencies on FND_MESSAGE

Line 890: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');

886: OPEN c_program_rec (l_program_id);
887: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
888: CLOSE c_program_rec;
889:
890: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');
891: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
892:
893: l_string := SUBSTR(fnd_message.get,1,1000);
894:

Line 891: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

887: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
888: CLOSE c_program_rec;
889:
890: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');
891: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
892:
893: l_string := SUBSTR(fnd_message.get,1,1000);
894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');

Line 893: l_string := SUBSTR(fnd_message.get,1,1000);

889:
890: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');
891: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
892:
893: l_string := SUBSTR(fnd_message.get,1,1000);
894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

Line 895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');

891: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
892:
893: l_string := SUBSTR(fnd_message.get,1,1000);
894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);

892:
893: l_string := SUBSTR(fnd_message.get,1,1000);
894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

893: l_string := SUBSTR(fnd_message.get,1,1000);
894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

Line 898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

894:
895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

Line 899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

895: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO');
896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

896: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
904:

Line 901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

897: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
904:
905:

Line 902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

898: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
904:
905:
906: l_fyi_notification := SUBSTR(l_string

Line 903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

899: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
900: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
901: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
902: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
903: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
904:
905:
906: l_fyi_notification := SUBSTR(l_string
907: || fnd_global.local_chr (10)

Line 1044: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');

1040: OPEN c_program_rec (l_program_id);
1041: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1042: CLOSE c_program_rec;
1043:
1044: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1045: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1046:
1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:

Line 1045: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1041: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1042: CLOSE c_program_rec;
1043:
1044: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1045: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1046:
1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');

Line 1047: l_string := SUBSTR(fnd_message.get,1,1000);

1043:
1044: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1045: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1046:
1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

Line 1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');

1045: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1046:
1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);

1046:
1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1047: l_string := SUBSTR(fnd_message.get,1,1000);
1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

Line 1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

1048:
1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

Line 1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

1049: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REQ');
1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);

Line 1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

1050: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);

Line 1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

1051: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1059:

Line 1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

1052: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1059:
1060:

Line 1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);

1053: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1059:
1060:
1061: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);

1054: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1055: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1056: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1059:
1060:
1061: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1062:

Line 1061: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

1057: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1058: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1059:
1060:
1061: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1062:
1063: -- IF (display_type = 'text/plain') THEN
1064: l_appr_notification := SUBSTR(l_string
1065: || fnd_global.local_chr (10)

Line 1200: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');

1196: OPEN c_program_rec (l_program_id);
1197: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1198: CLOSE c_program_rec;
1199:
1200: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1201: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1202:
1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:

Line 1201: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1197: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1198: CLOSE c_program_rec;
1199:
1200: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1201: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1202:
1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');

Line 1203: l_string := SUBSTR(fnd_message.get,1,1000);

1199:
1200: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1201: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1202:
1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

Line 1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');

1201: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1202:
1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);

1202:
1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1203: l_string := SUBSTR(fnd_message.get,1,1000);
1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

Line 1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

1204:
1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

Line 1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

1205: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_REJ');
1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);

Line 1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

1206: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);

Line 1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

1207: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1215:

Line 1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

1208: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1215:
1216:

Line 1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);

1209: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1215:
1216:
1217: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);

1210: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1211: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1212: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1215:
1216:
1217: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1218:

Line 1217: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

1213: fnd_message.set_token ('APPROVER', l_approver , FALSE);
1214: fnd_message.set_token ('APPR_NOTES', l_approver_notes , FALSE);
1215:
1216:
1217: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1218:
1219: l_rej_notification := SUBSTR(l_string
1220: || fnd_global.local_chr (10)
1221: || l_string1

Line 1352: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');

1348: OPEN c_program_rec (l_program_id);
1349: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1350: CLOSE c_program_rec;
1351:
1352: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1353: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1354:
1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:

Line 1353: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1349: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1350: CLOSE c_program_rec;
1351:
1352: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1353: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1354:
1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');

Line 1355: l_string := SUBSTR(fnd_message.get,1,1000);

1351:
1352: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1353: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1354:
1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);

Line 1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');

1353: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1354:
1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

Line 1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);

1354:
1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

Line 1359: fnd_message.set_token ('URL1', l_url1, FALSE);

1355: l_string := SUBSTR(fnd_message.get,1,1000);
1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 1360: fnd_message.set_token ('URL2', l_url2, FALSE);

1356:
1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1357: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_AP1');
1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

Line 1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

1358: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

Line 1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

1359: fnd_message.set_token ('URL1', l_url1, FALSE);
1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

1360: fnd_message.set_token ('URL2', l_url2, FALSE);
1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1368:

Line 1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

1361: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1368:
1369:

Line 1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

1362: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1368:
1369:
1370: l_appreq_notification := l_string

Line 1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

1363: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1364: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1365: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1366: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1367: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1368:
1369:
1370: l_appreq_notification := l_string
1371: || fnd_global.local_chr (10)

Line 1501: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');

1497: OPEN c_program_rec (l_program_id);
1498: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1499: CLOSE c_program_rec;
1500:
1501: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1502: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1503:
1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:

Line 1502: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1498: FETCH c_program_rec INTO l_program_name,l_level_meaning,l_start_date,l_end_date,l_owner_name,l_program_description, l_company_name;
1499: CLOSE c_program_rec;
1500:
1501: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1502: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1503:
1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');

Line 1504: l_string := SUBSTR(fnd_message.get,1,1000);

1500:
1501: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1502: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1503:
1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);

Line 1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');

1502: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1503:
1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

Line 1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);

1503:
1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

Line 1508: fnd_message.set_token ('URL1', l_url1, FALSE);

1504: l_string := SUBSTR(fnd_message.get,1,1000);
1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 1509: fnd_message.set_token ('URL2', l_url2, FALSE);

1505:
1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

Line 1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

1506: fnd_message.set_name ('PV', 'PV_WF_NTF_PROGRAM_REQ_INFO_RM1');
1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

Line 1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);

1507: fnd_message.set_token ('COMPANY_NAME', l_company_name, FALSE);
1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

Line 1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

1508: fnd_message.set_token ('URL1', l_url1, FALSE);
1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);

1509: fnd_message.set_token ('URL2', l_url2, FALSE);
1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1517:

Line 1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);

1510: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1517:
1518: l_apprem_notification := l_string

Line 1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);

1511: fnd_message.set_token ('PROGRAM_LEVEL', l_level_meaning, FALSE);
1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1517:
1518: l_apprem_notification := l_string
1519: || fnd_global.local_chr (10)

Line 1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

1512: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1513: fnd_message.set_token ('END_DATE', l_end_date, FALSE);
1514: fnd_message.set_token ('OWNER', l_owner_name, FALSE);
1515: fnd_message.set_token ('DESCRIPTION', l_program_description, FALSE);
1516: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1517:
1518: l_apprem_notification := l_string
1519: || fnd_global.local_chr (10)
1520: || l_string1

Line 1639: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');

1635: avalue=> l_approver_seq
1636: );
1637:
1638: --- set all the subjects here
1639: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');
1640: fnd_message.set_token (
1641: 'PROGRAM_NAME',
1642: l_object_details.name,
1643: FALSE

Line 1640: fnd_message.set_token (

1636: );
1637:
1638: --- set all the subjects here
1639: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_FYI_SUB');
1640: fnd_message.set_token (
1641: 'PROGRAM_NAME',
1642: l_object_details.name,
1643: FALSE
1644: );

Line 1647: l_string := fnd_message.get;

1643: FALSE
1644: );
1645:
1646:
1647: l_string := fnd_message.get;
1648: wf_engine.setitemattrtext (
1649: itemtype=> itemtype,
1650: itemkey=> itemkey,
1651: aname => 'FYI_SUBJECT',

Line 1655: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');

1651: aname => 'FYI_SUBJECT',
1652: avalue=> l_string
1653: );
1654:
1655: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1656: fnd_message.set_token ('PROGRAM_NAME', l_object_details.name, FALSE );
1657:
1658: l_string := fnd_message.get;
1659: wf_engine.setitemattrtext (

Line 1656: fnd_message.set_token ('PROGRAM_NAME', l_object_details.name, FALSE );

1652: avalue=> l_string
1653: );
1654:
1655: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1656: fnd_message.set_token ('PROGRAM_NAME', l_object_details.name, FALSE );
1657:
1658: l_string := fnd_message.get;
1659: wf_engine.setitemattrtext (
1660: itemtype=> itemtype,

Line 1658: l_string := fnd_message.get;

1654:
1655: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_APP_SUB');
1656: fnd_message.set_token ('PROGRAM_NAME', l_object_details.name, FALSE );
1657:
1658: l_string := fnd_message.get;
1659: wf_engine.setitemattrtext (
1660: itemtype=> itemtype,
1661: itemkey=> itemkey,
1662: aname => 'APRV_SUBJECT',

Line 1666: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');

1662: aname => 'APRV_SUBJECT',
1663: avalue=> l_string
1664: );
1665:
1666: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1667: fnd_message.set_token ('PROGRAM_NAME',l_object_details.name,FALSE );
1668:
1669: l_string := fnd_message.get;
1670:

Line 1667: fnd_message.set_token ('PROGRAM_NAME',l_object_details.name,FALSE );

1663: avalue=> l_string
1664: );
1665:
1666: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1667: fnd_message.set_token ('PROGRAM_NAME',l_object_details.name,FALSE );
1668:
1669: l_string := fnd_message.get;
1670:
1671: wf_engine.setitemattrtext (

Line 1669: l_string := fnd_message.get;

1665:
1666: fnd_message.set_name ('PV', 'PV_WF_NTF_REQUESTER_REJ_SUB');
1667: fnd_message.set_token ('PROGRAM_NAME',l_object_details.name,FALSE );
1668:
1669: l_string := fnd_message.get;
1670:
1671: wf_engine.setitemattrtext (
1672: itemtype=> itemtype,
1673: itemkey=> itemkey,

Line 1677: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');

1673: itemkey=> itemkey,
1674: aname => 'REJECT_SUBJECT',
1675: avalue=> l_string
1676: );
1677: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1678: fnd_message.set_token (
1679: 'PROGRAM_NAME',
1680: l_object_details.name,
1681: FALSE

Line 1678: fnd_message.set_token (

1674: aname => 'REJECT_SUBJECT',
1675: avalue=> l_string
1676: );
1677: fnd_message.set_name ('PV', 'PV_WF_NTF_APPROVER_OF_REQ_SUB');
1678: fnd_message.set_token (
1679: 'PROGRAM_NAME',
1680: l_object_details.name,
1681: FALSE
1682: );

Line 1684: l_string := fnd_message.get;

1680: l_object_details.name,
1681: FALSE
1682: );
1683:
1684: l_string := fnd_message.get;
1685:
1686: wf_engine.setitemattrtext (
1687: itemtype=> itemtype,
1688: itemkey=> itemkey,

Line 2277: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_SUB');

2273: , aname => 'OBJECT_TYPE'
2274: , avalue => p_object_type
2275: );
2276:
2277: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_SUB');
2278: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2280:
2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);

Line 2278: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);

2274: , avalue => p_object_type
2275: );
2276:
2277: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_SUB');
2278: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2280:
2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2282:

Line 2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);

2275: );
2276:
2277: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_SUB');
2278: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2280:
2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2282:
2283: WF_ENGINE.SetItemAttrText(

Line 2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);

2277: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_SUB');
2278: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2279: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2280:
2281: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2282:
2283: WF_ENGINE.SetItemAttrText(
2284: itemtype => p_itemtype
2285: , itemkey => p_itemkey

Line 2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');

2286: , aname => 'APPR_SUBJECT'
2287: , avalue => l_string_sub
2288: );
2289:
2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');
2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);

Line 2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

2287: , avalue => l_string_sub
2288: );
2289:
2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');
2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);
2295:

Line 2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

2288: );
2289:
2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');
2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);
2295:
2296: WF_ENGINE.SetItemAttrText(

Line 2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);

2289:
2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');
2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);
2295:
2296: WF_ENGINE.SetItemAttrText(
2297: itemtype => p_itemtype

Line 2294: l_string := SUBSTR(fnd_message.get,1,3000);

2290: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_NOTIF_BODY');
2291: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2292: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2293: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2294: l_string := SUBSTR(fnd_message.get,1,3000);
2295:
2296: WF_ENGINE.SetItemAttrText(
2297: itemtype => p_itemtype
2298: , itemkey => p_itemkey

Line 2303: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_SUB');

2299: , aname => 'FYI_BODY'
2300: , avalue => l_string
2301: );
2302:
2303: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_SUB');
2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2307:

Line 2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);

2300: , avalue => l_string
2301: );
2302:
2303: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_SUB');
2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2307:
2308: WF_ENGINE.SetItemAttrText(

Line 2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);

2301: );
2302:
2303: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_SUB');
2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2307:
2308: WF_ENGINE.SetItemAttrText(
2309: itemtype => p_itemtype

Line 2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);

2302:
2303: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_SUB');
2304: fnd_message.set_token ('PROGRAM_NAME', UPPER(l_program_name), FALSE);
2305: fnd_message.set_token ('PARTNER_NAME', UPPER(l_partner_name), FALSE);
2306: l_string_sub := SUBSTR(fnd_message.get,1,1000);
2307:
2308: WF_ENGINE.SetItemAttrText(
2309: itemtype => p_itemtype
2310: , itemkey => p_itemkey

Line 2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');

2311: , aname => 'REMINDER_SUBJECT'
2312: , avalue => l_string_sub
2313: );
2314:
2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');
2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);

Line 2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);

2312: , avalue => l_string_sub
2313: );
2314:
2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');
2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);
2320:

Line 2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);

2313: );
2314:
2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');
2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);
2320:
2321: WF_ENGINE.SetItemAttrText(

Line 2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);

2314:
2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');
2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);
2320:
2321: WF_ENGINE.SetItemAttrText(
2322: itemtype => p_itemtype

Line 2319: l_string := SUBSTR(fnd_message.get,1,3000);

2315: fnd_message.set_name ('PV', 'PV_ENRQ_FYI_REM_BODY');
2316: fnd_message.set_token ('PARTNER_NAME', l_partner_name, FALSE);
2317: fnd_message.set_token ('PROGRAM_NAME', l_program_name, FALSE);
2318: fnd_message.set_token ('ENROLLMENT_TYPE', l_enrollment_type, FALSE);
2319: l_string := SUBSTR(fnd_message.get,1,3000);
2320:
2321: WF_ENGINE.SetItemAttrText(
2322: itemtype => p_itemtype
2323: , itemkey => p_itemkey

Line 3472: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');

3468: from the default approver and so the approval status code is PENDING_DEFAULT
3469: */
3470: l_default_approver_id:= isnumber( FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR') );
3471: IF ( l_default_approver_id is NULL ) THEN
3472: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
3473: FND_MSG_PUB.add;
3474: RAISE FND_API.G_EXC_ERROR;
3475: END IF;
3476:

Line 3905: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_CM');

3901: OPEN is_partner_usr_csr (FND_GLOBAL.USER_ID);
3902: FETCH is_partner_usr_csr INTO l_isPartnerFlag;
3903: CLOSE is_partner_usr_csr;
3904: IF l_isPartnerFlag IS NULL THEN
3905: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_CM');
3906: ELSE
3907: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_PTNR');
3908: END IF;
3909: FND_MSG_PUB.add;

Line 3907: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_PTNR');

3903: CLOSE is_partner_usr_csr;
3904: IF l_isPartnerFlag IS NULL THEN
3905: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_CM');
3906: ELSE
3907: FND_MESSAGE.set_name('PV', 'PV_ENRQ_INCAPPRMSG_TO_PTNR');
3908: END IF;
3909: FND_MSG_PUB.add;
3910: RAISE FND_API.G_EXC_ERROR;
3911: END IF;

Line 4181: FND_MESSAGE.set_name('PV', 'PV_ENRQ_CONTRACT_NOT_SIGNED');

4177: l_allow_appr_wo_contract := FND_PROFILE.VALUE('PV_ALLOW_APPROVAL_WITHOUT_CONTRACT');
4178: IF l_allow_appr_wo_contract <> 'Y' THEN
4179: l_contract_signed:=checkcontract_status(enrl_request_id);
4180: IF l_contract_signed =false THEN
4181: FND_MESSAGE.set_name('PV', 'PV_ENRQ_CONTRACT_NOT_SIGNED');
4182: FND_MSG_PUB.add;
4183: RAISE FND_API.G_EXC_ERROR;
4184: END IF;
4185: END IF;

Line 4191: FND_MESSAGE.set_name('PV', 'PV_CHECKLIST_INCOMPLETE');

4187: --check whther approver has checked alll the checklist items
4188: --depending on the flag set at the program level,raise error if they are not checked.
4189: l_checklistStatus:=checklist_status(enrl_request_id);
4190: IF l_checklistStatus=false THEN
4191: FND_MESSAGE.set_name('PV', 'PV_CHECKLIST_INCOMPLETE');
4192: --FND_MESSAGE.set_token ('CHECKLISTLINK', l_checklistlink, FALSE);
4193: FND_MSG_PUB.add;
4194: RAISE FND_API.G_EXC_ERROR;
4195: END IF;

Line 4192: --FND_MESSAGE.set_token ('CHECKLISTLINK', l_checklistlink, FALSE);

4188: --depending on the flag set at the program level,raise error if they are not checked.
4189: l_checklistStatus:=checklist_status(enrl_request_id);
4190: IF l_checklistStatus=false THEN
4191: FND_MESSAGE.set_name('PV', 'PV_CHECKLIST_INCOMPLETE');
4192: --FND_MESSAGE.set_token ('CHECKLISTLINK', l_checklistlink, FALSE);
4193: FND_MSG_PUB.add;
4194: RAISE FND_API.G_EXC_ERROR;
4195: END IF;
4196:

Line 4393: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');

4389: ELSE --code if approver is deafault approver
4390: l_default_approver_id:= isnumber(FND_PROFILE.VALUE('PV_ENRQ_DEFAULT_APPR'));
4391: IF ( l_default_approver_id is NULL ) THEN
4392:
4393: FND_MESSAGE.set_name('PV', 'PV_ENRQ_APPR_NOT_SET');
4394: FND_MSG_PUB.add;
4395: RAISE FND_API.G_EXC_ERROR;
4396: END IF;
4397: OPEN person_id_csr (l_default_approver_id);

Line 5329: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');

5325: ,p_lookup_code => p_enrq_status
5326: );
5327:
5328: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5329: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5330: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENRQ_REQUEST_STATUS_CODE' );
5331: FND_MESSAGE.set_token('LOOKUP_CODE', p_enrq_status );
5332: RAISE FND_API.G_EXC_ERROR;
5333: END IF;

Line 5330: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENRQ_REQUEST_STATUS_CODE' );

5326: );
5327:
5328: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5329: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5330: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENRQ_REQUEST_STATUS_CODE' );
5331: FND_MESSAGE.set_token('LOOKUP_CODE', p_enrq_status );
5332: RAISE FND_API.G_EXC_ERROR;
5333: END IF;
5334:

Line 5331: FND_MESSAGE.set_token('LOOKUP_CODE', p_enrq_status );

5327:
5328: IF NOT FND_API.to_boolean(l_lookup_exists) THEN
5329: FND_MESSAGE.set_name('PV', 'PV_INVALID_LOOKUP_CODE');
5330: FND_MESSAGE.set_token('LOOKUP_TYPE','PV_ENRQ_REQUEST_STATUS_CODE' );
5331: FND_MESSAGE.set_token('LOOKUP_CODE', p_enrq_status );
5332: RAISE FND_API.G_EXC_ERROR;
5333: END IF;
5334:
5335: -- send thank you notifictaion