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.JL_CO_FA_TA_VALIDATE_PKG dependencies on FND_MESSAGE

Line 59: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');

55: err_msg VARCHAR2(200);
56:
57: BEGIN
58:
59: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);

Line 60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);

56:
57: BEGIN
58:
59: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
64: fnd_file.put_line( 1, fnd_message.get);

Line 62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');

58:
59: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
64: fnd_file.put_line( 1, fnd_message.get);
65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
66:

Line 63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);

59: fnd_message.set_name('JL', 'JL_CO_FA_PARAMETER');
60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
64: fnd_file.put_line( 1, fnd_message.get);
65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
66:
67: FOR rec_appraisal IN c_appraisals LOOP

Line 64: fnd_file.put_line( 1, fnd_message.get);

60: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
62: fnd_message.set_name('JL', 'JL_CO_FA_APPR_NUMBER');
63: fnd_message.set_token('APPRAISAL_NUMBER', p_appraisal_id);
64: fnd_file.put_line( 1, fnd_message.get);
65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
66:
67: FOR rec_appraisal IN c_appraisals LOOP
68:

Line 69: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');

65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');
66:
67: FOR rec_appraisal IN c_appraisals LOOP
68:
69: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');
70: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
71: fnd_file.put_line( 1, fnd_message.get);
72: /*Checking for the Fiscal Year */
73:

Line 70: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

66:
67: FOR rec_appraisal IN c_appraisals LOOP
68:
69: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');
70: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
71: fnd_file.put_line( 1, fnd_message.get);
72: /*Checking for the Fiscal Year */
73:
74: IF rec_appraisal.fiscal_year < 1990 THEN

Line 71: fnd_file.put_line( 1, fnd_message.get);

67: FOR rec_appraisal IN c_appraisals LOOP
68:
69: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');
70: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
71: fnd_file.put_line( 1, fnd_message.get);
72: /*Checking for the Fiscal Year */
73:
74: IF rec_appraisal.fiscal_year < 1990 THEN
75: x_appraisal_status := 'F';

Line 76: fnd_message.set_name('JL', 'JL_CO_FA_LESS_THAN_1990');

72: /*Checking for the Fiscal Year */
73:
74: IF rec_appraisal.fiscal_year < 1990 THEN
75: x_appraisal_status := 'F';
76: fnd_message.set_name('JL', 'JL_CO_FA_LESS_THAN_1990');
77: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
78: fnd_file.put_line( fnd_file.LOG, fnd_message.get);
79: END IF;
80:

Line 77: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

73:
74: IF rec_appraisal.fiscal_year < 1990 THEN
75: x_appraisal_status := 'F';
76: fnd_message.set_name('JL', 'JL_CO_FA_LESS_THAN_1990');
77: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
78: fnd_file.put_line( fnd_file.LOG, fnd_message.get);
79: END IF;
80:
81: /* Checking for valid currency Code */

Line 78: fnd_file.put_line( fnd_file.LOG, fnd_message.get);

74: IF rec_appraisal.fiscal_year < 1990 THEN
75: x_appraisal_status := 'F';
76: fnd_message.set_name('JL', 'JL_CO_FA_LESS_THAN_1990');
77: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
78: fnd_file.put_line( fnd_file.LOG, fnd_message.get);
79: END IF;
80:
81: /* Checking for valid currency Code */
82:

Line 89: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_CURRENCY_CODE');

85: IF x_appraisal_status = 'V' THEN
86: x_appraisal_status := 'C';
87: END IF;
88:
89: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_CURRENCY_CODE');
90: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
91: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
92: END IF;
93:

Line 90: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

86: x_appraisal_status := 'C';
87: END IF;
88:
89: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_CURRENCY_CODE');
90: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
91: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
92: END IF;
93:
94: FOR rec_asset IN c_assets(rec_appraisal.appraisal_id) LOOP

Line 91: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);

87: END IF;
88:
89: fnd_message.set_name('JL', 'JL_CO_FA_INVALID_CURRENCY_CODE');
90: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
91: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
92: END IF;
93:
94: FOR rec_asset IN c_assets(rec_appraisal.appraisal_id) LOOP
95:

Line 105: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_FOUND');

101: IF x_appraisal_status = 'V' THEN
102: x_appraisal_status := 'R';
103: END IF;
104:
105: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_FOUND');
106: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
107: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
108: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
109: END IF;

Line 106: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);

102: x_appraisal_status := 'R';
103: END IF;
104:
105: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_FOUND');
106: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
107: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
108: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
109: END IF;
110:

Line 107: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

103: END IF;
104:
105: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_FOUND');
106: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
107: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
108: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
109: END IF;
110:
111: /* Checking for appraisal value */

Line 108: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);

104:
105: fnd_message.set_name('JL', 'JL_CO_FA_ASSET_NOT_FOUND');
106: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
107: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
108: fnd_file.put_line(FND_FILE.LOG, fnd_message.get);
109: END IF;
110:
111: /* Checking for appraisal value */
112:

Line 121: fnd_message.set_name('JL', 'JL_CO_FA_NEGATIVE_VALUE');

117:
118: IF x_appraisal_status = 'V' THEN
119: x_appraisal_status := 'R';
120: END IF;
121: fnd_message.set_name('JL', 'JL_CO_FA_NEGATIVE_VALUE');
122: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
123: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
125: END IF;

Line 122: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);

118: IF x_appraisal_status = 'V' THEN
119: x_appraisal_status := 'R';
120: END IF;
121: fnd_message.set_name('JL', 'JL_CO_FA_NEGATIVE_VALUE');
122: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
123: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
125: END IF;
126:

Line 123: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);

119: x_appraisal_status := 'R';
120: END IF;
121: fnd_message.set_name('JL', 'JL_CO_FA_NEGATIVE_VALUE');
122: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
123: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
125: END IF;
126:
127:

Line 124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);

120: END IF;
121: fnd_message.set_name('JL', 'JL_CO_FA_NEGATIVE_VALUE');
122: fnd_message.set_token('APPRAISAL_NUMBER', rec_appraisal.appraisal_id);
123: fnd_message.set_token('ASSET_NUMBER', rec_asset.appr_asset_number);
124: fnd_file.put_line( FND_FILE.LOG, fnd_message.get);
125: END IF;
126:
127:
128: UPDATE jl_co_fa_asset_apprs

Line 149: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');

145: COMMIT WORK;
146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
150: fnd_file.put_line( 1, fnd_message.get);
151: err_num := SQLCODE;
152: err_msg := substr(SQLERRM, 1, 200);
153: RAISE_APPLICATION_ERROR( err_num, err_msg);

Line 150: fnd_file.put_line( 1, fnd_message.get);

146:
147: EXCEPTION
148: WHEN OTHERS THEN
149: fnd_message.set_name('JL', 'JL_CO_FA_GENERAL_ERROR');
150: fnd_file.put_line( 1, fnd_message.get);
151: err_num := SQLCODE;
152: err_msg := substr(SQLERRM, 1, 200);
153: RAISE_APPLICATION_ERROR( err_num, err_msg);
154: