DBA Data[Home] [Help]

APPS.AZW_UTIL dependencies on APP_EXCEPTION

Line 51: WHEN app_exception.application_exception THEN

47: from wf_process_activities
48: where process_item_type = p_itemtype
49: and process_name = p_workflow;
50: EXCEPTION
51: WHEN app_exception.application_exception THEN
52: RAISE ;
53: WHEN OTHERS THEN
54: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 59: APP_EXCEPTION.RAISE_EXCEPTION;

55: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
56: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
57: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
58: fnd_message.set_token('AZW_ERROR_STMT','select process_version from wf_process_activities');
59: APP_EXCEPTION.RAISE_EXCEPTION;
60: END;
61:
62: OPEN c_act_c;
63: FETCH c_act_c into act_itemtype, act_name;

Line 72: WHEN app_exception.application_exception THEN

68: where item_type = act_itemtype
69: and name = act_name
70: and end_date is NULL;
71: EXCEPTION
72: WHEN app_exception.application_exception THEN
73: RAISE ;
74: WHEN OTHERS THEN
75: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 80: APP_EXCEPTION.RAISE_EXCEPTION;

76: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
77: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
78: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
79: fnd_message.set_token('AZW_ERROR_STMT','select type from wf_activities');
80: APP_EXCEPTION.RAISE_EXCEPTION;
81: END;
82:
83: if (act_type = 'NOTICE') then
84: BEGIN

Line 91: WHEN app_exception.application_exception THEN

87: where item_type = act_itemtype
88: and name = act_name
89: and end_date is NULL;
90: EXCEPTION
91: WHEN app_exception.application_exception THEN
92: RAISE ;
93: WHEN OTHERS THEN
94: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 99: APP_EXCEPTION.RAISE_EXCEPTION;

95: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
96: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
97: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
98: fnd_message.set_token('AZW_ERROR_STMT','select message from wf_activities');
99: APP_EXCEPTION.RAISE_EXCEPTION;
100: END;
101:
102: BEGIN
103: OPEN c_apps_c;

Line 107: WHEN app_exception.application_exception THEN

103: OPEN c_apps_c;
104: FETCH c_apps_c into app_short_name;
105: CLOSE c_apps_c;
106: EXCEPTION
107: WHEN app_exception.application_exception THEN
108: RAISE ;
109: WHEN OTHERS THEN
110: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 115: APP_EXCEPTION.RAISE_EXCEPTION;

111: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
112: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
113: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
114: fnd_message.set_token('AZW_ERROR_STMT','cursor c_apps_c');
115: APP_EXCEPTION.RAISE_EXCEPTION;
116: END;
117:
118: BEGIN
119: OPEN c_target_c;

Line 123: WHEN app_exception.application_exception THEN

119: OPEN c_target_c;
120: FETCH c_target_c into target;
121: CLOSE c_target_c;
122: EXCEPTION
123: WHEN app_exception.application_exception THEN
124: RAISE ;
125: WHEN OTHERS THEN
126: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 131: APP_EXCEPTION.RAISE_EXCEPTION;

127: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
128: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
129: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
130: fnd_message.set_token('AZW_ERROR_STMT','cursor c_target_c');
131: APP_EXCEPTION.RAISE_EXCEPTION;
132: END;
133:
134: url := fnd_help.get_url(app_short_name, target);
135:

Line 143: WHEN app_exception.application_exception THEN

139: where message_type = act_itemtype
140: and message_name = mesg_name
141: and name = 'AZW_IA_DOC';
142: EXCEPTION
143: WHEN app_exception.application_exception THEN
144: RAISE ;
145: WHEN OTHERS THEN
146: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 151: APP_EXCEPTION.RAISE_EXCEPTION;

147: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
148: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
149: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
150: fnd_message.set_token('AZW_ERROR_STMT','update wf_message_attribute');
151: APP_EXCEPTION.RAISE_EXCEPTION;
152: END;
153: end if;
154:
155: FETCH c_act_c into act_itemtype, act_name;

Line 160: WHEN app_exception.application_exception THEN

156: end loop;
157: CLOSE c_act_c;
158:
159: EXCEPTION
160: WHEN app_exception.application_exception THEN
161: RAISE ;
162: WHEN OTHERS THEN
163: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 168: APP_EXCEPTION.RAISE_EXCEPTION;

164: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
165: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
166: fnd_message.set_token('AZW_ERROR_PROC','azw_util.UpdateDocUrl');
167: fnd_message.set_token('AZW_ERROR_STMT','cursor c_act_c');
168: APP_EXCEPTION.RAISE_EXCEPTION;
169: End UpdateDocUrl;
170:
171: -- IsProductInstalled
172: -- Called by workflow engine in branching functions activities.

Line 203: WHEN app_exception.application_exception THEN

199: else
200: result := no_result;
201: end if;
202: EXCEPTION
203: WHEN app_exception.application_exception THEN
204: RAISE ;
205: WHEN OTHERS THEN
206: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 211: APP_EXCEPTION.RAISE_EXCEPTION;

207: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
208: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
209: fnd_message.set_token('AZW_ERROR_PROC','azw_util.IsProductInstalled');
210: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
211: APP_EXCEPTION.RAISE_EXCEPTION;
212: END IsProductInstalled;
213:
214: -- CheckProduct
215: -- Called by IsProcessRunnable

Line 348: APP_EXCEPTION.RAISE_EXCEPTION;

344: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
345: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
346: fnd_message.set_token('AZW_ERROR_PROC','azw_util.validate_opm_context');
347: fnd_message.set_token('AZW_ERROR_STMT','UNKNOWN');
348: APP_EXCEPTION.RAISE_EXCEPTION;
349:
350: END validate_opm_context;
351:
352:

Line 478: APP_EXCEPTION.RAISE_EXCEPTION;

474: fnd_message.set_token('AZWCURTYPE', context_type);
475: fnd_message.set_token('AZWCURCTXT', context);
476: fnd_message.set_token('AZWDESTYPE', context_type);
477: fnd_message.set_token('AZWDESCTXT', context_name);
478: APP_EXCEPTION.RAISE_EXCEPTION;
479:
480: END CheckContext;
481:
482: -- Callback

Line 500: WHEN app_exception.application_exception THEN

496: CheckContext(itemtype, itemkey, result);
497: end if;
498:
499: EXCEPTION
500: WHEN app_exception.application_exception THEN
501: RAISE ;
502: WHEN OTHERS THEN
503: fnd_message.set_name('AZ','AZW_PLSQL_EXCEPTION');
504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);

Line 508: APP_EXCEPTION.RAISE_EXCEPTION;

504: fnd_message.set_token('AZW_ERROR_CODE',SQLCODE);
505: fnd_message.set_token('AZW_ERROR_MESG',SQLERRM);
506: fnd_message.set_token('AZW_ERROR_PROC','azw_util.Callback');
507: fnd_message.set_token('AZW_ERROR_STMT','Call to CheckContext');
508: APP_EXCEPTION.RAISE_EXCEPTION;
509: END Callback;
510:
511: -- PreviousStep
512: -- Called by notification form