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 4123: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');

4119: when avg_rates_no_ovhd then
4120: rollback;
4121: o_err_num := 9999;
4122: o_err_code := 'CST_NO_MAT_OVHDS';
4123: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');
4124: o_err_msg := FND_MESSAGE.Get;
4125: when overhead_error then
4126: rollback;
4127: o_err_num := 9999;

Line 4124: o_err_msg := FND_MESSAGE.Get;

4120: rollback;
4121: o_err_num := 9999;
4122: o_err_code := 'CST_NO_MAT_OVHDS';
4123: FND_MESSAGE.set_name('BOM', 'CST_NO_MAT_OVHDS');
4124: o_err_msg := FND_MESSAGE.Get;
4125: when overhead_error then
4126: rollback;
4127: o_err_num := 9999;
4128: o_err_code := 'CST_MAT_OVERHEAD';

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

4125: when overhead_error then
4126: rollback;
4127: o_err_num := 9999;
4128: o_err_code := 'CST_MAT_OVERHEAD';
4129: FND_MESSAGE.set_name('BOM', 'CST_MAT_OVERHEAD');
4130: o_err_msg := FND_MESSAGE.Get;
4131: when moh_rules_error then
4132: rollback;
4133: o_err_num := 9999;

Line 4130: o_err_msg := FND_MESSAGE.Get;

4126: rollback;
4127: o_err_num := 9999;
4128: o_err_code := 'CST_MAT_OVERHEAD';
4129: FND_MESSAGE.set_name('BOM', 'CST_MAT_OVERHEAD');
4130: o_err_msg := FND_MESSAGE.Get;
4131: when moh_rules_error then
4132: rollback;
4133: o_err_num := 9999;
4134: o_err_code := 'CST_RULES_ERROR';

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

4131: when moh_rules_error then
4132: rollback;
4133: o_err_num := 9999;
4134: o_err_code := 'CST_RULES_ERROR';
4135: FND_MESSAGE.set_name('BOM', 'CST_RULES_ERROR');
4136: o_err_msg := FND_MESSAGE.Get;
4137: when others then
4138: rollback;
4139: o_err_num := SQLCODE;

Line 4136: o_err_msg := FND_MESSAGE.Get;

4132: rollback;
4133: o_err_num := 9999;
4134: o_err_code := 'CST_RULES_ERROR';
4135: FND_MESSAGE.set_name('BOM', 'CST_RULES_ERROR');
4136: o_err_msg := FND_MESSAGE.Get;
4137: when others then
4138: rollback;
4139: o_err_num := SQLCODE;
4140: o_err_msg := 'CSTPLENG.apply_layer_material_ovhd (' || to_char(l_stmt_num) ||

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

5133: when neg_cost_error then
5134: rollback;
5135: o_err_num := 9999;
5136: o_err_code := 'CST_NEG_ITEM_COST';
5137: FND_MESSAGE.set_name('BOM', 'CST_NEG_ITEM_COST');
5138: o_err_msg := FND_MESSAGE.Get;
5139:
5140: /* when no_mctcd_error then
5141: rollback;

Line 5138: o_err_msg := FND_MESSAGE.Get;

5134: rollback;
5135: o_err_num := 9999;
5136: o_err_code := 'CST_NEG_ITEM_COST';
5137: FND_MESSAGE.set_name('BOM', 'CST_NEG_ITEM_COST');
5138: o_err_msg := FND_MESSAGE.Get;
5139:
5140: /* when no_mctcd_error then
5141: rollback;
5142: o_err_num := 9999;

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

5140: /* when no_mctcd_error then
5141: rollback;
5142: o_err_num := 9999;
5143: o_err_code := 'CST_NO_MCTCD';
5144: FND_MESSAGE.set_name('BOM', 'CST_NO_MCTCD');
5145: o_err_msg := FND_MESSAGE.Get;
5146: */
5147: when process_error then
5148: o_err_num := l_err_num;

Line 5145: o_err_msg := FND_MESSAGE.Get;

5141: rollback;
5142: o_err_num := 9999;
5143: o_err_code := 'CST_NO_MCTCD';
5144: FND_MESSAGE.set_name('BOM', 'CST_NO_MCTCD');
5145: o_err_msg := FND_MESSAGE.Get;
5146: */
5147: when process_error then
5148: o_err_num := l_err_num;
5149: o_err_code := l_err_code;

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

5637: (l_cost_elmt_id = 4 and i_osp_accnt is null) or
5638: (l_cost_elmt_id = 5 and i_ovhd_accnt is null)) then
5639: -- Error occured
5640:
5641: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5642: l_err_code := 'Invalid accounts.';
5643: l_err_msg := FND_MESSAGE.Get;
5644: l_err_num := 999;
5645:

Line 5643: l_err_msg := FND_MESSAGE.Get;

5639: -- Error occured
5640:
5641: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5642: l_err_code := 'Invalid accounts.';
5643: l_err_msg := FND_MESSAGE.Get;
5644: l_err_num := 999;
5645:
5646: raise cost_det_new_insert_error;
5647: end if;

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

5722:
5723: if (i_txn_action_id = 24 and i_mat_accnt is null) then
5724: -- Error occured only for layer cost update
5725:
5726: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5727: l_err_code := 'Invalid accounts.';
5728: l_err_msg := FND_MESSAGE.Get;
5729: l_err_num := 999;
5730:

Line 5728: l_err_msg := FND_MESSAGE.Get;

5724: -- Error occured only for layer cost update
5725:
5726: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_INVALID_ACCOUNT');
5727: l_err_code := 'Invalid accounts.';
5728: l_err_msg := FND_MESSAGE.Get;
5729: l_err_num := 999;
5730:
5731: raise cost_det_new_insert_error;
5732: end if;

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

6236: when no_acct_error then
6237: rollback;
6238: O_error_num := 9999;
6239: O_error_code := 'CST_NO_CG_ACCTS';
6240: FND_MESSAGE.set_name('BOM', 'CST_NO_CG_ACCTS');
6241: O_error_message := FND_MESSAGE.Get;
6242:
6243: when no_txn_det_error then
6244: rollback;

Line 6241: O_error_message := FND_MESSAGE.Get;

6237: rollback;
6238: O_error_num := 9999;
6239: O_error_code := 'CST_NO_CG_ACCTS';
6240: FND_MESSAGE.set_name('BOM', 'CST_NO_CG_ACCTS');
6241: O_error_message := FND_MESSAGE.Get;
6242:
6243: when no_txn_det_error then
6244: rollback;
6245: O_error_num := 9999;

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

6243: when no_txn_det_error then
6244: rollback;
6245: O_error_num := 9999;
6246: O_error_code := 'CST_NO_TXN_DET';
6247: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_DET');
6248: O_error_message := FND_MESSAGE.Get;
6249:
6250: when others then
6251: rollback;

Line 6248: O_error_message := FND_MESSAGE.Get;

6244: rollback;
6245: O_error_num := 9999;
6246: O_error_code := 'CST_NO_TXN_DET';
6247: FND_MESSAGE.set_name('BOM', 'CST_NO_TXN_DET');
6248: O_error_message := FND_MESSAGE.Get;
6249:
6250: when others then
6251: rollback;
6252: O_error_num := SQLCODE;