933: --
934: p_error_code := l_error_code;
935: --
936: IF l_err_msg_name IS NOT NULL THEN
937: p_error_message := substr(fnd_message.get_string('PQP',l_err_msg_name)
938: ,255 -- Bugfix 3405270
939: );
940: END IF;
941: --
1473:
1474: p_error_code := l_error_code;
1475: --
1476: if l_err_msg_name IS NOT NULL then
1477: p_error_message := substr(fnd_message.get_string('PQP',l_err_msg_name)
1478: ,255 -- Bugfix 3405270
1479: );
1480: end if;
1481:
1643: pqp_utilities.debug('l_value:',l_value);
1644: END IF;
1645:
1646: IF l_value IS NULL THEN
1647: fnd_message.set_name( 'PQP', 'PQP_230138_INV_WORK_PATTERN' );
1648: fnd_message.set_token( 'WORKPATTERN ',l_work_pattern);
1649: fnd_message.raise_error ;
1650: END IF;
1651:
1644: END IF;
1645:
1646: IF l_value IS NULL THEN
1647: fnd_message.set_name( 'PQP', 'PQP_230138_INV_WORK_PATTERN' );
1648: fnd_message.set_token( 'WORKPATTERN ',l_work_pattern);
1649: fnd_message.raise_error ;
1650: END IF;
1651:
1652:
1645:
1646: IF l_value IS NULL THEN
1647: fnd_message.set_name( 'PQP', 'PQP_230138_INV_WORK_PATTERN' );
1648: fnd_message.set_token( 'WORKPATTERN ',l_work_pattern);
1649: fnd_message.raise_error ;
1650: END IF;
1651:
1652:
1653: END IF ;
1670: );
1671: IF g_debug THEN
1672: pqp_utilities.debug('Leaving: '||l_proc_name,-999);
1673: END IF;
1674: fnd_message.raise_error;
1675: ELSE
1676: RAISE;
1677: END IF;
1678:
1758: debug_others(l_proc_name,l_proc_step);
1759: IF g_debug THEN
1760: debug('Leaving: '||l_proc_name,-999);
1761: END IF;
1762: fnd_message.raise_error;
1763: ELSE
1764: RAISE;
1765: END IF;
1766: END get_day_index_for_date;
2204: debug_others(l_proc_name,l_proc_step);
2205: IF g_debug THEN
2206: debug('Leaving: '||l_proc_name,-999);
2207: END IF;
2208: fnd_message.raise_error;
2209: ELSE
2210: RAISE;
2211: END IF;
2212: END load_work_pattern_into_cache;
2349: debug_others(l_proc_name,l_proc_step);
2350: IF g_debug THEN
2351: debug('Leaving: '||l_proc_name,-999);
2352: END IF;
2353: fnd_message.raise_error;
2354: ELSE
2355: RAISE;
2356: END IF;
2357: END add_working_days_using_one_wp;