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.ZX_TRN_VALIDATION_PKG dependencies on FND_LOG_MESSAGES

Line 99: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

95: l_specific_count NUMBER;
96:
97: -- Logging Infra
98: l_procedure_name CONSTANT VARCHAR2(30) := 'validate_trn';
99: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
100:
101: CURSOR tax_reg_num_csr(c_registration_number varchar2, c_party_type_code varchar2, c_tax_regime_code varchar2, c_tax varchar2, c_tax_jurisdiction_code varchar2) IS
102:
103: SELECT distinct ptp.party_id

Line 224: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

220: x_party_site_name_token OUT NOCOPY VARCHAR2) IS
221: --------------------------------------------------------------------------
222: -- Logging Infra:
223: l_procedure_name CONSTANT VARCHAR2(30) := 'display_msg';
224: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
225:
226: l_party_name VARCHAR2(5000) := NULL;
227: l_party_site_name VARCHAR2(5000) := NULL;
228:

Line 347: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

343: x_party_name_token OUT NOCOPY VARCHAR2,
344: x_party_site_name_token OUT NOCOPY VARCHAR2) IS
345: --------------------------------------------------------------------------
346: l_procedure_name CONSTANT VARCHAR2(30) := 'display_cross_msg';
347: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
348: l_party_name VARCHAR2(5000) := NULL;
349: l_party_site_name VARCHAR2(5000) := NULL;
350:
351: BEGIN

Line 482: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

478: --------------------------------------------------------------------------
479:
480: -- Logging Infra:
481: l_procedure_name CONSTANT VARCHAR2(30) := 'validate_header_trn';
482: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
483:
484: BEGIN
485:
486: -- Logging Infra: Procedure level

Line 1189: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1185: l_trn_type VARCHAR2(30);
1186:
1187: -- Logging Infra
1188: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_AT';
1189: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1190:
1191: /**************************/
1192: /* SUB-PROCEDURES SECTION */
1193: /**************************/

Line 1416: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1412: l_trn_type VARCHAR2(30);
1413:
1414: -- Logging Infra
1415: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_BE';
1416: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1417:
1418: /**************************/
1419: /* SUB-PROCEDURES SECTION */
1420: /**************************/

Line 1693: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1689: AS
1690:
1691: -- Logging Infra
1692: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_DK';
1693: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1694:
1695: BEGIN
1696:
1697: -- Logging Infra: Setting up runtime level

Line 1790: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1786: AS
1787:
1788: -- Logging Infra
1789: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_EE';
1790: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1791:
1792: BEGIN
1793:
1794: -- Logging Infra: Setting up runtime level

Line 1886: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1882: AS
1883:
1884: -- Logging Infra
1885: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_FI';
1886: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1887:
1888: BEGIN
1889:
1890: -- Logging Infra: Setting up runtime level

Line 1983: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1979: AS
1980:
1981: -- Logging Infra
1982: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_FR';
1983: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1984:
1985: function check_letter(check_value VARCHAR2,
1986: pos NUMBER)
1987: RETURN VARCHAR2

Line 2116: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2112: p_error_buffer OUT NOCOPY VARCHAR2)
2113: AS
2114: -- Logging Infra
2115: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_DE';
2116: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2117:
2118: BEGIN
2119:
2120: -- Logging Infra: Setting up runtime level

Line 2217: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2213: check_digit number(3);
2214:
2215: -- Logging Infra
2216: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_GR';
2217: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2218:
2219: BEGIN
2220:
2221: -- Logging Infra: Setting up runtime level

Line 2346: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2342: AS
2343:
2344: -- Logging Infra
2345: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_IE';
2346: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2347:
2348: function check_letter(check_value VARCHAR2,
2349: pos NUMBER)
2350: RETURN VARCHAR2

Line 2518: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2514: check_tot NUMBER(6);
2515:
2516: -- Logging Infra
2517: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_IT';
2518: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2519:
2520: /**************************/
2521: /* SUB-PROCEDURES SECTION */
2522: /**************************/

Line 2739: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2735: AS
2736:
2737: -- Logging Infra
2738: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LU';
2739: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2740:
2741: BEGIN
2742:
2743: -- Logging Infra: Setting up runtime level

Line 2836: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2832: AS
2833:
2834: -- Logging Infra
2835: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_SK';
2836: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2837: trn_value VARCHAR2(50);
2838:
2839: BEGIN
2840:

Line 2960: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2956: check_result VARCHAR2(1);
2957:
2958: -- Logging Infra
2959: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_NL';
2960: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2961:
2962: /**************************/
2963: /* SUB-PROCEDURES SECTION */
2964: /**************************/

Line 3223: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3219: len number;
3220:
3221: -- Logging Infra
3222: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_PL';
3223: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3224: trn_value VARCHAR2(50);
3225:
3226: BEGIN
3227:

Line 3364: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3360: TRN_STRING VARCHAR2(50);
3361:
3362: -- Logging Infra
3363: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_PT';
3364: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3365:
3366: BEGIN
3367:
3368: -- Logging Infra: Setting up runtime level

Line 3518: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3514: whole_value VARCHAR2(50);
3515:
3516: -- Logging Infra
3517: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_ES';
3518: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3519: N_Check_Digit varchar2(26) := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
3520: N_Check_Flag number := 0 ;
3521:
3522: /**************************/

Line 3821: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3817: AS
3818:
3819: -- Logging Infra
3820: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_SE';
3821: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3822:
3823: BEGIN
3824:
3825: -- Logging Infra: Setting up runtime level

Line 3928: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3924: position_i integer;
3925:
3926: -- Logging Infra
3927: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_GB';
3928: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3929:
3930: BEGIN
3931:
3932: -- Logging Infra: Setting up runtime level

Line 4072: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4068: AS
4069:
4070: -- Logging Infra
4071: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CH';
4072: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4073:
4074: BEGIN
4075:
4076: -- Logging Infra: Setting up runtime level

Line 4169: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4165: AS
4166:
4167: -- Logging Infra
4168: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_RU';
4169: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4170:
4171: BEGIN
4172:
4173: -- Logging Infra: Setting up runtime level

Line 4269: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4265: l_trn_value VARCHAR2(50);
4266:
4267: -- Logging Infra
4268: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_HU';
4269: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4270:
4271: BEGIN
4272:
4273: -- Logging Infra: Setting up runtime level

Line 4393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4389: l_control_digit_XX VARCHAR2(2);
4390:
4391: -- Logging Infra
4392: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_BR';
4393: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4394:
4395: BEGIN
4396:
4397: -- Logging Infra: Setting up runtime level

Line 4616: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4612: l_trn_digit VARCHAR2(1);
4613:
4614: -- Logging Infra
4615: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_AR';
4616: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4617:
4618: BEGIN
4619:
4620: -- Logging Infra: Setting up runtime level

Line 4757: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4753: l_trn_digit VARCHAR2(1);
4754:
4755: -- Logging Infra
4756: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CL';
4757: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4758:
4759: BEGIN
4760:
4761: -- Logging Infra: Setting up runtime level

Line 4898: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4894: l_mod_value NUMBER(2);
4895:
4896: -- Logging Infra
4897: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CO';
4898: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4899:
4900: BEGIN
4901:
4902: -- Logging Infra: Setting up runtime level

Line 5041: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5037: l_numeric_result VARCHAR2(10);
5038:
5039: -- Logging Infra
5040: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_TW';
5041: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5042:
5043: BEGIN
5044:
5045: -- Logging Infra: Setting up runtime level

Line 5133: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5129: AS
5130:
5131: -- Logging Infra
5132: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_MT';
5133: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5134:
5135: trn_value VARCHAR2(50);
5136: mt_prefix VARCHAR2(2);
5137:

Line 5310: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5306: AS
5307:
5308: -- Logging Infra
5309: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LV';
5310: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5311:
5312: trn_value VARCHAR2(50);
5313: lv_prefix VARCHAR2(2);
5314:

Line 5486: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5482: AS
5483:
5484: -- Logging Infra
5485: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_MT';
5486: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5487:
5488: trn_value VARCHAR2(50);
5489: si_prefix VARCHAR2(2);
5490:

Line 5662: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5658: AS
5659:
5660: -- Logging Infra
5661: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LT';
5662: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5663:
5664: trn_value VARCHAR2(50);
5665: lt_prefix VARCHAR2(2);
5666:

Line 5846: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5842: AS
5843:
5844: -- Logging Infra
5845: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CY';
5846: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5847:
5848:
5849: trn_value VARCHAR2(50);
5850: cy_prefix VARCHAR2(2);