DBA Data[Home] [Help]

APPS.CSI_MASS_EDIT_PUB dependencies on FND_MESSAGE

Line 351: l_errbuf := FND_MESSAGE.GET;

347: debug('Submitting with Parameters');
348: debug('Batch Id : '|| l_mass_edit_tbl(call_csr).entry_id);
349: debug('');
350: IF (l_request_id = 0) THEN
351: l_errbuf := FND_MESSAGE.GET;
352: debug('Call to Process Mass Edit Batch Concurrent Process has errored');
353: debug('For Batch Id'||l_mass_edit_tbl(call_csr).entry_id);
354: debug('Error message :'||substr(l_errbuf,1,75));
355: debug(' :'||substr(l_errbuf,76,150));

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

1717: px_mass_edit_inst_tbl,
1718: x_output);
1719:
1720: IF x_output IS NOT NULL THEN
1721: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1722: FND_MESSAGE.set_token('INST_NUM',x_output);
1723: FND_MSG_PUB.add;
1724: RAISE FND_API.g_exc_error;
1725: END IF;

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

1718: x_output);
1719:
1720: IF x_output IS NOT NULL THEN
1721: FND_MESSAGE.set_name('CSI','CSI_MU_DUP_BATCH_INSTANCES');
1722: FND_MESSAGE.set_token('INST_NUM',x_output);
1723: FND_MSG_PUB.add;
1724: RAISE FND_API.g_exc_error;
1725: END IF;
1726:

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

1846: -- either the batch id OR the batch name is required for a delete
1847: IF ( nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1848: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1849:
1850: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1851: FND_MESSAGE.set_token('API_NAME',l_api_name);
1852: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1853: FND_MSG_PUB.add;
1854: RAISE FND_API.g_exc_error;

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

1847: IF ( nvl(p_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1848: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1849:
1850: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1851: FND_MESSAGE.set_token('API_NAME',l_api_name);
1852: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1853: FND_MSG_PUB.add;
1854: RAISE FND_API.g_exc_error;
1855: END IF;

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

1848: AND nvl(p_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1849:
1850: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1851: FND_MESSAGE.set_token('API_NAME',l_api_name);
1852: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1853: FND_MSG_PUB.add;
1854: RAISE FND_API.g_exc_error;
1855: END IF;
1856:

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

1988: FOR m_ind in p_mass_edit_tbl.FIRST .. p_mass_edit_tbl.LAST LOOP
1989: IF ( nvl(p_mass_edit_tbl(m_ind).entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1990: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1991:
1992: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1993: FND_MESSAGE.set_token('API_NAME',l_api_name);
1994: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1995: FND_MSG_PUB.add;
1996: RAISE FND_API.g_exc_error;

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

1989: IF ( nvl(p_mass_edit_tbl(m_ind).entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
1990: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1991:
1992: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1993: FND_MESSAGE.set_token('API_NAME',l_api_name);
1994: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1995: FND_MSG_PUB.add;
1996: RAISE FND_API.g_exc_error;
1997: END IF;

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

1990: AND nvl(p_mass_edit_tbl(m_ind).name, fnd_api.g_miss_char) = fnd_api.g_miss_char ) THEN
1991:
1992: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
1993: FND_MESSAGE.set_token('API_NAME',l_api_name);
1994: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID OR Batch Name');
1995: FND_MSG_PUB.add;
1996: RAISE FND_API.g_exc_error;
1997: END IF;
1998:

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

2137: IF ( nvl(px_mass_edit_rec.entry_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2138: AND nvl(px_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char
2139: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2140: ) THEN
2141: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2142: FND_MESSAGE.set_token('API_NAME',l_api_name);
2143: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2144: FND_MSG_PUB.add;
2145: RAISE FND_API.g_exc_error;

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

2138: AND nvl(px_mass_edit_rec.name, fnd_api.g_miss_char) = fnd_api.g_miss_char
2139: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2140: ) THEN
2141: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2142: FND_MESSAGE.set_token('API_NAME',l_api_name);
2143: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2144: FND_MSG_PUB.add;
2145: RAISE FND_API.g_exc_error;
2146: END IF;

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

2139: AND nvl(px_mass_edit_rec.txn_line_id, fnd_api.g_miss_num) = fnd_api.g_miss_num
2140: ) THEN
2141: FND_MESSAGE.set_name('CSI','CSI_API_REQD_PARAM_MISSING');
2142: FND_MESSAGE.set_token('API_NAME',l_api_name);
2143: FND_MESSAGE.set_token('MISSING_PARAM','Batch ID / Batch Name / Transaction Line ID');
2144: FND_MSG_PUB.add;
2145: RAISE FND_API.g_exc_error;
2146: END IF;
2147:

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

2421: FETCH mu_customer_id_csr INTO l_mu_customer_id_rec;
2422: CLOSE mu_customer_id_csr;
2423: EXCEPTION
2424: WHEN NO_DATA_FOUND THEN
2425: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2426: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2427: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2428: fnd_msg_pub.add;
2429: RAISE FND_API.G_EXC_ERROR;

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

2422: CLOSE mu_customer_id_csr;
2423: EXCEPTION
2424: WHEN NO_DATA_FOUND THEN
2425: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2426: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2427: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2428: fnd_msg_pub.add;
2429: RAISE FND_API.G_EXC_ERROR;
2430:

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

2423: EXCEPTION
2424: WHEN NO_DATA_FOUND THEN
2425: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2426: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2427: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2428: fnd_msg_pub.add;
2429: RAISE FND_API.G_EXC_ERROR;
2430:
2431: WHEN TOO_MANY_ROWS THEN

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

2428: fnd_msg_pub.add;
2429: RAISE FND_API.G_EXC_ERROR;
2430:
2431: WHEN TOO_MANY_ROWS THEN
2432: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2433: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2434: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2435: fnd_msg_pub.add;
2436: RAISE FND_API.G_EXC_ERROR;

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

2429: RAISE FND_API.G_EXC_ERROR;
2430:
2431: WHEN TOO_MANY_ROWS THEN
2432: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2433: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2434: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2435: fnd_msg_pub.add;
2436: RAISE FND_API.G_EXC_ERROR;
2437: WHEN OTHERS THEN

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

2430:
2431: WHEN TOO_MANY_ROWS THEN
2432: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2433: fnd_message.set_token('PARTY_ID',l_mu_new_party_rec.PartyId);
2434: fnd_message.set_token('ACCOUNT_NUMBER',l_mu_new_party_rec.AccountId);
2435: fnd_msg_pub.add;
2436: RAISE FND_API.G_EXC_ERROR;
2437: WHEN OTHERS THEN
2438: debug('In to Others Exception while finding customer id');

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

2763: FETCH SYS_CUST_CSR INTO l_sys_cust_rec;
2764: CLOSE SYS_CUST_CSR;
2765: EXCEPTION
2766: WHEN NO_DATA_FOUND THEN
2767: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2768: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2769: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2770: fnd_msg_pub.add;
2771: RAISE FND_API.G_EXC_ERROR;

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

2764: CLOSE SYS_CUST_CSR;
2765: EXCEPTION
2766: WHEN NO_DATA_FOUND THEN
2767: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2768: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2769: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2770: fnd_msg_pub.add;
2771: RAISE FND_API.G_EXC_ERROR;
2772:

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

2765: EXCEPTION
2766: WHEN NO_DATA_FOUND THEN
2767: fnd_message.set_name('CSI', 'CSI_CUSTOMER_ID_NOT_FOUND');
2768: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2769: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2770: fnd_msg_pub.add;
2771: RAISE FND_API.G_EXC_ERROR;
2772:
2773: WHEN TOO_MANY_ROWS THEN

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

2770: fnd_msg_pub.add;
2771: RAISE FND_API.G_EXC_ERROR;
2772:
2773: WHEN TOO_MANY_ROWS THEN
2774: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2775: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2776: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2777: fnd_msg_pub.add;
2778: RAISE FND_API.G_EXC_ERROR;

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

2771: RAISE FND_API.G_EXC_ERROR;
2772:
2773: WHEN TOO_MANY_ROWS THEN
2774: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2775: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2776: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2777: fnd_msg_pub.add;
2778: RAISE FND_API.G_EXC_ERROR;
2779: WHEN OTHERS THEN

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

2772:
2773: WHEN TOO_MANY_ROWS THEN
2774: fnd_message.set_name('CSI', 'CSI_MULTIPLE_CUSTOMER_ID_FOUND');
2775: fnd_message.set_token('PARTY_ID',l_sys_acct_rec.Party_Id);
2776: fnd_message.set_token('ACCOUNT_NUMBER',l_sys_acct_rec.Account_Id);
2777: fnd_msg_pub.add;
2778: RAISE FND_API.G_EXC_ERROR;
2779: WHEN OTHERS THEN
2780: debug('In to Others Exception while finding customer id');