DBA Data[Home] [Help]

APPS.PSP_EFFORTS_PKG dependencies on FND_MESSAGE

Line 235: FND_MESSAGE.set_name('PSP','PSP_EFFORTS_PKG.CRT_POETA_FAIL');

231: ---
232: EXCEPTION
233: WHEN OTHERS THEN
234: --dbms_output.put_line('POETA retrieval failed');
235: FND_MESSAGE.set_name('PSP','PSP_EFFORTS_PKG.CRT_POETA_FAIL');
236: log_errors(template_id1,person_id1,'GL_POETA Selection Criteria failed' ,NULL,NULL);
237: ---RAISE FND_API.g_exc_unexpected_error;
238: END;
239: -----

Line 872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');

868: END IF;
869: ---
870: --- Generate Warning Reports For Normal And Adhoc Both. 4/28/98
871: ---
872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');
873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));

Line 873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));

869: ---
870: --- Generate Warning Reports For Normal And Adhoc Both. 4/28/98
871: ---
872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');
873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));
877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,

Line 874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));

870: --- Generate Warning Reports For Normal And Adhoc Both. 4/28/98
871: ---
872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');
873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));
877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,
878: t_prev_effort_report_id,t_prev_version_num);

Line 875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));

871: ---
872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');
873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));
877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,
878: t_prev_effort_report_id,t_prev_version_num);
879: ELSE

Line 876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));

872: FND_MESSAGE.set_name('PSP','PSP_EFT_REPORT_EXISTS');
873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));
877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,
878: t_prev_effort_report_id,t_prev_version_num);
879: ELSE
880: t_status_code := 'N'; --- See High Level Design Doc.

Line 877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,

873: FND_MESSAGE.set_token('PERSID', to_char(t_PERS_rec.person_id));
874: FND_MESSAGE.set_token('ASSIGN', to_char(t_DIST_row.assignment_id));
875: FND_MESSAGE.set_token('DISTDT', to_char(t_DIST_row.distribution_date,'MM/DD/YY'));
876: FND_MESSAGE.set_token('REPID',to_char(t_DIST_row.effort_report_id));
877: log_errors(a_template_id,t_PERS_rec.person_id,FND_MESSAGE.GET,
878: t_prev_effort_report_id,t_prev_version_num);
879: ELSE
880: t_status_code := 'N'; --- See High Level Design Doc.
881: END IF;

Line 1162: FND_MESSAGE.set_name('PSP','PSP_NO_MATCHING_ELEMENTS');

1158: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1159: retcode := 2; --- in Oracle Applications.
1160: RETURN;
1161: ELSIF g_element_flag = 'N' AND g_dist_flag = 'Y' THEN
1162: FND_MESSAGE.set_name('PSP','PSP_NO_MATCHING_ELEMENTS');
1163: errbuf1 := FND_MESSAGE.get;
1164: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1165: --dbms_output.put_line('The Element Type(s) Are Not Set Up in PSP_EFFORT_REPORT_ELEMENTS' );
1166: retcode := 2;

Line 1163: errbuf1 := FND_MESSAGE.get;

1159: retcode := 2; --- in Oracle Applications.
1160: RETURN;
1161: ELSIF g_element_flag = 'N' AND g_dist_flag = 'Y' THEN
1162: FND_MESSAGE.set_name('PSP','PSP_NO_MATCHING_ELEMENTS');
1163: errbuf1 := FND_MESSAGE.get;
1164: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1165: --dbms_output.put_line('The Element Type(s) Are Not Set Up in PSP_EFFORT_REPORT_ELEMENTS' );
1166: retcode := 2;
1167: ---RETURN;

Line 1169: FND_MESSAGE.set_name('PSP','PSP_NO_DISTRIBUTIONS');

1165: --dbms_output.put_line('The Element Type(s) Are Not Set Up in PSP_EFFORT_REPORT_ELEMENTS' );
1166: retcode := 2;
1167: ---RETURN;
1168: ELSIF g_dist_flag = 'N' THEN
1169: FND_MESSAGE.set_name('PSP','PSP_NO_DISTRIBUTIONS');
1170: errbuf1 := FND_MESSAGE.get;
1171: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1172: --dbms_output.put_line('No Distribution Lines were picked up for chosen criteria' );
1173: retcode := 2;

Line 1170: errbuf1 := FND_MESSAGE.get;

1166: retcode := 2;
1167: ---RETURN;
1168: ELSIF g_dist_flag = 'N' THEN
1169: FND_MESSAGE.set_name('PSP','PSP_NO_DISTRIBUTIONS');
1170: errbuf1 := FND_MESSAGE.get;
1171: errbuf := SUBSTR(errbuf1,1,230); --- More than 230 , it gives value error
1172: --dbms_output.put_line('No Distribution Lines were picked up for chosen criteria' );
1173: retcode := 2;
1174: ---RETURN;

Line 1213: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');

1209: nc := psp_wf_eff_pkg.INIT_WORKFLOW(a_template_id);
1210: -- END IF;
1211: ---------------------------------------------------------------------------------------------------------
1212: IF nc = -1 THEN
1213: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1214: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1215: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1216: errbuf := SUBSTR(errbuf1,1,230);
1217: retcode := 2;

Line 1214: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);

1210: -- END IF;
1211: ---------------------------------------------------------------------------------------------------------
1212: IF nc = -1 THEN
1213: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1214: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1215: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1216: errbuf := SUBSTR(errbuf1,1,230);
1217: retcode := 2;
1218: --dbms_output.put_line('WorkFlow Process Failed :: NO_DATA_FOUND');

Line 1215: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);

1211: ---------------------------------------------------------------------------------------------------------
1212: IF nc = -1 THEN
1213: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1214: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1215: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1216: errbuf := SUBSTR(errbuf1,1,230);
1217: retcode := 2;
1218: --dbms_output.put_line('WorkFlow Process Failed :: NO_DATA_FOUND');
1219: RETURN;

Line 1221: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');

1217: retcode := 2;
1218: --dbms_output.put_line('WorkFlow Process Failed :: NO_DATA_FOUND');
1219: RETURN;
1220: ELSIF nc = -2 THEN
1221: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1222: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1223: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1224: errbuf := SUBSTR(errbuf1,1,230);
1225: retcode := 2;

Line 1222: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);

1218: --dbms_output.put_line('WorkFlow Process Failed :: NO_DATA_FOUND');
1219: RETURN;
1220: ELSIF nc = -2 THEN
1221: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1222: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1223: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1224: errbuf := SUBSTR(errbuf1,1,230);
1225: retcode := 2;
1226: --dbms_output.put_line('Workflow Process Failed :: FATAL ERROR');

Line 1223: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);

1219: RETURN;
1220: ELSIF nc = -2 THEN
1221: FND_MESSAGE.set_name('PSP','PSP_WORKFLOW_FAILED');
1222: ---errbuf1 := SUBSTR(errbuf1 || chr(10) ||FND_MESSAGE.get,1999);
1223: errbuf1 := SUBSTR(FND_MESSAGE.get,1,1999);
1224: errbuf := SUBSTR(errbuf1,1,230);
1225: retcode := 2;
1226: --dbms_output.put_line('Workflow Process Failed :: FATAL ERROR');
1227: RETURN;