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 121: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

117: l_specific_count NUMBER;
118:
119: -- Logging Infra
120: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN';
121: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
122:
123: CURSOR tax_reg_num_csr(c_registration_number varchar2,
124: c_party_type_code varchar2,
125: c_tax_regime_code varchar2,

Line 247: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

243: x_party_site_name_token OUT NOCOPY VARCHAR2) IS
244: --------------------------------------------------------------------------
245: -- Logging Infra:
246: l_procedure_name CONSTANT VARCHAR2(30) := 'display_msg';
247: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
248:
249: l_party_name VARCHAR2(5000) := NULL;
250: l_party_site_name VARCHAR2(5000) := NULL;
251:

Line 370: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

366: x_party_name_token OUT NOCOPY VARCHAR2,
367: x_party_site_name_token OUT NOCOPY VARCHAR2) IS
368: --------------------------------------------------------------------------
369: l_procedure_name CONSTANT VARCHAR2(30) := 'display_cross_msg';
370: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
371: l_party_name VARCHAR2(5000) := NULL;
372: l_party_site_name VARCHAR2(5000) := NULL;
373:
374: BEGIN

Line 506: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

502: --------------------------------------------------------------------------
503:
504: -- Logging Infra:
505: l_procedure_name CONSTANT VARCHAR2(30) := 'validate_header_trn';
506: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
507:
508: BEGIN
509:
510: -- Logging Infra: Procedure level

Line 624: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

620: l_party_site_name VARCHAR2(5000);
621: l_allow_dup_regn_num_flag VARCHAR2(1);
622:
623: l_procedure_name CONSTANT VARCHAR2(30) := 'chk_dup_trn_with_no_tax_reg';
624: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
625:
626: BEGIN
627: -- Initialize
628: p_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1726: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1722: l_trn_type VARCHAR2(30);
1723:
1724: -- Logging Infra
1725: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_AT';
1726: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1727:
1728: /**************************/
1729: /* SUB-PROCEDURES SECTION */
1730: /**************************/

Line 1953: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

1949: l_trn_type VARCHAR2(30);
1950:
1951: -- Logging Infra
1952: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_BE';
1953: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
1954:
1955: /**************************/
1956: /* SUB-PROCEDURES SECTION */
1957: /**************************/

Line 2226: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2222: AS
2223:
2224: -- Logging Infra
2225: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_DK';
2226: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2227:
2228: BEGIN
2229:
2230: -- Logging Infra: Setting up runtime level

Line 2323: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2319: AS
2320:
2321: -- Logging Infra
2322: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_EE';
2323: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2324:
2325: BEGIN
2326:
2327: -- Logging Infra: Setting up runtime level

Line 2419: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2415: AS
2416:
2417: -- Logging Infra
2418: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_FI';
2419: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2420:
2421: BEGIN
2422:
2423: -- Logging Infra: Setting up runtime level

Line 2516: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2512: AS
2513:
2514: -- Logging Infra
2515: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_FR';
2516: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2517:
2518: function check_letter(check_value VARCHAR2,
2519: pos NUMBER)
2520: RETURN VARCHAR2

Line 2649: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2645: p_error_buffer OUT NOCOPY VARCHAR2)
2646: AS
2647: -- Logging Infra
2648: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_DE';
2649: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2650:
2651: BEGIN
2652:
2653: -- Logging Infra: Setting up runtime level

Line 2750: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2746: check_digit number(3);
2747:
2748: -- Logging Infra
2749: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_GR';
2750: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2751:
2752: BEGIN
2753:
2754: -- Logging Infra: Setting up runtime level

Line 2879: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

2875: AS
2876:
2877: -- Logging Infra
2878: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_IE';
2879: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
2880:
2881: function check_letter(check_value VARCHAR2,
2882: pos NUMBER)
2883: RETURN VARCHAR2

Line 3051: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3047: check_tot NUMBER(6);
3048:
3049: -- Logging Infra
3050: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_IT';
3051: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3052:
3053: /**************************/
3054: /* SUB-PROCEDURES SECTION */
3055: /**************************/

Line 3272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3268: AS
3269:
3270: -- Logging Infra
3271: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LU';
3272: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3273:
3274: BEGIN
3275:
3276: -- Logging Infra: Setting up runtime level

Line 3369: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3365: AS
3366:
3367: -- Logging Infra
3368: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_SK';
3369: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3370: trn_value VARCHAR2(50);
3371:
3372: BEGIN
3373:

Line 3493: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3489: check_result VARCHAR2(1);
3490:
3491: -- Logging Infra
3492: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_NL';
3493: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3494:
3495: /**************************/
3496: /* SUB-PROCEDURES SECTION */
3497: /**************************/

Line 3755: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3751: len number;
3752:
3753: -- Logging Infra
3754: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_PL';
3755: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3756: trn_value VARCHAR2(50);
3757:
3758: BEGIN
3759:

Line 3896: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

3892: TRN_STRING VARCHAR2(50);
3893:
3894: -- Logging Infra
3895: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_PT';
3896: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
3897:
3898: BEGIN
3899:
3900: -- Logging Infra: Setting up runtime level

Line 4050: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4046: whole_value VARCHAR2(50);
4047:
4048: -- Logging Infra
4049: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_ES';
4050: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4051: N_Check_Digit varchar2(26) := 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
4052: N_Check_Flag number := 0 ;
4053:
4054: /**************************/

Line 4350: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4346: AS
4347:
4348: -- Logging Infra
4349: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_SE';
4350: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4351:
4352: BEGIN
4353:
4354: -- Logging Infra: Setting up runtime level

Line 4458: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4454: position_i integer;
4455:
4456: -- Logging Infra
4457: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_GB';
4458: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4459:
4460: BEGIN
4461:
4462: -- Logging Infra: Setting up runtime level

Line 4621: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4617: AS
4618:
4619: -- Logging Infra
4620: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CH';
4621: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4622: l_result VARCHAR2(20); -- bug 14677337
4623:
4624: BEGIN
4625:

Line 4786: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4782: AS
4783:
4784: -- Logging Infra
4785: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_RU';
4786: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4787:
4788: BEGIN
4789:
4790: -- Logging Infra: Setting up runtime level

Line 4886: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

4882: l_trn_value VARCHAR2(50);
4883:
4884: -- Logging Infra
4885: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_HU';
4886: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
4887:
4888: BEGIN
4889:
4890: -- Logging Infra: Setting up runtime level

Line 5010: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5006: l_trn VARCHAR2(20);
5007:
5008: -- Logging Infra
5009: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_BR';
5010: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5011:
5012: BEGIN
5013:
5014: -- Logging Infra: Setting up runtime level

Line 5232: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5228: l_trn_digit VARCHAR2(1);
5229:
5230: -- Logging Infra
5231: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_AR';
5232: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5233:
5234: BEGIN
5235:
5236: -- Logging Infra: Setting up runtime level

Line 5372: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5368: l_trn_digit VARCHAR2(1);
5369:
5370: -- Logging Infra
5371: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CL';
5372: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5373:
5374: BEGIN
5375:
5376: -- Logging Infra: Setting up runtime level

Line 5512: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5508: l_mod_value NUMBER(2);
5509:
5510: -- Logging Infra
5511: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CO';
5512: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5513:
5514: BEGIN
5515:
5516: -- Logging Infra: Setting up runtime level

Line 5654: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5650: l_numeric_result VARCHAR2(10);
5651:
5652: -- Logging Infra
5653: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_TW';
5654: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5655:
5656: BEGIN
5657:
5658: -- Logging Infra: Setting up runtime level

Line 5746: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5742: AS
5743:
5744: -- Logging Infra
5745: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_MT';
5746: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5747:
5748: trn_value VARCHAR2(50);
5749: mt_prefix VARCHAR2(2);
5750:

Line 5923: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

5919: AS
5920:
5921: -- Logging Infra
5922: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LV';
5923: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
5924:
5925: trn_value VARCHAR2(50);
5926: lv_prefix VARCHAR2(2);
5927:

Line 6099: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

6095: AS
6096:
6097: -- Logging Infra
6098: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_MT';
6099: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6100:
6101: trn_value VARCHAR2(50);
6102: si_prefix VARCHAR2(2);
6103:

Line 6275: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

6271: AS
6272:
6273: -- Logging Infra
6274: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_LT';
6275: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6276:
6277: trn_value VARCHAR2(50);
6278: lt_prefix VARCHAR2(2);
6279:

Line 6459: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;

6455: AS
6456:
6457: -- Logging Infra
6458: l_procedure_name CONSTANT VARCHAR2(30) := 'VALIDATE_TRN_CY';
6459: l_log_msg FND_LOG_MESSAGES.MESSAGE_TEXT%TYPE;
6460:
6461:
6462: trn_value VARCHAR2(50);
6463: cy_prefix VARCHAR2(2);