DBA Data[Home] [Help]

APPS.IBY_DISBURSEMENT_SETUP_PUB dependencies on IBY_FORMATS_VL

Line 1526: FROM IBY_FORMATS_VL f

1522:
1523: CURSOR payment_formats_csr(p_payment_format_code VARCHAR2)
1524: IS
1525: SELECT COUNT(f.format_code)
1526: FROM IBY_FORMATS_VL f
1527: WHERE f.format_code = p_payment_format_code;
1528:
1529: CURSOR pmt_mthds_csr(p_payment_mthd_code VARCHAR2)
1530: IS

Line 1690: -- 7. Validate Payment Format Code (table: IBY_FORMATS_VL)

1686: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1687: print_debuginfo(l_module_name, 'Validate Payment Format Code');
1688: print_debuginfo(l_module_name, 'Payment Format Code::'||p_ext_payee_rec.Pmt_Format);
1689: END IF;
1690: -- 7. Validate Payment Format Code (table: IBY_FORMATS_VL)
1691: -- is not mandatory
1692: IF (p_ext_payee_rec.Pmt_Format IS NOT NULL) THEN
1693: OPEN payment_formats_csr(p_ext_payee_rec.Pmt_Format);
1694: FETCH payment_formats_csr INTO l_count;

Line 1702: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');

1698: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
1699: print_debuginfo(l_module_name, 'InValid Payment Format Code');
1700: END IF;
1701: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1702: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');
1703: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pmt_Format);
1704: FND_MSG_PUB.Add;
1705: l_valid := FALSE;
1706: END IF;