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_ENC_CREATE_LINES dependencies on PSP_ENC_CREATE_LINES

Line 1: PACKAGE BODY PSP_ENC_CREATE_LINES AS

1: PACKAGE BODY PSP_ENC_CREATE_LINES AS
2: /* $Header: PSPENLNB.pls 120.83.12020000.9 2013/03/27 00:01:30 lkodaman ship $ */
3:
4: --For Enh Bug 2259310 -Changed the name of the procedure and
5: --the parameter from 100_percent_end_date to enc_org_end_Date

Line 218: g_package_name VARCHAR2(31) DEFAULT 'PSP_ENC_CREATE_LINES.';

214: g_ext_precision NUMBER; -- For Bug 2916848 Ilo Mrc Ehnc.
215:
216: -- Introduced the following for bug fix 3462452
217: --g_debug BOOLEAN DEFAULT hr_utility.debug_enabled;
218: g_package_name VARCHAR2(31) DEFAULT 'PSP_ENC_CREATE_LINES.';
219: -- End of bug fix 3462452
220:
221: g_dff_grouping_option CHAR(1); -- Introduced for bug fix 2908859
222: g_request_id NUMBER(15);

Line 713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');

709: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
710: IF (g_error_message IS NULL) THEN
711: g_error_message := 'OBTAIN_ENC_ORG_END_DATE: ' || SQLERRM;
712: END IF;
713: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'OBTAIN_ENC_ORG_END_DATE');
714: p_return_status := fnd_api.g_ret_sts_unexp_error;
715: return;
716: End obtain_enc_org_end_date;
717:

Line 759: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');

755: IF (g_error_message IS NULL) THEN
756: g_error_message := 'OBTAIN_ENC_POETA_END_DATE: ' || SQLERRM;
757: END IF;
758: g_error_api_path := SUBSTR(' OBTAIN_ENC_POETA_END_DATE:'||g_error_api_path,1,230);
759: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' OBTAIN_ENC_POETA_END_DATE ');
760: p_return_status := fnd_api.g_ret_sts_unexp_error;
761: END obtain_enc_poeta_end_date;
762:
763:

Line 1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');

1532:
1533: p_return_status := fnd_api.g_ret_sts_success;
1534: EXCEPTION
1535: WHEN DIVIDE_BY_ZERO THEN
1536: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_ENC_AMOUNT ');
1537: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
1538: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
1539: p_return_status := fnd_api.g_ret_sts_unexp_error;
1540: WHEN OTHERS THEN

Line 3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');

3363: l_proc_step := 210;
3364: hr_utility.trace(fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3365: EXCEPTION
3366: WHEN suspense_autopop_failed THEN
3367: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES ');
3368: p_return_status := fnd_api.g_ret_sts_unexp_error;
3369: fnd_file.put_line(fnd_file.log, 'l_reason_code: ' || l_reason_code);
3370: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3371: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);

Line 3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');

3373: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
3374: IF (g_error_message IS NULL) THEN
3375: g_error_message := l_proc_name || ': ' || SQLERRM;
3376: END IF;
3377: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LINES');
3378: p_return_status := fnd_api.g_ret_sts_unexp_error;
3379: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
3380: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
3381: END create_lines;

Line 3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');

3860:
3861: EXCEPTION
3862: WHEN DIVIDE_BY_ZERO THEN
3863: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3864: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3865: p_return_status := fnd_api.g_ret_sts_unexp_error;
3866:
3867: WHEN OTHERS THEN
3868: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);

Line 3873: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');

3869: IF (g_error_message IS NULL) THEN
3870: g_error_message := 'DETERMINE_PRO_RATA_DATES: ' || SQLERRM;
3871: END IF;
3872: g_error_api_path := SUBSTR(' DETERMINE_PRO_RATA_DATES'||g_error_api_path,1,230);
3873: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' DETERMINE_PRO_RATA_DATES ');
3874: p_return_status := fnd_api.g_ret_sts_unexp_error;
3875:
3876: END determine_pro_rata_dates;
3877:

Line 4076: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');

4072: IF (g_error_message IS NULL) THEN
4073: g_error_message := 'INSERT_ENC_LINES_FROM_ARRAYS: ' || SQLERRM;
4074: END IF;
4075: g_error_api_path := SUBSTR(' INSERT_ENC_LINES_FROM_ARRAYS:'||g_error_api_path,1,230);
4076: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' INSERT_ENC_LINES_FROM_ARRAYS');
4077: p_return_status := fnd_api.g_ret_sts_unexp_error;
4078: END insert_enc_lines_from_arrays;
4079:
4080: -- Introduced the following procedure for bug fix 3462452

Line 6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');

6575: IF (g_error_message IS NULL) THEN
6576: g_error_message := l_proc_name || ': ' || SQLERRM;
6577: END IF;
6578: g_error_api_path := SUBSTR(' SUB_SLICE_ASG_CHUNK:'||g_error_api_path,1,230);
6579: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' SUB_SLICE_ASG_CHUNK');
6580: p_return_status := fnd_api.g_ret_sts_unexp_error;
6581: fnd_file.put_line(fnd_file.log, fnd_number.number_to_canonical(l_proc_step) || ': ' || l_proc_name);
6582: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ' || l_proc_name);
6583: END sub_slice_asg_chunk;

Line 6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6608: -- spc_track_cel('Init', NULL, 'End');
6609: EXCEPTION
6610: WHEN OTHERS THEN
6611: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6612: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_INIT: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6613: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6614: p_print_header => FND_API.G_TRUE);
6615: END cel_init;
6616:

Line 6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

6737: psp_message_s.print_error (p_mode => FND_FILE.LOG, p_print_header => FND_API.G_FALSE);
6738: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6739: WHEN OTHERS THEN
6740: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
6741: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_RANGE_CODE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
6742: psp_message_s.print_error(p_mode => FND_FILE.LOG,
6743: p_print_header => FND_API.G_TRUE);
6744: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_RANGE_CODE pactid: ' || pactid);
6745: END cel_range_code;

Line 7249: g_package_name := 'PSP_ENC_CREATE_LINES.';

7245: l_business_group_id := FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID');
7246: g_set_of_books_id := l_set_of_books_id;
7247: g_business_group_id := l_business_group_id;
7248: g_enc_line_type := 'U';
7249: g_package_name := 'PSP_ENC_CREATE_LINES.';
7250: g_payroll_action_id := p_payroll_action_id;
7251: g_dff_grouping_option := psp_general.get_enc_dff_grouping_option(l_business_group_id);
7252:
7253: OPEN cel_request_id_cur;

Line 7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

7719: p_information1 => NULL,
7720: p_return_status => l_return_status);
7721: END IF;
7722: END IF;
7723: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CEL_ARCHIVE: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
7724: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
7725: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving CEL_ARCHIVE (payroll_action_id: ' || p_payroll_action_id || ' chunk_number: ' || p_chunk_number ||')');
7726: ROLLBACK TO CEL_ARCHIVE;
7727: RAISE;

Line 8562: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');

8558: IF (g_error_message IS NULL) THEN
8559: g_error_message := 'CREATE_LIQ_LINES: ' || SQLERRM;
8560: END IF;
8561: g_error_api_path := SUBSTR('CREATE_LIQ_LINES:' || g_error_api_path,1,230);
8562: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_LIQ_LINES');
8563: p_return_status := fnd_api.g_ret_sts_unexp_error;
8564: END create_liq_lines;
8565:
8566: PROCEDURE create_sum_lines (p_payroll_action_id IN NUMBER,

Line 8783: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');

8779: IF (g_error_message IS NULL) THEN
8780: g_error_message := 'CREATE_SUM_LINES: ' || SQLERRM;
8781: END IF;
8782: g_error_api_path := SUBSTR('CREATE_SUM_LINES:' || g_error_api_path,1,230);
8783: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'CREATE_SUM_LINES');
8784: p_return_status := fnd_api.g_ret_sts_unexp_error;
8785: END create_sum_lines;
8786:
8787: PROCEDURE enc_pre_process (p_payroll_action_id IN NUMBER,

Line 10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

10058: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10059: IF (g_error_message IS NULL) THEN
10060: g_error_message := 'PSP_ENC_PROCESS: ' || SQLERRM;
10061: END IF;
10062: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ENC_PRE_PROCESS: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10063: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10064: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ENC_PRE_PROCESS
10065: p_payroll_action_id: ' || p_payroll_action_id || '
10066: p_payroll_id: ' || p_payroll_id || '

Line 10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);

10312: retcode := fnd_api.g_ret_sts_success;
10313: EXCEPTION
10314: WHEN OTHERS THEN
10315: fnd_file.put_line(fnd_file.log,DBMS_UTILITY.FORMAT_ERROR_BACKTRACE);
10316: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', 'ROLLBACK_CEL: SQLCODE: ' || fnd_number.number_to_canonical(SQLCODE) || ' SQLERRM: ' || SQLERRM);
10317: psp_message_s.print_error(p_mode => FND_FILE.LOG, p_print_header => FND_API.G_TRUE);
10318: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving ROLLBACK_CEL p_payroll_action_id: ' || p_payroll_action_id);
10319: retcode := fnd_api.g_ret_sts_unexp_error;
10320: END rollback_cel;

Line 11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');

11568: IF (g_error_message IS NULL) THEN
11569: g_error_message := 'LOAD_SCH_HIERARCHY: ' || SQLERRM;
11570: END IF;
11571: g_error_api_path := SUBSTR(' LOAD_SCH_HIERARCHY:'||g_error_api_path,1,230);
11572: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' LOAD_SCH_HIERARCHY');
11573: p_return_status := fnd_api.g_ret_sts_unexp_error;
11574: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' ' || fnd_number.number_to_canonical(l_proc_step) || ': LOAD_SCH_HIERARCHY');
11575: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving LOAD_SCH_HIERARCHY');
11576: END load_sch_hierarchy;

Line 12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');

12139: IF (g_error_message IS NULL) THEN
12140: g_error_message := 'UPDATE_HIERARCHY_DATES: ' || SQLERRM;
12141: END IF;
12142: g_error_api_path := SUBSTR(' UPDATE_HIERARCHY_DATES:'||g_error_api_path,1,230);
12143: fnd_msg_pub.add_exc_msg('PSP_ENC_CREATE_LINES', ' UPDATE_HIERARCHY_DATES');
12144: p_return_status := fnd_api.g_ret_sts_unexp_error;
12145: fnd_file.put_line(fnd_file.log, fnd_date.date_to_canonical(SYSDATE) || ' Leaving UPDATE_HIERARCHY_DATES');
12146: END update_hierarchy_dates;
12147:

Line 12327: END PSP_ENC_CREATE_LINES;

12323: r_gee.acct_type.DELETE;
12324:
12325: END clear_sch_hierarchy;
12326:
12327: END PSP_ENC_CREATE_LINES;