APPS.CSI_DIAGNOSTICS_PKG dependencies on XNP_MSGS

Line 3196: FROM xnp_msgs

3192: msg_status,
3193: body_text,
3194: creation_date,
3195: description
3196: FROM xnp_msgs
3197: WHERE (msg_code like 'CSI%' OR msg_code like 'CSE%')
3198: AND recipient_name is null
3199: AND msg_status IN ('READY', 'FAILED', 'REJECTED')
3200: AND msg_creation_date > p_freeze_date;

Line 3225: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';

3221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
3222: RAISE fnd_api.g_exc_error;
3223: END IF;
3224:
3225: l_object_name := l_schema_name||'.csi_xnp_msgs_temp';
3226:
3227: truncate_table(l_object_name);
3228:
3229: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

Line 3258: INSERT INTO csi_xnp_msgs_temp(

3254: xnp_xml_utils.decode(l_msg_text, 'MTL_TRANSACTION_ID', l_source_id);
3255: l_source_type := 'MTL_TRANSACTION_ID';
3256: END IF;
3257:
3258: INSERT INTO csi_xnp_msgs_temp(
3259: msg_id,
3260: msg_code,
3261: msg_text,
3262: msg_status,

Line 3299: FROM csi_xnp_msgs_temp

3295: source_type,
3296: creation_date,
3297: description,
3298: process_flag
3299: FROM csi_xnp_msgs_temp
3300: WHERE source_type = 'MTL_TRANSACTION_ID'
3301: AND source_id is not null;
3302:
3303: l_release number;

Line 3363: UPDATE xnp_msgs

3359: p_dequeue_flag => 'Y',
3360: p_release => l_release);
3361:
3362: -- this code needs to be changed to appropriate call in xnp
3363: UPDATE xnp_msgs
3364: SET msg_status = 'PROCESSED'
3365: WHERE msg_id = q_rec.msg_id;
3366:
3367: EXCEPTION

Line 3479: FROM csi_xnp_msgs_temp

3475: SELECT 'Y' INTO l_pending_msg_found
3476: FROM sys.dual
3477: WHERE exists (
3478: SELECT '1'
3479: FROM csi_xnp_msgs_temp
3480: WHERE source_type = 'MTL_TRANSACTION_ID'
3481: AND source_id = wip_txn_rec.mtl_txn_id
3482: AND nvl(msg_status, 'READY') <> 'PROCESSED');
3483: l_in_queue := true;

Line 3638: FROM csi_xnp_msgs_temp

3634: SELECT 'Y' INTO l_pending_msg_found
3635: FROM sys.dual
3636: WHERE exists (
3637: SELECT '1'
3638: FROM csi_xnp_msgs_temp
3639: WHERE source_type = 'MTL_TRANSACTION_ID'
3640: AND source_id = all_txn_rec.mtl_txn_id
3641: AND nvl(msg_status, 'READY') <> 'PROCESSED');
3642: l_in_queue := true;

Line 4035: -- dumps the xnp_msgs in to csi_xnp_msgs_tmp with the decoded value

4031: l_object_name varchar2(80);
4032:
4033: BEGIN
4034:
4035: -- dumps the xnp_msgs in to csi_xnp_msgs_tmp with the decoded value
4036: decode_queue;
4037:
4038: -- pump missing transaction for the serial numbers that are in error condition
4039: pump_err_missing_txns;

Line 9030: there is any pending in xnp_msgs.

9026: dump_diff(l_instance_rec);
9027: END IF;
9028:
9029: /* loop thru all the material transactions after freeze date and check if
9030: there is any pending in xnp_msgs.
9031:
9032: also check if there is any errors in csi_txn_errors. if found then skip
9033: the serial.
9034: */

Line 9082: FROM csi_xnp_msgs_temp

9078: SELECT 'Y' INTO l_pending_msg_found
9079: FROM sys.dual
9080: WHERE exists (
9081: SELECT '1'
9082: FROM csi_xnp_msgs_temp
9083: WHERE source_type = 'MTL_TRANSACTION_ID'
9084: AND source_id = all_txn_rec.mtl_txn_id
9085: AND nvl(msg_status, 'READY') <> 'PROCESSED');
9086:

Line 9087: l_skip_error := ' Unprocessed Message in XNP_MSGS for MTL_TXN_ID: '||

9083: WHERE source_type = 'MTL_TRANSACTION_ID'
9084: AND source_id = all_txn_rec.mtl_txn_id
9085: AND nvl(msg_status, 'READY') <> 'PROCESSED');
9086:
9087: l_skip_error := ' Unprocessed Message in XNP_MSGS for MTL_TXN_ID: '||
9088: all_txn_rec.mtl_txn_id;
9089: RAISE skip_serial;
9090:
9091: EXCEPTION