eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSD_HV_WIP_JOB_PVT dependencies on FND_MESSAGE

Line 188: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

184: -- messages in the UI
185:
186: FOR l_error in get_txn_interface_errors
187: LOOP
188: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
189: fnd_message.set_token('MESSAGE', l_error.error_explanation);
190: fnd_msg_pub.add;
191: END LOOP;
192:

Line 189: fnd_message.set_token('MESSAGE', l_error.error_explanation);

185:
186: FOR l_error in get_txn_interface_errors
187: LOOP
188: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
189: fnd_message.set_token('MESSAGE', l_error.error_explanation);
190: fnd_msg_pub.add;
191: END LOOP;
192:
193: RETURN TRUE;

Line 200: -- to the fnd_message stack.

196: END;
197:
198:
199: -- this procedure adds any errors from the wip_interface_errors table
200: -- to the fnd_message stack.
201: -- assumption: each group has one type of transaction (op, material, resource)
202: --
203: PROCEDURE add_wip_interface_errors(p_group_id NUMBER, p_txn_type NUMBER) IS
204: -- CONSTANTS --

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

246:
247: FOR wip_interface_rec in c_wip_interface_errors
248: LOOP
249: IF (p_txn_type = lc_txn_type_operations) THEN
250: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_OP_ERR');
251:
252: ELSIF (p_txn_type = lc_txn_type_materials) THEN
253: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_MTL_ERR');
254: open c_item_name(wip_interface_rec.inventory_item_id_new,

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

249: IF (p_txn_type = lc_txn_type_operations) THEN
250: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_OP_ERR');
251:
252: ELSIF (p_txn_type = lc_txn_type_materials) THEN
253: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_MTL_ERR');
254: open c_item_name(wip_interface_rec.inventory_item_id_new,
255: wip_interface_rec.organization_id);
256: fetch c_item_name into l_item_name;
257: close c_item_name;

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

254: open c_item_name(wip_interface_rec.inventory_item_id_new,
255: wip_interface_rec.organization_id);
256: fetch c_item_name into l_item_name;
257: close c_item_name;
258: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item_name);
259:
260: ELSIF (p_txn_type = lc_txn_type_resources) THEN
261: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
262: open c_resource_name(wip_interface_rec.resource_id_new);

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

257: close c_item_name;
258: FND_MESSAGE.SET_TOKEN('ITEM_NAME', l_item_name);
259:
260: ELSIF (p_txn_type = lc_txn_type_resources) THEN
261: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
262: open c_resource_name(wip_interface_rec.resource_id_new);
263: fetch c_resource_name into l_resource_name;
264: close c_resource_name;
265: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);

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

261: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_INTERFACE_RES_ERR');
262: open c_resource_name(wip_interface_rec.resource_id_new);
263: fetch c_resource_name into l_resource_name;
264: close c_resource_name;
265: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
266: END IF;
267:
268: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
269: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);

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

264: close c_resource_name;
265: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
266: END IF;
267:
268: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
269: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
270: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
271: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
272: FND_MSG_PUB.ADD;

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

265: FND_MESSAGE.SET_TOKEN('RES_NAME', l_resource_name);
266: END IF;
267:
268: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
269: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
270: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
271: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
272: FND_MSG_PUB.ADD;
273: END LOOP;

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

266: END IF;
267:
268: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
269: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
270: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
271: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
272: FND_MSG_PUB.ADD;
273: END LOOP;
274: END add_wip_interface_errors;

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

267:
268: FND_MESSAGE.SET_TOKEN('JOB_NAME', wip_interface_rec.wip_entity_name);
269: FND_MESSAGE.SET_TOKEN('OP_SEQ', wip_interface_rec.operation_seq_num);
270: FND_MESSAGE.SET_TOKEN('ERROR_TYPE', wip_interface_rec.error_type_meaning);
271: FND_MESSAGE.SET_TOKEN('ERROR_MSG', wip_interface_rec.error);
272: FND_MSG_PUB.ADD;
273: END LOOP;
274: END add_wip_interface_errors;
275:

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

539: l_job_header_rec.end_item_unit_number --bug#13472453
540: );
541: EXCEPTION
542: WHEN OTHERS THEN
543: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
544: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
545: FND_MSG_PUB.ADD;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: RETURN;

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

540: );
541: EXCEPTION
542: WHEN OTHERS THEN
543: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_HEADER_INSERT_ERR');
544: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_header_rec.job_name );
545: FND_MSG_PUB.ADD;
546: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
547: RETURN;
548: END;

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

734:
735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');
739: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: RETURN;

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

735:
736: EXCEPTION
737: WHEN OTHERS THEN
738: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_DETAILS_INSERT_ERR');
739: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_job_details_rec.wip_entity_id);
740: FND_MSG_PUB.ADD;
741: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
742: RETURN;
743: END;

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

877:
878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');
882: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );
883: FND_MSG_PUB.ADD;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: RETURN;

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

878:
879: EXCEPTION
880: WHEN OTHERS THEN
881: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_INSERT_ERR');
882: FND_MESSAGE.SET_TOKEN('JOB_NAME', l_transactions_interface_rec.transaction_source_id );
883: FND_MSG_PUB.ADD;
884: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
885: RETURN;
886: END;

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

944:
945:
946: EXCEPTION
947: WHEN OTHERS THEN
948: FND_MESSAGE.SET_NAME('CSD','CSD_TXNS_HEADER_UPDATE_ERR');
949: FND_MSG_PUB.ADD;
950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
951: RETURN;
952: END;

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

1033:
1034:
1035: EXCEPTION
1036: WHEN OTHERS THEN
1037: FND_MESSAGE.SET_NAME('CSD','CSD_TXN_LOTS_INSERT_ERR');
1038: FND_MSG_PUB.ADD;
1039: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1040: RETURN;
1041: END;

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

1099: p_srl_nmbrs_interface_rec.transaction_interface_id;
1100:
1101: EXCEPTION
1102: WHEN OTHERS THEN
1103: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_UPDATE_ERR');
1104: FND_MSG_PUB.ADD;
1105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1106: RETURN;
1107: END;

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

1142:
1143:
1144: EXCEPTION
1145: WHEN OTHERS THEN
1146: FND_MESSAGE.SET_NAME('CSD','CSD_SRL_NMBRS_INSERT_ERR');
1147: FND_MSG_PUB.ADD;
1148: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1149: RETURN;
1150: END;

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

1279:
1280:
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_COST_TXN_INSERT_ERR');
1284: FND_MSG_PUB.ADD;
1285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1286: RETURN;
1287:

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

1408:
1409:
1410: EXCEPTION
1411: WHEN OTHERS THEN
1412: FND_MESSAGE.SET_NAME('CSD','CSD_WIP_MOVE_TXN_INSERT_ERR');
1413: FND_MSG_PUB.ADD;
1414: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1415: RETURN;
1416:

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

1656: x_transaction_header_id => l_transaction_header_id
1657: );
1658:
1659: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1660: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1661: FND_MSG_PUB.ADD;
1662: RAISE FND_API.G_EXC_ERROR;
1663: END IF;
1664:

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

1680: p_txn_header_id => l_transaction_header_id
1681: -- p_txn_type IN VARCHAR2
1682: );
1683: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1684: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_TXN_FAILURE');
1685: FND_MSG_PUB.ADD;
1686: RAISE FND_API.G_EXC_ERROR;
1687: END IF;
1688: ELSE

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

1958: l_last_move_allowed;
1959: IF (get_last_operation_dtls%FOUND) THEN
1960: l_transaction_quantity := l_last_op_move_quantity;
1961: IF l_last_move_allowed = 'N' THEN
1962: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_MV_NOT_ALL');
1963: FND_MSG_PUB.ADD;
1964: close get_last_operation_dtls;
1965: RAISE FND_API.G_EXC_ERROR;
1966: END IF;

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

1967: END IF;
1968: close get_last_operation_dtls;
1969:
1970: IF l_transaction_quantity <= 0 THEN
1971: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_COMP_ZER_QTY');
1972: FND_MSG_PUB.ADD;
1973: RAISE FND_API.G_EXC_ERROR;
1974: END IF;
1975:

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

2358: End if;
2359: --bug#14456229 --14497341
2360:
2361:
2362: FND_MESSAGE.SET_NAME('CSD','CSD_PROCESS_MTI_TXN_FAILURE');
2363: FND_MSG_PUB.ADD;
2364: RAISE FND_API.G_EXC_ERROR;
2365: END IF;
2366:

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

2605: -- the quantities are passed forward. Currently, do not allow the user
2606: -- to skip operations for the same job. (eg, complete 10, skip 20, complete 30)
2607: IF l_prev_wip_entity_id = p_mv_txn_dtls_tbl(mv_ctr).wip_entity_id THEN
2608: IF l_prev_to_operation_seq_num <> p_mv_txn_dtls_tbl(mv_ctr).fm_operation_seq_num THEN
2609: FND_MESSAGE.SET_NAME('CSD','CSD_OP_COMP_SEQ_ERROR');
2610: FND_MSG_PUB.ADD;
2611: RAISE FND_API.G_EXC_ERROR;
2612: ELSE
2613: l_wip_move_txn_interface_rec.transaction_quantity := p_mv_txn_dtls_tbl(mv_ctr).transaction_quantity +

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

2700: (l_err_op_seq_num is not null)) THEN
2701:
2702: IF (l_err_op_seq_num is null) THEN
2703: close check_mv_interface_errors ;
2704: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2705: FND_MSG_PUB.ADD;
2706: RAISE FND_API.G_EXC_ERROR;
2707:
2708: ELSE

Line 2711: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE_DET');

2707:
2708: ELSE
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: WHILE check_mv_interface_errors%FOUND LOOP
2711: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE_DET');
2712: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_NAME', l_err_wip_entity_name);
2713: FND_MESSAGE.SET_TOKEN('OPERATION_SEQ_NUM', l_err_op_seq_num );
2714: FND_MSG_PUB.ADD;
2715: fetch check_mv_interface_errors into l_err_wip_entity_name, l_err_op_seq_num;

Line 2712: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_NAME', l_err_wip_entity_name);

2708: ELSE
2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: WHILE check_mv_interface_errors%FOUND LOOP
2711: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE_DET');
2712: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_NAME', l_err_wip_entity_name);
2713: FND_MESSAGE.SET_TOKEN('OPERATION_SEQ_NUM', l_err_op_seq_num );
2714: FND_MSG_PUB.ADD;
2715: fetch check_mv_interface_errors into l_err_wip_entity_name, l_err_op_seq_num;
2716: END LOOP;

Line 2713: FND_MESSAGE.SET_TOKEN('OPERATION_SEQ_NUM', l_err_op_seq_num );

2709: x_return_status := FND_API.G_RET_STS_ERROR;
2710: WHILE check_mv_interface_errors%FOUND LOOP
2711: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE_DET');
2712: FND_MESSAGE.SET_TOKEN('WIP_ENTITY_NAME', l_err_wip_entity_name);
2713: FND_MESSAGE.SET_TOKEN('OPERATION_SEQ_NUM', l_err_op_seq_num );
2714: FND_MSG_PUB.ADD;
2715: fetch check_mv_interface_errors into l_err_wip_entity_name, l_err_op_seq_num;
2716: END LOOP;
2717: END IF;

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

2722: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2723: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2724:
2725:
2726: FND_MESSAGE.SET_NAME('CSD','CSD_MOVE_TXN_FAILURE');
2727: FND_MSG_PUB.ADD;
2728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
2729:
2730:

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

3014:
3015: l_transactions_interface_rec.transaction_quantity := (-1) * p_mtl_txn_dtls_tbl(mtl_ctr).transaction_quantity;
3016:
3017: If l_transactions_interface_rec.transaction_quantity = 0 then
3018: FND_MESSAGE.SET_NAME('CSD','CSD_ISS_QTY_ZERO');
3019: FND_MSG_PUB.ADD;
3020: RAISE FND_API.G_EXC_ERROR;
3021: end if;
3022:

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

3526:
3527:
3528: -- IF nvl( x_msg_count, 0 ) = 0 THEN
3529:
3530: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3531: FND_MSG_PUB.ADD;
3532:
3533: RAISE FND_API.G_EXC_ERROR;
3534:

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

3566: If ( ml_error_exists( l_job_header_rec.group_id ) or
3567: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3568:
3569:
3570: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ISS_MASS_LD_FAILURE');
3571: FND_MSG_PUB.ADD;
3572: x_return_status := FND_API.G_RET_STS_ERROR;
3573:
3574: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

3613: -- ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3614: -- dbms_output.put_line('WIP Update Error');
3615:
3616:
3617: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3618: FND_MSG_PUB.ADD;
3619: RETURN; */
3620: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3621:

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

3820: p_mtl_txn_dtls_tbl => p_mtl_txn_dtls_tbl,
3821: p_transaction_header_id => p_transaction_header_id
3822: );
3823: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3824: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3825: FND_MSG_PUB.ADD;
3826: RAISE FND_API.G_EXC_ERROR;
3827: END IF;
3828:

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

3842: p_txn_header_id => p_transaction_header_id
3843: -- p_txn_type IN VARCHAR2
3844: );
3845: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
3846: FND_MESSAGE.SET_NAME('CSD','CSD_MAT_TXN_FAILURE');
3847: FND_MSG_PUB.ADD;
3848: RAISE FND_API.G_EXC_ERROR;
3849: END IF;
3850:

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

4218: -- If autocharge_type is null, throw an error and return;
4219: -- Uncomment following later - once profiles are defined
4220: /* IF l_job_details_rec.autocharge_type is NULL THEN
4221:
4222: FND_MESSAGE.SET_NAME('CSD','CSD_ATCHG_TYP_NULL');
4223: FND_MSG_PUB.ADD;
4224: RAISE FND_API.G_EXC_ERROR;
4225: end if;
4226:

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

4230: -- If basis_type is null, throw an error and return;
4231:
4232: IF l_job_details_rec.basis_type is NULL THEN
4233:
4234: FND_MESSAGE.SET_NAME('CSD','CSD_BASIS_TYP_NULL');
4235: FND_MSG_PUB.ADD;
4236: RAISE FND_API.G_EXC_ERROR;
4237: end if;
4238:

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

4241: -- If scheduled_flag is null, throw an error and return;
4242:
4243: IF l_job_details_rec.scheduled_flag is NULL THEN
4244:
4245: FND_MESSAGE.SET_NAME('CSD','CSD_SCD_FLG_NULL');
4246: FND_MSG_PUB.ADD;
4247: RAISE FND_API.G_EXC_ERROR;
4248: end if;
4249:

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

4252: -- If standard_rate_flag is null, throw an error and return;
4253:
4254: IF l_job_details_rec.standard_rate_flag is NULL THEN
4255:
4256: FND_MESSAGE.SET_NAME('CSD','CSD_STD_FLG_NULL');
4257: FND_MSG_PUB.ADD;
4258: RAISE FND_API.G_EXC_ERROR;
4259: end if; */
4260:

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

4283: l_wip_cost_txn_interface_rec.resource_seq_num := p_res_txn_dtls_tbl(res_ctr).resource_seq_num;
4284: l_wip_cost_txn_interface_rec.transaction_quantity := p_res_txn_dtls_tbl(res_ctr).transaction_quantity;
4285:
4286: If l_wip_cost_txn_interface_rec.transaction_quantity = 0 then
4287: FND_MESSAGE.SET_NAME('CSD','CSD_TRX_QTY_ZERO');
4288: FND_MSG_PUB.ADD;
4289: RAISE FND_API.G_EXC_ERROR;
4290: end if;
4291:

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

4497:
4498: If ( ml_error_exists( l_job_header_rec.group_id ) or
4499: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
4500:
4501: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_MASS_LD_FAILURE');
4502: FND_MSG_PUB.ADD;
4503: x_return_status := FND_API.G_RET_STS_ERROR;
4504:
4505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

4542:
4543: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4544: -- ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4545:
4546: FND_MESSAGE.SET_NAME('CSD','CSD_RES_TXN_FAILURE');
4547: FND_MSG_PUB.ADD;
4548: RETURN; -- later - once wip works - can remove this
4549: -- RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4550: */

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

4839: -- department has been specified, so throw an error.
4840: -- we cannot add the material to operation 1 since
4841: -- it would force a wip_supply_type of pull, which
4842: -- required backflush.
4843: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_OP_DEPT_NULL');
4844: FND_MSG_PUB.ADD;
4845: RAISE FND_API.G_EXC_ERROR;
4846: else
4847: l_op_dtls_tbl(1).new_row := 'Y';

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

4870: if (x_return_status = FND_API.G_RET_STS_SUCCESS) then
4871: l_op_seq_num := l_op_dtls_tbl(1).operation_seq_num;
4872: x_op_created := FND_API.G_TRUE;
4873: else
4874: FND_MESSAGE.SET_NAME('CSD','CSD_OP_AUTO_CREATE_FAILURE');
4875: FND_MSG_PUB.ADD;
4876: RAISE FND_API.G_EXC_ERROR;
4877: end if;
4878: end if; -- department profile

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

4969:
4970: -- swai bug 13964903, FP of bug#13837341, subhat
4971: -- subinventory is only required when the supply type is operation pull(3) or assembly pull (2).
4972: If l_job_details_rec.supply_subinventory is NULL AND l_wip_supply_type IN (2,3) then
4973: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_SUB_INV_NULL');
4974: FND_MSG_PUB.ADD;
4975: RAISE FND_API.G_EXC_ERROR;
4976: end if;
4977:

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

5029:
5030: If ( ml_error_exists( l_job_header_rec.group_id ) or
5031: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5032:
5033: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
5034: FND_MSG_PUB.ADD;
5035: x_return_status := FND_API.G_RET_STS_ERROR;
5036:
5037: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5215: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_UPD_MASS_LD_FAILURE');

5211: lc_mod_name,
5212: 'Error occured during WIP_MASSLOAD_PUB.massLoadJobs');
5213: END IF;
5214:
5215: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_UPD_MASS_LD_FAILURE');
5216: FND_MSG_PUB.ADD;
5217: x_return_status := FND_API.G_RET_STS_ERROR;
5218: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5219: p_count => x_msg_count,

Line 5242: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_UPD_MASS_LD_FAILURE');

5238:
5239: add_wip_interface_errors(l_job_header_rec.group_id,
5240: 2 /* 2 = materials */);
5241:
5242: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_UPD_MASS_LD_FAILURE');
5243: FND_MSG_PUB.ADD;
5244: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5245: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5246: p_count => x_msg_count,

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

5665:
5666: If ( ml_error_exists( l_job_header_rec.group_id ) or
5667: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
5668:
5669: FND_MESSAGE.SET_NAME('CSD','CSD_RES_ADD_MASS_LD_FAILURE');
5670: FND_MSG_PUB.ADD;
5671: x_return_status := FND_API.G_RET_STS_ERROR;
5672:
5673: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,

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

6065:
6066: If ( ml_error_exists( l_job_header_rec.group_id ) or
6067: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6068:
6069: FND_MESSAGE.SET_NAME('CSD','CSD_OP_ADD_MASS_LD_FAILURE');
6070: FND_MSG_PUB.ADD;
6071: x_return_status := FND_API.G_RET_STS_ERROR;
6072:
6073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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

6441: -- l_job_header_rec.organization_id := 207;
6442:
6443: IF l_job_header_rec.organization_id is NULL THEN
6444:
6445: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
6446: FND_MSG_PUB.ADD;
6447: RAISE FND_API.G_EXC_ERROR;
6448: end if;
6449:

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

6455: -- l_job_prefix := 'SR';
6456:
6457: IF l_job_prefix is NULL THEN
6458:
6459: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
6460: FND_MSG_PUB.ADD;
6461: RAISE FND_API.G_EXC_ERROR;
6462: end if;
6463:

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

6477: -- l_job_header_rec.class_code := 'Rework';
6478:
6479: IF l_job_header_rec.class_code is NULL THEN
6480:
6481: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
6482: FND_MSG_PUB.ADD;
6483: RAISE FND_API.G_EXC_ERROR;
6484: end if;
6485:

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

6598:
6599: -- ROLLBACK to CREATE_WIP_JOB_PVT ;
6600:
6601:
6602: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
6603: FND_MSG_PUB.ADD;
6604: RAISE FND_API.G_EXC_ERROR;
6605:
6606: -- Need to rollback Raise exception -

Line 6733: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');

6729: x_msg_count => l_msg_count,
6730: x_msg_data => l_msg_data
6731: );
6732: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6733: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');
6734: FND_MSG_PUB.ADD;
6735: RAISE FND_API.G_EXC_ERROR;
6736: END IF;
6737: if (l_default_rule_id is not null) then

Line 6759: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');

6755: x_msg_count => l_msg_count,
6756: x_msg_data => l_msg_data
6757: );
6758: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
6759: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');
6760: FND_MSG_PUB.ADD;
6761: RAISE FND_API.G_EXC_ERROR;
6762: END IF;
6763: if (l_default_rule_id is not null) then

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

6784: x_return_status => x_return_status,
6785: x_msg_count => x_msg_count,
6786: x_msg_data => x_msg_data);
6787: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
6788: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
6789: FND_MSG_PUB.ADD;
6790: RAISE FND_API.G_EXC_ERROR;
6791: END IF;
6792:

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

6794: /* IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
6795: ROLLBACK to CREATE_WIP_JOB_PVT ;
6796:
6797:
6798: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_CREAT_FAILURE');
6799: FND_MSG_PUB.ADD;
6800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR; */
6801:
6802:

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

7242:
7243:
7244: IF l_job_header_rec.organization_id is NULL THEN
7245:
7246: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REP_INV_NULL');
7247: FND_MSG_PUB.ADD;
7248: RAISE FND_API.G_EXC_ERROR;
7249: END IF;
7250:

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

7251: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');
7252:
7253: -- If l_job_prefix is null, throw an error and return;
7254: IF l_job_prefix is NULL THEN
7255: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_PREFIX_NULL');
7256: FND_MSG_PUB.ADD;
7257: RAISE FND_API.G_EXC_ERROR;
7258: END IF;
7259:

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

7260: l_job_header_rec.class_code :=
7261: fnd_profile.value('CSD_DEF_WIP_ACCOUNTING_CLASS');
7262:
7263: IF l_job_header_rec.class_code is NULL THEN
7264: FND_MESSAGE.SET_NAME('CSD','CSD_CLASS_CODE_NULL');
7265: FND_MSG_PUB.ADD;
7266: RAISE FND_API.G_EXC_ERROR;
7267: END IF;
7268:

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

7404:
7405: -- ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
7406:
7407:
7408: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
7409: FND_MSG_PUB.ADD;
7410: RAISE FND_API.G_EXC_ERROR;
7411:
7412: -- Need to rollback Raise exception -

Line 7476: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');

7472: x_msg_count => l_msg_count,
7473: x_msg_data => l_msg_data
7474: );
7475: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
7476: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');
7477: FND_MSG_PUB.ADD;
7478: RAISE FND_API.G_EXC_ERROR;
7479: END IF;
7480:

Line 7502: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');

7498: x_msg_count => l_msg_count,
7499: x_msg_data => l_msg_data
7500: );
7501: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
7502: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');
7503: FND_MSG_PUB.ADD;
7504: RAISE FND_API.G_EXC_ERROR;
7505: END IF;
7506: if (l_default_rule_id is not null) then

Line 7624: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');

7620: x_msg_count => l_msg_count,
7621: x_msg_data => l_msg_data
7622: );
7623: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
7624: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_REASON_CODE_FAILURE');
7625: FND_MSG_PUB.ADD;
7626: RAISE FND_API.G_EXC_ERROR;
7627: END IF;
7628: if (l_default_rule_id is not null) then

Line 7649: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');

7645: x_msg_count => l_msg_count,
7646: x_msg_data => l_msg_data
7647: );
7648: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
7649: FND_MESSAGE.SET_NAME('CSD','CSD_DEF_CREATE_RO_FLAG_FAILURE');
7650: FND_MSG_PUB.ADD;
7651: RAISE FND_API.G_EXC_ERROR;
7652: END IF;
7653: if (l_default_rule_id is not null) then

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

7675: x_return_status => x_return_status,
7676: x_msg_count => x_msg_count,
7677: x_msg_data => x_msg_data);
7678: IF NOT(x_return_status = FND_API.G_RET_STS_SUCCESS) THEN
7679: FND_MESSAGE.SET_NAME('CSD','CSD_JOB_GEN_FAILURE');
7680: FND_MSG_PUB.ADD;
7681: RAISE FND_API.G_EXC_ERROR;
7682: END IF;
7683: End if;

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

7849: l_show_messages_flag := 'T';
7850: open c_get_service_code_details(p_service_code_tbl(sc_ctr).service_code_id);
7851: fetch c_get_service_code_details into l_service_code;
7852: close c_get_service_code_details;
7853: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_BILLS_ROUTES_FOR_SC');
7854: FND_MESSAGE.set_token('SERVICE_CODE', l_service_code);
7855: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
7856: end if;
7857: -- swai: end bug 5239301

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

7850: open c_get_service_code_details(p_service_code_tbl(sc_ctr).service_code_id);
7851: fetch c_get_service_code_details into l_service_code;
7852: close c_get_service_code_details;
7853: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_BILLS_ROUTES_FOR_SC');
7854: FND_MESSAGE.set_token('SERVICE_CODE', l_service_code);
7855: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
7856: end if;
7857: -- swai: end bug 5239301
7858:

Line 8782: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_DEF_HV_BOM_RESOURCE');

8778:
8779: if (l_resource_id is null) then
8780: l_resource_id := fnd_profile.value('CSD_DEF_HV_BOM_RESOURCE');-- get resource from profile value.
8781: if (l_resource_id is null) then
8782: FND_MESSAGE.SET_NAME('CSD', 'CSD_NO_DEF_HV_BOM_RESOURCE');
8783: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8784: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8785: RETURN;
8786: else

Line 8794: FND_MESSAGE.SET_NAME('CSD', 'CSD_INVALID_DEF_HV_BOM_RES');

8790: fetch validate_op_res_dept into l_exists;
8791: close validate_op_res_dept;
8792:
8793: if (l_exists is null) then
8794: FND_MESSAGE.SET_NAME('CSD', 'CSD_INVALID_DEF_HV_BOM_RES');
8795: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);
8796: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8797: RETURN;
8798: end if;

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

9289:
9290: If ( ml_error_exists( l_job_header_rec.group_id ) or
9291: x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
9292:
9293: FND_MESSAGE.SET_NAME('CSD','CSD_MTL_ADD_MASS_LD_FAILURE');
9294: FND_MSG_PUB.ADD;
9295: x_return_status := FND_API.G_RET_STS_ERROR;
9296:
9297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 9667: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

9663: lc_mod_name,
9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);
9665: END IF;
9666:
9667: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9668: fnd_message.set_token('MESSAGE', l_error_message);
9669: fnd_msg_pub.add;
9670: x_return_status := FND_API.G_RET_STS_ERROR;
9671:

Line 9668: fnd_message.set_token('MESSAGE', l_error_message);

9664: 'Error during WIP_OPERATIONS_PKG.Delete_Operation: ' || l_error_message);
9665: END IF;
9666:
9667: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
9668: fnd_message.set_token('MESSAGE', l_error_message);
9669: fnd_msg_pub.add;
9670: x_return_status := FND_API.G_RET_STS_ERROR;
9671:
9672: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 10424: FND_MESSAGE.SET_NAME('CSD','CSD_EST_WIP_IMPORT_FAILURE');

10420: x_warning_flag => l_warning_flag );
10421:
10422:
10423: IF ((x_return_status <> FND_API.G_RET_STS_SUCCESS ) OR (l_warning_flag = FND_API.G_TRUE)) THEN
10424: FND_MESSAGE.SET_NAME('CSD','CSD_EST_WIP_IMPORT_FAILURE');
10425: FND_MSG_PUB.ADD;
10426: RAISE FND_API.G_EXC_ERROR;
10427: END IF;
10428: