DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on FND_MESSAGE

Line 424: l_errbuf := FND_MESSAGE.GET;

420: debug('Submitting with Parameters');
421: debug('Batch Id : '|| l_mass_edit_tbl(call_csr).entry_id);
422: debug('');
423: IF (l_request_id = 0) THEN
424: l_errbuf := FND_MESSAGE.GET;
425: debug('Call to Process Mass Edit Batch Concurrent Process has errored');
426: debug('For Batch Id'||l_mass_edit_tbl(call_csr).entry_id);
427: debug('Error message :'||substr(l_errbuf,1,75));
428: debug(' :'||substr(l_errbuf,76,150));

Line 1836: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');

1832: px_mass_edit_inst_tbl,
1833: x_output);
1834:
1835: IF x_output IS NOT NULL THEN
1836: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1837: FND_MESSAGE.set_token('INST_NUM',x_output);
1838: FND_MSG_PUB.add;
1839: RAISE FND_API.g_exc_error;
1840: END IF;

Line 1837: FND_MESSAGE.set_token('INST_NUM',x_output);

1833: x_output);
1834:
1835: IF x_output IS NOT NULL THEN
1836: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1837: FND_MESSAGE.set_token('INST_NUM',x_output);
1838: FND_MSG_PUB.add;
1839: RAISE FND_API.g_exc_error;
1840: END IF;
1841:

Line 1965: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

1961: -- either the batch id OR the batch name is required for a delete
1962: IF ( nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1963: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1964:
1965: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1966: FND_MESSAGE.set_token('API_NAME',l_api_name);
1967: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1968: FND_MSG_PUB.add;
1969: RAISE FND_API.g_exc_error;

Line 1966: FND_MESSAGE.set_token('API_NAME',l_api_name);

1962: IF ( nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1963: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1964:
1965: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1966: FND_MESSAGE.set_token('API_NAME',l_api_name);
1967: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1968: FND_MSG_PUB.add;
1969: RAISE FND_API.g_exc_error;
1970: END IF;

Line 1967: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');

1963: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1964:
1965: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1966: FND_MESSAGE.set_token('API_NAME',l_api_name);
1967: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1968: FND_MSG_PUB.add;
1969: RAISE FND_API.g_exc_error;
1970: END IF;
1971:

Line 2107: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

2103: FOR m_ind in p_mass_edit_tbl.FIRST .. p_mass_edit_tbl.LAST LOOP
2104: IF ( nvl(p_mass_edit_tbl(m_ind).entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2105: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
2106:
2107: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2108: FND_MESSAGE.set_token('API_NAME',l_api_name);
2109: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
2110: FND_MSG_PUB.add;
2111: RAISE FND_API.g_exc_error;

Line 2108: FND_MESSAGE.set_token('API_NAME',l_api_name);

2104: IF ( nvl(p_mass_edit_tbl(m_ind).entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2105: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
2106:
2107: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2108: FND_MESSAGE.set_token('API_NAME',l_api_name);
2109: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
2110: FND_MSG_PUB.add;
2111: RAISE FND_API.g_exc_error;
2112: END IF;

Line 2109: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');

2105: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
2106:
2107: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2108: FND_MESSAGE.set_token('API_NAME',l_api_name);
2109: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
2110: FND_MSG_PUB.add;
2111: RAISE FND_API.g_exc_error;
2112: END IF;
2113:

Line 2256: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');

2252: IF ( nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2253: AND nvl(px_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char
2254: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2255: ) THEN
2256: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2257: FND_MESSAGE.set_token('API_NAME',l_api_name);
2258: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2259: FND_MSG_PUB.add;
2260: RAISE FND_API.g_exc_error;

Line 2257: FND_MESSAGE.set_token('API_NAME',l_api_name);

2253: AND nvl(px_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char
2254: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2255: ) THEN
2256: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2257: FND_MESSAGE.set_token('API_NAME',l_api_name);
2258: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2259: FND_MSG_PUB.add;
2260: RAISE FND_API.g_exc_error;
2261: END IF;

Line 2258: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');

2254: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2255: ) THEN
2256: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2257: FND_MESSAGE.set_token('API_NAME',l_api_name);
2258: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2259: FND_MSG_PUB.add;
2260: RAISE FND_API.g_exc_error;
2261: END IF;
2262:

Line 2540: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');

2536: FETCH mu_customer_id_csr INTO l_mu_customer_id_rec;
2537: CLOSE mu_customer_id_csr;
2538: EXCEPTION
2539: WHEN NO_DATA_FOUND THEN
2540: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2541: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2542: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2543: fnd_msg_pub.add;
2544: RAISE FND_API.G_EXC_ERROR;

Line 2541: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);

2537: CLOSE mu_customer_id_csr;
2538: EXCEPTION
2539: WHEN NO_DATA_FOUND THEN
2540: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2541: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2542: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2543: fnd_msg_pub.add;
2544: RAISE FND_API.G_EXC_ERROR;
2545:

Line 2542: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);

2538: EXCEPTION
2539: WHEN NO_DATA_FOUND THEN
2540: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2541: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2542: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2543: fnd_msg_pub.add;
2544: RAISE FND_API.G_EXC_ERROR;
2545:
2546: WHEN TOO_MANY_ROWS THEN

Line 2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

2543: fnd_msg_pub.add;
2544: RAISE FND_API.G_EXC_ERROR;
2545:
2546: WHEN TOO_MANY_ROWS THEN
2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2548: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2549: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2550: fnd_msg_pub.add;
2551: RAISE FND_API.G_EXC_ERROR;

Line 2548: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);

2544: RAISE FND_API.G_EXC_ERROR;
2545:
2546: WHEN TOO_MANY_ROWS THEN
2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2548: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2549: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2550: fnd_msg_pub.add;
2551: RAISE FND_API.G_EXC_ERROR;
2552: WHEN OTHERS THEN

Line 2549: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);

2545:
2546: WHEN TOO_MANY_ROWS THEN
2547: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2548: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2549: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2550: fnd_msg_pub.add;
2551: RAISE FND_API.G_EXC_ERROR;
2552: WHEN OTHERS THEN
2553: debug('In to Others Exception while finding customer id');

Line 2882: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');

2878: FETCH SYS_CUST_CSR INTO l_sys_cust_rec;
2879: CLOSE SYS_CUST_CSR;
2880: EXCEPTION
2881: WHEN NO_DATA_FOUND THEN
2882: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2883: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2884: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_ERROR;

Line 2883: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);

2879: CLOSE SYS_CUST_CSR;
2880: EXCEPTION
2881: WHEN NO_DATA_FOUND THEN
2882: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2883: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2884: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_ERROR;
2887:

Line 2884: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);

2880: EXCEPTION
2881: WHEN NO_DATA_FOUND THEN
2882: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2883: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2884: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_ERROR;
2887:
2888: WHEN TOO_MANY_ROWS THEN

Line 2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');

2885: fnd_msg_pub.add;
2886: RAISE FND_API.G_EXC_ERROR;
2887:
2888: WHEN TOO_MANY_ROWS THEN
2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2890: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2891: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2892: fnd_msg_pub.add;
2893: RAISE FND_API.G_EXC_ERROR;

Line 2890: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);

2886: RAISE FND_API.G_EXC_ERROR;
2887:
2888: WHEN TOO_MANY_ROWS THEN
2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2890: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2891: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2892: fnd_msg_pub.add;
2893: RAISE FND_API.G_EXC_ERROR;
2894: WHEN OTHERS THEN

Line 2891: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);

2887:
2888: WHEN TOO_MANY_ROWS THEN
2889: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2890: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2891: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2892: fnd_msg_pub.add;
2893: RAISE FND_API.G_EXC_ERROR;
2894: WHEN OTHERS THEN
2895: debug('In to Others Exception while finding customer id');