DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on FND_MESSAGE

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

670:
671:
672: IF (l_req_running > 1) THEN /* More than one running, so error this one out*/
673: l_error_message := 'CST_ACC_ERROR';
674: fnd_message.set_name('BOM','CST_ACC_ERROR');
675: RAISE fnd_api.g_exc_error;
676: END IF;
677:
678:

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

691:
692:
693: IF l_acc_accounts = 0 THEN
694: l_error_message := 'CST_ACC_ACCOUNTS_ERR';
695: fnd_message.set_name('BOM','CST_ACC_ACCOUNTS_ERR');
696: RAISE fnd_api.g_exc_error;
697: END IF;
698:
699: l_stmt_num := 20;

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

758:
759:
760: IF l_p_from_date > l_to_date THEN
761: l_error_message := 'CST_INVALID_TO_DATE';
762: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
763: RAISE fnd_api.g_exc_error;
764: ELSE
765: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
766: fnd_message.set_token('MESSAGE','Calculated from_date:'||

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

761: l_error_message := 'CST_INVALID_TO_DATE';
762: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
763: RAISE fnd_api.g_exc_error;
764: ELSE
765: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
766: fnd_message.set_token('MESSAGE','Calculated from_date:'||
767: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||
768: TO_CHAR(l_to_date,'DD-MM-YYYY'));
769: RAISE stop_here;

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

762: fnd_message.set_name('BOM','CST_INVALID_TO_DATE');
763: RAISE fnd_api.g_exc_error;
764: ELSE
765: fnd_message.set_name('FND','FORM_TECHNICAL_ERROR');
766: fnd_message.set_token('MESSAGE','Calculated from_date:'||
767: TO_CHAR(l_from_date,'DD-MM-YYYY')||' > l_to_date:'||
768: TO_CHAR(l_to_date,'DD-MM-YYYY'));
769: RAISE stop_here;
770: END IF;

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

996: WHEN OTHERS THEN
997:
998: ROLLBACK;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: fnd_message.set_name('BOM','CST_UNEXPECTED');
1001: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
1002: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
1003: debug('l_stmt_num:'||l_stmt_num);
1004:

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

997:
998: ROLLBACK;
999: x_return_status := FND_API.g_ret_sts_unexp_error ;
1000: fnd_message.set_name('BOM','CST_UNEXPECTED');
1001: fnd_message.set_token('TOKEN',SUBSTRB(SQLERRM,1,180));
1002: debug('EXCEPTION OTHERS in accrual_load '||SUBSTRB(SQLERRM,1,180));
1003: debug('l_stmt_num:'||l_stmt_num);
1004:
1005: fnd_msg_pub.add;

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

2163: WHEN OTHERS THEN
2164: rollback;
2165: x_return_status := FND_API.g_ret_sts_unexp_error ;
2166: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2167: fnd_message.set_name('BOM','CST_UNEXPECTED');
2168: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2169: debug('l_stmt_num:'||l_stmt_num);
2170:
2171: fnd_msg_pub.add;

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

2164: rollback;
2165: x_return_status := FND_API.g_ret_sts_unexp_error ;
2166: debug('EXCEPTION OTHERS in Upgrade_old_data :'|| l_stmt_num || ' - ' || substrb(SQLERRM,1,180));
2167: fnd_message.set_name('BOM','CST_UNEXPECTED');
2168: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2169: debug('l_stmt_num:'||l_stmt_num);
2170:
2171: fnd_msg_pub.add;
2172:

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

2468:
2469: WHEN OTHERS THEN
2470: rollback;
2471: x_return_status := FND_API.g_ret_sts_unexp_error ;
2472: fnd_message.set_name('BOM','CST_UNEXPECTED');
2473: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2474: debug('l_stmt_num :'||l_stmt_num);
2475: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));
2476: fnd_msg_pub.add;

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

2469: WHEN OTHERS THEN
2470: rollback;
2471: x_return_status := FND_API.g_ret_sts_unexp_error ;
2472: fnd_message.set_name('BOM','CST_UNEXPECTED');
2473: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2474: debug('l_stmt_num :'||l_stmt_num);
2475: debug('EXCEPTION OTHERS in Load_ap_misc_data '||substrb(SQLERRM,1,180));
2476: fnd_msg_pub.add;
2477: FND_MSG_PUB.count_and_get

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

2939:
2940: WHEN OTHERS THEN
2941: rollback;
2942: x_return_status := FND_API.g_ret_sts_unexp_error ;
2943: fnd_message.set_name('BOM','CST_UNEXPECTED');
2944: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2945: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
2946: debug('l_stmt_num :'||l_stmt_num);
2947: fnd_msg_pub.add;

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

2940: WHEN OTHERS THEN
2941: rollback;
2942: x_return_status := FND_API.g_ret_sts_unexp_error ;
2943: fnd_message.set_name('BOM','CST_UNEXPECTED');
2944: fnd_message.set_token('TOKEN',substrb(SQLERRM,1,180));
2945: debug('EXCEPTION OTHERS in Load_inv_misc_data '||substrb(SQLERRM,1,140));
2946: debug('l_stmt_num :'||l_stmt_num);
2947: fnd_msg_pub.add;
2948: FND_MSG_PUB.count_and_get

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

3043:
3044: WHEN OTHERS THEN
3045: rollback;
3046: x_return_status := FND_API.g_ret_sts_unexp_error ;
3047: fnd_message.set_name('BOM','CST_UNEXPECTED');
3048: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3049: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3050: debug('l_stmt_num :'||l_stmt_num);
3051: fnd_msg_pub.add;

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

3044: WHEN OTHERS THEN
3045: rollback;
3046: x_return_status := FND_API.g_ret_sts_unexp_error ;
3047: fnd_message.set_name('BOM','CST_UNEXPECTED');
3048: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3049: debug('EXCEPTION OTHERS in Insert_build_parameters '||substrb(SQLERRM,1,140));
3050: debug('l_stmt_num :'||l_stmt_num);
3051: fnd_msg_pub.add;
3052: FND_MSG_PUB.count_and_get

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

3945: WHEN OTHERS THEN
3946: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
3947: CLOSE c_po_dists;
3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: fnd_message.set_name('BOM','CST_UNEXPECTED');
3950: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3951: ROLLBACK;
3952: fnd_msg_pub.add;
3953:

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

3946: debug('EXCEPTION OTHERS in Load_ap_po_data ' || l_stmt_num || ' ' || substrb(SQLERRM,1,140));
3947: CLOSE c_po_dists;
3948: x_return_status := FND_API.g_ret_sts_unexp_error ;
3949: fnd_message.set_name('BOM','CST_UNEXPECTED');
3950: fnd_message.set_token('TOKEN',substr(SQLERRM,1,180));
3951: ROLLBACK;
3952: fnd_msg_pub.add;
3953:
3954: FND_MSG_PUB.count_and_get