DBA Data[Home] [Help]

APPS.QA_SKIPLOT_UTILITY dependencies on QA_SKIPLOT_UTILITY

Line 1: PACKAGE BODY QA_SKIPLOT_UTILITY AS

1: PACKAGE BODY QA_SKIPLOT_UTILITY AS
2: /* $Header: qaslutlb.pls 120.1 2006/02/15 08:43:15 ntungare noship $ */
3:
4: --
5: -- local function

Line 156: p_module_name =>'QA_SKIPLOT_UTILITY.check_date_span',

152: -- this case should not happen
153: --
154: else
155: insert_error_log (
156: p_module_name =>'QA_SKIPLOT_UTILITY.check_date_span',
157: p_error_message => 'Next lotid or next receipt date is null');
158: end if;
159:
160: return fnd_api.g_false;

Line 221: p_module_name =>'QA_SKIPLOT_UTILITY.CHECK_SKIPLOT_AVAILABILITY',

217:
218: WHEN OTHERS THEN
219:
220: insert_error_log (
221: p_module_name =>'QA_SKIPLOT_UTILITY.CHECK_SKIPLOT_AVAILABILITY',
222: p_error_message => 'QA_SKIPLOT_CHECK_AVALIABLITY_ERR',
223: p_comments => SUBSTR (SQLERRM , 1 , 240));
224:
225: return fnd_api.g_false;

Line 415: p_module_name => 'QA_SKIPLOT_UTILITY.FETCH_PLAN_STATE',

411:
412: EXCEPTION
413: WHEN OTHERS THEN
414: insert_error_log (
415: p_module_name => 'QA_SKIPLOT_UTILITY.FETCH_PLAN_STATE',
416: p_error_message => 'fail to fetch plan state',
417: p_comments => SUBSTR (SQLERRM , 1 , 240));
418: APP_EXCEPTION.RAISE_EXCEPTION;
419:

Line 497: p_module_name =>'QA_SKIPLOT_UTILITY.INIT_PLAN_STATE',

493: --
494: -- insert into error log
495: --
496: insert_error_log (
497: p_module_name =>'QA_SKIPLOT_UTILITY.INIT_PLAN_STATE',
498: p_error_message => 'QA_SKIPLOT_INIT_STATE_FAILURE',
499: p_comments => 'process_plan_id or criteria_id not available');
500:
501: fnd_message.set_name ('QA', 'QA_SKIPLOT_INIT_STATE_FAILURE');

Line 559: p_module_name => 'QA_SKIPLOT_UTILITY.INIT_PLAN_STATE',

555:
556: EXCEPTION
557: WHEN OTHERS THEN
558: insert_error_log (
559: p_module_name => 'QA_SKIPLOT_UTILITY.INIT_PLAN_STATE',
560: p_error_message => 'fail to delete and insert initial plan state',
561: p_comments => SUBSTR (SQLERRM , 1 , 240));
562:
563: END INIT_PLAN_STATE;

Line 589: p_module_name => 'QA_SKIPLOT_UTILITY.INIT_PLAN_STATES',

585:
586: EXCEPTION
587: WHEN OTHERS THEN
588: insert_error_log (
589: p_module_name => 'QA_SKIPLOT_UTILITY.INIT_PLAN_STATES',
590: p_error_message => 'fail to update qa_skiplot_plan_states',
591: p_comments => SUBSTR (SQLERRM , 1 , 240));
592: END INIT_PLAN_STATES;
593:

Line 642: p_module_name => 'QA_SKIPLOT_UTILITY.RESET_PLAN_STATES',

638:
639: EXCEPTION
640: WHEN OTHERS THEN
641: insert_error_log (
642: p_module_name => 'QA_SKIPLOT_UTILITY.RESET_PLAN_STATES',
643: p_error_message => 'fail to update qa_skiplot_plan_states',
644: p_comments => SUBSTR (SQLERRM , 1 , 240));
645: END RESET_PLAN_STATES;
646:

Line 901: p_module_name => 'QA_SKIPLOT_UTILITY.UPDATE_PLAN_STATE',

897:
898: EXCEPTION
899: WHEN OTHERS THEN
900: insert_error_log (
901: p_module_name => 'QA_SKIPLOT_UTILITY.UPDATE_PLAN_STATE',
902: p_error_message => 'QA_SKIPLOT_UPDATE_STATE_FAILURE',
903: p_comments => SUBSTR (SQLERRM , 1 , 240));
904:
905: END UPDATE_PLAN_STATE;

Line 1125: p_module_name => 'QA_SKIPLOT_UTILITY.LAUNCH_WORKFLOW',

1121:
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: insert_error_log (
1125: p_module_name => 'QA_SKIPLOT_UTILITY.LAUNCH_WORKFLOW',
1126: p_error_message => 'QA_SKIPLOT_WORKFLOW_FAILURE',
1127: p_comments => SUBSTR (SQLERRM , 1 , 240));
1128:
1129: END LAUNCH_WORKFLOW;

Line 1247: p_module_name => 'QA_SKIPLOT_UTILITY.UPDATE_STATE_HISTORY',

1243:
1244: EXCEPTION
1245: WHEN OTHERS THEN
1246: insert_error_log (
1247: p_module_name => 'QA_SKIPLOT_UTILITY.UPDATE_STATE_HISTORY',
1248: p_error_message => 'QA_SKIPLOT_UPDATE_HISTORY_FAILURE',
1249: p_comments => SUBSTR (SQLERRM , 1 , 240));
1250: END UPDATE_STATE_HISTORY;
1251:

Line 1396: END QA_SKIPLOT_UTILITY;

1392: close pid;
1393: return nvl(proc_id, -1);
1394: END GET_PROCESS_ID;
1395:
1396: END QA_SKIPLOT_UTILITY;
1397: