DBA Data[Home] [Help]

APPS.PQP_ABSVAL_PKG dependencies on FND_MESSAGE

Line 151: fnd_message.set_name( 'PQP', 'PQP_230661_OSP_DUMMY_MSG' );

147: SUBSTRB(SQLERRM,1,2000);
148: IF g_debug THEN
149: debug(l_message);
150: END IF;
151: fnd_message.set_name( 'PQP', 'PQP_230661_OSP_DUMMY_MSG' );
152: fnd_message.set_token( 'TOKEN',l_message);
153: END debug_others;
154: --
155: --

Line 152: fnd_message.set_token( 'TOKEN',l_message);

148: IF g_debug THEN
149: debug(l_message);
150: END IF;
151: fnd_message.set_name( 'PQP', 'PQP_230661_OSP_DUMMY_MSG' );
152: fnd_message.set_token( 'TOKEN',l_message);
153: END debug_others;
154: --
155: --
156: --

Line 424: fnd_message.raise_error;

420: debug_others(l_proc_name,l_proc_step);
421: IF g_debug THEN
422: debug('Leaving: '||l_proc_name,-999);
423: END IF;
424: fnd_message.raise_error;
425: ELSE
426: RAISE;
427: END IF;
428: END get_scheme_start_date;

Line 710: fnd_message.raise_error;

706: );
707: IF g_debug THEN
708: debug('Leaving: '||l_proc_name,-999);
709: END IF;
710: fnd_message.raise_error;
711: ELSE
712: RAISE;
713: END IF;
714: END write_duration_summary ;

Line 814: fnd_message.raise_error;

810: );
811: IF g_debug THEN
812: debug('Leaving: '||l_proc_name,-999);
813: END IF;
814: fnd_message.raise_error;
815: ELSE
816: RAISE;
817: END IF;
818: END create_duration_summary ;

Line 1007: fnd_message.raise_error;

1003: );
1004: IF g_debug THEN
1005: debug('Leaving: '||l_proc_name,-999);
1006: END IF;
1007: fnd_message.raise_error;
1008: ELSE
1009: RAISE;
1010: END IF;
1011: END update_duration_summary ;

Line 1069: fnd_message.raise_error;

1065: );
1066: IF g_debug THEN
1067: debug('Leaving: '||l_proc_name,-999);
1068: END IF;
1069: fnd_message.raise_error;
1070: ELSE
1071: RAISE;
1072: END IF;
1073: END write_absence_summary ;

Line 1277: fnd_message.raise_error;

1273: debug_others(l_proc_name,l_proc_step);
1274: IF g_debug THEN
1275: debug('Leaving: '||l_proc_name,-999);
1276: END IF;
1277: fnd_message.raise_error;
1278: ELSE
1279: RAISE;
1280: END IF;
1281: END delete_absence_plan_details;

Line 2022: fnd_message.raise_error;

2018: debug('Leaving: '||l_proc_name,-999);
2019: END IF;
2020: -- p_message := SQLERRM;
2021: -- p_error_code := -1;
2022: fnd_message.raise_error;
2023: ELSE
2024: RAISE;
2025: END IF;
2026: END get_plan_extra_info_n_cache_it;

Line 2071: fnd_message.raise_error;

2067: debug('Leaving: '||l_proc_name,-999);
2068: END IF;
2069: -- p_message := SQLERRM;
2070: -- p_error_code := -1;
2071: fnd_message.raise_error;
2072: ELSE
2073: RAISE;
2074: END IF;
2075: END get_param_value;

Line 2163: fnd_message.raise_error;

2159: );
2160: IF g_debug THEN
2161: debug('Leaving: '||l_proc_name,-999);
2162: END IF;
2163: fnd_message.raise_error;
2164: ELSE
2165: RAISE;
2166: END IF;
2167: END get_absence_part_days;

Line 2399: fnd_message.raise_error;

2395: debug('Leaving: '||l_proc_name,-999);
2396: END IF;
2397: -- p_message := SQLERRM;
2398: -- p_error_code := -1;
2399: fnd_message.raise_error;
2400: ELSE
2401: RAISE;
2402: END IF;
2403: END get_absences_taken;

Line 2522: fnd_message.raise_error;

2518: debug('Leaving: '||l_proc_name,-999);
2519: END IF;
2520: -- p_message := SQLERRM;
2521: -- p_error_code := -1;
2522: fnd_message.raise_error;
2523: ELSE
2524: RAISE;
2525: END IF;
2526: END get_adjusted_scheme_start_date;

Line 2763: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');

2759: END IF;
2760:
2761: --If exited the loop due to safety cut-off
2762: IF l_cutoff_counter > 100 THEN
2763: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2764: fnd_message.set_token('PROCNAME',l_proc_name);
2765: fnd_message.set_token('PROCSTEP',35);
2766: fnd_message.raise_error;
2767: END IF;

Line 2764: fnd_message.set_token('PROCNAME',l_proc_name);

2760:
2761: --If exited the loop due to safety cut-off
2762: IF l_cutoff_counter > 100 THEN
2763: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2764: fnd_message.set_token('PROCNAME',l_proc_name);
2765: fnd_message.set_token('PROCSTEP',35);
2766: fnd_message.raise_error;
2767: END IF;
2768:

Line 2765: fnd_message.set_token('PROCSTEP',35);

2761: --If exited the loop due to safety cut-off
2762: IF l_cutoff_counter > 100 THEN
2763: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2764: fnd_message.set_token('PROCNAME',l_proc_name);
2765: fnd_message.set_token('PROCSTEP',35);
2766: fnd_message.raise_error;
2767: END IF;
2768:
2769:

Line 2766: fnd_message.raise_error;

2762: IF l_cutoff_counter > 100 THEN
2763: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2764: fnd_message.set_token('PROCNAME',l_proc_name);
2765: fnd_message.set_token('PROCSTEP',35);
2766: fnd_message.raise_error;
2767: END IF;
2768:
2769:
2770: --

Line 3071: fnd_message.raise_error;

3067: END IF;
3068: -- p_message := SQLERRM;
3069: -- p_error_code := -1;
3070: p_absences_taken_to_date := l_absences_taken_to_date_nc;
3071: fnd_message.raise_error;
3072: ELSE
3073: RAISE;
3074: END IF;
3075: END get_absences_taken_to_date;

Line 3340: fnd_message.raise_error;

3336: END IF;
3337: -- p_message := SQLERRM;
3338: -- p_error_code := -1;
3339: p_entitlements_remaining := l_entitlements_remaining_nc;
3340: fnd_message.raise_error;
3341: ELSE
3342: RAISE;
3343: END IF;
3344: END get_entitlements_remaining;

Line 3426: fnd_message.raise_error;

3422: debug('Leaving: '||l_proc_name,-999);
3423: END IF;
3424: -- p_message := SQLERRM;
3425: -- p_error_code := -1;
3426: fnd_message.raise_error;
3427: ELSE
3428: RAISE;
3429: END IF;
3430: END set_daily_absence_cache;

Line 3683: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );

3679: OR negative_value
3680: OR INVALID_NUMBER
3681: THEN
3682:
3683: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3684: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3685: fnd_message.raise_error;
3686:
3687: END;

Line 3684: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);

3680: OR INVALID_NUMBER
3681: THEN
3682:
3683: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3684: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3685: fnd_message.raise_error;
3686:
3687: END;
3688: --

Line 3685: fnd_message.raise_error;

3681: THEN
3682:
3683: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3684: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3685: fnd_message.raise_error;
3686:
3687: END;
3688: --
3689: --

Line 4638: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');

4634: debug(l_proc_name, 84);
4635: END IF;
4636:
4637: IF cc = 11 THEN
4638: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4639: fnd_message.set_token('PROCNAME',l_proc_name);
4640: fnd_message.set_token('PROCSTEP',85);
4641: fnd_message.raise_error;
4642: END IF;

Line 4639: fnd_message.set_token('PROCNAME',l_proc_name);

4635: END IF;
4636:
4637: IF cc = 11 THEN
4638: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4639: fnd_message.set_token('PROCNAME',l_proc_name);
4640: fnd_message.set_token('PROCSTEP',85);
4641: fnd_message.raise_error;
4642: END IF;
4643:

Line 4640: fnd_message.set_token('PROCSTEP',85);

4636:
4637: IF cc = 11 THEN
4638: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4639: fnd_message.set_token('PROCNAME',l_proc_name);
4640: fnd_message.set_token('PROCSTEP',85);
4641: fnd_message.raise_error;
4642: END IF;
4643:
4644: END IF;

Line 4641: fnd_message.raise_error;

4637: IF cc = 11 THEN
4638: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4639: fnd_message.set_token('PROCNAME',l_proc_name);
4640: fnd_message.set_token('PROCSTEP',85);
4641: fnd_message.raise_error;
4642: END IF;
4643:
4644: END IF;
4645:

Line 4842: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');

4838: debug(l_proc_name, 105);
4839: END IF;
4840:
4841: IF dd = 2001 THEN
4842: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4843: fnd_message.set_token('PROCNAME',l_proc_name);
4844: fnd_message.set_token('PROCSTEP',105);
4845: fnd_message.raise_error;
4846: END IF;

Line 4843: fnd_message.set_token('PROCNAME',l_proc_name);

4839: END IF;
4840:
4841: IF dd = 2001 THEN
4842: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4843: fnd_message.set_token('PROCNAME',l_proc_name);
4844: fnd_message.set_token('PROCSTEP',105);
4845: fnd_message.raise_error;
4846: END IF;
4847:

Line 4844: fnd_message.set_token('PROCSTEP',105);

4840:
4841: IF dd = 2001 THEN
4842: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4843: fnd_message.set_token('PROCNAME',l_proc_name);
4844: fnd_message.set_token('PROCSTEP',105);
4845: fnd_message.raise_error;
4846: END IF;
4847:
4848: IF g_debug THEN

Line 4845: fnd_message.raise_error;

4841: IF dd = 2001 THEN
4842: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4843: fnd_message.set_token('PROCNAME',l_proc_name);
4844: fnd_message.set_token('PROCSTEP',105);
4845: fnd_message.raise_error;
4846: END IF;
4847:
4848: IF g_debug THEN
4849: debug_exit(l_proc_name);

Line 4865: fnd_message.raise_error;

4861: debug('Leaving: '||l_proc_name,-999);
4862: END IF;
4863: -- p_message := SQLERRM;
4864: -- p_error_code := -1;
4865: fnd_message.raise_error;
4866: ELSE
4867: RAISE;
4868: END IF;
4869: END generate_daily_absences;

Line 5272: fnd_message.raise_error;

5268: debug('Leaving: '||l_proc_name,-999);
5269: END IF;
5270: -- p_message := SQLERRM;
5271: -- p_error_code := -1;
5272: fnd_message.raise_error;
5273: ELSE
5274: RAISE;
5275: END IF;
5276: END update_absence_plan_details;

Line 5618: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );

5614: OR invalid_length_of_service
5615: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5616: THEN
5617:
5618: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5619: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5620: fnd_message.raise_error;
5621:
5622: END;

Line 5619: fnd_message.set_token( 'TOKEN', NVL(l_value,''));

5615: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5616: THEN
5617:
5618: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5619: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5620: fnd_message.raise_error;
5621:
5622: END;
5623:

Line 5620: fnd_message.raise_error;

5616: THEN
5617:
5618: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5619: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5620: fnd_message.raise_error;
5621:
5622: END;
5623:
5624: BEGIN

Line 5645: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );

5641: OR invalid_length_of_service
5642: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5643: THEN
5644:
5645: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5646: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5647: fnd_message.raise_error;
5648:
5649: END;

Line 5646: fnd_message.set_token( 'TOKEN', NVL(l_value,''));

5642: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5643: THEN
5644:
5645: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5646: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5647: fnd_message.raise_error;
5648:
5649: END;
5650:

Line 5647: fnd_message.raise_error;

5643: THEN
5644:
5645: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5646: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5647: fnd_message.raise_error;
5648:
5649: END;
5650:
5651:

Line 6005: fnd_message.raise_error;

6001: debug('Leaving: '||l_proc_name,-999);
6002: END IF;
6003: -- p_message := SQLERRM;
6004: -- p_error_code := -1;
6005: fnd_message.raise_error;
6006: ELSE
6007: RAISE;
6008: END IF;
6009: END create_absence_plan_details;

Line 6093: fnd_message.raise_error;

6089: );
6090: IF g_debug THEN
6091: debug('Leaving: '||l_proc_name,-999);
6092: END IF;
6093: fnd_message.raise_error;
6094: ELSE
6095: RAISE;
6096: END IF;
6097: END get_contract_level_wp ;

Line 6175: fnd_message.raise_error;

6171: );
6172: IF g_debug THEN
6173: debug('Leaving: '||l_proc_name,-999);
6174: END IF;
6175: fnd_message.raise_error;
6176: ELSE
6177: RAISE;
6178: END IF;
6179: END get_absence_standard_ft_wp ;

Line 6219: fnd_message.set_name( 'PQP', 'PQP_23000_INV_WORK_PATTERN' );

6215: ,p_override_wp => p_work_pattern
6216: ) ;
6217:
6218: IF l_average_days_per_week <= 0 THEN
6219: fnd_message.set_name( 'PQP', 'PQP_23000_INV_WORK_PATTERN' );
6220: fnd_message.raise_error ;
6221: END IF ;
6222:
6223: IF g_debug THEN

Line 6220: fnd_message.raise_error ;

6216: ) ;
6217:
6218: IF l_average_days_per_week <= 0 THEN
6219: fnd_message.set_name( 'PQP', 'PQP_23000_INV_WORK_PATTERN' );
6220: fnd_message.raise_error ;
6221: END IF ;
6222:
6223: IF g_debug THEN
6224: debug('l_average_days_per_week:'||l_average_days_per_week);

Line 6241: fnd_message.raise_error;

6237: );
6238: IF g_debug THEN
6239: debug('Leaving: '||l_proc_name,-999);
6240: END IF;
6241: fnd_message.raise_error;
6242: ELSE
6243: RAISE;
6244: END IF;
6245:

Line 6307: fnd_message.raise_error;

6303: );
6304: IF g_debug THEN
6305: debug('Leaving: '||l_proc_name,-999);
6306: END IF;
6307: fnd_message.raise_error;
6308: ELSE
6309: RAISE;
6310: END IF;
6311: END get_assignment_work_pattern ;

Line 6502: fnd_message.raise_error;

6498: );
6499: IF g_debug THEN
6500: debug('Leaving: '||l_proc_name,-999);
6501: END IF;
6502: fnd_message.raise_error;
6503: ELSE
6504: RAISE;
6505: END IF;
6506:

Line 6679: fnd_message.raise_error;

6675: );
6676: IF g_debug THEN
6677: debug('Leaving: '||l_proc_name,-999);
6678: END IF;
6679: fnd_message.raise_error;
6680: ELSE
6681: RAISE;
6682: END IF;
6683: END get_factors ;

Line 6748: fnd_message.raise_error;

6744: );
6745: IF g_debug THEN
6746: debug('Leaving: '||l_proc_name,-999);
6747: END IF;
6748: fnd_message.raise_error;
6749: ELSE
6750: RAISE;
6751: END IF;
6752: END convert_entitlements ;