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 1298: fnd_message.raise_error;

1294: debug_others(l_proc_name,l_proc_step);
1295: IF g_debug THEN
1296: debug('Leaving: '||l_proc_name,-999);
1297: END IF;
1298: fnd_message.raise_error;
1299: ELSE
1300: RAISE;
1301: END IF;
1302: END delete_absence_plan_details;

Line 2043: fnd_message.raise_error;

2039: debug('Leaving: '||l_proc_name,-999);
2040: END IF;
2041: -- p_message := SQLERRM;
2042: -- p_error_code := -1;
2043: fnd_message.raise_error;
2044: ELSE
2045: RAISE;
2046: END IF;
2047: END get_plan_extra_info_n_cache_it;

Line 2092: fnd_message.raise_error;

2088: debug('Leaving: '||l_proc_name,-999);
2089: END IF;
2090: -- p_message := SQLERRM;
2091: -- p_error_code := -1;
2092: fnd_message.raise_error;
2093: ELSE
2094: RAISE;
2095: END IF;
2096: END get_param_value;

Line 2184: fnd_message.raise_error;

2180: );
2181: IF g_debug THEN
2182: debug('Leaving: '||l_proc_name,-999);
2183: END IF;
2184: fnd_message.raise_error;
2185: ELSE
2186: RAISE;
2187: END IF;
2188: END get_absence_part_days;

Line 2420: fnd_message.raise_error;

2416: debug('Leaving: '||l_proc_name,-999);
2417: END IF;
2418: -- p_message := SQLERRM;
2419: -- p_error_code := -1;
2420: fnd_message.raise_error;
2421: ELSE
2422: RAISE;
2423: END IF;
2424: END get_absences_taken;

Line 2543: fnd_message.raise_error;

2539: debug('Leaving: '||l_proc_name,-999);
2540: END IF;
2541: -- p_message := SQLERRM;
2542: -- p_error_code := -1;
2543: fnd_message.raise_error;
2544: ELSE
2545: RAISE;
2546: END IF;
2547: END get_adjusted_scheme_start_date;

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

2780: END IF;
2781:
2782: --If exited the loop due to safety cut-off
2783: IF l_cutoff_counter > 100 THEN
2784: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2785: fnd_message.set_token('PROCNAME',l_proc_name);
2786: fnd_message.set_token('PROCSTEP',35);
2787: fnd_message.raise_error;
2788: END IF;

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

2781:
2782: --If exited the loop due to safety cut-off
2783: IF l_cutoff_counter > 100 THEN
2784: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2785: fnd_message.set_token('PROCNAME',l_proc_name);
2786: fnd_message.set_token('PROCSTEP',35);
2787: fnd_message.raise_error;
2788: END IF;
2789:

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

2782: --If exited the loop due to safety cut-off
2783: IF l_cutoff_counter > 100 THEN
2784: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2785: fnd_message.set_token('PROCNAME',l_proc_name);
2786: fnd_message.set_token('PROCSTEP',35);
2787: fnd_message.raise_error;
2788: END IF;
2789:
2790:

Line 2787: fnd_message.raise_error;

2783: IF l_cutoff_counter > 100 THEN
2784: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
2785: fnd_message.set_token('PROCNAME',l_proc_name);
2786: fnd_message.set_token('PROCSTEP',35);
2787: fnd_message.raise_error;
2788: END IF;
2789:
2790:
2791: --

Line 3092: fnd_message.raise_error;

3088: END IF;
3089: -- p_message := SQLERRM;
3090: -- p_error_code := -1;
3091: p_absences_taken_to_date := l_absences_taken_to_date_nc;
3092: fnd_message.raise_error;
3093: ELSE
3094: RAISE;
3095: END IF;
3096: END get_absences_taken_to_date;

Line 3361: fnd_message.raise_error;

3357: END IF;
3358: -- p_message := SQLERRM;
3359: -- p_error_code := -1;
3360: p_entitlements_remaining := l_entitlements_remaining_nc;
3361: fnd_message.raise_error;
3362: ELSE
3363: RAISE;
3364: END IF;
3365: END get_entitlements_remaining;

Line 3447: fnd_message.raise_error;

3443: debug('Leaving: '||l_proc_name,-999);
3444: END IF;
3445: -- p_message := SQLERRM;
3446: -- p_error_code := -1;
3447: fnd_message.raise_error;
3448: ELSE
3449: RAISE;
3450: END IF;
3451: END set_daily_absence_cache;

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

3701: OR negative_value
3702: OR INVALID_NUMBER
3703: THEN
3704:
3705: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3706: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3707: fnd_message.raise_error;
3708:
3709: END;

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

3702: OR INVALID_NUMBER
3703: THEN
3704:
3705: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3706: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3707: fnd_message.raise_error;
3708:
3709: END;
3710: --

Line 3707: fnd_message.raise_error;

3703: THEN
3704:
3705: fnd_message.set_name( 'PQP', 'PQP_230167_OSP_NON_NUM_OFFSET' );
3706: fnd_message.set_token( 'TOKEN1', l_waiting_days_txt);
3707: fnd_message.raise_error;
3708:
3709: END;
3710: --
3711: --

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

4662: debug(l_proc_name, 84);
4663: END IF;
4664:
4665: IF cc = 11 THEN
4666: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4667: fnd_message.set_token('PROCNAME',l_proc_name);
4668: fnd_message.set_token('PROCSTEP',85);
4669: fnd_message.raise_error;
4670: END IF;

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

4663: END IF;
4664:
4665: IF cc = 11 THEN
4666: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4667: fnd_message.set_token('PROCNAME',l_proc_name);
4668: fnd_message.set_token('PROCSTEP',85);
4669: fnd_message.raise_error;
4670: END IF;
4671:

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

4664:
4665: IF cc = 11 THEN
4666: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4667: fnd_message.set_token('PROCNAME',l_proc_name);
4668: fnd_message.set_token('PROCSTEP',85);
4669: fnd_message.raise_error;
4670: END IF;
4671:
4672: END IF;

Line 4669: fnd_message.raise_error;

4665: IF cc = 11 THEN
4666: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4667: fnd_message.set_token('PROCNAME',l_proc_name);
4668: fnd_message.set_token('PROCSTEP',85);
4669: fnd_message.raise_error;
4670: END IF;
4671:
4672: END IF;
4673:

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

4866: debug(l_proc_name, 105);
4867: END IF;
4868:
4869: IF dd = 2001 THEN
4870: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4871: fnd_message.set_token('PROCNAME',l_proc_name);
4872: fnd_message.set_token('PROCSTEP',105);
4873: fnd_message.raise_error;
4874: END IF;

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

4867: END IF;
4868:
4869: IF dd = 2001 THEN
4870: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4871: fnd_message.set_token('PROCNAME',l_proc_name);
4872: fnd_message.set_token('PROCSTEP',105);
4873: fnd_message.raise_error;
4874: END IF;
4875:

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

4868:
4869: IF dd = 2001 THEN
4870: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4871: fnd_message.set_token('PROCNAME',l_proc_name);
4872: fnd_message.set_token('PROCSTEP',105);
4873: fnd_message.raise_error;
4874: END IF;
4875:
4876: IF g_debug THEN

Line 4873: fnd_message.raise_error;

4869: IF dd = 2001 THEN
4870: fnd_message.set_name('PQP','PQP_230011_LOOP_MAX_ITERATIONS');
4871: fnd_message.set_token('PROCNAME',l_proc_name);
4872: fnd_message.set_token('PROCSTEP',105);
4873: fnd_message.raise_error;
4874: END IF;
4875:
4876: IF g_debug THEN
4877: debug_exit(l_proc_name);

Line 4893: fnd_message.raise_error;

4889: debug('Leaving: '||l_proc_name,-999);
4890: END IF;
4891: -- p_message := SQLERRM;
4892: -- p_error_code := -1;
4893: fnd_message.raise_error;
4894: ELSE
4895: RAISE;
4896: END IF;
4897: END generate_daily_absences;

Line 5300: fnd_message.raise_error;

5296: debug('Leaving: '||l_proc_name,-999);
5297: END IF;
5298: -- p_message := SQLERRM;
5299: -- p_error_code := -1;
5300: fnd_message.raise_error;
5301: ELSE
5302: RAISE;
5303: END IF;
5304: END update_absence_plan_details;

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

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

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

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

Line 5648: fnd_message.raise_error;

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

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

5669: OR invalid_length_of_service
5670: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5671: THEN
5672:
5673: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5674: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5675: fnd_message.raise_error;
5676:
5677: END;

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

5670: OR INVALID_NUMBER -- doesn't arise in PL/SQL
5671: THEN
5672:
5673: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5674: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5675: fnd_message.raise_error;
5676:
5677: END;
5678:

Line 5675: fnd_message.raise_error;

5671: THEN
5672:
5673: fnd_message.set_name( 'PQP', 'PQP_230012_OSPOMP_INALID_LOS' );
5674: fnd_message.set_token( 'TOKEN', NVL(l_value,''));
5675: fnd_message.raise_error;
5676:
5677: END;
5678:
5679:

Line 6033: fnd_message.raise_error;

6029: debug('Leaving: '||l_proc_name,-999);
6030: END IF;
6031: -- p_message := SQLERRM;
6032: -- p_error_code := -1;
6033: fnd_message.raise_error;
6034: ELSE
6035: RAISE;
6036: END IF;
6037: END create_absence_plan_details;

Line 6121: fnd_message.raise_error;

6117: );
6118: IF g_debug THEN
6119: debug('Leaving: '||l_proc_name,-999);
6120: END IF;
6121: fnd_message.raise_error;
6122: ELSE
6123: RAISE;
6124: END IF;
6125: END get_contract_level_wp ;

Line 6203: fnd_message.raise_error;

6199: );
6200: IF g_debug THEN
6201: debug('Leaving: '||l_proc_name,-999);
6202: END IF;
6203: fnd_message.raise_error;
6204: ELSE
6205: RAISE;
6206: END IF;
6207: END get_absence_standard_ft_wp ;

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

6243: ,p_override_wp => p_work_pattern
6244: ) ;
6245:
6246: IF l_average_days_per_week <= 0 THEN
6247: fnd_message.set_name( 'PQP', 'PQP_23000_INV_WORK_PATTERN' );
6248: fnd_message.raise_error ;
6249: END IF ;
6250:
6251: IF g_debug THEN

Line 6248: fnd_message.raise_error ;

6244: ) ;
6245:
6246: IF l_average_days_per_week <= 0 THEN
6247: fnd_message.set_name( 'PQP', 'PQP_23000_INV_WORK_PATTERN' );
6248: fnd_message.raise_error ;
6249: END IF ;
6250:
6251: IF g_debug THEN
6252: debug('l_average_days_per_week:'||l_average_days_per_week);

Line 6269: fnd_message.raise_error;

6265: );
6266: IF g_debug THEN
6267: debug('Leaving: '||l_proc_name,-999);
6268: END IF;
6269: fnd_message.raise_error;
6270: ELSE
6271: RAISE;
6272: END IF;
6273:

Line 6335: fnd_message.raise_error;

6331: );
6332: IF g_debug THEN
6333: debug('Leaving: '||l_proc_name,-999);
6334: END IF;
6335: fnd_message.raise_error;
6336: ELSE
6337: RAISE;
6338: END IF;
6339: END get_assignment_work_pattern ;

Line 6573: fnd_message.raise_error;

6569: );
6570: IF g_debug THEN
6571: debug('Leaving: '||l_proc_name,-999);
6572: END IF;
6573: fnd_message.raise_error;
6574: ELSE
6575: RAISE;
6576: END IF;
6577:

Line 6750: fnd_message.raise_error;

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

Line 6819: fnd_message.raise_error;

6815: );
6816: IF g_debug THEN
6817: debug('Leaving: '||l_proc_name,-999);
6818: END IF;
6819: fnd_message.raise_error;
6820: ELSE
6821: RAISE;
6822: END IF;
6823: END convert_entitlements ;