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.SOA_GENERATE dependencies on WF_CORE

Line 180: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');

176:
177: begin
178: if (p_base_class_id is null ) then
179: p_err_code := -1;
180: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');
181: raise program_exit;
182: end if;
183:
184: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 198: wf_core.token('BaseClassId',p_base_class_id);

194: close c_class_name;
195:
196: if c_class_rec.l_count = 0 then
197: p_err_code := -1;
198: wf_core.token('BaseClassId',p_base_class_id);
199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
200: raise program_exit;
201: end if;
202:

Line 199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

195:
196: if c_class_rec.l_count = 0 then
197: p_err_code := -1;
198: wf_core.token('BaseClassId',p_base_class_id);
199: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
200: raise program_exit;
201: end if;
202:
203: for c1 in c_methods(p_base_class_id)

Line 221: wf_core.token('BaseClassId',p_base_class_id);

217: when program_exit then
218: raise program_exit;
219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

Line 222: wf_core.token('BaseClassName', p_base_class_name);

218: raise program_exit;
219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;

Line 223: wf_core.token('FunctionId',c1.function_id);

219: when others then
220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;

Line 224: wf_core.token('SqlErr',SQLERRM);

220: p_err_code := -1;
221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;
228:

Line 225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

221: wf_core.token('BaseClassId',p_base_class_id);
222: wf_core.token('BaseClassName', p_base_class_name);
223: wf_core.token('FunctionId',c1.function_id);
224: wf_core.token('SqlErr',SQLERRM);
225: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
226: raise program_exit;
227: end;
228:
229: end loop;

Line 231: wf_core.token('BaseClassId',p_base_class_id);

227: end;
228:
229: end loop;
230:
231: wf_core.token('BaseClassId',p_base_class_id);
232: wf_core.token('BaseClassName', p_base_class_name);
233: if (method_count = 0 ) then
234: p_err_code := -1;
235: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

Line 232: wf_core.token('BaseClassName', p_base_class_name);

228:
229: end loop;
230:
231: wf_core.token('BaseClassId',p_base_class_id);
232: wf_core.token('BaseClassName', p_base_class_name);
233: if (method_count = 0 ) then
234: p_err_code := -1;
235: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
236: elsif ( method_count > 0 ) then

Line 235: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

231: wf_core.token('BaseClassId',p_base_class_id);
232: wf_core.token('BaseClassName', p_base_class_name);
233: if (method_count = 0 ) then
234: p_err_code := -1;
235: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
236: elsif ( method_count > 0 ) then
237: p_err_code := 0;
238: p_err_message := wf_core.translate('WF_WS_SUCCESS');
239: end if;

Line 238: p_err_message := wf_core.translate('WF_WS_SUCCESS');

234: p_err_code := -1;
235: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
236: elsif ( method_count > 0 ) then
237: p_err_code := 0;
238: p_err_message := wf_core.translate('WF_WS_SUCCESS');
239: end if;
240:
241: exception
242: when program_exit then

Line 246: wf_core.token('BaseClassId',p_base_class_id);

242: when program_exit then
243: null;
244: when others then
245: p_err_code := -1;
246: wf_core.token('BaseClassId',p_base_class_id);
247: wf_core.token('BaseClassName', p_base_class_name);
248: wf_core.token('SqlErr',SQLERRM);
249: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
250: end create_class_derived_entry;

Line 247: wf_core.token('BaseClassName', p_base_class_name);

243: null;
244: when others then
245: p_err_code := -1;
246: wf_core.token('BaseClassId',p_base_class_id);
247: wf_core.token('BaseClassName', p_base_class_name);
248: wf_core.token('SqlErr',SQLERRM);
249: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
250: end create_class_derived_entry;
251:

Line 248: wf_core.token('SqlErr',SQLERRM);

244: when others then
245: p_err_code := -1;
246: wf_core.token('BaseClassId',p_base_class_id);
247: wf_core.token('BaseClassName', p_base_class_name);
248: wf_core.token('SqlErr',SQLERRM);
249: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
250: end create_class_derived_entry;
251:
252:

Line 249: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');

245: p_err_code := -1;
246: wf_core.token('BaseClassId',p_base_class_id);
247: wf_core.token('BaseClassName', p_base_class_name);
248: wf_core.token('SqlErr',SQLERRM);
249: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
250: end create_class_derived_entry;
251:
252:
253: /**

Line 303: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

299:
300:
301: if ( (p_base_class_id is null) or (p_base_function_id is null)) then
302: p_err_code := -1;
303: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
304: raise program_exit;
305: end if;
306:
307:

Line 319: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

315: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'Base Class ID='||p_base_class_id||' does not exist');
316: end if;
317:
318: p_err_code := -1;
319: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
320: raise program_exit;
321:
322: elsif c_base_class_entry%FOUND then
323:

Line 340: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');

336: end if;
337:
338: if ( c_base_function_entry_rec.irep_class_id <> p_base_class_id ) then
339: p_err_code :=-1;
340: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');
341: raise program_exit;
342: end if;
343:
344: if ( c_base_class_entry_rec.scope_type = 'PUBLIC' AND c_base_function_entry_rec.irep_scope = 'PUBLIC' ) then

Line 360: p_err_message := wf_core.translate('WF_WS_XMLG_OUTBOUND');

356: end if;
357:
358:
359: p_err_code :=-1;
360: p_err_message := wf_core.translate('WF_WS_XMLG_OUTBOUND');
361: raise ignore_rec;
362: end if;
363:
364: /**

Line 554: p_err_message :=wf_core.translate('WF_WS_XMLG_INVALID_ENTRY');

550: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'Invalid Function Name does not have : ');
551: end if;
552:
553: p_err_code := -1;
554: p_err_message :=wf_core.translate('WF_WS_XMLG_INVALID_ENTRY');
555: end if;
556:
557: elsif ( c_base_class_entry_rec.class_type = 'SERVICEBEAN' or c_base_class_entry_rec.class_type = 'WSDL' or
558: c_base_class_entry_rec.class_type = 'PLSQL' or c_base_class_entry_rec.class_type = 'CONCURRENTPROGRAM' or

Line 577: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

573: --dbms_output.put_line('I_Operation='||i_operation||'x');
574: --dbms_output.put_line('I_Operation length='||length(i_operation)||'x');
575: if ( (i_operation is null ) or (length(i_operation) is NULL ) ) then
576: p_err_code := -1;
577: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
578: raise program_exit;
579: end if;
580:
581: create_class_entry_detail

Line 674: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

670: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', 'ClassID,FunctionID:'||c_base_class_entry_rec.class_id||','||c_base_function_entry_rec.function_id||' Not a public interface/method to be exposed');
671: end if;
672:
673: p_err_code := -1;
674: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
675: raise program_exit;
676: end if;
677: else
678: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 683: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');

679: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_derived_entry', ' No records found for FunctionID='||c_base_function_entry_rec.function_id);
680: end if;
681:
682: p_err_code := -1;
683: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');
684: raise program_exit;
685: end if;
686:
687: close c_base_function_entry;

Line 693: wf_core.token('ClassId',p_base_class_id);

689:
690: close c_base_class_entry;
691:
692: p_err_code := 0;
693: wf_core.token('ClassId',p_base_class_id);
694: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
695:
696: exception
697: when ignore_rec then

Line 694: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

690: close c_base_class_entry;
691:
692: p_err_code := 0;
693: wf_core.token('ClassId',p_base_class_id);
694: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
695:
696: exception
697: when ignore_rec then
698: raise ignore_rec;

Line 703: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;

699: when program_exit then
700: raise program_exit;
701: when others then
702: p_err_code := -1;
703: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;
704: raise program_exit;
705: end create_function_derived_entry;
706:
707: procedure create_class_entry_detail

Line 763: p_err_message := wf_core.translate('WF_WS_CLASS_NAME_IS_NULL');

759: begin
760:
761: if ( (p_class_name is null) or (p_base_class_id is null) ) then
762: p_err_code := -1;
763: p_err_message := wf_core.translate('WF_WS_CLASS_NAME_IS_NULL');
764: raise program_exit;
765: end if;
766:
767: open c_derived_class(p_class_name,p_entry_type);

Line 860: p_err_message := wf_core.translate('WF_WS_CLASS_INSERT')||SQLERRM;

856: when program_exit then
857: raise program_exit;
858: when others then
859: p_err_code := -1;
860: p_err_message := wf_core.translate('WF_WS_CLASS_INSERT')||SQLERRM;
861: end;
862:
863: p_class_id_out := l_class_id;
864:

Line 911: p_err_message := wf_core.translate('WF_WS_CLASS_UPDATE')||SQLERRM;

907: when program_exit then
908: raise program_exit;
909: when others then
910: p_err_code := -1;
911: p_err_message := wf_core.translate('WF_WS_CLASS_UPDATE')||SQLERRM;
912: end;
913:
914: p_class_id_out := c_derived_class_rec.class_id;
915: end if;

Line 920: p_err_message := wf_core.translate('WF_WS_SUCCESS');

916:
917: close c_derived_class;
918:
919: p_err_code := 0;
920: p_err_message := wf_core.translate('WF_WS_SUCCESS');
921: exception
922: when program_exit then
923: raise program_exit;
924: when others then

Line 926: wf_core.token('BaseClassName',p_class_name);

922: when program_exit then
923: raise program_exit;
924: when others then
925: p_err_code := -1;
926: wf_core.token('BaseClassName',p_class_name);
927: wf_core.token('SqlErr',SQLERRM);
928: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
929: raise program_exit;
930: end create_class_entry_detail;

Line 927: wf_core.token('SqlErr',SQLERRM);

923: raise program_exit;
924: when others then
925: p_err_code := -1;
926: wf_core.token('BaseClassName',p_class_name);
927: wf_core.token('SqlErr',SQLERRM);
928: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
929: raise program_exit;
930: end create_class_entry_detail;
931:

Line 928: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');

924: when others then
925: p_err_code := -1;
926: wf_core.token('BaseClassName',p_class_name);
927: wf_core.token('SqlErr',SQLERRM);
928: p_err_message := wf_core.translate('WF_WS_CLASS_CREATE');
929: raise program_exit;
930: end create_class_entry_detail;
931:
932:

Line 1181: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1177:
1178: close c_derived_method;
1179:
1180: p_err_code := 0;
1181: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1182: exception
1183: when program_exit then
1184: raise program_exit;
1185: when others then

Line 1187: wf_core.token('FunctionName',p_function_name);

1183: when program_exit then
1184: raise program_exit;
1185: when others then
1186: p_err_code := -1;
1187: wf_core.token('FunctionName',p_function_name);
1188: wf_core.token('BaseFunctionId',p_base_function_id);
1189: wf_core.token('DerivedClassId',p_irep_class_id);
1190: wf_core.token('SqlErr',SQLERRM);
1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');

Line 1188: wf_core.token('BaseFunctionId',p_base_function_id);

1184: raise program_exit;
1185: when others then
1186: p_err_code := -1;
1187: wf_core.token('FunctionName',p_function_name);
1188: wf_core.token('BaseFunctionId',p_base_function_id);
1189: wf_core.token('DerivedClassId',p_irep_class_id);
1190: wf_core.token('SqlErr',SQLERRM);
1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1192: raise program_exit;

Line 1189: wf_core.token('DerivedClassId',p_irep_class_id);

1185: when others then
1186: p_err_code := -1;
1187: wf_core.token('FunctionName',p_function_name);
1188: wf_core.token('BaseFunctionId',p_base_function_id);
1189: wf_core.token('DerivedClassId',p_irep_class_id);
1190: wf_core.token('SqlErr',SQLERRM);
1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1192: raise program_exit;
1193: end create_function_entry_detail;

Line 1190: wf_core.token('SqlErr',SQLERRM);

1186: p_err_code := -1;
1187: wf_core.token('FunctionName',p_function_name);
1188: wf_core.token('BaseFunctionId',p_base_function_id);
1189: wf_core.token('DerivedClassId',p_irep_class_id);
1190: wf_core.token('SqlErr',SQLERRM);
1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1192: raise program_exit;
1193: end create_function_entry_detail;
1194:

Line 1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');

1187: wf_core.token('FunctionName',p_function_name);
1188: wf_core.token('BaseFunctionId',p_base_function_id);
1189: wf_core.token('DerivedClassId',p_irep_class_id);
1190: wf_core.token('SqlErr',SQLERRM);
1191: p_err_message := wf_core.translate('WF_WS_FUNCTION_CREATE');
1192: raise program_exit;
1193: end create_function_entry_detail;
1194:
1195: procedure create_function_lang_entries

Line 1242: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1238: p_err_message
1239: );
1240: end loop;
1241: p_err_code := 0;
1242: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1243:
1244: exception
1245: when program_exit then
1246: raise program_exit;

Line 1249: wf_core.token('BaseFunctionId',p_base_function_id);

1245: when program_exit then
1246: raise program_exit;
1247: when others then
1248: p_err_code := -1;
1249: wf_core.token('BaseFunctionId',p_base_function_id);
1250: wf_core.token('DerivedFunctionId',p_function_id);
1251: wf_core.token('DerivedFunctionName',p_function_name);
1252: wf_core.token('SqlErr',SQLERRM);
1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');

Line 1250: wf_core.token('DerivedFunctionId',p_function_id);

1246: raise program_exit;
1247: when others then
1248: p_err_code := -1;
1249: wf_core.token('BaseFunctionId',p_base_function_id);
1250: wf_core.token('DerivedFunctionId',p_function_id);
1251: wf_core.token('DerivedFunctionName',p_function_name);
1252: wf_core.token('SqlErr',SQLERRM);
1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1254: raise program_exit;

Line 1251: wf_core.token('DerivedFunctionName',p_function_name);

1247: when others then
1248: p_err_code := -1;
1249: wf_core.token('BaseFunctionId',p_base_function_id);
1250: wf_core.token('DerivedFunctionId',p_function_id);
1251: wf_core.token('DerivedFunctionName',p_function_name);
1252: wf_core.token('SqlErr',SQLERRM);
1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1254: raise program_exit;
1255: end create_function_lang_entries;

Line 1252: wf_core.token('SqlErr',SQLERRM);

1248: p_err_code := -1;
1249: wf_core.token('BaseFunctionId',p_base_function_id);
1250: wf_core.token('DerivedFunctionId',p_function_id);
1251: wf_core.token('DerivedFunctionName',p_function_name);
1252: wf_core.token('SqlErr',SQLERRM);
1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1254: raise program_exit;
1255: end create_function_lang_entries;
1256:

Line 1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');

1249: wf_core.token('BaseFunctionId',p_base_function_id);
1250: wf_core.token('DerivedFunctionId',p_function_id);
1251: wf_core.token('DerivedFunctionName',p_function_name);
1252: wf_core.token('SqlErr',SQLERRM);
1253: p_err_message := wf_core.translate('WF_WS_FUNC_LANG_ENTRIES');
1254: raise program_exit;
1255: end create_function_lang_entries;
1256:
1257:

Line 1349: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

1345: end if;
1346:
1347: close c_function_language;
1348:
1349: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
1350: p_err_code :=0;
1351: exception
1352: when program_exit then
1353: raise program_exit;

Line 1356: wf_core.token('DerivedFunctionName', p_function_name);

1352: when program_exit then
1353: raise program_exit;
1354: when others then
1355: p_err_code := -1;
1356: wf_core.token('DerivedFunctionName', p_function_name);
1357: wf_core.token('DerivedFunctionId',p_function_id);
1358: wf_core.token('Lang',p_language);
1359: wf_core.token('SqlErr',SQLERRM);
1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');

Line 1357: wf_core.token('DerivedFunctionId',p_function_id);

1353: raise program_exit;
1354: when others then
1355: p_err_code := -1;
1356: wf_core.token('DerivedFunctionName', p_function_name);
1357: wf_core.token('DerivedFunctionId',p_function_id);
1358: wf_core.token('Lang',p_language);
1359: wf_core.token('SqlErr',SQLERRM);
1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1361: raise program_exit;

Line 1358: wf_core.token('Lang',p_language);

1354: when others then
1355: p_err_code := -1;
1356: wf_core.token('DerivedFunctionName', p_function_name);
1357: wf_core.token('DerivedFunctionId',p_function_id);
1358: wf_core.token('Lang',p_language);
1359: wf_core.token('SqlErr',SQLERRM);
1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1361: raise program_exit;
1362: end create_function_language;

Line 1359: wf_core.token('SqlErr',SQLERRM);

1355: p_err_code := -1;
1356: wf_core.token('DerivedFunctionName', p_function_name);
1357: wf_core.token('DerivedFunctionId',p_function_id);
1358: wf_core.token('Lang',p_language);
1359: wf_core.token('SqlErr',SQLERRM);
1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1361: raise program_exit;
1362: end create_function_language;
1363:

Line 1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');

1356: wf_core.token('DerivedFunctionName', p_function_name);
1357: wf_core.token('DerivedFunctionId',p_function_id);
1358: wf_core.token('Lang',p_language);
1359: wf_core.token('SqlErr',SQLERRM);
1360: p_err_message := wf_core.translate('WF_WS_FUNC_LANG');
1361: raise program_exit;
1362: end create_function_language;
1363:
1364: procedure create_class_language

Line 1457: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

1453: end if;
1454:
1455: close c_class_language;
1456:
1457: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
1458: p_err_code :=0;
1459: exception
1460: when program_exit then
1461: raise program_exit;

Line 1464: wf_core.token('DerivedClassName', p_derived_class_name);

1460: when program_exit then
1461: raise program_exit;
1462: when others then
1463: p_err_code := -1;
1464: wf_core.token('DerivedClassName', p_derived_class_name);
1465: wf_core.token('DerivedClassId',p_class_id);
1466: wf_core.token('Lang',p_language);
1467: wf_core.token('SqlErr',SQLERRM);
1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');

Line 1465: wf_core.token('DerivedClassId',p_class_id);

1461: raise program_exit;
1462: when others then
1463: p_err_code := -1;
1464: wf_core.token('DerivedClassName', p_derived_class_name);
1465: wf_core.token('DerivedClassId',p_class_id);
1466: wf_core.token('Lang',p_language);
1467: wf_core.token('SqlErr',SQLERRM);
1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1469: raise program_exit;

Line 1466: wf_core.token('Lang',p_language);

1462: when others then
1463: p_err_code := -1;
1464: wf_core.token('DerivedClassName', p_derived_class_name);
1465: wf_core.token('DerivedClassId',p_class_id);
1466: wf_core.token('Lang',p_language);
1467: wf_core.token('SqlErr',SQLERRM);
1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1469: raise program_exit;
1470: end create_class_language;

Line 1467: wf_core.token('SqlErr',SQLERRM);

1463: p_err_code := -1;
1464: wf_core.token('DerivedClassName', p_derived_class_name);
1465: wf_core.token('DerivedClassId',p_class_id);
1466: wf_core.token('Lang',p_language);
1467: wf_core.token('SqlErr',SQLERRM);
1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1469: raise program_exit;
1470: end create_class_language;
1471:

Line 1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');

1464: wf_core.token('DerivedClassName', p_derived_class_name);
1465: wf_core.token('DerivedClassId',p_class_id);
1466: wf_core.token('Lang',p_language);
1467: wf_core.token('SqlErr',SQLERRM);
1468: p_err_message := wf_core.translate('WF_WS_CLASS_LANG');
1469: raise program_exit;
1470: end create_class_language;
1471:
1472:

Line 1523: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1519: );
1520: end loop;
1521:
1522: p_err_code := 0;
1523: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1524:
1525: exception
1526: when program_exit then
1527: raise program_exit;

Line 1530: wf_core.token('DerivedClassName', p_derived_class_name);

1526: when program_exit then
1527: raise program_exit;
1528: when others then
1529: p_err_code := -1;
1530: wf_core.token('DerivedClassName', p_derived_class_name);
1531: wf_core.token('DerivedClassId',p_class_id);
1532: wf_core.token('SqlErr',SQLERRM);
1533: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1534: raise program_exit;

Line 1531: wf_core.token('DerivedClassId',p_class_id);

1527: raise program_exit;
1528: when others then
1529: p_err_code := -1;
1530: wf_core.token('DerivedClassName', p_derived_class_name);
1531: wf_core.token('DerivedClassId',p_class_id);
1532: wf_core.token('SqlErr',SQLERRM);
1533: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1534: raise program_exit;
1535: end create_class_lang_entries;

Line 1532: wf_core.token('SqlErr',SQLERRM);

1528: when others then
1529: p_err_code := -1;
1530: wf_core.token('DerivedClassName', p_derived_class_name);
1531: wf_core.token('DerivedClassId',p_class_id);
1532: wf_core.token('SqlErr',SQLERRM);
1533: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1534: raise program_exit;
1535: end create_class_lang_entries;
1536:

Line 1533: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');

1529: p_err_code := -1;
1530: wf_core.token('DerivedClassName', p_derived_class_name);
1531: wf_core.token('DerivedClassId',p_class_id);
1532: wf_core.token('SqlErr',SQLERRM);
1533: p_err_message := wf_core.translate('WF_WS_CLASS_LANG_ENTRIES');
1534: raise program_exit;
1535: end create_class_lang_entries;
1536:
1537: procedure create_xmlg_schema

Line 1585: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1581: p_clob := i_tmp;
1582: dbms_lob.freetemporary(i_tmp);
1583:
1584: p_err_code := 0;
1585: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1586: exception
1587: when program_exit then
1588: raise program_exit;
1589: when others then

Line 1591: wf_core.token('InterfaceName',p_port_type);

1587: when program_exit then
1588: raise program_exit;
1589: when others then
1590: p_err_code := -1;
1591: wf_core.token('InterfaceName',p_port_type);
1592: wf_core.token('SqlErr',SQLERRM);
1593: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1594: raise program_exit;
1595: end create_xmlg_schema;

Line 1592: wf_core.token('SqlErr',SQLERRM);

1588: raise program_exit;
1589: when others then
1590: p_err_code := -1;
1591: wf_core.token('InterfaceName',p_port_type);
1592: wf_core.token('SqlErr',SQLERRM);
1593: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1594: raise program_exit;
1595: end create_xmlg_schema;
1596:

Line 1593: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');

1589: when others then
1590: p_err_code := -1;
1591: wf_core.token('InterfaceName',p_port_type);
1592: wf_core.token('SqlErr',SQLERRM);
1593: p_err_message := wf_core.translate('WF_WS_XMLG_SCHEMA');
1594: raise program_exit;
1595: end create_xmlg_schema;
1596:
1597:

Line 1615: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1611: p_new_name := l_var;
1612: end if;
1613:
1614: p_err_code := 0;
1615: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1616: exception
1617: when program_exit then
1618: raise program_exit;
1619: when others then

Line 1621: wf_core.token('Name',p_name);

1617: when program_exit then
1618: raise program_exit;
1619: when others then
1620: p_err_code := -1;
1621: wf_core.token('Name',p_name);
1622: wf_core.token('SqlErr',SQLERRM);
1623: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1624: raise program_exit;
1625: end to_upper;

Line 1622: wf_core.token('SqlErr',SQLERRM);

1618: raise program_exit;
1619: when others then
1620: p_err_code := -1;
1621: wf_core.token('Name',p_name);
1622: wf_core.token('SqlErr',SQLERRM);
1623: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1624: raise program_exit;
1625: end to_upper;
1626:

Line 1623: p_err_message := wf_core.translate('WF_WS_XMLG_NS');

1619: when others then
1620: p_err_code := -1;
1621: wf_core.token('Name',p_name);
1622: wf_core.token('SqlErr',SQLERRM);
1623: p_err_message := wf_core.translate('WF_WS_XMLG_NS');
1624: raise program_exit;
1625: end to_upper;
1626:
1627:

Line 1662: wf_core.token('GetRootElement mapCode', p_map_code);

1658:
1659: exception
1660: when others then
1661: p_err_code := -1;
1662: wf_core.token('GetRootElement mapCode', p_map_code);
1663: wf_core.token('SqlErr',SQLERRM);
1664: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1665: raise program_exit;
1666: end get_root_element;

Line 1663: wf_core.token('SqlErr',SQLERRM);

1659: exception
1660: when others then
1661: p_err_code := -1;
1662: wf_core.token('GetRootElement mapCode', p_map_code);
1663: wf_core.token('SqlErr',SQLERRM);
1664: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1665: raise program_exit;
1666: end get_root_element;
1667:

Line 1664: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');

1660: when others then
1661: p_err_code := -1;
1662: wf_core.token('GetRootElement mapCode', p_map_code);
1663: wf_core.token('SqlErr',SQLERRM);
1664: p_err_message := wf_core.translate('WF_WS_MODULE_FAILED');
1665: raise program_exit;
1666: end get_root_element;
1667:
1668: procedure create_object_derived_entry

Line 1706: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');

1702: begin
1703:
1704: if (p_base_object_id is null ) then
1705: p_err_code := -1;
1706: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_ID');
1707: raise program_exit;
1708: end if;
1709:
1710: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1725: --wf_core.token('BaseClassId',p_base_class_id);

1721:
1722: if c_object_rec.l_count = 0 then
1723: p_err_code := -1;
1724: --todo create new token
1725: --wf_core.token('BaseClassId',p_base_class_id);
1726: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1727: raise program_exit;
1728: end if;
1729:

Line 1726: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

1722: if c_object_rec.l_count = 0 then
1723: p_err_code := -1;
1724: --todo create new token
1725: --wf_core.token('BaseClassId',p_base_class_id);
1726: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1727: raise program_exit;
1728: end if;
1729:
1730: for c1 in c_methods(p_base_object_id)

Line 1750: --wf_core.token('BaseClassId',p_base_object_id);

1746: raise program_exit;
1747: when others then
1748: p_err_code := -1;
1749: --todo create new tokens
1750: --wf_core.token('BaseClassId',p_base_object_id);
1751: --wf_core.token('BaseClassName', p_base_object_name);
1752: --wf_core.token('FunctionId',c1.function_id);
1753: --wf_core.token('SqlErr',SQLERRM);
1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

Line 1751: --wf_core.token('BaseClassName', p_base_object_name);

1747: when others then
1748: p_err_code := -1;
1749: --todo create new tokens
1750: --wf_core.token('BaseClassId',p_base_object_id);
1751: --wf_core.token('BaseClassName', p_base_object_name);
1752: --wf_core.token('FunctionId',c1.function_id);
1753: --wf_core.token('SqlErr',SQLERRM);
1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1755: raise program_exit;

Line 1752: --wf_core.token('FunctionId',c1.function_id);

1748: p_err_code := -1;
1749: --todo create new tokens
1750: --wf_core.token('BaseClassId',p_base_object_id);
1751: --wf_core.token('BaseClassName', p_base_object_name);
1752: --wf_core.token('FunctionId',c1.function_id);
1753: --wf_core.token('SqlErr',SQLERRM);
1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1755: raise program_exit;
1756: end;

Line 1753: --wf_core.token('SqlErr',SQLERRM);

1749: --todo create new tokens
1750: --wf_core.token('BaseClassId',p_base_object_id);
1751: --wf_core.token('BaseClassName', p_base_object_name);
1752: --wf_core.token('FunctionId',c1.function_id);
1753: --wf_core.token('SqlErr',SQLERRM);
1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1755: raise program_exit;
1756: end;
1757:

Line 1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');

1750: --wf_core.token('BaseClassId',p_base_object_id);
1751: --wf_core.token('BaseClassName', p_base_object_name);
1752: --wf_core.token('FunctionId',c1.function_id);
1753: --wf_core.token('SqlErr',SQLERRM);
1754: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_ITER');
1755: raise program_exit;
1756: end;
1757:
1758: end loop;

Line 1760: wf_core.token('BaseClassId',p_base_object_id);

1756: end;
1757:
1758: end loop;
1759:
1760: wf_core.token('BaseClassId',p_base_object_id);
1761: wf_core.token('BaseClassName', p_base_object_name);
1762: if (method_count = 0 ) then
1763: p_err_code := -1;
1764: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

Line 1761: wf_core.token('BaseClassName', p_base_object_name);

1757:
1758: end loop;
1759:
1760: wf_core.token('BaseClassId',p_base_object_id);
1761: wf_core.token('BaseClassName', p_base_object_name);
1762: if (method_count = 0 ) then
1763: p_err_code := -1;
1764: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1765: elsif ( method_count > 0 ) then

Line 1764: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');

1760: wf_core.token('BaseClassId',p_base_object_id);
1761: wf_core.token('BaseClassName', p_base_object_name);
1762: if (method_count = 0 ) then
1763: p_err_code := -1;
1764: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1765: elsif ( method_count > 0 ) then
1766: p_err_code := 0;
1767: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1768: end if;

Line 1767: p_err_message := wf_core.translate('WF_WS_SUCCESS');

1763: p_err_code := -1;
1764: p_err_message := wf_core.translate('WF_WS_NO_BASE_METHODS');
1765: elsif ( method_count > 0 ) then
1766: p_err_code := 0;
1767: p_err_message := wf_core.translate('WF_WS_SUCCESS');
1768: end if;
1769:
1770: exception
1771: when program_exit then

Line 1775: wf_core.token('BaseClassId',p_base_object_id);

1771: when program_exit then
1772: null;
1773: when others then
1774: p_err_code := -1;
1775: wf_core.token('BaseClassId',p_base_object_id);
1776: wf_core.token('BaseClassName', p_base_object_name);
1777: wf_core.token('SqlErr',SQLERRM);
1778: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1779: end create_object_derived_entry;

Line 1776: wf_core.token('BaseClassName', p_base_object_name);

1772: null;
1773: when others then
1774: p_err_code := -1;
1775: wf_core.token('BaseClassId',p_base_object_id);
1776: wf_core.token('BaseClassName', p_base_object_name);
1777: wf_core.token('SqlErr',SQLERRM);
1778: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1779: end create_object_derived_entry;
1780:

Line 1777: wf_core.token('SqlErr',SQLERRM);

1773: when others then
1774: p_err_code := -1;
1775: wf_core.token('BaseClassId',p_base_object_id);
1776: wf_core.token('BaseClassName', p_base_object_name);
1777: wf_core.token('SqlErr',SQLERRM);
1778: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1779: end create_object_derived_entry;
1780:
1781: /**

Line 1778: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');

1774: p_err_code := -1;
1775: wf_core.token('BaseClassId',p_base_object_id);
1776: wf_core.token('BaseClassName', p_base_object_name);
1777: wf_core.token('SqlErr',SQLERRM);
1778: p_err_message := wf_core.translate('WF_WS_CLASS_DERIVED');
1779: end create_object_derived_entry;
1780:
1781: /**
1782: Procedure for creating a Derived Entry for all functions of a base Object Entry

Line 1832: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

1828:
1829:
1830: if ( (p_base_object_id is null) or (p_base_function_id is null)) then
1831: p_err_code := -1;
1832: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
1833: raise program_exit;
1834: end if;
1835:
1836:

Line 1848: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

1844: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create.obj.function.derived.entry', 'Base Object ID='||p_base_object_id||' does not exist');
1845: end if;
1846:
1847: p_err_code := -1;
1848: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
1849: raise program_exit;
1850:
1851: elsif c_base_object_entry%FOUND then
1852:

Line 1869: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');

1865: end if;
1866:
1867: if ( c_base_function_entry_rec.irep_class_id <> p_base_object_id ) then
1868: p_err_code :=-1;
1869: p_err_message := wf_core.translate('WF_WS_CLASS_FUNC_MISMATCH');
1870: raise program_exit;
1871: end if;
1872:
1873: if ( c_base_object_entry_rec.irep_scope = 'PUBLIC' AND c_base_function_entry_rec.irep_scope = 'PUBLIC' ) then

Line 1895: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

1891: --dbms_output.put_line('I_Operation='||i_operation||'x');
1892: --dbms_output.put_line('I_Operation length='||length(i_operation)||'x');
1893: if ( (i_operation is null ) or (length(i_operation) is NULL ) ) then
1894: p_err_code := -1;
1895: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
1896: raise program_exit;
1897: end if;
1898:
1899:

Line 1994: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

1990: ||c_base_object_entry_rec.object_id||','||c_base_function_entry_rec.function_id||' Not a public interface/method to be exposed');
1991: end if;
1992:
1993: p_err_code := -1;
1994: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
1995: raise program_exit;
1996: end if;
1997: else
1998: if( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2003: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');

1999: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create.obj.function.derived.entry', ' No records found for FunctionID='||c_base_function_entry_rec.function_id);
2000: end if;
2001:
2002: p_err_code := -1;
2003: p_err_message := wf_core.translate('WF_WS_BASE_FUNC_NOT_EXIST');
2004: raise program_exit;
2005: end if;
2006:
2007: close c_base_function_entry;

Line 2014: --wf_core.token('ClassId',p_base_class_id);

2010: close c_base_object_entry;
2011:
2012: p_err_code := 0;
2013: --todo create new token
2014: --wf_core.token('ClassId',p_base_class_id);
2015: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2016:
2017: exception
2018: when ignore_rec then

Line 2015: p_err_message :=wf_core.translate('WF_WS_SUCCESS');

2011:
2012: p_err_code := 0;
2013: --todo create new token
2014: --wf_core.token('ClassId',p_base_class_id);
2015: p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2016:
2017: exception
2018: when ignore_rec then
2019: raise ignore_rec;

Line 2024: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;

2020: when program_exit then
2021: raise program_exit;
2022: when others then
2023: p_err_code := -1;
2024: p_err_message :=wf_core.translate('WF_WS_GENERIC_CLASS_ERROR')||'Error in Creating Derived Entry for Base FUNCTION_ID='||p_base_function_id||SQLERRM;
2025: raise program_exit;
2026: end create_obj_func_derived_entry;
2027:
2028:

Line 2061: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');

2057:
2058:
2059: if ( p_base_object_id is null) then
2060: p_err_code := -1;
2061: p_err_message := wf_core.translate('WF_WS_MISSING_CLASS_FUNC_ID');
2062: raise program_exit;
2063: end if;
2064:
2065:

Line 2077: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');

2073: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_object_function_base_entry', 'Base Object ID='||p_base_object_id||' does not exist');
2074: end if;
2075:
2076: p_err_code := -1;
2077: p_err_message := wf_core.translate('WF_WS_BASE_CLASS_NOT_EXIST');
2078: raise program_exit;
2079:
2080: elsif c_base_object_entry%FOUND then
2081:

Line 2101: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');

2097:
2098: --dbms_output.put_line('Function ='||p_function_name);
2099: if ( (p_function_name is null ) or (length(p_function_name) is NULL ) ) then
2100: p_err_code := -1;
2101: p_err_message :=wf_core.translate('WF_WS_MISSING_IREP_METHOD_NAME');
2102: raise program_exit;
2103: end if;
2104:
2105:

Line 2197: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');

2193: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE, 'oracle.apps.fnd.wf.ws.create_object_function_base_entry', 'objectID:'||c_base_object_entry_rec.object_id||' Not a public interface to be exposed');
2194: end if;
2195:
2196: p_err_code := -1;
2197: p_err_message := wf_core.translate('WF_WS_NOT_PUBLIC');
2198: raise program_exit;
2199: end if;
2200:
2201:

Line 2208: --wf_core.token('BaseClassId',p_base_object_id);

2204: close c_base_object_entry;
2205:
2206: p_err_code := 0;
2207: -- todo create new tokens for successful message.
2208: --wf_core.token('BaseClassId',p_base_object_id);
2209: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2210:
2211: exception
2212: when ignore_rec then

Line 2209: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');

2205:
2206: p_err_code := 0;
2207: -- todo create new tokens for successful message.
2208: --wf_core.token('BaseClassId',p_base_object_id);
2209: --p_err_message :=wf_core.translate('WF_WS_SUCCESS');
2210:
2211: exception
2212: when ignore_rec then
2213: raise ignore_rec;

Line 2218: p_err_message :=wf_core.translate('WF_WS_GENERIC_object_ERROR')||'Error in Creating Base Entry for Base object_ID='||p_base_object_id||SQLERRM;

2214: when program_exit then
2215: raise program_exit;
2216: when others then
2217: p_err_code := -1;
2218: p_err_message :=wf_core.translate('WF_WS_GENERIC_object_ERROR')||'Error in Creating Base Entry for Base object_ID='||p_base_object_id||SQLERRM;
2219: raise program_exit;
2220: end create_obj_function_base_entry;
2221:
2222: end SOA_GENERATE;