DBA Data[Home] [Help]

APPS.CSTPLENG dependencies on FND_MESSAGE

Line 148: FND_MESSAGE.set_name('BOM','CST_NO_COST_HOOK_DATA');

144: return l_ret_val;
145: when rows_not_found then
146: o_err_num := l_err_num;
147: o_err_code := 'CST_NO_COST_HOOK_DATA';
148: FND_MESSAGE.set_name('BOM','CST_NO_COST_HOOK_DATA');
149: o_err_msg := FND_MESSAGE.get;
150: l_ret_val := 0;
151: return l_ret_val;
152: when others then

Line 149: o_err_msg := FND_MESSAGE.get;

145: when rows_not_found then
146: o_err_num := l_err_num;
147: o_err_code := 'CST_NO_COST_HOOK_DATA';
148: FND_MESSAGE.set_name('BOM','CST_NO_COST_HOOK_DATA');
149: o_err_msg := FND_MESSAGE.get;
150: l_ret_val := 0;
151: return l_ret_val;
152: when others then
153: rollback;

Line 693: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

689:
690: if (l_return_status <> fnd_api.g_ret_sts_success) then
691: FND_FILE.put_line(FND_FILE.log, l_msg_data);
692: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
693: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
694: FND_MESSAGE.set_token('TEXT', l_api_message);
695: FND_MSG_pub.add;
696: raise fnd_api.g_exc_unexpected_error;
697: end if;

Line 694: FND_MESSAGE.set_token('TEXT', l_api_message);

690: if (l_return_status <> fnd_api.g_ret_sts_success) then
691: FND_FILE.put_line(FND_FILE.log, l_msg_data);
692: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
693: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
694: FND_MESSAGE.set_token('TEXT', l_api_message);
695: FND_MSG_pub.add;
696: raise fnd_api.g_exc_unexpected_error;
697: end if;
698:

Line 767: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

763:
764: if (l_return_status <> fnd_api.g_ret_sts_success) then
765: FND_FILE.put_line(FND_FILE.log, l_msg_data);
766: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
767: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
768: FND_MESSAGE.set_token('TEXT', l_api_message);
769: FND_MSG_pub.add;
770: raise fnd_api.g_exc_unexpected_error;
771: end if;

Line 768: FND_MESSAGE.set_token('TEXT', l_api_message);

764: if (l_return_status <> fnd_api.g_ret_sts_success) then
765: FND_FILE.put_line(FND_FILE.log, l_msg_data);
766: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
767: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
768: FND_MESSAGE.set_token('TEXT', l_api_message);
769: FND_MSG_pub.add;
770: raise fnd_api.g_exc_unexpected_error;
771: end if;
772:

Line 1146: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

1142:
1143: if (l_return_status <> fnd_api.g_ret_sts_success) then
1144: FND_FILE.put_line(FND_FILE.log, l_msg_data);
1145: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
1146: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
1147: FND_MESSAGE.set_token('TEXT', l_api_message);
1148: FND_MSG_pub.add;
1149: raise fnd_api.g_exc_unexpected_error;
1150: end if;

Line 1147: FND_MESSAGE.set_token('TEXT', l_api_message);

1143: if (l_return_status <> fnd_api.g_ret_sts_success) then
1144: FND_FILE.put_line(FND_FILE.log, l_msg_data);
1145: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
1146: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
1147: FND_MESSAGE.set_token('TEXT', l_api_message);
1148: FND_MSG_pub.add;
1149: raise fnd_api.g_exc_unexpected_error;
1150: end if;
1151:

Line 1218: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');

1214:
1215: if (l_return_status <> fnd_api.g_ret_sts_success) then
1216: FND_FILE.put_line(FND_FILE.log, l_msg_data);
1217: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
1218: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
1219: FND_MESSAGE.set_token('TEXT', l_api_message);
1220: FND_MSG_pub.add;
1221: raise fnd_api.g_exc_unexpected_error;
1222: end if;

Line 1219: FND_MESSAGE.set_token('TEXT', l_api_message);

1215: if (l_return_status <> fnd_api.g_ret_sts_success) then
1216: FND_FILE.put_line(FND_FILE.log, l_msg_data);
1217: l_api_message := 'get_zeroCostIssue_flag returned unexpected error';
1218: FND_MESSAGE.set_name('BOM','CST_API_MESSAGE');
1219: FND_MESSAGE.set_token('TEXT', l_api_message);
1220: FND_MSG_pub.add;
1221: raise fnd_api.g_exc_unexpected_error;
1222: end if;
1223:

Line 4102: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');

4098: when avg_rates_no_ovhd then
4099: rollback;
4100: o_err_num := 9999;
4101: o_err_code := 'CST_NO_MAT_OVHDS';
4102: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');
4103: o_err_msg := FND_MESSAGE.Get;
4104: when overhead_error then
4105: rollback;
4106: o_err_num := 9999;

Line 4103: o_err_msg := FND_MESSAGE.Get;

4099: rollback;
4100: o_err_num := 9999;
4101: o_err_code := 'CST_NO_MAT_OVHDS';
4102: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');
4103: o_err_msg := FND_MESSAGE.Get;
4104: when overhead_error then
4105: rollback;
4106: o_err_num := 9999;
4107: o_err_code := 'CST_MAT_OVERHEAD';

Line 4108: FND_MESSAGE.set_name('BOM', 'CST_MAT_OVERHEAD');

4104: when overhead_error then
4105: rollback;
4106: o_err_num := 9999;
4107: o_err_code := 'CST_MAT_OVERHEAD';
4108: FND_MESSAGE.set_name('BOM', 'CST_MAT_OVERHEAD');
4109: o_err_msg := FND_MESSAGE.Get;
4110: when moh_rules_error then
4111: rollback;
4112: o_err_num := 9999;

Line 4109: o_err_msg := FND_MESSAGE.Get;

4105: rollback;
4106: o_err_num := 9999;
4107: o_err_code := 'CST_MAT_OVERHEAD';
4108: FND_MESSAGE.set_name('BOM', 'CST_MAT_OVERHEAD');
4109: o_err_msg := FND_MESSAGE.Get;
4110: when moh_rules_error then
4111: rollback;
4112: o_err_num := 9999;
4113: o_err_code := 'CST_RULES_ERROR';

Line 4114: FND_MESSAGE.set_name('BOM', 'CST_RULES_ERROR');

4110: when moh_rules_error then
4111: rollback;
4112: o_err_num := 9999;
4113: o_err_code := 'CST_RULES_ERROR';
4114: FND_MESSAGE.set_name('BOM', 'CST_RULES_ERROR');
4115: o_err_msg := FND_MESSAGE.Get;
4116: when others then
4117: rollback;
4118: o_err_num := SQLCODE;

Line 4115: o_err_msg := FND_MESSAGE.Get;

4111: rollback;
4112: o_err_num := 9999;
4113: o_err_code := 'CST_RULES_ERROR';
4114: FND_MESSAGE.set_name('BOM', 'CST_RULES_ERROR');
4115: o_err_msg := FND_MESSAGE.Get;
4116: when others then
4117: rollback;
4118: o_err_num := SQLCODE;
4119: o_err_msg := 'CSTPLENG.apply_layer_material_ovhd (' || to_char(l_stmt_num) ||

Line 5033: FND_MESSAGE.set_name('BOM', 'CST_NEG_ITEM_COST');

5029: when neg_cost_error then
5030: rollback;
5031: o_err_num := 9999;
5032: o_err_code := 'CST_NEG_ITEM_COST';
5033: FND_MESSAGE.set_name('BOM', 'CST_NEG_ITEM_COST');
5034: o_err_msg := FND_MESSAGE.Get;
5035:
5036: /* when no_mctcd_error then
5037: rollback;

Line 5034: o_err_msg := FND_MESSAGE.Get;

5030: rollback;
5031: o_err_num := 9999;
5032: o_err_code := 'CST_NEG_ITEM_COST';
5033: FND_MESSAGE.set_name('BOM', 'CST_NEG_ITEM_COST');
5034: o_err_msg := FND_MESSAGE.Get;
5035:
5036: /* when no_mctcd_error then
5037: rollback;
5038: o_err_num := 9999;

Line 5040: FND_MESSAGE.set_name('BOM', 'CST_NO_MCTCD');

5036: /* when no_mctcd_error then
5037: rollback;
5038: o_err_num := 9999;
5039: o_err_code := 'CST_NO_MCTCD';
5040: FND_MESSAGE.set_name('BOM', 'CST_NO_MCTCD');
5041: o_err_msg := FND_MESSAGE.Get;
5042: */
5043: when process_error then
5044: o_err_num := l_err_num;

Line 5041: o_err_msg := FND_MESSAGE.Get;

5037: rollback;
5038: o_err_num := 9999;
5039: o_err_code := 'CST_NO_MCTCD';
5040: FND_MESSAGE.set_name('BOM', 'CST_NO_MCTCD');
5041: o_err_msg := FND_MESSAGE.Get;
5042: */
5043: when process_error then
5044: o_err_num := l_err_num;
5045: o_err_code := l_err_code;

Line 5537: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');

5533: (l_cost_elmt_id = 4 and i_osp_accnt is null) or
5534: (l_cost_elmt_id = 5 and i_ovhd_accnt is null)) then
5535: -- Error occured
5536:
5537: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5538: l_err_code := 'Invalid accounts.';
5539: l_err_msg := FND_MESSAGE.Get;
5540: l_err_num := 999;
5541:

Line 5539: l_err_msg := FND_MESSAGE.Get;

5535: -- Error occured
5536:
5537: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5538: l_err_code := 'Invalid accounts.';
5539: l_err_msg := FND_MESSAGE.Get;
5540: l_err_num := 999;
5541:
5542: raise cost_det_new_insert_error;
5543: end if;

Line 5622: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');

5618:
5619: if (i_txn_action_id = 24 and i_mat_accnt is null) then
5620: -- Error occured only for layer cost update
5621:
5622: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5623: l_err_code := 'Invalid accounts.';
5624: l_err_msg := FND_MESSAGE.Get;
5625: l_err_num := 999;
5626:

Line 5624: l_err_msg := FND_MESSAGE.Get;

5620: -- Error occured only for layer cost update
5621:
5622: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5623: l_err_code := 'Invalid accounts.';
5624: l_err_msg := FND_MESSAGE.Get;
5625: l_err_num := 999;
5626:
5627: raise cost_det_new_insert_error;
5628: end if;

Line 6128: FND_MESSAGE.set_name('BOM', 'CST_NO_CG_ACCTS');

6124: when no_acct_error then
6125: rollback;
6126: O_error_num := 9999;
6127: O_error_code := 'CST_NO_CG_ACCTS';
6128: FND_MESSAGE.set_name('BOM', 'CST_NO_CG_ACCTS');
6129: O_error_message := FND_MESSAGE.Get;
6130:
6131: when no_txn_det_error then
6132: rollback;

Line 6129: O_error_message := FND_MESSAGE.Get;

6125: rollback;
6126: O_error_num := 9999;
6127: O_error_code := 'CST_NO_CG_ACCTS';
6128: FND_MESSAGE.set_name('BOM', 'CST_NO_CG_ACCTS');
6129: O_error_message := FND_MESSAGE.Get;
6130:
6131: when no_txn_det_error then
6132: rollback;
6133: O_error_num := 9999;

Line 6135: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_DET');

6131: when no_txn_det_error then
6132: rollback;
6133: O_error_num := 9999;
6134: O_error_code := 'CST_NO_TXN_DET';
6135: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_DET');
6136: O_error_message := FND_MESSAGE.Get;
6137:
6138: when others then
6139: rollback;

Line 6136: O_error_message := FND_MESSAGE.Get;

6132: rollback;
6133: O_error_num := 9999;
6134: O_error_code := 'CST_NO_TXN_DET';
6135: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_DET');
6136: O_error_message := FND_MESSAGE.Get;
6137:
6138: when others then
6139: rollback;
6140: O_error_num := SQLCODE;