DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on FND_MESSAGE

Line 666: fnd_message.set_name('BOM','CST_ACC_ERROR');

662:
663:
664: IF (l_req_running > 1) THEN /* More than one running, so error this one out*/
665: l_error_message := 'CST_ACC_ERROR';
666: fnd_message.set_name('BOM','CST_ACC_ERROR');
667: RAISE fnd_api.g_exc_error;
668: END IF;
669:
670:

Line 687: fnd_message.set_name('BOM','CST_ACC_ACCOUNTS_ERR');

683:
684:
685: IF l_acc_accounts = 0 THEN
686: l_error_message := 'CST_ACC_ACCOUNTS_ERR';
687: fnd_message.set_name('BOM','CST_ACC_ACCOUNTS_ERR');
688: RAISE fnd_api.g_exc_error;
689: END IF;
690:
691: l_stmt_num := 20;

Line 754: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');

750:
751:
752: IF l_p_from_date > l_to_date THEN
753: l_error_message := 'CST_INVALID_TO_DATE';
754: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
755: RAISE fnd_api.g_exc_error;
756: ELSE
757: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
758: fnd_message.set_token('MESSAGE','Calculated from_date:'||

Line 757: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');

753: l_error_message := 'CST_INVALID_TO_DATE';
754: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
755: RAISE fnd_api.g_exc_error;
756: ELSE
757: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
758: fnd_message.set_token('MESSAGE','Calculated from_date:'||
759: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||
760: TO_CHAR(l_to_date,'DD-MM-YYYY'));
761: RAISE stop_here;

Line 758: fnd_message.set_token('MESSAGE','Calculated from_date:'||

754: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
755: RAISE fnd_api.g_exc_error;
756: ELSE
757: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
758: fnd_message.set_token('MESSAGE','Calculated from_date:'||
759: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||
760: TO_CHAR(l_to_date,'DD-MM-YYYY'));
761: RAISE stop_here;
762: END IF;

Line 976: fnd_message.set_name('BOM','CST_UNEXPECTED');

972: WHEN OTHERS THEN
973:
974: ROLLBACK;
975: x_return_status := FND_API.g_ret_sts_unexp_error ;
976: fnd_message.set_name('BOM','CST_UNEXPECTED');
977: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
978: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
979: debug('l_stmt_num:'||l_stmt_num);
980:

Line 977: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));

973:
974: ROLLBACK;
975: x_return_status := FND_API.g_ret_sts_unexp_error ;
976: fnd_message.set_name('BOM','CST_UNEXPECTED');
977: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
978: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
979: debug('l_stmt_num:'||l_stmt_num);
980:
981: fnd_msg_pub.add;

Line 2237: fnd_message.set_name('BOM','CST_UNEXPECTED');

2233: WHEN OTHERS THEN
2234: rollback;
2235: x_return_status := FND_API.g_ret_sts_unexp_error ;
2236: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2237: fnd_message.set_name('BOM','CST_UNEXPECTED');
2238: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2239: debug('l_stmt_num:'||l_stmt_num);
2240:
2241: fnd_msg_pub.add;

Line 2238: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));

2234: rollback;
2235: x_return_status := FND_API.g_ret_sts_unexp_error ;
2236: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2237: fnd_message.set_name('BOM','CST_UNEXPECTED');
2238: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2239: debug('l_stmt_num:'||l_stmt_num);
2240:
2241: fnd_msg_pub.add;
2242:

Line 2629: fnd_message.set_name('BOM','CST_UNEXPECTED');

2625:
2626: WHEN OTHERS THEN
2627: rollback;
2628: x_return_status := FND_API.g_ret_sts_unexp_error ;
2629: fnd_message.set_name('BOM','CST_UNEXPECTED');
2630: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2631: debug('l_stmt_num :'||l_stmt_num);
2632: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));
2633: fnd_msg_pub.add;

Line 2630: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));

2626: WHEN OTHERS THEN
2627: rollback;
2628: x_return_status := FND_API.g_ret_sts_unexp_error ;
2629: fnd_message.set_name('BOM','CST_UNEXPECTED');
2630: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2631: debug('l_stmt_num :'||l_stmt_num);
2632: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));
2633: fnd_msg_pub.add;
2634: FND_MSG_PUB.count_and_get

Line 3241: fnd_message.set_name('BOM','CST_UNEXPECTED');

3237:
3238: WHEN OTHERS THEN
3239: rollback;
3240: x_return_status := FND_API.g_ret_sts_unexp_error ;
3241: fnd_message.set_name('BOM','CST_UNEXPECTED');
3242: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
3243: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
3244: debug('l_stmt_num :'||l_stmt_num);
3245: fnd_msg_pub.add;

Line 3242: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));

3238: WHEN OTHERS THEN
3239: rollback;
3240: x_return_status := FND_API.g_ret_sts_unexp_error ;
3241: fnd_message.set_name('BOM','CST_UNEXPECTED');
3242: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
3243: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
3244: debug('l_stmt_num :'||l_stmt_num);
3245: fnd_msg_pub.add;
3246: FND_MSG_PUB.count_and_get

Line 3345: fnd_message.set_name('BOM','CST_UNEXPECTED');

3341:
3342: WHEN OTHERS THEN
3343: rollback;
3344: x_return_status := FND_API.g_ret_sts_unexp_error ;
3345: fnd_message.set_name('BOM','CST_UNEXPECTED');
3346: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3347: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3348: debug('l_stmt_num :'||l_stmt_num);
3349: fnd_msg_pub.add;

Line 3346: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));

3342: WHEN OTHERS THEN
3343: rollback;
3344: x_return_status := FND_API.g_ret_sts_unexp_error ;
3345: fnd_message.set_name('BOM','CST_UNEXPECTED');
3346: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3347: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3348: debug('l_stmt_num :'||l_stmt_num);
3349: fnd_msg_pub.add;
3350: FND_MSG_PUB.count_and_get

Line 4320: fnd_message.set_name('BOM','CST_UNEXPECTED');

4316: WHEN OTHERS THEN
4317: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
4318: CLOSE c_po_dists;
4319: x_return_status := FND_API.g_ret_sts_unexp_error ;
4320: fnd_message.set_name('BOM','CST_UNEXPECTED');
4321: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
4322: ROLLBACK;
4323: fnd_msg_pub.add;
4324:

Line 4321: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));

4317: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
4318: CLOSE c_po_dists;
4319: x_return_status := FND_API.g_ret_sts_unexp_error ;
4320: fnd_message.set_name('BOM','CST_UNEXPECTED');
4321: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
4322: ROLLBACK;
4323: fnd_msg_pub.add;
4324:
4325: FND_MSG_PUB.count_and_get