DBA Data[Home] [Help]

APPS.OKL_REPORT_PVT dependencies on FND_MESSAGE

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

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

Line 4906: l_inv_bill_to_site_msg := fnd_message.get;

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

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

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

Line 4947: l_inv_pmt_method_msg := fnd_message.get;

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

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

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

Line 4977: l_inv_bank_account_msg := fnd_message.get;

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

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

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

Line 5002: l_inv_bill_to_site_msg := fnd_message.get;

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

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

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

Line 5041: l_inv_pmt_method_msg := fnd_message.get;

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

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

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

Line 5069: l_inv_bank_account_msg := fnd_message.get;

5065: -- validate bank account id in iby
5066: IF l_validate_k_bank_account.instr_status = 'I' OR l_validate_k_bank_account.bnk_status = 'I' THEN
5067: IF l_khr_id <> bill_tbl(k).khr_id THEN
5068: fnd_message.set_name('OKL','OKL_INVALID_BANK_ACCT');
5069: l_inv_bank_account_msg := fnd_message.get;
5070: -- insert into gt table
5071: insert_gt(bill_tbl(k).contract_number,
5072: l_party_name,
5073: l_account_number,

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

5092: OPEN c_gl_ccid_valid (cp_ccid => l_ccid.code_combination_id,
5093: cp_bill_date => bill_tbl(k).bill_date);
5094: FETCH c_gl_ccid_valid INTO l_exists;
5095: IF c_gl_ccid_valid%NOTFOUND THEN
5096: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5097: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5098: l_inv_ccid_msg := fnd_message.get;
5099: -- insert into gt table
5100: insert_gt(bill_tbl(k).contract_number,

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

5093: cp_bill_date => bill_tbl(k).bill_date);
5094: FETCH c_gl_ccid_valid INTO l_exists;
5095: IF c_gl_ccid_valid%NOTFOUND THEN
5096: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5097: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5098: l_inv_ccid_msg := fnd_message.get;
5099: -- insert into gt table
5100: insert_gt(bill_tbl(k).contract_number,
5101: l_party_name,

Line 5098: l_inv_ccid_msg := fnd_message.get;

5094: FETCH c_gl_ccid_valid INTO l_exists;
5095: IF c_gl_ccid_valid%NOTFOUND THEN
5096: fnd_message.set_name('OKL','OKL_INVALID_CCID');
5097: fnd_message.set_token('STREAM_TYPE', bill_tbl(k).sty_name);
5098: l_inv_ccid_msg := fnd_message.get;
5099: -- insert into gt table
5100: insert_gt(bill_tbl(k).contract_number,
5101: l_party_name,
5102: l_account_number,