APPS.ECX_TRANSACTIONS_API dependencies on ECX_UTIL_API

Line 45: x_return_status := ECX_UTIL_API.G_NO_ERROR;

41: and party_type = p_party_type; --Bug #2183619
42:
43: begin
44: x_transaction_id :=-1;
45: x_return_status := ECX_UTIL_API.G_NO_ERROR;
46: x_msg := null;
47:
48: -- make sure the transaction_type, transaction_subtype and party_type are not null.
49: if ( p_transaction_type is null )

Line 51: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

47:
48: -- make sure the transaction_type, transaction_subtype and party_type are not null.
49: if ( p_transaction_type is null )
50: then
51: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
52: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_TYPE_NOT_NULL');
53: return;
54: end if;
55:

Line 58: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

54: end if;
55:
56: if ( p_transaction_subtype is null )
57: then
58: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
59: x_msg := ecx_debug.getTranslatedMessage('ECX_TRAN_SUBTYPE_NOT_NULL');
60: return;
61: end if;
62:

Line 65: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

61: end if;
62:
63: if ( p_party_type is null )
64: then
65: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
66: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');
67: return;
68: end if;
69:

Line 70: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))

66: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');
67: return;
68: end if;
69:
70: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))
71: then
72: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
73: x_transaction_id := -1;
74: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);

Line 72: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

68: end if;
69:
70: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))
71: then
72: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
73: x_transaction_id := -1;
74: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);
75: return;
76: end if;

Line 97: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;

93: close c_transaction;
94:
95: Exception
96: when too_many_rows then
97: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
98: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANS_TOO_MANY_ROWS',
99: 'p_transaction_type', p_transaction_type,
100: 'p_transaction_subtype', p_transaction_subtype,
101: 'p_party_type',p_party_type

Line 115: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

111: 'p_transaction_type',p_transaction_type,
112: 'p_transaction_subtype',p_transaction_subtype,
113: 'p_party_type',p_party_type
114: );
115: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
116: if c_transaction%ISOPEN
117: then
118: close c_transaction;
119: end if;

Line 122: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

118: close c_transaction;
119: end if;
120:
121: when others then
122: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
123: x_msg := substr(SQLERRM,1,200);
124:
125: if c_transaction%ISOPEN
126: then

Line 157: x_return_status := ECX_UTIL_API.G_NO_ERROR;

153: x1_msg varchar2(200);
154: x1_transaction_id pls_integer;
155: i_rowid varchar2(2000);
156: begin
157: x_return_status := ECX_UTIL_API.G_NO_ERROR;
158: x_transaction_id :=-1;
159: x_msg := null;
160:
161: -- make sure the transaction_type, transaction_subtype and party_type are not null.

Line 164: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

160:
161: -- make sure the transaction_type, transaction_subtype and party_type are not null.
162: if ( p_transaction_type is null )
163: then
164: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
165: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_TYPE_NOT_NULL');
166: return;
167: end if;
168:

Line 171: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

167: end if;
168:
169: if ( p_transaction_subtype is null )
170: then
171: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
172: x_msg := ecx_debug.getTranslatedMessage('ECX_TRAN_SUBTYPE_NOT_NULL');
173: return;
174: end if;
175:

Line 178: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

174: end if;
175:
176: if ( p_party_type is null )
177: then
178: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
179: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');
180: return;
181: end if;
182:

Line 183: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))

179: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');
180: return;
181: end if;
182:
183: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))
184: then
185: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
186: x_transaction_id := -1;
187: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);

Line 185: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

181: end if;
182:
183: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))
184: then
185: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
186: x_transaction_id := -1;
187: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);
188: return;
189: end if;

Line 210: if ( x1_return_status = ECX_UTIL_API.G_NO_DATA_ERROR )

206: x_last_updated_by => i_last_updated_by,
207: x_last_update_date => i_last_update_date
208: );
209:
210: if ( x1_return_status = ECX_UTIL_API.G_NO_DATA_ERROR )
211: then
212: select ecx_transactions_s.nextval
213: into x_transaction_id
214: from dual;

Line 241: elsif ( x1_return_status = ECX_UTIL_API.G_NO_ERROR ) then

237: x_last_update_date => sysdate,
238: x_last_updated_by => i_last_updated_by,
239: x_last_update_login => 0);
240:
241: elsif ( x1_return_status = ECX_UTIL_API.G_NO_ERROR ) then
242: raise dup_val_on_index;
243: else
244: x_return_status := x1_return_status;
245: x_msg := x1_msg;

Line 251: x_return_status := ECX_UTIL_API.G_DUP_ERROR;

247: end if;
248:
249: Exception
250: when dup_val_on_index then
251: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
252: x_msg := ecx_debug.getTranslatedMessage('ECX_DUPLICATE_TRANSACTIONS',
253: 'p_transaction_type',p_transaction_type,
254: 'p_transaction_subtype',p_transaction_subtype,
255: 'p_party_type',p_party_type);

Line 258: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

254: 'p_transaction_subtype',p_transaction_subtype,
255: 'p_party_type',p_party_type);
256:
257: when no_data_found then
258: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
259: x_msg := ecx_debug.getTranslatedMessage
260: ('ECX_TRANSACTION_NOT_FOUND',
261: 'p_transaction_type' ,p_transaction_type,
262: 'p_transaction_subtype',p_transaction_subtype,

Line 266: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

262: 'p_transaction_subtype',p_transaction_subtype,
263: 'p_party_type' , p_party_type);
264:
265: when others then
266: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
267: x_msg := substr(SQLERRM,1,200);
268: end create_transaction;
269:
270: /**

Line 287: x_return_status := ECX_UTIL_API.G_NO_ERROR;

283: )
284: is
285: i_last_updated_by pls_integer;
286: begin
287: x_return_status := ECX_UTIL_API.G_NO_ERROR;
288: x_msg := null;
289: -- make sure the p_transaction_id is not null.
290: If p_transaction_id is null
291: then

Line 292: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

288: x_msg := null;
289: -- make sure the p_transaction_id is not null.
290: If p_transaction_id is null
291: then
292: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
293: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');
294: return;
295: end if;
296:

Line 314: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

310: Where transaction_id = p_transaction_id;
311:
312: if (sql%rowcount = 0)
313: then
314: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
315: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
316: 'p_table',
317: 'ECX_TRANSACTIONS_B',
318: 'p_param_name',

Line 336: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

332: userenv('LANG') in (language, source_lang);
333:
334: if (sql%rowcount = 0)
335: then
336: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
337: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_TRANS_ROWS_UPDATED',
338: 'p_table',
339: 'ECX_TRANSACTIONS_TL',
340: 'p_param_name',

Line 349: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

345: end if;
346:
347: Exception
348: when others then
349: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
350: x_msg := substr(1,200,SQLERRM);
351: end update_transaction;
352:
353: /**

Line 371: x_return_status := ECX_UTIL_API.G_NO_ERROR;

367:
368: num pls_integer;
369:
370: Begin
371: x_return_status := ECX_UTIL_API.G_NO_ERROR;
372: x_msg := null;
373:
374: If p_transaction_id is null
375: then

Line 376: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

372: x_msg := null;
373:
374: If p_transaction_id is null
375: then
376: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
377: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');
378: return;
379: end if;
380:

Line 400: x_return_status := ECX_UTIL_API.G_REFER_ERROR;

396:
397: if (num > 0)
398: then
399: x_msg := ecx_debug.getTranslatedMessage('ECX_TP_DETAIL_EXISTS');
400: x_return_status := ECX_UTIL_API.G_REFER_ERROR;
401: return;
402: end if;
403:
404: delete from ecx_ext_processes

Line 411: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

407: /* Call table handler API for deletion */
408: ECX_TRANSACTIONS_PKG.DELETE_ROW(x_transaction_id => p_transaction_id);
409: exception
410: when no_data_found then
411: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
412: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
413: 'p_table', 'ECX_TRANSACTIONS',
414: 'p_param_name','Transaction ID',
415: 'p_param_id',p_transaction_id);

Line 418: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

414: 'p_param_name','Transaction ID',
415: 'p_param_id',p_transaction_id);
416: when others then
417: x_msg := substr(SQLERRM,1,200);
418: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
419: end delete_transaction;
420:
421: /**
422: Overloaded Procedure.This Retrieve_Ext_Process API is used to retrieve an existing external

Line 455: x_return_status := ECX_UTIL_API.G_NO_ERROR;

451: is
452: num varchar2(2000);
453:
454: begin
455: x_return_status := ECX_UTIL_API.G_NO_ERROR;
456: x_msg := null;
457: x_ext_process_id :=-1;
458: x_transaction_id :=-1;
459:

Line 481: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

477: end if;
478:
479: if ( p_direction is null )
480: then
481: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
482: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');
483: return;
484: end if;
485:

Line 488: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

484: end if;
485:
486: if ( p_standard is null )
487: then
488: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
489: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
490: return;
491: end if;
492:

Line 493: if NOT (ECX_UTIL_API.validate_direction(p_direction))

489: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
490: return;
491: end if;
492:
493: if NOT (ECX_UTIL_API.validate_direction(p_direction))
494: then
495: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
496: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
497: return;

Line 496: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

492:
493: if NOT (ECX_UTIL_API.validate_direction(p_direction))
494: then
495: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
496: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
497: return;
498: end if;
499:
500: -- make sure it is a valid standard.

Line 510: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

506: and standard_type = p_standard_type;
507: exception
508: when no_data_found then
509: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NOT_FOUND','p_standard',p_standard);
510: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
511: return;
512: end;
513:
514: -- select data from ECX_EXT_PROCESSES

Line 541: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;

537: and (p_ext_subtype is null or ext_subtype=p_ext_subtype);
538:
539: exception
540: when too_many_rows then
541: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
542: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_TOO_MANY_ROWS',
543: 'p_transaction_type', p_transaction_type,
544: 'p_transaction_subtype', p_transaction_subtype,
545: 'p_standard', p_standard,

Line 555: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

551: 'p_transaction_type',p_transaction_type,
552: 'p_transaction_subtype',p_transaction_subtype,
553: 'p_standard',p_standard
554: );
555: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
556: when others then
557: x_msg := substr(SQLERRM,1,200);
558: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
559: end retrieve_external_transaction;

Line 558: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

554: );
555: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
556: when others then
557: x_msg := substr(SQLERRM,1,200);
558: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
559: end retrieve_external_transaction;
560:
561: /**
562: This Retrieve_Ext_Process API is used to retrieve an existing external

Line 590: x_return_status := ECX_UTIL_API.G_NO_ERROR;

586: p_standard_type IN varchar2
587: )
588: is
589: begin
590: x_return_status := ECX_UTIL_API.G_NO_ERROR;
591: x_msg := null;
592: x_ext_process_id :=-1;
593:
594: If p_transaction_id is null

Line 596: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

592: x_ext_process_id :=-1;
593:
594: If p_transaction_id is null
595: then
596: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
597: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');
598: return;
599: end if;
600:

Line 603: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

599: end if;
600:
601: if ( p_direction is null )
602: then
603: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
604: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');
605: return;
606: end if;
607:

Line 610: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

606: end if;
607:
608: if ( p_standard is null )
609: then
610: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
611: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
612: return;
613: end if;
614:

Line 615: if NOT (ECX_UTIL_API.validate_direction(p_direction))

611: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
612: return;
613: end if;
614:
615: if NOT (ECX_UTIL_API.validate_direction(p_direction))
616: then
617: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
618: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
619: return;

Line 618: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

614:
615: if NOT (ECX_UTIL_API.validate_direction(p_direction))
616: then
617: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
618: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
619: return;
620: end if;
621:
622: -- make sure it is a valid standard.

Line 634: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

630: when no_data_found then
631: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',
632: 'p_standard',p_standard,
633: 'p_std_type', p_standard_type);
634: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
635: return;
636: end;
637:
638: -- select data from ECX_EXT_PROCESSES

Line 668: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;

664: and (p_ext_type is null or eep.ext_type=p_ext_type)
665: and (p_ext_subtype is null or eep.ext_subtype=p_ext_subtype);
666: exception
667: when too_many_rows then
668: x_return_status := ECX_UTIL_API.G_TOO_MANY_ROWS;
669: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS1_TOO_MANY_ROWS', 'p_transaction_id', p_transaction_id,
670: 'p_standard', p_standard,
671: 'p_direction', p_direction
672: );

Line 680: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

676: 'p_transaction_id', p_transaction_id,
677: 'p_standard',p_standard,
678: 'p_direction',p_direction
679: );
680: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
681: when others then
682: x_msg := substr(SQLERRM,1,200);
683: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
684: end retrieve_external_transaction;

Line 683: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

679: );
680: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
681: when others then
682: x_msg := substr(SQLERRM,1,200);
683: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
684: end retrieve_external_transaction;
685:
686: /**
687: This Create_Ext_Process API is used to create a new external process definition in the ECX_EXT_PROCESSES table.

Line 710: x_return_status := ECX_UTIL_API.G_NO_ERROR;

706: I_stand_id pls_integer;
707: x_return_code pls_integer;
708: i_last_updated_by pls_integer;
709: begin
710: x_return_status := ECX_UTIL_API.G_NO_ERROR;
711: x_msg := null;
712: x_ext_process_id :=-1;
713:
714: If (p_transaction_id is null)

Line 716: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

712: x_ext_process_id :=-1;
713:
714: If (p_transaction_id is null)
715: then
716: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
717: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');
718: return;
719: end if;
720:

Line 723: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

719: end if;
720:
721: If (p_ext_type is null)
722: then
723: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
724: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TYPE_NOT_NULL');
725: return;
726: end if;
727:

Line 730: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

726: end if;
727:
728: If (p_ext_subtype is null)
729: then
730: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
731: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_SUBTYPE_NOT_NULL');
732: return;
733: end if;
734:

Line 737: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

733: end if;
734:
735: if ( p_direction is null )
736: then
737: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
738: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');
739: return;
740: end if;
741:

Line 744: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

740: end if;
741:
742: if ( p_standard is null )
743: then
744: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
745: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
746: return;
747: end if;
748:

Line 749: if NOT (ECX_UTIL_API.validate_direction(p_direction))

745: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
746: return;
747: end if;
748:
749: if NOT (ECX_UTIL_API.validate_direction(p_direction))
750: then
751: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
752: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
753: return;

Line 752: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

748:
749: if NOT (ECX_UTIL_API.validate_direction(p_direction))
750: then
751: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
752: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
753: return;
754: end if;
755:
756: if p_direction = 'IN'

Line 760: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

756: if p_direction = 'IN'
757: then
758: if ( p_queue_name is null )
759: then
760: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
761: x_msg := ecx_debug.getTranslatedMessage('ECX_QUEUE_NAME_NOT_NULL');
762: return;
763: end if;
764:

Line 766: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))

762: return;
763: end if;
764:
765: -- make sure it is a valid queue name.
766: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))
767: then
768: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);
769: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
770: return;

Line 769: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

765: -- make sure it is a valid queue name.
766: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))
767: then
768: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);
769: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
770: return;
771: end if;
772: end if;
773:

Line 783: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

779: where standard_code = p_standard
780: and standard_type = p_standard_type;
781: exception
782: when no_data_found then
783: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
784: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',
785: 'p_standard', p_standard,
786: 'p_std_type', p_standard_type);
787: return;

Line 841: x_return_status := ECX_UTIL_API.G_DUP_ERROR;

837: 'p_transaction_id', p_transaction_id,
838: 'p_ext_type', p_ext_type,
839: 'p_ext_subtype', p_ext_subtype
840: );
841: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
842: when others then
843: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
844: x_msg := substr(SQLERRM,1,200);
845: end create_external_transaction;

Line 843: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

839: 'p_ext_subtype', p_ext_subtype
840: );
841: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
842: when others then
843: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
844: x_msg := substr(SQLERRM,1,200);
845: end create_external_transaction;
846:
847: /**

Line 876: x_return_status := ECX_UTIL_API.G_NO_ERROR;

872: i_creation_date date;
873: i_last_updated_by pls_integer;
874: i_last_update_date date;
875: begin
876: x_return_status := ECX_UTIL_API.G_NO_ERROR;
877: x_msg := null;
878: x_transaction_id :=-1;
879: x_ext_process_id :=-1;
880: ecx_transactions_api.retrieve_transaction

Line 916: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

912: );
913: exception
914: when others then
915: x_msg := substr(SQLERRM,1,200);
916: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
917: end create_external_transaction;
918:
919: /**
920: Update_Ext_Process API is used to update an existing external process definition in the ECX_EXT_PROCESSES table.

Line 941: x_return_status := ECX_UTIL_API.G_NO_ERROR;

937: is
938: I_stand_id pls_integer;
939: i_last_updated_by pls_integer;
940: begin
941: x_return_status := ECX_UTIL_API.G_NO_ERROR;
942: x_msg := null;
943:
944: If ( p_ext_process_id is null )
945: then

Line 947: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

943:
944: If ( p_ext_process_id is null )
945: then
946: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_ID_NOT_NULL','p_ext_process_id',p_ext_process_id);
947: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
948: return;
949: end if;
950:
951: If (p_ext_type is null)

Line 953: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

949: end if;
950:
951: If (p_ext_type is null)
952: then
953: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
954: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TYPE_NOT_NULL');
955: return;
956: end if;
957:

Line 960: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

956: end if;
957:
958: If (p_ext_subtype is null)
959: then
960: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
961: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_SUBTYPE_NOT_NULL');
962: return;
963: end if;
964:

Line 967: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

963: end if;
964:
965: if ( p_direction is null )
966: then
967: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
968: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');
969: return;
970: end if;
971:

Line 974: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

970: end if;
971:
972: if ( p_standard is null )
973: then
974: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
975: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
976: return;
977: end if;
978:

Line 979: if NOT (ECX_UTIL_API.validate_direction(p_direction))

975: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');
976: return;
977: end if;
978:
979: if NOT (ECX_UTIL_API.validate_direction(p_direction))
980: then
981: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
982: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
983: return;

Line 982: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

978:
979: if NOT (ECX_UTIL_API.validate_direction(p_direction))
980: then
981: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);
982: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
983: return;
984: end if;
985:
986: if p_direction = 'IN'

Line 990: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

986: if p_direction = 'IN'
987: then
988: if ( p_queue_name is null )
989: then
990: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
991: x_msg := ecx_debug.getTranslatedMessage('ECX_QUEUE_NAME_NOT_NULL');
992: return;
993: end if;
994:

Line 996: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))

992: return;
993: end if;
994:
995: -- make sure it is a valid queue name.
996: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))
997: then
998: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);
999: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
1000: return;

Line 999: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

995: -- make sure it is a valid queue name.
996: If NOT (ECX_UTIL_API.validate_queue_name(p_queue_name))
997: then
998: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);
999: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
1000: return;
1001: end if;
1002: end if;
1003:

Line 1016: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;

1012: when no_data_found then
1013: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',
1014: 'p_standard', p_standard,
1015: 'p_std_type', p_standard_type);
1016: x_return_status := ECX_UTIL_API.G_INVALID_PARAM;
1017: return;
1018: end;
1019:
1020: if p_owner = 'SEED'

Line 1041: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

1037: where ext_process_id = p_ext_process_id;
1038:
1039: if (sql%rowcount = 0)
1040: then
1041: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1042: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',
1043: 'p_table', 'ecx_ext_processes', 'p_key', p_ext_process_id);
1044: return;
1045: end if;

Line 1054: x_return_status := ECX_UTIL_API.G_DUP_ERROR;

1050: 'p_ext_process_id', p_ext_process_id,
1051: 'p_ext_type', p_ext_type,
1052: 'p_ext_subtype', p_ext_subtype
1053: );
1054: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
1055: when others then
1056: x_msg := substr(SQLERRM,1,200);
1057: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
1058: end update_external_transaction;

Line 1057: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

1053: );
1054: x_return_status := ECX_UTIL_API.G_DUP_ERROR;
1055: when others then
1056: x_msg := substr(SQLERRM,1,200);
1057: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
1058: end update_external_transaction;
1059:
1060: /**
1061: This Delete_Ext_Process API is used to delete an existing external process definition in the ECX_EXT_PROCESSES table.

Line 1074: x_return_status := ECX_UTIL_API.G_NO_ERROR;

1070: is
1071: num pls_integer;
1072: begin
1073: x_msg := null;
1074: x_return_status := ECX_UTIL_API.G_NO_ERROR;
1075: if (p_ext_process_id is null)
1076: then
1077: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_ID_NOT_NULL');
1078: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

Line 1078: x_return_status := ECX_UTIL_API.G_NULL_PARAM;

1074: x_return_status := ECX_UTIL_API.G_NO_ERROR;
1075: if (p_ext_process_id is null)
1076: then
1077: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_ID_NOT_NULL');
1078: x_return_status := ECX_UTIL_API.G_NULL_PARAM;
1079: return;
1080: end if;
1081:
1082: -- make sure that is no TP using this process first.

Line 1091: x_return_status := ECX_UTIL_API.G_REFER_ERROR;

1087:
1088: if (num > 0)
1089: then
1090: x_msg := ecx_debug.getTranslatedMessage('ECX_TP_DETAIL_EXISTS','p_ext_process_id',p_ext_process_id);
1091: x_return_status := ECX_UTIL_API.G_REFER_ERROR;
1092: return;
1093: end if;
1094:
1095: delete from ecx_ext_processes

Line 1100: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;

1096: where ext_process_id = p_ext_process_id;
1097:
1098: if (sql%rowcount = 0)
1099: then
1100: x_return_status := ECX_UTIL_API.G_NO_DATA_ERROR;
1101: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',
1102: 'p_table', 'ECX_EXT_PROCESSES', 'p_key', p_ext_process_id);
1103: return;
1104: end if;

Line 1109: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;

1105:
1106: exception
1107: when others then
1108: x_msg := substr(SQLERRM,1,200);
1109: x_return_status := ECX_UTIL_API.G_UNEXP_ERROR;
1110: end delete_external_transaction;
1111:
1112: END ECX_TRANSACTIONS_API;