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.ECX_TRANSACTIONS_API dependencies on ECX_DEBUG

Line 52: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_TYPE_NOT_NULL');

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:
56: if ( p_transaction_subtype is null )

Line 59: x_msg := ecx_debug.getTranslatedMessage('ECX_TRAN_SUBTYPE_NOT_NULL');

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:
63: if ( p_party_type is null )

Line 66: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');

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:
70: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))

Line 74: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);

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;
77:
78: open c_transaction(p_transaction_type,p_transaction_subtype,

Line 98: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANS_TOO_MANY_ROWS',

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
102: );

Line 110: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_NOT_FOUND',

106: close c_transaction;
107: end if;
108:
109: when no_data_found then
110: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_NOT_FOUND',
111: 'p_transaction_type',p_transaction_type,
112: 'p_transaction_subtype',p_transaction_subtype,
113: 'p_party_type',p_party_type
114: );

Line 165: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_TYPE_NOT_NULL');

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:
169: if ( p_transaction_subtype is null )

Line 172: x_msg := ecx_debug.getTranslatedMessage('ECX_TRAN_SUBTYPE_NOT_NULL');

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:
176: if ( p_party_type is null )

Line 179: x_msg := ecx_debug.getTranslatedMessage('ECX_PARTY_TYPE_NOT_NULL');

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:
183: if NOT (ECX_UTIL_API.validate_party_type(p_party_type))

Line 187: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_PARTY_TYPE','p_party_type',p_party_type);

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;
190:
191:

Line 252: x_msg := ecx_debug.getTranslatedMessage('ECX_DUPLICATE_TRANSACTIONS',

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);
256:

Line 259: x_msg := ecx_debug.getTranslatedMessage

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,
263: 'p_party_type' , p_party_type);

Line 293: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_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:
297: -- update description in ECX_TRANSACTIONS.

Line 315: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',

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',
319: 'Transaction ID',

Line 337: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_TRANS_ROWS_UPDATED',

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',
341: 'Transaction ID',

Line 377: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_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:
381: -- make sure that is no TP using this transaction first.

Line 399: x_msg := ecx_debug.getTranslatedMessage('ECX_TP_DETAIL_EXISTS');

395: and eep.transaction_id = p_transaction_id;
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:

Line 412: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',

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);
416: when others then

Line 482: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');

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:
486: if ( p_standard is null )

Line 489: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');

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:
493: if NOT (ECX_UTIL_API.validate_direction(p_direction))

Line 495: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);

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;
498: end if;
499:

Line 509: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_CODE_NOT_FOUND','p_standard',p_standard);

505: where standard_code = p_standard
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:

Line 542: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_TOO_MANY_ROWS',

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,
546: 'p_direction', p_direction

Line 550: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TRANSACTION_NOT_FOUND',

546: 'p_direction', p_direction
547: );
548: when no_data_found then
549:
550: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TRANSACTION_NOT_FOUND',
551: 'p_transaction_type',p_transaction_type,
552: 'p_transaction_subtype',p_transaction_subtype,
553: 'p_standard',p_standard
554: );

Line 597: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');

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:
601: if ( p_direction is null )

Line 604: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');

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:
608: if ( p_standard is null )

Line 611: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');

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:
615: if NOT (ECX_UTIL_API.validate_direction(p_direction))

Line 617: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);

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;
620: end if;
621:

Line 631: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',

627: where standard_code = p_standard
628: and standard_type = p_standard_type;
629: exception
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;

Line 669: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS1_TOO_MANY_ROWS', 'p_transaction_id', p_transaction_id,

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: );
673:

Line 675: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TRANSACTION1_NOT_FOUND',

671: 'p_direction', p_direction
672: );
673:
674: when no_data_found then
675: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TRANSACTION1_NOT_FOUND',
676: 'p_transaction_id', p_transaction_id,
677: 'p_standard',p_standard,
678: 'p_direction',p_direction
679: );

Line 717: x_msg := ecx_debug.getTranslatedMessage('ECX_TRANSACTION_ID_NOT_NULL');

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:
721: If (p_ext_type is null)

Line 724: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TYPE_NOT_NULL');

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:
728: If (p_ext_subtype is null)

Line 731: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_SUBTYPE_NOT_NULL');

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:
735: if ( p_direction is null )

Line 738: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');

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:
742: if ( p_standard is null )

Line 745: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');

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:
749: if NOT (ECX_UTIL_API.validate_direction(p_direction))

Line 751: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);

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;
754: end if;
755:

Line 761: x_msg := ecx_debug.getTranslatedMessage('ECX_QUEUE_NAME_NOT_NULL');

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:
765: -- make sure it is a valid queue name.

Line 768: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);

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;
771: end if;
772: end if;

Line 784: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',

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;
788: end;

Line 836: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESSES_EXISTS',

832: );
833:
834: exception
835: when dup_val_on_index then
836: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESSES_EXISTS',
837: 'p_transaction_id', p_transaction_id,
838: 'p_ext_type', p_ext_type,
839: 'p_ext_subtype', p_ext_subtype
840: );

Line 946: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_ID_NOT_NULL','p_ext_process_id',p_ext_process_id);

942: x_msg := null;
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:

Line 954: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_TYPE_NOT_NULL');

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:
958: If (p_ext_subtype is null)

Line 961: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_SUBTYPE_NOT_NULL');

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:
965: if ( p_direction is null )

Line 968: x_msg := ecx_debug.getTranslatedMessage('ECX_DIRECTION_NOT_NULL');

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:
972: if ( p_standard is null )

Line 975: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_NULL');

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:
979: if NOT (ECX_UTIL_API.validate_direction(p_direction))

Line 981: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_DIRECTION','p_direction',p_direction);

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;
984: end if;
985:

Line 991: x_msg := ecx_debug.getTranslatedMessage('ECX_QUEUE_NAME_NOT_NULL');

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:
995: -- make sure it is a valid queue name.

Line 998: x_msg := ecx_debug.getTranslatedMessage('ECX_INVALID_QUEUE_NAME','p_queue_name',p_queue_name);

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;
1001: end if;
1002: end if;

Line 1013: x_msg := ecx_debug.getTranslatedMessage('ECX_STANDARD_NOT_FOUND',

1009: where standard_code = p_standard
1010: and standard_type = p_standard_type;
1011: exception
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;

Line 1042: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_UPDATED',

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;
1046:

Line 1049: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_EXISTS',

1045: end if;
1046:
1047: exception
1048: when dup_val_on_index then
1049: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_EXISTS',
1050: 'p_ext_process_id', p_ext_process_id,
1051: 'p_ext_type', p_ext_type,
1052: 'p_ext_subtype', p_ext_subtype
1053: );

Line 1077: x_msg := ecx_debug.getTranslatedMessage('ECX_EXT_PROCESS_ID_NOT_NULL');

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;
1079: return;
1080: end if;
1081:

Line 1090: x_msg := ecx_debug.getTranslatedMessage('ECX_TP_DETAIL_EXISTS','p_ext_process_id',p_ext_process_id);

1086: where ext_process_id = p_ext_process_id;
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:

Line 1101: x_msg := ecx_debug.getTranslatedMessage('ECX_NO_ROWS_DELETED',

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;
1105: