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));
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;
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:
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;
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;
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:
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;
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;
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:
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;
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;
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:
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;
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:
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
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;
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
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');
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;
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:
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
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;
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
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');