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.AZW_HIER dependencies on FND_MESSAGE

Line 87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

83: WHEN app_exception.application_exception THEN
84: RAISE ;
85: WHEN OTHERS THEN
86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');

Line 88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

84: RAISE ;
85: WHEN OTHERS THEN
86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;

Line 89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

85: WHEN OTHERS THEN
86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END group_hierarchy_tree_not_found;

Line 90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');

86: --DBMS_OUTPUT.PUT_LINE('error: group_hierarchy_tree_not_found: ' || SQLERRM);
87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END group_hierarchy_tree_not_found;
94:

Line 91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');

87: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
88: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
89: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
90: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.group_hierarchy_tree_not_found');
91: fnd_message.set_token('AZW_ERROR_STMT','select count(*) from az_groups');
92: APP_EXCEPTION.RAISE_EXCEPTION;
93: END group_hierarchy_tree_not_found;
94:
95:

Line 137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

133: WHEN app_exception.application_exception THEN
134: RAISE ;
135: WHEN OTHERS THEN
136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

Line 138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

134: RAISE ;
135: WHEN OTHERS THEN
136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
142: APP_EXCEPTION.RAISE_EXCEPTION;

Line 139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

135: WHEN OTHERS THEN
136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
142: APP_EXCEPTION.RAISE_EXCEPTION;
143: END;

Line 140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');

136: --DBMS_OUTPUT.PUT_LINE('error: get_leaf_nodes: ' || SQLERRM);
137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
142: APP_EXCEPTION.RAISE_EXCEPTION;
143: END;
144:

Line 141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

137: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
138: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
139: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
140: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
141: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
142: APP_EXCEPTION.RAISE_EXCEPTION;
143: END;
144:
145: FETCH leaf_node_cursor INTO v_group_id;

Line 154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

150: EXCEPTION
151: WHEN app_exception.application_exception THEN
152: RAISE ;
153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');

Line 155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

151: WHEN app_exception.application_exception THEN
152: RAISE ;
153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');
159: APP_EXCEPTION.RAISE_EXCEPTION;

Line 156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

152: RAISE ;
153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: END get_leaf_nodes;

Line 157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');

153: WHEN OTHERS THEN
154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: END get_leaf_nodes;
161:

Line 158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');

154: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
155: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
156: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
157: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_leaf_nodes');
158: fnd_message.set_token('AZW_ERROR_STMT','CURSOR leaf_node_cursor');
159: APP_EXCEPTION.RAISE_EXCEPTION;
160: END get_leaf_nodes;
161:
162: --

Line 323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

319: EXCEPTION
320: WHEN app_exception.application_exception THEN
321: RAISE;
322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');

Line 324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

320: WHEN app_exception.application_exception THEN
321: RAISE;
322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
328: APP_EXCEPTION.RAISE_EXCEPTION;

Line 325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

321: RAISE;
322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: END;

Line 326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

322: WHEN OTHERS THEN
323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: END;
330: ELSE /* p_sort_by = 'PN' */

Line 327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');

323: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
324: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
325: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
326: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
327: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
328: APP_EXCEPTION.RAISE_EXCEPTION;
329: END;
330: ELSE /* p_sort_by = 'PN' */
331: BEGIN

Line 375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

371:
372: END LOOP;
373: EXCEPTION
374: WHEN OTHERS THEN
375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');

Line 376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

372: END LOOP;
373: EXCEPTION
374: WHEN OTHERS THEN
375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
380: APP_EXCEPTION.RAISE_EXCEPTION;

Line 377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

373: EXCEPTION
374: WHEN OTHERS THEN
375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: END;

Line 378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

374: WHEN OTHERS THEN
375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: END;
382: END IF; /* p_sort_by = 'PH' */

Line 379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');

375: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
376: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
377: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
378: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
379: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn');
380: APP_EXCEPTION.RAISE_EXCEPTION;
381: END;
382: END IF; /* p_sort_by = 'PH' */
383:

Line 389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

385: WHEN app_exception.application_exception THEN
386: RAISE;
387: WHEN OTHERS THEN
388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');

Line 390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

386: RAISE;
387: WHEN OTHERS THEN
388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');
394: APP_EXCEPTION.RAISE_EXCEPTION;

Line 391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

387: WHEN OTHERS THEN
388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');
394: APP_EXCEPTION.RAISE_EXCEPTION;
395:

Line 392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');

388: --DBMS_OUTPUT.PUT_LINE('error: get_process: ' || SQLERRM);
389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');
394: APP_EXCEPTION.RAISE_EXCEPTION;
395:
396: END get_process;

Line 393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');

389: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
390: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
391: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
392: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_process');
393: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn/ph');
394: APP_EXCEPTION.RAISE_EXCEPTION;
395:
396: END get_process;
397:

Line 555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

551: WHEN app_exception.application_exception THEN
552: RAISE;
553: WHEN OTHERS THEN
554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');

Line 556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

552: RAISE;
553: WHEN OTHERS THEN
554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');
560: APP_EXCEPTION.RAISE_EXCEPTION;

Line 557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

553: WHEN OTHERS THEN
554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');
560: APP_EXCEPTION.RAISE_EXCEPTION;
561:

Line 558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');

554: --dbms_output.put_line('*** Error: get_group_hierarchy_tree: ' || SQLERRM);
555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');
560: APP_EXCEPTION.RAISE_EXCEPTION;
561:
562: END get_group_hierarchy_tree;

Line 559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');

555: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
556: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
557: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
558: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy_tree');
559: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_tree_cursor');
560: APP_EXCEPTION.RAISE_EXCEPTION;
561:
562: END get_group_hierarchy_tree;
563:

Line 631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

627: EXCEPTION
628: WHEN app_exception.application_exception THEN
629: RAISE;
630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');

Line 632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

628: WHEN app_exception.application_exception THEN
629: RAISE;
630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;

Line 633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

629: RAISE;
630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: END;

Line 634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

630: WHEN OTHERS THEN
631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: END;
638:

Line 635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');

631: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
632: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
633: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
634: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
635: fnd_message.set_token('AZW_ERROR_STMT','select lookup_code ... from az_groups');
636: APP_EXCEPTION.RAISE_EXCEPTION;
637: END;
638:
639: IF group_hierarchy_tree_not_found(v_node_id) THEN

Line 682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

678: EXCEPTION
679: WHEN app_exception.application_exception THEN
680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

Line 683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

679: WHEN app_exception.application_exception THEN
680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
687: APP_EXCEPTION.RAISE_EXCEPTION;

Line 684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

680: RAISE;
681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
687: APP_EXCEPTION.RAISE_EXCEPTION;
688: END;

Line 685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

681: WHEN OTHERS THEN
682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
687: APP_EXCEPTION.RAISE_EXCEPTION;
688: END;
689: get_process(v_rollup_flag, v_node_id, p_process_status,p_process_phase,

Line 686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

682: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
683: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
684: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
685: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
686: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
687: APP_EXCEPTION.RAISE_EXCEPTION;
688: END;
689: get_process(v_rollup_flag, v_node_id, p_process_status,p_process_phase,
690: p_assigned_user, p_task_status,

Line 745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

741: WHEN app_exception.application_exception THEN
742: RAISE;
743: WHEN OTHERS THEN
744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

742: RAISE;
743: WHEN OTHERS THEN
744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
750: APP_EXCEPTION.RAISE_EXCEPTION;

Line 747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

743: WHEN OTHERS THEN
744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
750: APP_EXCEPTION.RAISE_EXCEPTION;
751: END get_group_hierarchy;

Line 748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');

744: --dbms_output.put_line('*** Error: get_group_hierarchy: ' || SQLERRM);
745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
750: APP_EXCEPTION.RAISE_EXCEPTION;
751: END get_group_hierarchy;
752:

Line 749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

745: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
746: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
747: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
748: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_group_hierarchy');
749: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
750: APP_EXCEPTION.RAISE_EXCEPTION;
751: END get_group_hierarchy;
752:
753:

Line 777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

773: EXCEPTION
774: WHEN app_exception.application_exception THEN
775: RAISE;
776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');

Line 778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

774: WHEN app_exception.application_exception THEN
775: RAISE;
776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;

Line 779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

775: RAISE;
776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END;

Line 780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');

776: WHEN OTHERS THEN
777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END;
784: END IF;

Line 781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');

777: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
778: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
779: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
780: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
781: fnd_message.set_token('AZW_ERROR_STMT','select language_code ... from fnd_languages');
782: APP_EXCEPTION.RAISE_EXCEPTION;
783: END;
784: END IF;
785:

Line 797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

793: EXCEPTION
794: WHEN app_exception.application_exception THEN
795: RAISE;
796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');

Line 798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

794: WHEN app_exception.application_exception THEN
795: RAISE;
796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;

Line 799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

795: RAISE;
796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: END;

Line 800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

796: WHEN OTHERS THEN
797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: END;
804:

Line 801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');

797: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
798: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
799: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
800: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
801: fnd_message.set_token('AZW_ERROR_STMT','select text into v_days from wf_resources');
802: APP_EXCEPTION.RAISE_EXCEPTION;
803: END;
804:
805: BEGIN

Line 816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

812: EXCEPTION
813: WHEN app_exception.application_exception THEN
814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');

Line 817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

813: WHEN app_exception.application_exception THEN
814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;

Line 818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

814: RAISE;
815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;
822: END;

Line 819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

815: WHEN OTHERS THEN
816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;
822: END;
823:

Line 820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');

816: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
817: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
818: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
819: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
820: fnd_message.set_token('AZW_ERROR_STMT','select text into v_done from wf_resources');
821: APP_EXCEPTION.RAISE_EXCEPTION;
822: END;
823:
824: BEGIN

Line 835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: RAISE;
834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');

Line 836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

832: WHEN app_exception.application_exception THEN
833: RAISE;
834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;

Line 837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

833: RAISE;
834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END;

Line 838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

834: WHEN OTHERS THEN
835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END;
842:

Line 839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');

835: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
836: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
837: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
838: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
839: fnd_message.set_token('AZW_ERROR_STMT','select text into v_skip from wf_resources');
840: APP_EXCEPTION.RAISE_EXCEPTION;
841: END;
842:
843: BEGIN

Line 854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

850: EXCEPTION
851: WHEN app_exception.application_exception THEN
852: RAISE;
853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');

Line 855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

851: WHEN app_exception.application_exception THEN
852: RAISE;
853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;

Line 856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

852: RAISE;
853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END;

Line 857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');

853: WHEN OTHERS THEN
854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END;
861: END task_init;

Line 858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');

854: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
855: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
856: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
857: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.tast_init');
858: fnd_message.set_token('AZW_ERROR_STMT','select text into v_priority_display from wf_resources');
859: APP_EXCEPTION.RAISE_EXCEPTION;
860: END;
861: END task_init;
862:

Line 942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

938: EXCEPTION
939: WHEN app_exception.application_exception THEN
940: RAISE;
941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');

Line 943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

939: WHEN app_exception.application_exception THEN
940: RAISE;
941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');
947: APP_EXCEPTION.RAISE_EXCEPTION;

Line 944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

940: RAISE;
941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END;

Line 945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

941: WHEN OTHERS THEN
942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END;
949:

Line 946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');

942: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
943: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
944: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
945: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
946: fnd_message.set_token('AZW_ERROR_STMT','CURSOR root_group_hierarchy_cursor');
947: APP_EXCEPTION.RAISE_EXCEPTION;
948: END;
949:
950: -- get all the remaining hierarchy leaf groups and insert into hierarchy table

Line 983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

979: EXCEPTION
980: WHEN app_exception.application_exception THEN
981: RAISE;
982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');

Line 984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

980: WHEN app_exception.application_exception THEN
981: RAISE;
982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
988: APP_EXCEPTION.RAISE_EXCEPTION;

Line 985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

981: RAISE;
982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989: END;

Line 986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

982: WHEN OTHERS THEN
983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989: END;
990:

Line 987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');

983: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
984: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
985: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
986: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
987: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
988: APP_EXCEPTION.RAISE_EXCEPTION;
989: END;
990:
991: EXCEPTION

Line 995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

991: EXCEPTION
992: WHEN app_exception.application_exception THEN
993: RAISE;
994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');

Line 996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

992: WHEN app_exception.application_exception THEN
993: RAISE;
994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
1000: APP_EXCEPTION.RAISE_EXCEPTION;

Line 997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

993: RAISE;
994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001:

Line 998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');

994: WHEN OTHERS THEN
995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001:
1002: END get_all_group_hierarchy;

Line 999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');

995: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
996: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
997: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
998: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_group_hierarchy');
999: fnd_message.set_token('AZW_ERROR_STMT','CURSOR group_hierarchy_cursor');
1000: APP_EXCEPTION.RAISE_EXCEPTION;
1001:
1002: END get_all_group_hierarchy;
1003:

Line 1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1112: EXCEPTION
1113: WHEN app_exception.application_exception THEN
1114: RAISE;
1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');

Line 1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1113: WHEN app_exception.application_exception THEN
1114: RAISE;
1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
1121: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1114: RAISE;
1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
1121: APP_EXCEPTION.RAISE_EXCEPTION;
1122: END;

Line 1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1115: WHEN OTHERS THEN
1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
1121: APP_EXCEPTION.RAISE_EXCEPTION;
1122: END;
1123:

Line 1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');

1116: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1117: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1118: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1119: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1120: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_ph');
1121: APP_EXCEPTION.RAISE_EXCEPTION;
1122: END;
1123:
1124: ELSE

Line 1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1162: EXCEPTION
1163: WHEN app_exception.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');

Line 1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1163: WHEN app_exception.application_exception THEN
1164: RAISE;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');
1171: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1164: RAISE;
1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172: END;

Line 1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1165: WHEN OTHERS THEN
1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172: END;
1173: END IF;

Line 1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');

1166: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1167: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1168: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1169: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1170: fnd_message.set_token('AZW_ERROR_STMT','CURSOR process_hierarchy_pn_all');
1171: APP_EXCEPTION.RAISE_EXCEPTION;
1172: END;
1173: END IF;
1174:

Line 1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1175: EXCEPTION
1176: WHEN app_exception.application_exception THEN
1177: RAISE;
1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1176: WHEN app_exception.application_exception THEN
1177: RAISE;
1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1184: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1177: RAISE;
1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1184: APP_EXCEPTION.RAISE_EXCEPTION;
1185:

Line 1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');

1178: WHEN OTHERS THEN
1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1184: APP_EXCEPTION.RAISE_EXCEPTION;
1185:
1186: END get_all_process;

Line 1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

1179: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1180: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1181: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1182: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_process');
1183: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1184: APP_EXCEPTION.RAISE_EXCEPTION;
1185:
1186: END get_all_process;
1187:

Line 1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1407: EXCEPTION
1408: WHEN app_exception.application_exception THEN
1409: RAISE;
1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');

Line 1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1408: WHEN app_exception.application_exception THEN
1409: RAISE;
1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');
1416: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1409: RAISE;
1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');
1416: APP_EXCEPTION.RAISE_EXCEPTION;
1417: END;

Line 1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1410: WHEN OTHERS THEN
1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');
1416: APP_EXCEPTION.RAISE_EXCEPTION;
1417: END;
1418: END IF;

Line 1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');

1411: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1412: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1413: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1414: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1415: fnd_message.set_token('AZW_ERROR_STMT','while inserting task to hierarchy table');
1416: APP_EXCEPTION.RAISE_EXCEPTION;
1417: END;
1418: END IF;
1419: END IF;

Line 1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1433: EXCEPTION
1434: WHEN app_exception.application_exception THEN
1435: RAISE;
1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');

Line 1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1434: WHEN app_exception.application_exception THEN
1435: RAISE;
1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');
1442: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1435: RAISE;
1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;

Line 1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1436: WHEN OTHERS THEN
1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:

Line 1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');

1437: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1438: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1439: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1440: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1441: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_tasks_cursor');
1442: APP_EXCEPTION.RAISE_EXCEPTION;
1443: END;
1444:
1445: FETCH az_item_types

Line 1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1450: EXCEPTION
1451: WHEN app_exception.application_exception THEN
1452: RAISE;
1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');

Line 1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1451: WHEN app_exception.application_exception THEN
1452: RAISE;
1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');
1459: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1452: RAISE;
1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460:

Line 1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');

1453: WHEN OTHERS THEN
1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460:
1461: END get_all_task;

Line 1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');

1454: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1455: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1456: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1457: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_all_task');
1458: fnd_message.set_token('AZW_ERROR_STMT','While looping in CURSOR az_item_types');
1459: APP_EXCEPTION.RAISE_EXCEPTION;
1460:
1461: END get_all_task;
1462:

Line 1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1537: EXCEPTION
1538: WHEN app_exception.application_exception THEN
1539: RAISE;
1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');

Line 1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1538: WHEN app_exception.application_exception THEN
1539: RAISE;
1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1539: RAISE;
1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;
1547: END;

Line 1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');

1540: WHEN OTHERS THEN
1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;
1547: END;
1548:

Line 1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');

1541: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1542: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1543: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1544: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1545: fnd_message.set_token('AZW_ERROR_STMT','select language_code .. from fnd_languages');
1546: APP_EXCEPTION.RAISE_EXCEPTION;
1547: END;
1548:
1549: -- initialize the language specific display labels for task's label

Line 1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1611: EXCEPTION
1612: WHEN app_exception.application_exception THEN
1613: RAISE;
1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');

Line 1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1612: WHEN app_exception.application_exception THEN
1613: RAISE;
1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');
1620: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1613: RAISE;
1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END;

Line 1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');

1614: WHEN OTHERS THEN
1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END;
1622:

Line 1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');

1615: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1616: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1617: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1618: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1619: fnd_message.set_token('AZW_ERROR_STMT','CURSOR get_context_types_c');
1620: APP_EXCEPTION.RAISE_EXCEPTION;
1621: END;
1622:
1623: -- Now insert processes/tasks for each their respective context

Line 1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1646: EXCEPTION
1647: WHEN app_exception.application_exception THEN
1648: RAISE;
1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

Line 1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1647: WHEN app_exception.application_exception THEN
1648: RAISE;
1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
1655: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1648: RAISE;
1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
1655: APP_EXCEPTION.RAISE_EXCEPTION;
1656: END;

Line 1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');

1649: WHEN OTHERS THEN
1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
1655: APP_EXCEPTION.RAISE_EXCEPTION;
1656: END;
1657:

Line 1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');

1650: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1651: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1652: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1653: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1654: fnd_message.set_token('AZW_ERROR_STMT','insert into az_webform_messages');
1655: APP_EXCEPTION.RAISE_EXCEPTION;
1656: END;
1657:
1658: EXCEPTION

Line 1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1659: WHEN app_exception.application_exception THEN
1660: RAISE;
1661: WHEN OTHERS THEN
1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);
1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1660: RAISE;
1661: WHEN OTHERS THEN
1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);
1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1668: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1661: WHEN OTHERS THEN
1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);
1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1668: APP_EXCEPTION.RAISE_EXCEPTION;
1669:

Line 1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');

1662: --DBMS_OUTPUT.PUT_LINE('error: get_hierarchy: ' || SQLERRM);
1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1668: APP_EXCEPTION.RAISE_EXCEPTION;
1669:
1670: END get_hierarchy;

Line 1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

1663: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1664: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1665: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1666: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_hierarchy');
1667: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1668: APP_EXCEPTION.RAISE_EXCEPTION;
1669:
1670: END get_hierarchy;
1671:

Line 1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1714: END LOOP;
1715: EXCEPTION
1716: WHEN OTHERS THEN
1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);
1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1715: EXCEPTION
1716: WHEN OTHERS THEN
1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);
1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1723: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1716: WHEN OTHERS THEN
1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);
1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1723: APP_EXCEPTION.RAISE_EXCEPTION;
1724: END insert_proc_task_for_context;

Line 1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');

1717: --DBMS_OUTPUT.PUT_LINE('error: insert_proc_task_for_context: ' || SQLERRM);
1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1723: APP_EXCEPTION.RAISE_EXCEPTION;
1724: END insert_proc_task_for_context;
1725:

Line 1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

1718: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1719: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1720: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1721: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_proc_task_for_context');
1722: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1723: APP_EXCEPTION.RAISE_EXCEPTION;
1724: END insert_proc_task_for_context;
1725:
1726: /*---------------------------------------------------------------

Line 1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1787: END IF;
1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);
1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1788: EXCEPTION
1789: WHEN OTHERS THEN
1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);
1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1796: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1789: WHEN OTHERS THEN
1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);
1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1796: APP_EXCEPTION.RAISE_EXCEPTION;
1797: END insert_context;

Line 1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');

1790: --DBMS_OUTPUT.PUT_LINE('error: insert_context: ' || SQLERRM);
1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1796: APP_EXCEPTION.RAISE_EXCEPTION;
1797: END insert_context;
1798:

Line 1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

1791: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1792: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1793: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1794: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_context');
1795: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1796: APP_EXCEPTION.RAISE_EXCEPTION;
1797: END insert_context;
1798:
1799:

Line 1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1880: END LOOP;
1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

Line 1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1881: EXCEPTION
1882: WHEN OTHERS THEN
1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1889: APP_EXCEPTION.RAISE_EXCEPTION;

Line 1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1882: WHEN OTHERS THEN
1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890: END insert_groups_for_context;

Line 1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');

1883: --DBMS_OUTPUT.PUT_LINE('AZW_HIER.insert_groups_for_context: ' || SQLERRM);
1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890: END insert_groups_for_context;
1891:

Line 1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');

1884: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1885: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1886: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1887: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.insert_groups_for_context');
1888: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
1889: APP_EXCEPTION.RAISE_EXCEPTION;
1890: END insert_groups_for_context;
1891:
1892: /*---------------------------------------------------------------

Line 1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');

1917: END LOOP;
1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');

Line 1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

1918:
1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;

Line 1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);

1919: EXCEPTION
1920: WHEN OTHERS THEN
1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:

Line 1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');

1920: WHEN OTHERS THEN
1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:
1928: END AZW_HIER;

Line 1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');

1921: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
1922: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
1923: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
1924: fnd_message.set_token('AZW_ERROR_PROC','azw_hier.get_context');
1925: fnd_message.set_token('AZW_ERROR_STMT','cursor select from az_processes ');
1926: END get_context;
1927:
1928: END AZW_HIER;