DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on FND_MESSAGE

Line 4904: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');

4900: OPEN validate_bill_to_site(l_ext_line_addr_id);
4901: FETCH validate_bill_to_site INTO l_exists;
4902: IF validate_bill_to_site%NOTFOUND THEN
4903: IF l_khr_id <> bill_tbl(k).khr_id THEN
4904: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');
4905: l_inv_bill_to_site_msg := fnd_message.get;
4906: -- insert into gt table
4907: insert_gt(bill_tbl(k).contract_number,
4908: l_party_name,

Line 4905: l_inv_bill_to_site_msg := fnd_message.get;

4901: FETCH validate_bill_to_site INTO l_exists;
4902: IF validate_bill_to_site%NOTFOUND THEN
4903: IF l_khr_id <> bill_tbl(k).khr_id THEN
4904: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');
4905: l_inv_bill_to_site_msg := fnd_message.get;
4906: -- insert into gt table
4907: insert_gt(bill_tbl(k).contract_number,
4908: l_party_name,
4909: l_account_number,

Line 4945: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');

4941: FETCH validate_pmt_method INTO l_exists;
4942:
4943: IF validate_pmt_method%NOTFOUND OR validate_cust_pmt_method%NOTFOUND THEN
4944: IF l_khr_id <> bill_tbl(k).khr_id THEN
4945: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');
4946: l_inv_pmt_method_msg := fnd_message.get;
4947: -- insert into gt table
4948: insert_gt(bill_tbl(k).contract_number,
4949: l_party_name,

Line 4946: l_inv_pmt_method_msg := fnd_message.get;

4942:
4943: IF validate_pmt_method%NOTFOUND OR validate_cust_pmt_method%NOTFOUND THEN
4944: IF l_khr_id <> bill_tbl(k).khr_id THEN
4945: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');
4946: l_inv_pmt_method_msg := fnd_message.get;
4947: -- insert into gt table
4948: insert_gt(bill_tbl(k).contract_number,
4949: l_party_name,
4950: l_account_number,

Line 4975: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');

4971:
4972: FOR l_validate_bank_account IN validate_bank_account(cp_instrument_payment_use_id => l_bank_line_id1) LOOP
4973: -- validate bank account id in iby
4974: IF l_validate_bank_account.instr_status = 'I' OR l_validate_bank_account.bnk_status = 'I' THEN
4975: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');
4976: l_inv_bank_account_msg := fnd_message.get;
4977: -- insert into gt table
4978: insert_gt(bill_tbl(k).contract_number,
4979: l_party_name,

Line 4976: l_inv_bank_account_msg := fnd_message.get;

4972: FOR l_validate_bank_account IN validate_bank_account(cp_instrument_payment_use_id => l_bank_line_id1) LOOP
4973: -- validate bank account id in iby
4974: IF l_validate_bank_account.instr_status = 'I' OR l_validate_bank_account.bnk_status = 'I' THEN
4975: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');
4976: l_inv_bank_account_msg := fnd_message.get;
4977: -- insert into gt table
4978: insert_gt(bill_tbl(k).contract_number,
4979: l_party_name,
4980: l_account_number,

Line 5000: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');

4996: OPEN validate_bill_to_site(l_ext_addr_id);
4997: FETCH validate_bill_to_site INTO l_exists;
4998: IF validate_bill_to_site%NOTFOUND THEN
4999: IF l_khr_id <> bill_tbl(k).khr_id THEN
5000: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');
5001: l_inv_bill_to_site_msg := fnd_message.get;
5002: -- insert into gt table
5003: insert_gt(bill_tbl(k).contract_number,
5004: l_party_name,

Line 5001: l_inv_bill_to_site_msg := fnd_message.get;

4997: FETCH validate_bill_to_site INTO l_exists;
4998: IF validate_bill_to_site%NOTFOUND THEN
4999: IF l_khr_id <> bill_tbl(k).khr_id THEN
5000: fnd_message.set_name('OKL','OKL_INVALID_BILL_TO_SITE');
5001: l_inv_bill_to_site_msg := fnd_message.get;
5002: -- insert into gt table
5003: insert_gt(bill_tbl(k).contract_number,
5004: l_party_name,
5005: l_account_number,

Line 5036: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');

5032: FETCH validate_pmt_method INTO l_exists;
5033:
5034: IF validate_pmt_method%NOTFOUND OR validate_cust_pmt_method%NOTFOUND THEN
5035: IF l_khr_id <> bill_tbl(k).khr_id THEN
5036: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');
5037: l_inv_pmt_method_msg := fnd_message.get;
5038: -- insert into gt table
5039: insert_gt(bill_tbl(k).contract_number,
5040: l_party_name,

Line 5037: l_inv_pmt_method_msg := fnd_message.get;

5033:
5034: IF validate_pmt_method%NOTFOUND OR validate_cust_pmt_method%NOTFOUND THEN
5035: IF l_khr_id <> bill_tbl(k).khr_id THEN
5036: fnd_message.set_name('OKL','OKL_INVALID_PMT_METHOD');
5037: l_inv_pmt_method_msg := fnd_message.get;
5038: -- insert into gt table
5039: insert_gt(bill_tbl(k).contract_number,
5040: l_party_name,
5041: l_account_number,

Line 5062: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');

5058: FOR l_validate_k_bank_account IN validate_k_bank_account(cp_khr_id => bill_tbl(k).khr_id) LOOP
5059: -- validate bank account id in iby
5060: IF l_validate_k_bank_account.instr_status = 'I' OR l_validate_k_bank_account.bnk_status = 'I' THEN
5061: IF l_khr_id <> bill_tbl(k).khr_id THEN
5062: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');
5063: l_inv_bank_account_msg := fnd_message.get;
5064: -- insert into gt table
5065: insert_gt(bill_tbl(k).contract_number,
5066: l_party_name,

Line 5063: l_inv_bank_account_msg := fnd_message.get;

5059: -- validate bank account id in iby
5060: IF l_validate_k_bank_account.instr_status = 'I' OR l_validate_k_bank_account.bnk_status = 'I' THEN
5061: IF l_khr_id <> bill_tbl(k).khr_id THEN
5062: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');
5063: l_inv_bank_account_msg := fnd_message.get;
5064: -- insert into gt table
5065: insert_gt(bill_tbl(k).contract_number,
5066: l_party_name,
5067: l_account_number,

Line 5088: fnd_message.set_name('OKL','OKL_INVALID_CCID');

5084: OPEN c_gl_ccid_valid (cp_ccid => l_ccid.code_combination_id,
5085: cp_bill_date => bill_tbl(k).bill_date);
5086: FETCH c_gl_ccid_valid INTO l_exists;
5087: IF c_gl_ccid_valid%NOTFOUND THEN
5088: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5089: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5090: l_inv_ccid_msg := fnd_message.get;
5091: -- insert into gt table
5092: insert_gt(bill_tbl(k).contract_number,

Line 5089: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);

5085: cp_bill_date => bill_tbl(k).bill_date);
5086: FETCH c_gl_ccid_valid INTO l_exists;
5087: IF c_gl_ccid_valid%NOTFOUND THEN
5088: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5089: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5090: l_inv_ccid_msg := fnd_message.get;
5091: -- insert into gt table
5092: insert_gt(bill_tbl(k).contract_number,
5093: l_party_name,

Line 5090: l_inv_ccid_msg := fnd_message.get;

5086: FETCH c_gl_ccid_valid INTO l_exists;
5087: IF c_gl_ccid_valid%NOTFOUND THEN
5088: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5089: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5090: l_inv_ccid_msg := fnd_message.get;
5091: -- insert into gt table
5092: insert_gt(bill_tbl(k).contract_number,
5093: l_party_name,
5094: l_account_number,