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_MSG_PUB

Line 190: fnd_msg_pub.add;

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;
194: end if;

Line 272: FND_MSG_PUB.ADD;

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:
276: -- This procedure checks if the specified Job name exists in the

Line 545: FND_MSG_PUB.ADD;

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;
549:

Line 740: FND_MSG_PUB.ADD;

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;
744:

Line 883: FND_MSG_PUB.ADD;

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;
887:

Line 949: FND_MSG_PUB.ADD;

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;
953:

Line 1038: FND_MSG_PUB.ADD;

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;
1042:

Line 1104: FND_MSG_PUB.ADD;

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;
1108:

Line 1147: FND_MSG_PUB.ADD;

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;
1151:

Line 1284: FND_MSG_PUB.ADD;

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:
1288: END;

Line 1413: FND_MSG_PUB.ADD;

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:
1417: END;

Line 1636: FND_MSG_PUB.initialize;

1632: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1633: END IF;
1634:
1635: IF FND_API.to_boolean(p_init_msg_list) THEN
1636: FND_MSG_PUB.initialize;
1637: END IF;
1638:
1639: x_return_status := FND_API.G_RET_STS_SUCCESS;
1640:

Line 1661: FND_MSG_PUB.ADD;

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:
1665: -- if no need for details, then we can process transactions and commit

Line 1685: FND_MSG_PUB.ADD;

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
1689: --if we need details, pass back the transaction header id

Line 1704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1700: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1701: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1702: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1703:
1704: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1705: p_count => x_msg_count,
1706: p_data => x_msg_data);
1707:
1708: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1719: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1715: WHEN FND_API.G_EXC_ERROR THEN
1716: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1717: x_return_status := FND_API.G_RET_STS_ERROR;
1718:
1719: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1720: p_count => x_msg_count,
1721: p_data => x_msg_data);
1722:
1723: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1729: WHEN OTHERS THEN
1730: ROLLBACK to PROCESS_JOB_COMP_TXN_PVT ;
1731: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1732:
1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1734: -- Add Unexpected Error to Message List, here SQLERRM is used for
1735: -- getting the error
1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1737: p_procedure_name => lc_api_name );

Line 1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

1732:
1733: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1734: -- Add Unexpected Error to Message List, here SQLERRM is used for
1735: -- getting the error
1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1737: p_procedure_name => lc_api_name );
1738: END IF;
1739:
1740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 1740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

1736: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
1737: p_procedure_name => lc_api_name );
1738: END IF;
1739:
1740: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1741: p_count => x_msg_count,
1742: p_data => x_msg_data);
1743:
1744: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1929: FND_MSG_PUB.initialize;

1925: END IF;
1926:
1927:
1928: IF FND_API.to_boolean(p_init_msg_list) THEN
1929: FND_MSG_PUB.initialize;
1930: END IF;
1931:
1932: -- initialize out params
1933: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1963: FND_MSG_PUB.ADD;

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;
1967: END IF;

Line 1972: FND_MSG_PUB.ADD;

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:
1976: l_transactions_interface_rec.source_code := lc_completion_source_code;

Line 2210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2206: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2207: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
2208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2209:
2210: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2211: p_count => x_msg_count,
2212: p_data => x_msg_data);
2213:
2214: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2222: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
2223: x_return_status := FND_API.G_RET_STS_ERROR;
2224:
2225:
2226: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2227: p_count => x_msg_count,
2228: p_data => x_msg_data);
2229:
2230: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2236: WHEN OTHERS THEN
2237: ROLLBACK to INSERT_JOB_COMP_TXN_PVT ;
2238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2239:
2240: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2241:
2242: -- Add Unexpected Error to Message List, here SQLERRM is used for
2243: -- getting the error
2244:

Line 2245: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

2241:
2242: -- Add Unexpected Error to Message List, here SQLERRM is used for
2243: -- getting the error
2244:
2245: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2246: p_procedure_name => lc_api_name );
2247: END IF;
2248:
2249: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2249: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2245: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2246: p_procedure_name => lc_api_name );
2247: END IF;
2248:
2249: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2250: p_count => x_msg_count,
2251: p_data => x_msg_data);
2252:
2253: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2305: FND_MSG_PUB.initialize;

2301: END IF;
2302:
2303:
2304: IF FND_API.to_boolean(p_init_msg_list) THEN
2305: FND_MSG_PUB.initialize;
2306: END IF;
2307: x_return_status := FND_API.G_RET_STS_SUCCESS;
2308:
2309: -- get the wip entity ids being processed.

Line 2363: FND_MSG_PUB.ADD;

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:
2367: -- subhat FedEx material update changes.

Line 2403: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2399: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2400: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2401: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2402:
2403: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2404: p_count => x_msg_count,
2405: p_data => x_msg_data);
2406:
2407: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2419: --bug#14456229 --14497341
2420:
2421: x_return_status := FND_API.G_RET_STS_ERROR;
2422:
2423: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2424: p_count => x_msg_count,
2425: p_data => x_msg_data);
2426:
2427: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2433: WHEN OTHERS THEN
2434: ROLLBACK to PROCESS_MTI_TRANSACTIONS_PVT ;
2435: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2436:
2437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2438: -- Add Unexpected Error to Message List, here SQLERRM is used for
2439: -- getting the error
2440: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2441: p_procedure_name => lc_api_name );

Line 2440: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

2436:
2437: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2438: -- Add Unexpected Error to Message List, here SQLERRM is used for
2439: -- getting the error
2440: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2441: p_procedure_name => lc_api_name );
2442: END IF;
2443:
2444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2440: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2441: p_procedure_name => lc_api_name );
2442: END IF;
2443:
2444: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2445: p_count => x_msg_count,
2446: p_data => x_msg_data);
2447:
2448: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2560: FND_MSG_PUB.initialize;

2556: END IF;
2557:
2558:
2559: IF FND_API.to_boolean(p_init_msg_list) THEN
2560: FND_MSG_PUB.initialize;
2561: END IF;
2562:
2563:
2564:

Line 2610: FND_MSG_PUB.ADD;

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 +
2614: l_prev_transaction_quantity;

Line 2705: FND_MSG_PUB.ADD;

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
2709: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2714: FND_MSG_PUB.ADD;

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;
2718: end if;

Line 2727: FND_MSG_PUB.ADD;

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:
2731: /* IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2750: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2752:
2753: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2754: p_count => x_msg_count,
2755: p_data => x_msg_data);
2756:
2757: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2769: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2765: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2766: x_return_status := FND_API.G_RET_STS_ERROR;
2767:
2768:
2769: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2770: p_count => x_msg_count,
2771: p_data => x_msg_data);
2772:
2773: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2779: WHEN OTHERS THEN
2780: ROLLBACK to PROCESS_OPER_COMP_TXN_PVT ;
2781: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2782:
2783: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2784:
2785: -- Add Unexpected Error to Message List, here SQLERRM is used for
2786: -- getting the error
2787:

Line 2788: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

2784:
2785: -- Add Unexpected Error to Message List, here SQLERRM is used for
2786: -- getting the error
2787:
2788: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2789: p_procedure_name => lc_api_name );
2790: END IF;
2791:
2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

2788: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
2789: p_procedure_name => lc_api_name );
2790: END IF;
2791:
2792: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
2793: p_count => x_msg_count,
2794: p_data => x_msg_data);
2795:
2796: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 2941: FND_MSG_PUB.initialize;

2937: END IF;
2938:
2939:
2940: IF FND_API.to_boolean(p_init_msg_list) THEN
2941: FND_MSG_PUB.initialize;
2942: END IF;
2943:
2944:
2945:

Line 3019: FND_MSG_PUB.ADD;

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:
3023:

Line 3531: FND_MSG_PUB.ADD;

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:
3535: -- END IF;

Line 3571: FND_MSG_PUB.ADD;

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,
3575: p_count => x_msg_count,

Line 3574: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
3575: p_count => x_msg_count,
3576: p_data => x_msg_data);
3577:
3578: RETURN;

Line 3596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3592: WHEN OTHERS THEN
3593:
3594: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3595:
3596: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3597:
3598: -- Add Unexpected Error to Message List, here SQLERRM is used for
3599: -- getting the error
3600:

Line 3601: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

3597:
3598: -- Add Unexpected Error to Message List, here SQLERRM is used for
3599: -- getting the error
3600:
3601: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3602: p_procedure_name => lc_api_name );
3603: END IF;
3604:
3605: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3605: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3601: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3602: p_procedure_name => lc_api_name );
3603: END IF;
3604:
3605: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3606: p_count => x_msg_count,
3607: p_data => x_msg_data);
3608:
3609: END;

Line 3618: FND_MSG_PUB.ADD;

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:
3622:

Line 3706: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3702: -- dbms_output.put_line( 'FND_API.G_EXC_UNEXPECTED_ERROR error'|| sqlerrm);
3703: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3704: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3705:
3706: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3707: p_count => x_msg_count,
3708: p_data => x_msg_data);
3709:
3710: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3722: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3718: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3719: x_return_status := FND_API.G_RET_STS_ERROR;
3720:
3721:
3722: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3723: p_count => x_msg_count,
3724: p_data => x_msg_data);
3725:
3726: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3737: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3733: -- dbms_output.put_line( 'OTHERS error' || sqlerrm );
3734: ROLLBACK to PROCESS_ISSUE_MTL_TXN_PVT ;
3735: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3736:
3737: -- IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3738:
3739: -- Add Unexpected Error to Message List, here SQLERRM is used for
3740: -- getting the error
3741:

Line 3742: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

3738:
3739: -- Add Unexpected Error to Message List, here SQLERRM is used for
3740: -- getting the error
3741:
3742: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3743: p_procedure_name => lc_api_name );
3744: -- END IF;
3745:
3746: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3746: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3742: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3743: p_procedure_name => lc_api_name );
3744: -- END IF;
3745:
3746: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3747: p_count => x_msg_count,
3748: p_data => x_msg_data);
3749:
3750: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3802: FND_MSG_PUB.initialize;

3798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3799: END IF;
3800:
3801: IF FND_API.to_boolean(p_init_msg_list) THEN
3802: FND_MSG_PUB.initialize;
3803: END IF;
3804:
3805: x_return_status := FND_API.G_RET_STS_SUCCESS;
3806:

Line 3825: FND_MSG_PUB.ADD;

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:
3829: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3847: FND_MSG_PUB.ADD;

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:
3851: -- Standard check for p_commit

Line 3862: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3858: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3859: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3861:
3862: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3863: p_count => x_msg_count,
3864: p_data => x_msg_data);
3865:
3866: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3876: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3872: WHEN FND_API.G_EXC_ERROR THEN
3873: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3874: x_return_status := FND_API.G_RET_STS_ERROR;
3875:
3876: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3877: p_count => x_msg_count,
3878: p_data => x_msg_data);
3879:
3880: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

3886: WHEN OTHERS THEN
3887: ROLLBACK to PROCESS_MTL_TXNS_LOT_SRL_PVT ;
3888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3889:
3890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3891: -- Add Unexpected Error to Message List, here SQLERRM is used for
3892: -- getting the error
3893: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3894: p_procedure_name => lc_api_name );

Line 3893: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

3889:
3890: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3891: -- Add Unexpected Error to Message List, here SQLERRM is used for
3892: -- getting the error
3893: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3894: p_procedure_name => lc_api_name );
3895: END IF;
3896:
3897: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 3897: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

3893: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
3894: p_procedure_name => lc_api_name );
3895: END IF;
3896:
3897: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
3898: p_count => x_msg_count,
3899: p_data => x_msg_data);
3900:
3901: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3964: FND_MSG_PUB.initialize;

3960: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3961: END IF;
3962:
3963: IF FND_API.to_boolean(p_init_msg_list) THEN
3964: FND_MSG_PUB.initialize;
3965: END IF;
3966:
3967: x_return_status := FND_API.G_RET_STS_SUCCESS;
3968:

Line 4065: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4061: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4062: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
4063: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4064:
4065: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4066: p_count => x_msg_count,
4067: p_data => x_msg_data);
4068:
4069: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4075: WHEN FND_API.G_EXC_ERROR THEN
4076: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
4077: x_return_status := FND_API.G_RET_STS_ERROR;
4078:
4079: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4080: p_count => x_msg_count,
4081: p_data => x_msg_data);
4082:
4083: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4093: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4089: WHEN OTHERS THEN
4090: ROLLBACK to UPDATE_MTL_TXNS_LOT_SRL_PVT ;
4091: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4092:
4093: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4094: -- Add Unexpected Error to Message List, here SQLERRM is used for
4095: -- getting the error
4096: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4097: p_procedure_name => lc_api_name );

Line 4096: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

4092:
4093: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4094: -- Add Unexpected Error to Message List, here SQLERRM is used for
4095: -- getting the error
4096: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4097: p_procedure_name => lc_api_name );
4098: END IF;
4099:
4100: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4100: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4096: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4097: p_procedure_name => lc_api_name );
4098: END IF;
4099:
4100: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4101: p_count => x_msg_count,
4102: p_data => x_msg_data);
4103:
4104: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4189: FND_MSG_PUB.initialize;

4185: END IF;
4186:
4187:
4188: IF FND_API.to_boolean(p_init_msg_list) THEN
4189: FND_MSG_PUB.initialize;
4190: END IF;
4191:
4192:
4193:

Line 4223: FND_MSG_PUB.ADD;

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:
4227:

Line 4235: FND_MSG_PUB.ADD;

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:
4239: l_job_details_rec.scheduled_flag := fnd_profile.value('CSD_HV_SCD_FLG');

Line 4246: FND_MSG_PUB.ADD;

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:
4250: l_job_details_rec.standard_rate_flag := fnd_profile.value('CSD_HV_STD_FLG');

Line 4257: FND_MSG_PUB.ADD;

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:
4261: l_wip_cost_txn_interface_rec.transaction_date := sysdate;

Line 4288: FND_MSG_PUB.ADD;

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:
4292: l_wip_cost_txn_interface_rec.transaction_uom := p_res_txn_dtls_tbl(res_ctr).transaction_uom;

Line 4502: FND_MSG_PUB.ADD;

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,
4506: p_count => x_msg_count,

Line 4505: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
4506: p_count => x_msg_count,
4507: p_data => x_msg_data);
4508:
4509: RETURN;

Line 4527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4523: WHEN OTHERS THEN
4524:
4525: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4526:
4527: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4528:
4529: -- Add Unexpected Error to Message List, here SQLERRM is used for
4530: -- getting the error
4531:

Line 4532: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

4528:
4529: -- Add Unexpected Error to Message List, here SQLERRM is used for
4530: -- getting the error
4531:
4532: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4533: p_procedure_name => lc_api_name );
4534: END IF;
4535:
4536: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4536: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4532: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4533: p_procedure_name => lc_api_name );
4534: END IF;
4535:
4536: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4537: p_count => x_msg_count,
4538: p_data => x_msg_data);
4539:
4540: END;

Line 4547: FND_MSG_PUB.ADD;

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: */
4551:

Line 4577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4574: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4576:
4577: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4578: p_count => x_msg_count,
4579: p_data => x_msg_data);
4580:
4581: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4593: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4589: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4590: x_return_status := FND_API.G_RET_STS_ERROR;
4591:
4592:
4593: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4594: p_count => x_msg_count,
4595: p_data => x_msg_data);
4596:
4597: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4607: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

4603: WHEN OTHERS THEN
4604: ROLLBACK to PROCESS_TRANSACT_RES_TXN_PVT ;
4605: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4606:
4607: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
4608:
4609: -- Add Unexpected Error to Message List, here SQLERRM is used for
4610: -- getting the error
4611:

Line 4612: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

4608:
4609: -- Add Unexpected Error to Message List, here SQLERRM is used for
4610: -- getting the error
4611:
4612: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4613: p_procedure_name => lc_api_name );
4614: END IF;
4615:
4616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 4616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

4612: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
4613: p_procedure_name => lc_api_name );
4614: END IF;
4615:
4616: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
4617: p_count => x_msg_count,
4618: p_data => x_msg_data);
4619:
4620: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 4778: FND_MSG_PUB.initialize;

4774: END IF;
4775:
4776: -- Initialize message list if p_init_msg_list is set to TRUE
4777: IF FND_API.to_boolean(p_init_msg_list) THEN
4778: FND_MSG_PUB.initialize;
4779: END IF;
4780:
4781:
4782: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 4844: FND_MSG_PUB.ADD;

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';
4848: l_op_dtls_tbl(1).wip_entity_id := p_mtl_txn_dtls_tbl(mtl_ctr).wip_entity_id;

Line 4875: FND_MSG_PUB.ADD;

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
4879: end if; -- operation does not exist

Line 4974: FND_MSG_PUB.ADD;

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:
4978:

Line 5034: FND_MSG_PUB.ADD;

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,
5038: p_count => x_msg_count,

Line 5037: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
5038: p_count => x_msg_count,
5039: p_data => x_msg_data);
5040: -- Need to rollback Raise exception -
5041: -- once commit is removed from above call

Line 5061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5057: -- when rollback for WIP works, remove x_return_status, count_and_get,
5058: -- and return then reinstate raise exception above
5059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5060: /*
5061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5062: -- Add Unexpected Error to Message List, here SQLERRM is used for
5063: -- getting the error
5064:
5065: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

Line 5065: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

5061: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5062: -- Add Unexpected Error to Message List, here SQLERRM is used for
5063: -- getting the error
5064:
5065: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5066: p_procedure_name => lc_api_name );
5067: END IF;
5068: */
5069: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5069: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5065: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5066: p_procedure_name => lc_api_name );
5067: END IF;
5068: */
5069: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5070: p_count => x_msg_count,
5071: p_data => x_msg_data);
5072:
5073: END;

Line 5216: FND_MSG_PUB.ADD;

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,
5220: p_data => x_msg_data);

Line 5218: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
5220: p_data => x_msg_data);
5221: -- do not return: keep going even if requirements cannot be saved,
5222: -- because wip transaction details can be updated.

Line 5243: FND_MSG_PUB.ADD;

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,
5247: p_data => x_msg_data);

Line 5245: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
5247: p_data => x_msg_data);
5248: END;
5249: END IF; -- p_mtl_txn_dtls_tbl(mtl_ctr).new_row <> 'Y'

Line 5378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5374: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5375: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
5376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5377:
5378: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5379: p_count => x_msg_count,
5380: p_data => x_msg_data);
5381:
5382: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5394: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5390: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
5391: x_return_status := FND_API.G_RET_STS_ERROR;
5392:
5393:
5394: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5395: p_count => x_msg_count,
5396: p_data => x_msg_data);
5397:
5398: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5404: WHEN OTHERS THEN
5405: ROLLBACK to PROCESS_SAVE_MTL_TXN_DTLS_PVT ;
5406: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5407:
5408: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5409:
5410: -- Add Unexpected Error to Message List, here SQLERRM is used for
5411: -- getting the error
5412:

Line 5413: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

5409:
5410: -- Add Unexpected Error to Message List, here SQLERRM is used for
5411: -- getting the error
5412:
5413: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5414: p_procedure_name => lc_api_name );
5415: END IF;
5416:
5417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5413: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5414: p_procedure_name => lc_api_name );
5415: END IF;
5416:
5417: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5418: p_count => x_msg_count,
5419: p_data => x_msg_data);
5420:
5421: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5532: FND_MSG_PUB.initialize;

5528:
5529:
5530: -- Initialize message list if p_init_msg_list is set to TRUE
5531: IF FND_API.to_boolean(p_init_msg_list) THEN
5532: FND_MSG_PUB.initialize;
5533: END IF;
5534:
5535: x_return_status := FND_API.G_RET_STS_SUCCESS;
5536:

Line 5670: FND_MSG_PUB.ADD;

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,
5674: p_count => x_msg_count,

Line 5673: FND_MSG_PUB.count_and_get(p_encoded => FND_API.G_FALSE,

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,
5674: p_count => x_msg_count,
5675: p_data => x_msg_data);
5676:
5677: -- Need to rollback Raise exception -

Line 5700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5696: -- when rollback for WIP works, remove x_return_status, count_and_get,
5697: -- and return then reinstate raise exception above
5698: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5699: /*
5700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5701: -- Add Unexpected Error to Message List, here SQLERRM is used for
5702: -- getting the error
5703: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5704: p_procedure_name => lc_api_name );

Line 5703: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

5699: /*
5700: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5701: -- Add Unexpected Error to Message List, here SQLERRM is used for
5702: -- getting the error
5703: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5704: p_procedure_name => lc_api_name );
5705: END IF;
5706: */
5707: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5707: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5703: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5704: p_procedure_name => lc_api_name );
5705: END IF;
5706: */
5707: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5708: p_count => x_msg_count,
5709: p_data => x_msg_data);
5710: return;
5711: END;

Line 5842: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5838: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
5839: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5840: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5841:
5842: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5843: p_count => x_msg_count,
5844: p_data => x_msg_data);
5845:
5846: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5858: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5854: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5855: x_return_status := FND_API.G_RET_STS_ERROR;
5856:
5857:
5858: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5859: p_count => x_msg_count,
5860: p_data => x_msg_data);
5861:
5862: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

5868: WHEN OTHERS THEN
5869: ROLLBACK to PROCESS_SAVE_RES_TXN_DTLS_PVT ;
5870: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5871:
5872: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
5873:
5874: -- Add Unexpected Error to Message List, here SQLERRM is used for
5875: -- getting the error
5876:

Line 5877: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

5873:
5874: -- Add Unexpected Error to Message List, here SQLERRM is used for
5875: -- getting the error
5876:
5877: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5878: p_procedure_name => lc_api_name );
5879: END IF;
5880:
5881: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 5881: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

5877: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
5878: p_procedure_name => lc_api_name );
5879: END IF;
5880:
5881: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
5882: p_count => x_msg_count,
5883: p_data => x_msg_data);
5884:
5885: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 5962: FND_MSG_PUB.initialize;

5958:
5959:
5960: -- Initialize message list if p_init_msg_list is set to TRUE
5961: IF FND_API.to_boolean(p_init_msg_list) THEN
5962: FND_MSG_PUB.initialize;
5963: END IF;
5964:
5965: x_return_status := FND_API.G_RET_STS_SUCCESS;
5966:

Line 6070: FND_MSG_PUB.ADD;

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,
6074: p_count => x_msg_count,

Line 6073: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
6074: p_count => x_msg_count,
6075: p_data => x_msg_data);
6076:
6077: -- Need to rollback Raise exception -

Line 6099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6095: -- when rollback for WIP works, remove x_return_status, count_and_get,
6096: -- and return then reinstate raise exception above
6097: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6098: /*
6099: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6100:
6101: -- Add Unexpected Error to Message List, here SQLERRM is used for
6102: -- getting the error
6103:

Line 6104: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

6100:
6101: -- Add Unexpected Error to Message List, here SQLERRM is used for
6102: -- getting the error
6103:
6104: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6105: p_procedure_name => lc_api_name );
6106: END IF;
6107: */
6108: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6108: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6104: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6105: p_procedure_name => lc_api_name );
6106: END IF;
6107: */
6108: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6109: p_count => x_msg_count,
6110: p_data => x_msg_data);
6111: return;
6112: END;

Line 6240: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6236: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6237: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
6238: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6239:
6240: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6241: p_count => x_msg_count,
6242: p_data => x_msg_data);
6243:
6244: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6256: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6252: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
6253: x_return_status := FND_API.G_RET_STS_ERROR;
6254:
6255:
6256: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6257: p_count => x_msg_count,
6258: p_data => x_msg_data);
6259:
6260: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

6266: WHEN OTHERS THEN
6267: ROLLBACK to PROCESS_SAVE_OP_DTLS_PVT ;
6268: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6269:
6270: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
6271:
6272: -- Add Unexpected Error to Message List, here SQLERRM is used for
6273: -- getting the error
6274:

Line 6275: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

6271:
6272: -- Add Unexpected Error to Message List, here SQLERRM is used for
6273: -- getting the error
6274:
6275: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6276: p_procedure_name => lc_api_name );
6277: END IF;
6278:
6279: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 6279: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6275: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
6276: p_procedure_name => lc_api_name );
6277: END IF;
6278:
6279: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6280: p_count => x_msg_count,
6281: p_data => x_msg_data);
6282:
6283: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 6431: FND_MSG_PUB.initialize;

6427: END IF;
6428:
6429: -- Initialize message list if p_init_msg_list is set to TRUE
6430: IF FND_API.to_boolean(p_init_msg_list) THEN
6431: FND_MSG_PUB.initialize;
6432: END IF;
6433:
6434: -- Initialize API return status to success
6435: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 6446: FND_MSG_PUB.ADD;

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:
6450:

Line 6460: FND_MSG_PUB.ADD;

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:
6464:

Line 6482: FND_MSG_PUB.ADD;

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:
6486:

Line 6603: FND_MSG_PUB.ADD;

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 -
6607: -- once commit is removed from above call

Line 6734: FND_MSG_PUB.ADD;

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
6738: l_mtl_txn_dtls_tbl(0).REASON_ID := l_default_reason_id;

Line 6760: FND_MSG_PUB.ADD;

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
6764: if l_default_create_ro_flag = 'Y' then

Line 6789: FND_MSG_PUB.ADD;

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:
6793:

Line 6799: FND_MSG_PUB.ADD;

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:
6803: -- dbms_output.put_line('In Error');

Line 6992: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

6988: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
6989: ROLLBACK to CREATE_WIP_JOB_PVT ;
6990: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6991:
6992: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
6993: p_count => x_msg_count,
6994: p_data => x_msg_data);
6995:
6996: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 7008: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7004: ROLLBACK to CREATE_WIP_JOB_PVT ;
7005: x_return_status := FND_API.G_RET_STS_ERROR;
7006:
7007:
7008: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7009: p_count => x_msg_count,
7010: p_data => x_msg_data);
7011:
7012: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 7022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7018: WHEN OTHERS THEN
7019: ROLLBACK to CREATE_WIP_JOB_PVT ;
7020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7021:
7022: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7023:
7024: -- Add Unexpected Error to Message List, here SQLERRM is used for
7025: -- getting the error
7026:

Line 7027: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

7023:
7024: -- Add Unexpected Error to Message List, here SQLERRM is used for
7025: -- getting the error
7026:
7027: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
7028: p_procedure_name => lc_api_name );
7029: END IF;
7030:
7031: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 7031: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7027: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
7028: p_procedure_name => lc_api_name );
7029: END IF;
7030:
7031: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7032: p_count => x_msg_count,
7033: p_data => x_msg_data);
7034:
7035: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 7234: FND_MSG_PUB.initialize;

7230: END IF;
7231:
7232: -- Initialize message list if p_init_msg_list is set to TRUE
7233: IF FND_API.to_boolean(p_init_msg_list) THEN
7234: FND_MSG_PUB.initialize;
7235: END IF;
7236:
7237: -- Initialize API return status to success
7238: x_return_status:=FND_API.G_RET_STS_SUCCESS;

Line 7247: FND_MSG_PUB.ADD;

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:
7251: l_job_prefix := fnd_profile.value('CSD_DEFAULT_JOB_PREFIX');

Line 7256: FND_MSG_PUB.ADD;

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:
7260: l_job_header_rec.class_code :=

Line 7265: FND_MSG_PUB.ADD;

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:
7269: -- Populate the Job Header Record

Line 7409: FND_MSG_PUB.ADD;

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 -
7413: -- once commit is removed from above call

Line 7477: FND_MSG_PUB.ADD;

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:
7481: if (l_default_rule_id is not null) then

Line 7503: FND_MSG_PUB.ADD;

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
7507: if l_default_create_ro_flag = 'Y' then

Line 7625: FND_MSG_PUB.ADD;

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
7629: l_mtl_txn_dtls_tbl(i).REASON_ID := l_default_reason_id;

Line 7650: FND_MSG_PUB.ADD;

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
7654: if l_default_create_ro_flag = 'Y' then

Line 7680: FND_MSG_PUB.ADD;

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;
7684:

Line 7855: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);

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:
7859: l_ro_service_code_rec.ro_service_code_id := p_service_code_tbl(sc_ctr).ro_service_code_id;

Line 7905: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7901: -- if there are messages to show, then set the return status in order
7902: -- to flag this, but do not rollback.
7903: if l_show_messages_flag = 'T' then
7904: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7905: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7906: p_count => x_msg_count,
7907: p_data => x_msg_data);
7908: end if;
7909: -- swai: end bug 5239301

Line 7923: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7919: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
7920: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
7921: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7922:
7923: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7924: p_count => x_msg_count,
7925: p_data => x_msg_data);
7926:
7927: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 7939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7935: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
7936: x_return_status := FND_API.G_RET_STS_ERROR;
7937:
7938:
7939: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7940: p_count => x_msg_count,
7941: p_data => x_msg_data);
7942:
7943: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 7953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

7949: WHEN OTHERS THEN
7950: ROLLBACK to GENERATE_WIP_JOBS_FROM_SCS_PVT ;
7951: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
7952:
7953: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
7954:
7955: -- Add Unexpected Error to Message List, here SQLERRM is used for
7956: -- getting the error
7957:

Line 7958: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

7954:
7955: -- Add Unexpected Error to Message List, here SQLERRM is used for
7956: -- getting the error
7957:
7958: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
7959: p_procedure_name => lc_api_name );
7960: END IF;
7961:
7962: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 7962: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

7958: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
7959: p_procedure_name => lc_api_name );
7960: END IF;
7961:
7962: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
7963: p_count => x_msg_count,
7964: p_data => x_msg_data);
7965:
7966: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8110: FND_MSG_PUB.initialize;

8106: END IF;
8107:
8108:
8109: IF FND_API.to_boolean(p_init_msg_list) THEN
8110: FND_MSG_PUB.initialize;
8111: END IF;
8112:
8113: x_return_status := FND_API.G_RET_STS_SUCCESS;
8114:

Line 8144: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8141: ROLLBACK to PROCESS_AUTO_ISSUE_MTL_TXN_PVT ;
8142: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8143:
8144: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8145: p_count => x_msg_count,
8146: p_data => x_msg_data);
8147:
8148: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8160: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8156: ROLLBACK to PROCESS_AUTO_ISSUE_MTL_TXN_PVT ;
8157: x_return_status := FND_API.G_RET_STS_ERROR;
8158:
8159:
8160: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8161: p_count => x_msg_count,
8162: p_data => x_msg_data);
8163:
8164: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8170: WHEN OTHERS THEN
8171: ROLLBACK to PROCESS_AUTO_ISSUE_MTL_TXN_PVT ;
8172: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8173:
8174: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8175:
8176: -- Add Unexpected Error to Message List, here SQLERRM is used for
8177: -- getting the error
8178:

Line 8179: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

8175:
8176: -- Add Unexpected Error to Message List, here SQLERRM is used for
8177: -- getting the error
8178:
8179: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8180: p_procedure_name => lc_api_name );
8181: END IF;
8182:
8183: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 8183: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8179: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8180: p_procedure_name => lc_api_name );
8181: END IF;
8182:
8183: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8184: p_count => x_msg_count,
8185: p_data => x_msg_data);
8186:
8187: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8332: FND_MSG_PUB.initialize;

8328: END IF;
8329:
8330:
8331: IF FND_API.to_boolean(p_init_msg_list) THEN
8332: FND_MSG_PUB.initialize;
8333: END IF;
8334:
8335: x_return_status := FND_API.G_RET_STS_SUCCESS;
8336:

Line 8365: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8361: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8362: ROLLBACK to PROCESS_AUTO_TRANS_RES_TXN_PVT ;
8363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8364:
8365: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8366: p_count => x_msg_count,
8367: p_data => x_msg_data);
8368:
8369: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8377: ROLLBACK to PROCESS_AUTO_TRANS_RES_TXN_PVT ;
8378: x_return_status := FND_API.G_RET_STS_ERROR;
8379:
8380:
8381: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8382: p_count => x_msg_count,
8383: p_data => x_msg_data);
8384:
8385: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8391: WHEN OTHERS THEN
8392: ROLLBACK to PROCESS_AUTO_TRANS_RES_TXN_PVT ;
8393: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8394:
8395: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8396:
8397: -- Add Unexpected Error to Message List, here SQLERRM is used for
8398: -- getting the error
8399:

Line 8400: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

8396:
8397: -- Add Unexpected Error to Message List, here SQLERRM is used for
8398: -- getting the error
8399:
8400: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8401: p_procedure_name => lc_api_name );
8402: END IF;
8403:
8404: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 8404: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8400: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8401: p_procedure_name => lc_api_name );
8402: END IF;
8403:
8404: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8405: p_count => x_msg_count,
8406: p_data => x_msg_data);
8407:
8408: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8507: FND_MSG_PUB.initialize;

8503: END IF;
8504:
8505:
8506: IF FND_API.to_boolean(p_init_msg_list) THEN
8507: FND_MSG_PUB.initialize;
8508: END IF;
8509:
8510: x_return_status := FND_API.G_RET_STS_SUCCESS;
8511:

Line 8540: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8536: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8537: ROLLBACK to PROCESS_AUTO_OPER_COMP_TXN_PVT ;
8538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8539:
8540: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8541: p_count => x_msg_count,
8542: p_data => x_msg_data);
8543:
8544: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8552: ROLLBACK to PROCESS_AUTO_OPER_COMP_TXN_PVT ;
8553: x_return_status := FND_API.G_RET_STS_ERROR;
8554:
8555:
8556: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8557: p_count => x_msg_count,
8558: p_data => x_msg_data);
8559:
8560: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8566: WHEN OTHERS THEN
8567: ROLLBACK to PROCESS_AUTO_OPER_COMP_TXN_PVT ;
8568: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8569:
8570: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8571:
8572: -- Add Unexpected Error to Message List, here SQLERRM is used for
8573: -- getting the error
8574:

Line 8575: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

8571:
8572: -- Add Unexpected Error to Message List, here SQLERRM is used for
8573: -- getting the error
8574:
8575: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8576: p_procedure_name => lc_api_name );
8577: END IF;
8578:
8579: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 8579: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8575: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8576: p_procedure_name => lc_api_name );
8577: END IF;
8578:
8579: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8580: p_count => x_msg_count,
8581: p_data => x_msg_data);
8582:
8583: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8764: FND_MSG_PUB.initialize;

8760: END IF;
8761:
8762:
8763: IF FND_API.to_boolean(p_init_msg_list) THEN
8764: FND_MSG_PUB.initialize;
8765: END IF;
8766:
8767: x_return_status := FND_API.G_RET_STS_SUCCESS;
8768:

Line 8783: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);

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
8787: -- Bug 8923513: Validate the resource against the operation department

Line 8795: FND_MSG_PUB.add_detail(p_message_type => FND_MSG_PUB.G_WARNING_MSG);

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;
8799: end if;

Line 8922: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8918: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
8919: ROLLBACK to PROCESS_TIME_CLOCK_RES_TXN_PVT ;
8920: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8921:
8922: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8923: p_count => x_msg_count,
8924: p_data => x_msg_data);
8925:
8926: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8938: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8934: ROLLBACK to PROCESS_TIME_CLOCK_RES_TXN_PVT ;
8935: x_return_status := FND_API.G_RET_STS_ERROR;
8936:
8937:
8938: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8939: p_count => x_msg_count,
8940: p_data => x_msg_data);
8941:
8942: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 8952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

8948: WHEN OTHERS THEN
8949: ROLLBACK to PROCESS_TIME_CLOCK_RES_TXN_PVT ;
8950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
8951:
8952: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
8953:
8954: -- Add Unexpected Error to Message List, here SQLERRM is used for
8955: -- getting the error
8956:

Line 8957: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

8953:
8954: -- Add Unexpected Error to Message List, here SQLERRM is used for
8955: -- getting the error
8956:
8957: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8958: p_procedure_name => lc_api_name );
8959: END IF;
8960:
8961: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 8961: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

8957: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
8958: p_procedure_name => lc_api_name );
8959: END IF;
8960:
8961: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
8962: p_count => x_msg_count,
8963: p_data => x_msg_data);
8964:
8965: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9033: FND_MSG_PUB.initialize;

9029: END IF;
9030:
9031:
9032: IF FND_API.to_boolean(p_init_msg_list) THEN
9033: FND_MSG_PUB.initialize;
9034: END IF;
9035:
9036: x_return_status := FND_API.G_RET_STS_SUCCESS;
9037:

Line 9088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9084: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9085: ROLLBACK to PROCESS_COMP_WORK_RO_STATUS ;
9086: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9087:
9088: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9089: p_count => x_msg_count,
9090: p_data => x_msg_data);
9091:
9092: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9104: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9100: ROLLBACK to PROCESS_COMP_WORK_RO_STATUS ;
9101: x_return_status := FND_API.G_RET_STS_ERROR;
9102:
9103:
9104: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9105: p_count => x_msg_count,
9106: p_data => x_msg_data);
9107:
9108: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9114: WHEN OTHERS THEN
9115: ROLLBACK to PROCESS_COMP_WORK_RO_STATUS ;
9116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9117:
9118: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9119:
9120: -- Add Unexpected Error to Message List, here SQLERRM is used for
9121: -- getting the error
9122:

Line 9123: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

9119:
9120: -- Add Unexpected Error to Message List, here SQLERRM is used for
9121: -- getting the error
9122:
9123: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9124: p_procedure_name => lc_api_name );
9125: END IF;
9126:
9127: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 9127: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9123: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9124: p_procedure_name => lc_api_name );
9125: END IF;
9126:
9127: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9128: p_count => x_msg_count,
9129: p_data => x_msg_data);
9130:
9131: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9214: FND_MSG_PUB.initialize;

9210: END IF;
9211:
9212: -- Initialize message list if p_init_msg_list is set to TRUE
9213: IF FND_API.to_boolean(p_init_msg_list) THEN
9214: FND_MSG_PUB.initialize;
9215: END IF;
9216:
9217:
9218: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9294: FND_MSG_PUB.ADD;

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,
9298: p_count => x_msg_count,

Line 9297: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
9298: p_count => x_msg_count,
9299: p_data => x_msg_data);
9300: -- Need to rollback Raise exception -
9301: -- once commit is removed from above call

Line 9321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9317: -- when rollback for WIP works, remove x_return_status, count_and_get,
9318: -- and return then reinstate raise exception above
9319: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9320: /*
9321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9322: -- Add Unexpected Error to Message List, here SQLERRM is used for
9323: -- getting the error
9324:
9325: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

Line 9325: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

9321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9322: -- Add Unexpected Error to Message List, here SQLERRM is used for
9323: -- getting the error
9324:
9325: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9326: p_procedure_name => lc_api_name );
9327: END IF;
9328: */
9329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 9329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9325: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9326: p_procedure_name => lc_api_name );
9327: END IF;
9328: */
9329: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9330: p_count => x_msg_count,
9331: p_data => x_msg_data);
9332:
9333: END;

Line 9366: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9362: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9363: ROLLBACK to PROCESS_DELETE_MTL_TXN_DTL_PVT ;
9364: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9365:
9366: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9367: p_count => x_msg_count,
9368: p_data => x_msg_data);
9369:
9370: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9382: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9378: ROLLBACK to PROCESS_DELETE_MTL_TXN_DTL_PVT ;
9379: x_return_status := FND_API.G_RET_STS_ERROR;
9380:
9381:
9382: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9383: p_count => x_msg_count,
9384: p_data => x_msg_data);
9385:
9386: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9392: WHEN OTHERS THEN
9393: ROLLBACK to PROCESS_DELETE_MTL_TXN_DTL_PVT ;
9394: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9395:
9396: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9397:
9398: -- Add Unexpected Error to Message List, here SQLERRM is used for
9399: -- getting the error
9400:

Line 9401: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

9397:
9398: -- Add Unexpected Error to Message List, here SQLERRM is used for
9399: -- getting the error
9400:
9401: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9402: p_procedure_name => lc_api_name );
9403: END IF;
9404:
9405: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 9405: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9401: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9402: p_procedure_name => lc_api_name );
9403: END IF;
9404:
9405: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9406: p_count => x_msg_count,
9407: p_data => x_msg_data);
9408:
9409: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9641: FND_MSG_PUB.initialize;

9637: END IF;
9638:
9639: -- Initialize message list if p_init_msg_list is set to TRUE
9640: IF FND_API.to_boolean(p_init_msg_list) THEN
9641: FND_MSG_PUB.initialize;
9642: END IF;
9643:
9644:
9645: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 9669: fnd_msg_pub.add;

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,
9673: p_count => x_msg_count,

Line 9672: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

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,
9673: p_count => x_msg_count,
9674: p_data => x_msg_data);
9675: RETURN;
9676: end if;

Line 9796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
9793: ROLLBACK to PROCESS_DELETE_OP_DTL_PVT ;
9794: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9795:
9796: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9797: p_count => x_msg_count,
9798: p_data => x_msg_data);
9799:
9800: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9812: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9808: ROLLBACK to PROCESS_DELETE_op_dtl_PVT ;
9809: x_return_status := FND_API.G_RET_STS_ERROR;
9810:
9811:
9812: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9813: p_count => x_msg_count,
9814: p_data => x_msg_data);
9815:
9816: IF ( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

9822: WHEN OTHERS THEN
9823: ROLLBACK to PROCESS_DELETE_op_dtl_PVT ;
9824: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
9825:
9826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
9827:
9828: -- Add Unexpected Error to Message List, here SQLERRM is used for
9829: -- getting the error
9830:

Line 9831: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

9827:
9828: -- Add Unexpected Error to Message List, here SQLERRM is used for
9829: -- getting the error
9830:
9831: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9832: p_procedure_name => lc_api_name );
9833: END IF;
9834:
9835: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 9835: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

9831: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
9832: p_procedure_name => lc_api_name );
9833: END IF;
9834:
9835: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
9836: p_count => x_msg_count,
9837: p_data => x_msg_data);
9838:
9839: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 9897: fnd_msg_pub.initialize;

9893:
9894: -- Initialize message list if p_init_msg_list is set to TRUE
9895: IF fnd_api.to_boolean(p_init_msg_list)
9896: THEN
9897: fnd_msg_pub.initialize;
9898: END IF;
9899:
9900: x_return_status := fnd_api.g_ret_sts_success;
9901:

Line 10362: FND_MSG_PUB.initialize;

10358: END IF;
10359:
10360:
10361: IF FND_API.to_boolean(p_init_msg_list) THEN
10362: FND_MSG_PUB.initialize;
10363: END IF;
10364:
10365: -- initialize out params
10366: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 10425: FND_MSG_PUB.ADD;

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:
10429:

Line 10441: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

10437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
10438: ROLLBACK to GENERATE_ESTIMATE_FROM_WIP ;
10439: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10440:
10441: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
10442: p_count => x_msg_count,
10443: p_data => x_msg_data);
10444:
10445: IF (lc_excep_level >= lc_debug_level ) then

Line 10457: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

10453: ROLLBACK to GENERATE_ESTIMATE_FROM_WIP ;
10454: x_return_status := FND_API.G_RET_STS_ERROR;
10455:
10456:
10457: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
10458: p_count => x_msg_count,
10459: p_data => x_msg_data);
10460:
10461: IF ( lc_error_level >= lc_debug_level ) then

Line 10471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

10467: WHEN OTHERS THEN
10468: ROLLBACK to GENERATE_ESTIMATE_FROM_WIP ;
10469: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
10470:
10471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10472: -- Add Unexpected Error to Message List, here SQLERRM is used for
10473: -- getting the error
10474: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
10475: p_procedure_name => lc_api_name );

Line 10474: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,

10470:
10471: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
10472: -- Add Unexpected Error to Message List, here SQLERRM is used for
10473: -- getting the error
10474: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
10475: p_procedure_name => lc_api_name );
10476: END IF;
10477:
10478: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

Line 10478: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

10474: FND_MSG_PUB.add_exc_msg(p_pkg_name => G_PKG_NAME,
10475: p_procedure_name => lc_api_name );
10476: END IF;
10477:
10478: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
10479: p_count => x_msg_count,
10480: p_data => x_msg_data);
10481:
10482: IF ( lc_excep_level >= lc_debug_level) then