DBA Data[Home] [Help]

APPS.CSD_HV_WIP_JOB_PVT dependencies on FND_MESSAGE

Line 168: -- to the fnd_message stack.

164: END;
165:
166:
167: -- this procedure adds any errors from the wip_interface_errors table
168: -- to the fnd_message stack.
169: -- assumption: each group has one type of transaction (op, material, resource)
170: --
171: PROCEDURE add_wip_interface_errors(p_group_id NUMBER, p_txn_type NUMBER) IS
172: -- CONSTANTS --

Line 218: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_OP_ERR');

214:
215: FOR wip_interface_rec in c_wip_interface_errors
216: LOOP
217: IF (p_txn_type = lc_txn_type_operations) THEN
218: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_OP_ERR');
219:
220: ELSIF (p_txn_type = lc_txn_type_materials) THEN
221: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_MTL_ERR');
222: open c_item_name(wip_interface_rec.inventory_item_id_new,

Line 221: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_MTL_ERR');

217: IF (p_txn_type = lc_txn_type_operations) THEN
218: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_OP_ERR');
219:
220: ELSIF (p_txn_type = lc_txn_type_materials) THEN
221: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_MTL_ERR');
222: open c_item_name(wip_interface_rec.inventory_item_id_new,
223: wip_interface_rec.organization_id);
224: fetch c_item_name into l_item_name;
225: close c_item_name;

Line 226: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item_name);

222: open c_item_name(wip_interface_rec.inventory_item_id_new,
223: wip_interface_rec.organization_id);
224: fetch c_item_name into l_item_name;
225: close c_item_name;
226: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item_name);
227:
228: ELSIF (p_txn_type = lc_txn_type_resources) THEN
229: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
230: open c_resource_name(wip_interface_rec.resource_id_new);

Line 229: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');

225: close c_item_name;
226: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item_name);
227:
228: ELSIF (p_txn_type = lc_txn_type_resources) THEN
229: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
230: open c_resource_name(wip_interface_rec.resource_id_new);
231: fetch c_resource_name into l_resource_name;
232: close c_resource_name;
233: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);

Line 233: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);

229: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
230: open c_resource_name(wip_interface_rec.resource_id_new);
231: fetch c_resource_name into l_resource_name;
232: close c_resource_name;
233: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
234: END IF;
235:
236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);

Line 236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);

232: close c_resource_name;
233: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
234: END IF;
235:
236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
238: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
239: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
240: FND_MSG_PUB.ADD;

Line 237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);

233: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
234: END IF;
235:
236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
238: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
239: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
240: FND_MSG_PUB.ADD;
241: END LOOP;

Line 238: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);

234: END IF;
235:
236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
238: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
239: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
240: FND_MSG_PUB.ADD;
241: END LOOP;
242: END add_wip_interface_errors;

Line 239: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);

235:
236: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
237: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
238: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
239: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
240: FND_MSG_PUB.ADD;
241: END LOOP;
242: END add_wip_interface_errors;
243:

Line 505: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');

501: l_job_header_rec.alternate_bom_designator
502: );
503: EXCEPTION
504: WHEN OTHERS THEN
505: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
506: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
507: FND_MSG_PUB.ADD;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RETURN;

Line 506: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );

502: );
503: EXCEPTION
504: WHEN OTHERS THEN
505: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
506: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
507: FND_MSG_PUB.ADD;
508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
509: RETURN;
510: END;

Line 698: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');

694:
695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');
699: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);
700: FND_MSG_PUB.ADD;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: RETURN;

Line 699: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);

695:
696: EXCEPTION
697: WHEN OTHERS THEN
698: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');
699: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);
700: FND_MSG_PUB.ADD;
701: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
702: RETURN;
703: END;

Line 841: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');

837:
838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');
842: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );
843: FND_MSG_PUB.ADD;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: RETURN;

Line 842: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );

838:
839: EXCEPTION
840: WHEN OTHERS THEN
841: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');
842: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );
843: FND_MSG_PUB.ADD;
844: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
845: RETURN;
846: END;

Line 908: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_UPDATE_ERR');

904:
905:
906: EXCEPTION
907: WHEN OTHERS THEN
908: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_UPDATE_ERR');
909: FND_MSG_PUB.ADD;
910: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: RETURN;
912: END;

Line 997: FND_MESSAGE.SET_NAME('CSD','CSD_TXN_LOTS_INSERT_ERR');

993:
994:
995: EXCEPTION
996: WHEN OTHERS THEN
997: FND_MESSAGE.SET_NAME('CSD','CSD_TXN_LOTS_INSERT_ERR');
998: FND_MSG_PUB.ADD;
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1000: RETURN;
1001: END;

Line 1063: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_UPDATE_ERR');

1059: p_srl_nmbrs_interface_rec.transaction_interface_id;
1060:
1061: EXCEPTION
1062: WHEN OTHERS THEN
1063: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_UPDATE_ERR');
1064: FND_MSG_PUB.ADD;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: RETURN;
1067: END;

Line 1106: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_INSERT_ERR');

1102:
1103:
1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_INSERT_ERR');
1107: FND_MSG_PUB.ADD;
1108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1109: RETURN;
1110: END;

Line 1243: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_COST_TXN_INSERT_ERR');

1239:
1240:
1241: EXCEPTION
1242: WHEN OTHERS THEN
1243: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_COST_TXN_INSERT_ERR');
1244: FND_MSG_PUB.ADD;
1245: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: RETURN;
1247:

Line 1372: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_MOVE_TXN_INSERT_ERR');

1368:
1369:
1370: EXCEPTION
1371: WHEN OTHERS THEN
1372: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_MOVE_TXN_INSERT_ERR');
1373: FND_MSG_PUB.ADD;
1374: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1375: RETURN;
1376:

Line 1461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');

1457: x_transaction_header_id => l_transaction_header_id
1458: );
1459:
1460: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1462: FND_MSG_PUB.ADD;
1463: RAISE FND_API.G_EXC_ERROR;
1464: END IF;
1465:

Line 1485: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');

1481: p_txn_header_id => l_transaction_header_id
1482: -- p_txn_type IN VARCHAR2
1483: );
1484: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1485: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1486: FND_MSG_PUB.ADD;
1487: RAISE FND_API.G_EXC_ERROR;
1488: END IF;
1489: ELSE

Line 1757: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_MV_NOT_ALL');

1753: l_last_move_allowed;
1754: IF (get_last_operation_dtls%FOUND) THEN
1755: l_transaction_quantity := l_last_op_move_quantity;
1756: IF l_last_move_allowed = 'N' THEN
1757: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_MV_NOT_ALL');
1758: FND_MSG_PUB.ADD;
1759: close get_last_operation_dtls;
1760: RAISE FND_API.G_EXC_ERROR;
1761: END IF;

Line 1766: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_ZER_QTY');

1762: END IF;
1763: close get_last_operation_dtls;
1764:
1765: IF l_transaction_quantity <= 0 THEN
1766: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_ZER_QTY');
1767: FND_MSG_PUB.ADD;
1768: RAISE FND_API.G_EXC_ERROR;
1769: END IF;
1770:

Line 2058: FND_MESSAGE.SET_NAME('CSD','CSD_PROCESS_MTI_TXN_FAILURE');

2054: p_header_id => p_txn_header_id );
2055:
2056: IF ( txn_int_error_exists( p_txn_header_id) or
2057: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
2058: FND_MESSAGE.SET_NAME('CSD','CSD_PROCESS_MTI_TXN_FAILURE');
2059: FND_MSG_PUB.ADD;
2060: RAISE FND_API.G_EXC_ERROR;
2061: END IF;
2062:

Line 2272: FND_MESSAGE.SET_NAME('CSD','CSD_OP_COMP_SEQ_ERROR');

2268: -- the quantities are passed forward. Currently, do not allow the user
2269: -- to skip operations for the same job. (eg, complete 10, skip 20, complete 30)
2270: IF l_prev_wip_entity_id = p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id THEN
2271: IF l_prev_to_operation_seq_num <> p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num THEN
2272: FND_MESSAGE.SET_NAME('CSD','CSD_OP_COMP_SEQ_ERROR');
2273: FND_MSG_PUB.ADD;
2274: RAISE FND_API.G_EXC_ERROR;
2275: ELSE
2276: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +

Line 2372: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');

2368:
2369: -- ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2370:
2371:
2372: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2373: FND_MSG_PUB.ADD;
2374: RAISE FND_API.G_EXC_ERROR;
2375: -- Need to rollback Raise exception -
2376: -- once commit is removed from above call

Line 2388: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');

2384: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2385: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2386:
2387:
2388: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2389: FND_MSG_PUB.ADD;
2390: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2391:
2392:

Line 2673: FND_MESSAGE.SET_NAME('CSD','CSD_ISS_QTY_ZERO');

2669:
2670: l_transactions_interface_rec.transaction_quantity := (-1) * p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity;
2671:
2672: If l_transactions_interface_rec.transaction_quantity = 0 then
2673: FND_MESSAGE.SET_NAME('CSD','CSD_ISS_QTY_ZERO');
2674: FND_MSG_PUB.ADD;
2675: RAISE FND_API.G_EXC_ERROR;
2676: end if;
2677:

Line 3158: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');

3154:
3155:
3156: -- IF nvl( x_msg_count, 0 ) = 0 THEN
3157:
3158: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3159: FND_MSG_PUB.ADD;
3160:
3161: RAISE FND_API.G_EXC_ERROR;
3162:

Line 3196: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');

3192: If ( ml_error_exists( l_job_header_rec.group_id ) or
3193: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3194:
3195:
3196: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');
3197: FND_MSG_PUB.ADD;
3198: x_return_status := FND_API.G_RET_STS_ERROR;
3199:
3200: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3236: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');

3232: -- ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3233: -- dbms_output.put_line('WIP Update Error');
3234:
3235:
3236: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3237: FND_MSG_PUB.ADD;
3238: RETURN; */
3239: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3240:

Line 3387: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');

3383: p_mtl_txn_dtls_tbl => p_mtl_txn_dtls_tbl,
3384: p_transaction_header_id => p_transaction_header_id
3385: );
3386: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3387: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3388: FND_MSG_PUB.ADD;
3389: RAISE FND_API.G_EXC_ERROR;
3390: END IF;
3391:

Line 3409: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');

3405: p_txn_header_id => p_transaction_header_id
3406: -- p_txn_type IN VARCHAR2
3407: );
3408: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3409: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3410: FND_MSG_PUB.ADD;
3411: RAISE FND_API.G_EXC_ERROR;
3412: END IF;
3413:

Line 3785: FND_MESSAGE.SET_NAME('CSD','CSD_ATCHG_TYP_NULL');

3781: -- If autocharge_type is null, throw an error and return;
3782: -- Uncomment following later - once profiles are defined
3783: /* IF l_job_details_rec.autocharge_type is NULL THEN
3784:
3785: FND_MESSAGE.SET_NAME('CSD','CSD_ATCHG_TYP_NULL');
3786: FND_MSG_PUB.ADD;
3787: RAISE FND_API.G_EXC_ERROR;
3788: end if;
3789:

Line 3797: FND_MESSAGE.SET_NAME('CSD','CSD_BASIS_TYP_NULL');

3793: -- If basis_type is null, throw an error and return;
3794:
3795: IF l_job_details_rec.basis_type is NULL THEN
3796:
3797: FND_MESSAGE.SET_NAME('CSD','CSD_BASIS_TYP_NULL');
3798: FND_MSG_PUB.ADD;
3799: RAISE FND_API.G_EXC_ERROR;
3800: end if;
3801:

Line 3808: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_FLG_NULL');

3804: -- If scheduled_flag is null, throw an error and return;
3805:
3806: IF l_job_details_rec.scheduled_flag is NULL THEN
3807:
3808: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_FLG_NULL');
3809: FND_MSG_PUB.ADD;
3810: RAISE FND_API.G_EXC_ERROR;
3811: end if;
3812:

Line 3819: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');

3815: -- If standard_rate_flag is null, throw an error and return;
3816:
3817: IF l_job_details_rec.standard_rate_flag is NULL THEN
3818:
3819: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');
3820: FND_MSG_PUB.ADD;
3821: RAISE FND_API.G_EXC_ERROR;
3822: end if; */
3823:

Line 3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');

3846: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
3847: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
3848:
3849: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
3850: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');
3851: FND_MSG_PUB.ADD;
3852: RAISE FND_API.G_EXC_ERROR;
3853: end if;
3854:

Line 4048: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');

4044:
4045: If ( ml_error_exists( l_job_header_rec.group_id ) or
4046: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4047:
4048: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');
4049: FND_MSG_PUB.ADD;
4050: x_return_status := FND_API.G_RET_STS_ERROR;
4051:
4052: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4086: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_FAILURE');

4082:
4083: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4084: -- ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4085:
4086: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_FAILURE');
4087: FND_MSG_PUB.ADD;
4088: RETURN; -- later - once wip works - can remove this
4089: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4090: */

Line 4329: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_OP_DEPT_NULL');

4325: -- department has been specified, so throw an error.
4326: -- we cannot add the material to operation 1 since
4327: -- it would force a wip_supply_type of pull, which
4328: -- required backflush.
4329: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_OP_DEPT_NULL');
4330: FND_MSG_PUB.ADD;
4331: RAISE FND_API.G_EXC_ERROR;
4332: else
4333: l_op_dtls_tbl(1).new_row := 'Y';

Line 4360: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');

4356: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4357: l_op_seq_num := l_op_dtls_tbl(1).operation_seq_num;
4358: x_op_created := FND_API.G_TRUE;
4359: else
4360: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');
4361: FND_MSG_PUB.ADD;
4362: RAISE FND_API.G_EXC_ERROR;
4363: end if;
4364: end if; -- department profile

Line 4394: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');

4390: l_job_details_rec.wip_entity_id := p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id;
4391: l_job_details_rec.supply_subinventory := p_mtl_txn_dtls_tbl(mtl_ctr).supply_subinventory;
4392:
4393: If l_job_details_rec.supply_subinventory is null then
4394: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
4395: FND_MSG_PUB.ADD;
4396: RAISE FND_API.G_EXC_ERROR;
4397: end if;
4398:

Line 4454: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');

4450:
4451: If ( ml_error_exists( l_job_header_rec.group_id ) or
4452: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4453:
4454: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
4455: FND_MSG_PUB.ADD;
4456: x_return_status := FND_API.G_RET_STS_ERROR;
4457:
4458: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4873: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');

4869:
4870: If ( ml_error_exists( l_job_header_rec.group_id ) or
4871: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4872:
4873: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');
4874: FND_MSG_PUB.ADD;
4875: x_return_status := FND_API.G_RET_STS_ERROR;
4876:
4877: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,

Line 5230: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');

5226:
5227: If ( ml_error_exists( l_job_header_rec.group_id ) or
5228: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5229:
5230: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');
5231: FND_MSG_PUB.ADD;
5232: x_return_status := FND_API.G_RET_STS_ERROR;
5233:
5234: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5548: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');

5544: -- l_job_header_rec.organization_id := 207;
5545:
5546: IF l_job_header_rec.organization_id is NULL THEN
5547:
5548: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
5549: FND_MSG_PUB.ADD;
5550: RAISE FND_API.G_EXC_ERROR;
5551: end if;
5552:

Line 5562: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');

5558: -- l_job_prefix := 'SR';
5559:
5560: IF l_job_prefix is NULL THEN
5561:
5562: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5565: end if;
5566:

Line 5576: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');

5572: -- l_job_header_rec.class_code := 'Rework';
5573:
5574: IF l_job_header_rec.class_code is NULL THEN
5575:
5576: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
5577: FND_MSG_PUB.ADD;
5578: RAISE FND_API.G_EXC_ERROR;
5579: end if;
5580:

Line 5686: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');

5682:
5683: -- ROLLBACK to CREATE_WIP_JOB_PVT ;
5684:
5685:
5686: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
5687: FND_MSG_PUB.ADD;
5688: RAISE FND_API.G_EXC_ERROR;
5689:
5690: -- Need to rollback Raise exception -

Line 5785: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');

5781: x_return_status => x_return_status,
5782: x_msg_count => x_msg_count,
5783: x_msg_data => x_msg_data);
5784: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
5785: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
5786: FND_MSG_PUB.ADD;
5787: RAISE FND_API.G_EXC_ERROR;
5788: END IF;
5789: end if;

Line 5800: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');

5796: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5797: ROLLBACK to CREATE_WIP_JOB_PVT ;
5798:
5799:
5800: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
5801: FND_MSG_PUB.ADD;
5802: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
5803:
5804:

Line 6218: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');

6214:
6215:
6216: IF l_job_header_rec.organization_id is NULL THEN
6217:
6218: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
6219: FND_MSG_PUB.ADD;
6220: RAISE FND_API.G_EXC_ERROR;
6221: END IF;
6222:

Line 6227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');

6223: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
6224:
6225: -- If l_job_prefix is null, throw an error and return;
6226: IF l_job_prefix is NULL THEN
6227: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
6228: FND_MSG_PUB.ADD;
6229: RAISE FND_API.G_EXC_ERROR;
6230: END IF;
6231:

Line 6236: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');

6232: l_job_header_rec.class_code :=
6233: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
6234:
6235: IF l_job_header_rec.class_code is NULL THEN
6236: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
6237: FND_MSG_PUB.ADD;
6238: RAISE FND_API.G_EXC_ERROR;
6239: END IF;
6240:

Line 6353: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');

6349:
6350: -- ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
6351:
6352:
6353: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6354: FND_MSG_PUB.ADD;
6355: RAISE FND_API.G_EXC_ERROR;
6356:
6357: -- Need to rollback Raise exception -

Line 6461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');

6457: x_return_status => x_return_status,
6458: x_msg_count => x_msg_count,
6459: x_msg_data => x_msg_data);
6460: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6461: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6462: FND_MSG_PUB.ADD;
6463: RAISE FND_API.G_EXC_ERROR;
6464: END IF;
6465: end if;

Line 6639: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_BILLS_ROUTES_FOR_SC');

6635: l_show_messages_flag := 'T';
6636: open c_get_service_code_details(p_service_code_tbl(sc_ctr).service_code_id);
6637: fetch c_get_service_code_details into l_service_code;
6638: close c_get_service_code_details;
6639: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_BILLS_ROUTES_FOR_SC');
6640: FND_MESSAGE.set_token('SERVICE_CODE', l_service_code);
6641: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6642: end if;
6643: -- swai: end bug 5239301

Line 6640: FND_MESSAGE.set_token('SERVICE_CODE', l_service_code);

6636: open c_get_service_code_details(p_service_code_tbl(sc_ctr).service_code_id);
6637: fetch c_get_service_code_details into l_service_code;
6638: close c_get_service_code_details;
6639: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_BILLS_ROUTES_FOR_SC');
6640: FND_MESSAGE.set_token('SERVICE_CODE', l_service_code);
6641: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
6642: end if;
6643: -- swai: end bug 5239301
6644: