DBA Data[Home] [Help]

APPS.FII_AP_PAY_STATUS dependencies on FND_MESSAGE

Line 249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');

245: | FII_MEASURE2 - Number of Invoices |
246: +--------------------------------------------------------------*/
247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');

Line 250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');

246: +--------------------------------------------------------------*/
247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');

Line 251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');

247:
248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:

Line 252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');

248: /****************Messages to be displayed in the report**************/ /* Added for bug 3120355 */
249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent

Line 253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');

249: stmt1 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE1');
250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent
257: -- Following sql changed for customer bug-6028881. Added supplier to where clause

Line 254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');

250: stmt2 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE2');
251: stmt3 := FND_MESSAGE.get_string('FII', 'FII_AP_PAST_DUE3');
252: stmt4 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE3');
253: stmt5 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE2');
254: stmt6 := FND_MESSAGE.get_string('FII', 'FII_AP_DUE1');
255:
256: -- Construct the sql query to be sent
257: -- Following sql changed for customer bug-6028881. Added supplier to where clause
258: sqlstmt := '