APPS.OEONUM dependencies on OEONUM

Line 1: PACKAGE BODY OEONUM AS

1: PACKAGE BODY OEONUM AS
2: /* $Header: OEXONUMB.pls 115.2 99/07/16 08:13:52 porting shi $ */
3:
4: PROCEDURE dummy is
5: begin

Line 48: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

44: null;
45:
46: WHEN OTHERS THEN
47: return_status := -1;
48: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
49: Operation=>'Create Source',
50: Message=>'Sql stmt 1');
51: return;
52:

Line 80: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

76: ad_ddl_found := FALSE;
77:
78: WHEN OTHERS THEN
79: return_status := -1;
80: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
81: Operation=>'Create Source',
82: Message=>'Sql stmt 2');
83: return;
84:

Line 108: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

104: WHEN NO_DATA_FOUND THEN
105: oexoenum_found := FALSE;
106: WHEN OTHERS THEN
107: return_status := -1;
108: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
109: Operation=>'Create Source',
110: Message=>'Sql stmt 3');
111: return;
112: END;

Line 177: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

173: end if;
174:
175: if x = 0 then /* fnd_installation.get_app_info failed */
176: return_status := -1;
177: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
178: Operation=>'Create Source',
179: Message=>' get_app_info failed 1');
180: return;
181:

Line 241: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',

237: if dbms_sql.is_open(cid) then
238: dbms_sql.close_cursor(cid);
239: end if;
240: return_status := -1;
241: OEONUM.Raise_Exception(Routine=>'OEONUM.CreateSource',
242: Operation=>'Create Source',
243: Message=>' Sql Stmt 3');
244: return;
245:

Line 286: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',

282: dbms_sql.column_value(cid,1,sequence_number);
283: else
284: dbms_sql.close_cursor(cid);
285: return_status := -1;
286: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',
287: Operation=>'Get next number',
288: Message=>' Sql stmt 4');
289: return;
290:

Line 308: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',

304: if dbms_sql.is_open(cid) then
305: dbms_sql.close_cursor(cid);
306: end if;
307: return_status := -1;
308: OEONUM.Raise_Exception(Routine=>'OEONUM.GetNextNumber',
309: Operation=>'Get next number',
310: Message=>' When Others');
311: return;
312:

Line 343: OEONUM.Raise_Exception(Routine=>'OEONUM.GetCurrentNumber',

339: EXCEPTION
340:
341: WHEN NO_DATA_FOUND THEN
342: return_status := -1;
343: OEONUM.Raise_Exception(Routine=>'OEONUM.GetCurrentNumber',
344: Operation=>'Get current number',
345: Message=>' Sql stmt 5, When no_data_found');
346: return;
347:

Line 350: OEONUM.Raise_Exception(Routine=>'OEONUM.GetCurrentNumber',

346: return;
347:
348: WHEN OTHERS THEN
349: return_status := -1;
350: OEONUM.Raise_Exception(Routine=>'OEONUM.GetCurrentNumber',
351: Operation=>'Get current number',
352: Message=>' Sql stmt 5, when others');
353: return;
354:

Line 392: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',

388: BEGIN
389:
390: if source_id is null then
391: return_status := -1;
392: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',
393: Operation=>'Order Number Sequence',
394: Message=>' Source id is null ');
395: return;
396:

Line 404: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',

400: sequence_name := OE_NUM_BASE_SEQ_NAME || ltrim(rtrim(to_char(source_id)));
401:
402: if length(sequence_name) > DATABASE_OBJECT_LENGTH then
403: return_status := -1;
404: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',
405: Operation=>'Order Number Sequence',
406: Message=>' Sequence Name Length exceeds ');
407: return;
408:

Line 414: OEONUM.CreateSource(sequence_name => sequence_name,

410:
411:
412: if action = OE_NUM_ACT_CREATE then
413:
414: OEONUM.CreateSource(sequence_name => sequence_name,
415: cache => cache,
416: min_value => min_value,
417: start_with => start_with,
418: return_status => return_status);

Line 422: OEONUM.GetCurrentNumber(sequence_name => sequence_name,

418: return_status => return_status);
419:
420: elsif action = OE_NUM_ACT_CURRENT then
421:
422: OEONUM.GetCurrentNumber(sequence_name => sequence_name,
423: returned_sequence => sequence_number,
424: return_status => return_status);
425:
426: returned_sequence:=sequence_number;

Line 430: OEONUM.GetNextNumber(sequence_name => sequence_name,

426: returned_sequence:=sequence_number;
427:
428: elsif action = OE_NUM_ACT_NEXT then
429:
430: OEONUM.GetNextNumber(sequence_name => sequence_name,
431: returned_sequence => sequence_number,
432: return_status => return_status);
433:
434: returned_sequence:=sequence_number;

Line 438: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',

434: returned_sequence:=sequence_number;
435:
436: else
437: return_status := -1;
438: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',
439: Operation=>'Order Number Sequence',
440: Message=>' Invalid Action ');
441: return;
442: end if;

Line 448: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',

444: EXCEPTION
445:
446: WHEN OTHERS THEN
447: return_status := -1;
448: OEONUM.Raise_Exception(Routine=>'OEONUM.OrderNumberSequence',
449: Operation=>'Order Number Sequence',
450: Message=>' When Others');
451: return;
452:

Line 479: END OEONUM;

475:
476: END;
477:
478:
479: END OEONUM;