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.PSP_LABOR_DIST dependencies on FND_MSG_PUB

Line 312: fnd_msg_pub.initialize;

308: l_TGL_REVB_ACC_DATE := 'P';
309: end if;
310: close get_tgl_revb_acc_date;
311:
312: fnd_msg_pub.initialize;
313: OPEN payroll_control_cur;
314: LOOP
315: l_total_dr_pay_amount := 0;
316: l_total_cr_pay_amount := 0;

Line 445: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','ADJUSTED_PERCENTAGES');

441: raise fnd_api.g_exc_unexpected_error;
442: end if;
443: exception
444: when others then
445: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','ADJUSTED_PERCENTAGES');
446: raise;
447: end;
448: hr_utility.trace('Close get_adjusted_percentages array_size='||project_id_array.count);
449: l_sum_adj_amount := 0;

Line 636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');

632:
633: WHEN OTHERS THEN
634: ROLLBACK;
635:
636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
639: fnd_msg_pub.add;
640: retcode := 2;

Line 639: fnd_msg_pub.add;

635:
636: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
637: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
638: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
639: fnd_msg_pub.add;
640: retcode := 2;
641: psp_message_s.print_error(p_mode => FND_FILE.LOG,
642: p_print_header => FND_API.G_TRUE);
643: raise;

Line 764: fnd_msg_pub.add;

760: retcode := 0;
761: /*********************************************************************
762: ** Added by Bijoy - 08/06/99 to display error in consurrent log
763: *******************************************************************/
764: fnd_msg_pub.add;
765: psp_message_s.print_success;
766:
767: EXCEPTION
768: WHEN EXCESS_SALARY_FOUND THEN

Line 780: fnd_msg_pub.add;

776: fnd_message.set_token('END_DATE',l_sub_end_dt);
777: /*********************************************************************
778: ** Added by Bijoy - 08/06/99 to display error in consurrent log
779: *******************************************************************/
780: fnd_msg_pub.add;
781: retcode := 2;
782: psp_message_s.print_error(p_mode => FND_FILE.LOG,
783: p_print_header => FND_API.G_TRUE);
784: -- l_dist_message := fnd_message.get;

Line 794: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

790: /*********************************************************************
791: ** Added by Bijoy - 08/06/99 to display error in consurrent log
792: *******************************************************************/
793: g_error_api_path := SUBSTR('CREATE_LINES:'||g_error_api_path,1,230);
794: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
795: p_encoded => FND_API.G_FALSE,
796: p_data => l_msg_data,
797: p_msg_index_out => l_msg_count); */
798:

Line 801: fnd_msg_pub.add;

797: p_msg_index_out => l_msg_count); */
798:
799: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
800: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
801: fnd_msg_pub.add;
802: -- l_dist_message := fnd_message.get;
803:
804: -- errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230);
805: retcode := 2;

Line 813: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');

809: raise; --- for nih sal cap 4304623
810: WHEN OTHERS THEN
811: ROLLBACK;
812: -- g_error_api_path := SUBSTR('CREATE_LINES:'||g_error_api_path,1,230);
813: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
814: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
815: p_encoded => FND_API.G_FALSE,
816: p_data => l_msg_data,
817: p_msg_index_out => l_msg_count); */

Line 814: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,

810: WHEN OTHERS THEN
811: ROLLBACK;
812: -- g_error_api_path := SUBSTR('CREATE_LINES:'||g_error_api_path,1,230);
813: fnd_msg_pub.add_exc_msg('PSP_LABOR_DIST','CREATE_LINES2');
814: /* fnd_msg_pub.get(p_msg_index => FND_MSG_PUB.G_FIRST,
815: p_encoded => FND_API.G_FALSE,
816: p_data => l_msg_data,
817: p_msg_index_out => l_msg_count); */
818:

Line 821: fnd_msg_pub.add;

817: p_msg_index_out => l_msg_count); */
818:
819: fnd_message.set_name('PSP','PSP_LD_BATCH_DISTRIBUTED');
820: fnd_message.set_token('NUMB_BATCHES',l_batch_count);
821: fnd_msg_pub.add;
822: -- l_dist_message := fnd_message.get;
823:
824: /* errbuf := SUBSTR(g_msg || chr(10) || l_msg_data || chr(10) || l_dist_message||chr(10)||chr(10)||g_error_api_path,1,230); */
825: retcode := 2;

Line 1001: fnd_msg_pub.add;

997: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
998: /* Added assignment_number and employee_number inplace of assignment_id*/
999: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1000: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1001: fnd_msg_pub.add;
1002: -- Commented for bug fix 2267098 (return status set in exception)
1003: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
1004: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098
1005:

Line 1350: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GLOBAL_EARNINGS_ELEMENT');

1346: p_return_status := fnd_api.g_ret_sts_unexp_error;
1347:
1348: WHEN OTHERS THEN
1349: g_error_api_path := SUBSTR('GLOBAL_EARNINGS_ELEMENT:'||g_error_api_path,1,230);
1350: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GLOBAL_EARNINGS_ELEMENT');
1351: p_return_status := fnd_api.g_ret_sts_unexp_error;
1352: END;
1353:
1354: ----------------------------- E L E M E N T T Y P E --------------------------------------

Line 1532: fnd_msg_pub.add;

1528: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
1529: /* Added assignment_number and employee_number inplace of assignment_id*/
1530: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
1531: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
1532: fnd_msg_pub.add;
1533: -- Commented for bug fix 2267098 (return status set in exception)
1534: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
1535: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098
1536: END IF;

Line 1889: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ELEMENT_TYPE_HIERARCHY');

1885: p_return_status := fnd_api.g_ret_sts_unexp_error;
1886:
1887: WHEN OTHERS THEN
1888: g_error_api_path := SUBSTR('ELEMENT_TYPE_HIERARCHY:'||g_error_api_path,1,230);
1889: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ELEMENT_TYPE_HIERARCHY');
1890: p_return_status := fnd_api.g_ret_sts_unexp_error;
1891: END;
1892:
1893: ----------------------------- E L E M E N T C L A S S --------------------------------------

Line 2078: fnd_msg_pub.add;

2074: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2075: /* Added assignment_number and employee_number inplace of assignment_id*/
2076: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2077: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2078: fnd_msg_pub.add;
2079: -- Commented for bug fix 2267098 (return status set in exception)
2080: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
2081: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098
2082:

Line 2474: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ELEMENT_CLASS_HIERARCHY');

2470: p_return_status := fnd_api.g_ret_sts_unexp_error;
2471:
2472: WHEN OTHERS THEN
2473: g_error_api_path := SUBSTR('ELEMENT_CLASS_HIERARCHY:'||g_error_api_path,1,230);
2474: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ELEMENT_CLASS_HIERARCHY');
2475: p_return_status := fnd_api.g_ret_sts_unexp_error;
2476:
2477: END;
2478:

Line 2658: fnd_msg_pub.add;

2654: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
2655: /* Added assignment_number and employee_number inplace of assignment_id*/
2656: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
2657: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
2658: fnd_msg_pub.add;
2659: -- Commented for bug fix 2267098 (return status set in exception)
2660: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
2661: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098
2662:

Line 3026: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ASSIGNMENT_HIERARCHY');

3022:
3023: WHEN OTHERS THEN
3024: -- dbms_output.put_line(' asg hiearchy when others ='||sqlerrm);
3025: g_error_api_path := SUBSTR('ASSIGNMENT_HIERARCHY:'||g_error_api_path,1,230);
3026: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ASSIGNMENT_HIERARCHY');
3027: p_return_status := fnd_api.g_ret_sts_unexp_error;
3028:
3029: END;
3030:

Line 3205: fnd_msg_pub.add;

3201: -- fnd_message.set_token('ASSIGNMENT_ID',p_assignment_id); --Commented for bug 2374680
3202: /* Added assignment_number and employee_number inplace of assignment_id*/
3203: fnd_message.set_token('ASSIGNMENT_NUMBER',g_assignment_number);
3204: fnd_message.set_token('EMPLOYEE_NUMBER',g_employee_number);
3205: fnd_msg_pub.add;
3206: -- Commented for bug fix 2267098 (return status set in exception)
3207: -- p_return_status := fnd_api.g_ret_sts_unexp_error;
3208: RAISE fnd_api.g_exc_unexpected_error; -- Introduced for bug 2267098
3209:

Line 3572: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ORG_LABOR_SCHEDULE_HIERARCHY');

3568: p_return_status := fnd_api.g_ret_sts_unexp_error;
3569:
3570: WHEN OTHERS THEN
3571: g_error_api_path := SUBSTR('ORG_LABOR_SCHEDULE_HIERARCHY:'||g_error_api_path,1,230);
3572: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','ORG_LABOR_SCHEDULE_HIERARCHY');
3573: p_return_status := fnd_api.g_ret_sts_unexp_error;
3574: END;
3575:
3576: ------------------------------ D E F A U L T A / C --------------------------------------

Line 3966: fnd_msg_pub.add;

3962:
3963: WHEN DEFAULT_AC_NOT_FOUND THEN
3964: g_error_api_path := SUBSTR('DEFAULT_ACCOUNT:'||g_error_api_path,1,230);
3965: fnd_message.set_name('PSP','PSP_LD_DEFAULT_AC_NOT_SET_UP');
3966: fnd_msg_pub.add;
3967: g_msg := SUBSTR(fnd_message.get,1,230);
3968: --- Next line added by Abhijit as a patch on 7/24/98.
3969: p_proc_executed := 'FALSE';
3970: p_return_status := fnd_api.g_ret_sts_success;

Line 3974: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','DEFAULT_ACCOUNT');

3970: p_return_status := fnd_api.g_ret_sts_success;
3971:
3972: WHEN OTHERS THEN
3973: g_error_api_path := SUBSTR('DEFAULT_ACCOUNT:'||g_error_api_path,1,230);
3974: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','DEFAULT_ACCOUNT');
3975: p_return_status := fnd_api.g_ret_sts_unexp_error;
3976:
3977: END;
3978:

Line 4553: fnd_msg_pub.add;

4549:
4550: WHEN NO_PROFILE_EXISTS THEN
4551: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4552: fnd_message.set_name('PSP','PSP_NO_PROFILE_EXISTS');
4553: fnd_msg_pub.add;
4554: p_return_status := fnd_api.g_ret_sts_unexp_error;
4555:
4556: WHEN NO_VAL_DATE_MATCHES THEN
4557: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);

Line 4561: fnd_msg_pub.add;

4557: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4558: fnd_message.set_name('PSP','PSP_NO_VAL_DATE_MATCHES');
4559: fnd_message.set_token('ORG_NAME',l_organization_name);
4560: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4561: fnd_msg_pub.add;
4562: p_return_status := fnd_api.g_ret_sts_unexp_error;
4563:
4564: WHEN NO_GLOBAL_ACCT_EXISTS THEN
4565: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);

Line 4569: fnd_msg_pub.add;

4565: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4566: fnd_message.set_name('PSP','PSP_NO_GLOBAL_ACCT_EXISTS');
4567: fnd_message.set_token('ORG_NAME',l_organization_name);
4568: fnd_message.set_token('PAYROLL_DATE',p_payroll_start_date);
4569: fnd_msg_pub.add;
4570: p_return_status := fnd_api.g_ret_sts_unexp_error;
4571:
4572: WHEN NO_REC_IN_GMS_AWARDS_V THEN
4573: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);

Line 4575: fnd_msg_pub.add;

4571:
4572: WHEN NO_REC_IN_GMS_AWARDS_V THEN
4573: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4574: fnd_message.set_name('PSP','PSP_NO_REC_IN_GMS_AWARDS_V');
4575: fnd_msg_pub.add;
4576: p_return_status := fnd_api.g_ret_sts_unexp_error;
4577:
4578: WHEN PROJECT_AWARD_NOT_LNKD THEN
4579: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);

Line 4583: fnd_msg_pub.add;

4579: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4580: fnd_message.set_name('PSP','PSP_PROJECT_AWARD_NOT_LINKED');
4581: fnd_message.set_token('PROJECT_NAME',to_char(l_project_id));
4582: fnd_message.set_token('AWARD_NAME',to_char(l_award_id));
4583: fnd_msg_pub.add;
4584: p_return_status := fnd_api.g_ret_sts_unexp_error;
4585:
4586: WHEN SUSPENSE_AC_INVALID THEN
4587: /* Following added for bug 2514611 */

Line 4597: fnd_msg_pub.add;

4593: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
4594: fnd_message.set_token('ORG_NAME',l_organization_name);
4595: fnd_message.set_token('PATC_STATUS',l_patc_status);
4596: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
4597: fnd_msg_pub.add;
4598: p_return_status := fnd_api.g_ret_sts_unexp_error;
4599:
4600: WHEN OTHERS THEN
4601: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);

Line 4602: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','SUSPENSE_ACCOUNT');

4598: p_return_status := fnd_api.g_ret_sts_unexp_error;
4599:
4600: WHEN OTHERS THEN
4601: g_error_api_path := SUBSTR('SUSPENSE_ACCOUNT:'||g_error_api_path,1,230);
4602: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','SUSPENSE_ACCOUNT');
4603: p_return_status := fnd_api.g_ret_sts_unexp_error;
4604:
4605: END;
4606:

Line 5132: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','INSERT_INTO_DISTRIBUTION_LINES');

5128: p_return_status := fnd_api.g_ret_sts_success;
5129: EXCEPTION
5130: WHEN OTHERS THEN
5131: -- dbms_output.put_line('inert into dist lines = '||sqlerrm);
5132: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','INSERT_INTO_DISTRIBUTION_LINES');
5133: p_return_status := fnd_api.g_ret_sts_unexp_error;
5134:
5135: END insert_into_distribution_lines;
5136:

Line 5164: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','INSERT_INTO_AUTOPOP_RESULTS');

5160: p_return_status := fnd_api.g_ret_sts_success;
5161:
5162: EXCEPTION
5163: WHEN OTHERS THEN
5164: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','INSERT_INTO_AUTOPOP_RESULTS');
5165: p_return_status := fnd_api.g_ret_sts_unexp_error;
5166:
5167: END insert_into_autopop_results;
5168:

Line 6058: /*if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then

6054: WHEN OTHERS THEN
6055: -- dbms_output.put_line('error occured d ='||sqlerrm);
6056: g_error_api_path := SUBSTR('GET_DISTRIBUTION LINES:'||g_error_api_path,1,230);
6057:
6058: /*if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6059:
6060: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6061: l_api_name);
6062: end if; */

Line 6060: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,

6056: g_error_api_path := SUBSTR('GET_DISTRIBUTION LINES:'||g_error_api_path,1,230);
6057:
6058: /*if FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) then
6059:
6060: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME,
6061: l_api_name);
6062: end if; */
6063:
6064: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 7313: fnd_msg_pub.add;

7309: fnd_message.set_name('PSP','PSP_NO_EXCESS_ACCOUNT');
7310: fnd_message.set_token('ENAME',l_full_name);
7311: fnd_message.set_token('ASGNUM',l_asg_number);
7312: fnd_message.set_token('DISTDATE',t_dist_date(i));
7313: fnd_msg_pub.add;
7314: raise no_excess_account;
7315: end if;
7316: close generic_excess_act;
7317: close org_excess_act;

Line 7498: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','APPLY_SALARY_CAP');

7494: t_cap_sched_amount.delete;
7495:
7496: exception
7497: when others then
7498: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','APPLY_SALARY_CAP');
7499: raise;
7500: End apply_salary_cap;
7501:
7502: procedure excess_account_autopop(p_payroll_control_id in number,

Line 7789: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','EXCESS_ACCOUNT_AUTOPOP');

7785: end loop;
7786: close autopop_exc_cur;
7787: exception
7788: when others then
7789: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','EXCESS_ACCOUNT_AUTOPOP');
7790: raise;
7791: end excess_account_autopop;
7792: ------------- introduced for 5080403
7793: procedure generic_account_autopop(p_payroll_control_id in number,

Line 8131: fnd_msg_pub.add;

8127: fnd_message.set_token('ASG_NUM',l_asg_num);
8128: fnd_message.set_token('CHARGING_ACCOUNT',l_account);
8129: fnd_message.set_token('AUTOPOP_ERROR',l_auto_status);
8130: fnd_message.set_token('EFF_DATE',l_effective_date);
8131: fnd_msg_pub.add;
8132: raise suspense_autopop_fail;
8133: else
8134: suspense_account(
8135: x_proc_executed,

Line 8217: fnd_msg_pub.add;

8213: fnd_message.set_name('PSP','PSP_LD_SUSPENSE_AC_INVALID');
8214: fnd_message.set_token('ORG_NAME',l_organization_name);
8215: fnd_message.set_token('PATC_STATUS',l_patc_status);
8216: fnd_message.set_token('EMPLOYEE_NAME',l_employee_name); --Bug 2514611
8217: fnd_msg_pub.add;
8218: raise suspense_autopop_fail;
8219: else
8220: update psp_distribution_lines
8221: set auto_expenditure_type = l_new_expenditure_type

Line 8316: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GENERIC_ACCOUNT_AUTOPOP');

8312: t_award_id.delete;
8313: t_gl_code_combination_id.delete;
8314: t_account_id.delete;
8315: close dist_line_cur;
8316: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GENERIC_ACCOUNT_AUTOPOP');
8317: raise;
8318: when others then
8319: if dist_line_cur%isopen then
8320: close dist_line_cur;

Line 8336: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GENERIC_ACCOUNT_AUTOPOP:'||p_schedule_type);

8332: t_award_id.delete;
8333: t_gl_code_combination_id.delete;
8334: t_account_id.delete;
8335: end if;
8336: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','GENERIC_ACCOUNT_AUTOPOP:'||p_schedule_type);
8337: raise;
8338: end generic_account_autopop;
8339: ------------------------------------------
8340:

Line 8574: fnd_msg_pub.add;

8570: psp_general.get_configuration_option_value(g_business_group_id,
8571: 'PSP_GENERIC_EXCESS_ACCT_ORG');
8572: if l_gen_excess_org_id is null then
8573: fnd_message.set_name('PSP','PSP_SET_GEN_EXCESS_ORG');
8574: fnd_msg_pub.add;
8575: l_error_flag := 'Y';
8576: else
8577:
8578: open check_generic_excess(l_begin_dist_date, l_gen_excess_org_id, g_business_group_id);

Line 8585: fnd_msg_pub.add;

8581:
8582: if l_count = 0 then
8583: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8584: fnd_message.set_token('BDATE',l_begin_dist_date);
8585: fnd_msg_pub.add;
8586: l_error_flag := 'Y';
8587: else
8588: open check_generic_excess(l_end_dist_date, l_gen_excess_org_id, g_business_group_id);
8589: fetch check_generic_excess into l_count;

Line 8595: fnd_msg_pub.add;

8591:
8592: if l_count = 0 then
8593: fnd_message.set_name('PSP', 'PSP_SET_GEN_EXCESS_ACNT');
8594: fnd_message.set_token('BDATE',l_end_dist_date);
8595: fnd_msg_pub.add;
8596: l_error_flag := 'Y';
8597: end if;
8598: end if;
8599: end if;

Line 8619: fnd_msg_pub.add;

8615: if l_sponsor_id is null then
8616: l_error_flag := 'Y';
8617: fnd_message.set_name('PSP', 'PSP_MAP_SAL_CAP_SPONSOR');
8618: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8619: fnd_msg_pub.add;
8620: end if;
8621:
8622: open check_salary_cap_exists(l_sponsor_code, l_begin_dist_date);
8623: fetch check_salary_cap_exists into l_count;

Line 8631: fnd_msg_pub.add;

8627: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8628: fnd_message.set_token('XDATE', l_begin_dist_date);
8629: fnd_message.set_token('BDATE', l_begin_dist_date);
8630: fnd_message.set_token('EDATE', l_end_dist_date);
8631: fnd_msg_pub.add;
8632: close check_salary_cap_exists;
8633: else
8634: close check_salary_cap_exists;
8635: open check_salary_cap_exists(l_sponsor_code, l_end_dist_date);

Line 8644: fnd_msg_pub.add;

8640: fnd_message.set_token('SPONSOR_NAME', l_sponsor_name);
8641: fnd_message.set_token('XDATE', l_end_dist_date);
8642: fnd_message.set_token('BDATE', l_begin_dist_date);
8643: fnd_message.set_token('EDATE', l_end_dist_date);
8644: fnd_msg_pub.add;
8645: end if;
8646: close check_salary_cap_exists;
8647: end if;
8648: end loop;

Line 8671: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','RANGE_CODE-NO RECORDS');

8667:
8668: --- comment it
8669: --- fnd_file.put_line(fnd_file.log,' sqlstr ='||sqlstr);
8670: else
8671: fnd_msg_pub.add_exc_msg('PSB_LABOR_DIST','RANGE_CODE-NO RECORDS');
8672: psp_message_s.print_error(p_mode => FND_FILE.LOG,
8673: p_print_header => FND_API.G_TRUE);
8674: raise fnd_api.g_exc_unexpected_error;
8675: end if;