DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_VALIDATE_PKG dependencies on FND_FILE

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 61: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');

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);
65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');

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 65: fnd_file.put_line(FND_FILE.LOG, '----------------------------------------');

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:
69: fnd_message.set_name('JL', 'JL_CO_FA_APPR_MESG');

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 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 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 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 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 142: fnd_file.put_line(FND_FILE.LOG, ' ');

138: SET appraisal_status = x_appraisal_status
139: WHERE current of c_appraisals;
140:
141: x_appraisal_status := 'V';
142: fnd_file.put_line(FND_FILE.LOG, ' ');
143: END LOOP;
144:
145: COMMIT WORK;
146:

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: