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.XNP_MESSAGE dependencies on XNP_MSGS

Line 17: PROCEDURE decode_xnp_msgs (

13: g_new_line CONSTANT VARCHAR2(10) := convert(fnd_global.local_chr(10),
14: substr(userenv('LANGUAGE'), instr(userenv('LANGUAGE'),'.') +1),
15: 'WE8ISO8859P1') ;
16:
17: PROCEDURE decode_xnp_msgs (
18: p_msg_header IN OUT NOCOPY XNP_MESSAGE.MSG_HEADER_REC_TYPE,
19: p_body_text IN VARCHAR2
20: ) ;
21:

Line 47: CURSOR get_message ( message_id IN XNP_MSGS.MSG_ID%TYPE ) IS

43: )
44: IS
45:
46:
47: CURSOR get_message ( message_id IN XNP_MSGS.MSG_ID%TYPE ) IS
48: SELECT msg_id,
49: msg_code,
50: reference_id,
51: opp_reference_id,

Line 59: FROM xnp_msgs

55: msg_version,
56: order_id,
57: wi_instance_id,
58: fa_instance_id
59: FROM xnp_msgs
60: WHERE msg_id = message_id ;
61:
62: BEGIN
63:

Line 319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;

315: )
316: IS
317: BEGIN
318:
319: SELECT ( XNP_MSGS_S.nextval ) INTO x_msg_id FROM DUAL ;
320:
321: END get_sequence;
322:
323: /***************************************************************************

Line 341: CURSOR get_message (message_id IN XNP_MSGS.MSG_ID%TYPE ) IS

337: l_lob_loc CLOB;
338: l_amount_to_read INTEGER;
339: l_rec_found BOOLEAN := false;
340:
341: CURSOR get_message (message_id IN XNP_MSGS.MSG_ID%TYPE ) IS
342: SELECT msg_id,
343: msg_code,
344: reference_id,
345: opp_reference_id,

Line 354: FROM xnp_msgs

350: order_id,
351: wi_instance_id,
352: fa_instance_id,
353: body_text
354: FROM xnp_msgs
355: WHERE msg_id = message_id ;
356:
357: BEGIN
358:

Line 406: CURSOR get_lob_loc ( message_id IN XNP_MSGS.MSG_ID%TYPE ) IS

402:
403: l_lob_loc CLOB ;
404: l_amount_to_read INTEGER;
405:
406: CURSOR get_lob_loc ( message_id IN XNP_MSGS.MSG_ID%TYPE ) IS
407: SELECT body_text from xnp_msgs
408: WHERE msg_id = message_id ;
409:
410: BEGIN

Line 407: SELECT body_text from xnp_msgs

403: l_lob_loc CLOB ;
404: l_amount_to_read INTEGER;
405:
406: CURSOR get_lob_loc ( message_id IN XNP_MSGS.MSG_ID%TYPE ) IS
407: SELECT body_text from xnp_msgs
408: WHERE msg_id = message_id ;
409:
410: BEGIN
411:

Line 434: ***** Purpose: Inserts a message into XNP_MSGS table

430: END get;
431:
432: /***************************************************************************
433: ***** Procedure: PUSH()
434: ***** Purpose: Inserts a message into XNP_MSGS table
435: ***** and enqueues the message on a specified Queue .
436: ****************************************************************************/
437:
438: PROCEDURE push(

Line 466: l_adapter_name XNP_MSGS.ADAPTER_NAME%TYPE;

462:
463: l_lob_loc CLOB ;
464: l_correlation_id VARCHAR2(1024) ;
465:
466: l_adapter_name XNP_MSGS.ADAPTER_NAME%TYPE;
467: l_fe_name XNP_MSGS.FE_NAME%TYPE;
468:
469: l_msg_header xnp_message.msg_header_rec_type ;
470: l_temp_fe NUMBER;

Line 467: l_fe_name XNP_MSGS.FE_NAME%TYPE;

463: l_lob_loc CLOB ;
464: l_correlation_id VARCHAR2(1024) ;
465:
466: l_adapter_name XNP_MSGS.ADAPTER_NAME%TYPE;
467: l_fe_name XNP_MSGS.FE_NAME%TYPE;
468:
469: l_msg_header xnp_message.msg_header_rec_type ;
470: l_temp_fe NUMBER;
471: l_temp_adapter NUMBER;

Line 547: decode_xnp_msgs(l_msg_header, p_body_text) ;

543: IF (((l_msg_header.direction_indr = 'I') OR
544: (l_msg_header.direction_indr IS NULL)) AND
545: (xdp_utilities.g_message_list.COUNT < 0)
546: ) THEN
547: decode_xnp_msgs(l_msg_header, p_body_text) ;
548: END IF ;
549:
550: INSERT into xnp_msgs (
551: msg_id,

Line 550: INSERT into xnp_msgs (

546: ) THEN
547: decode_xnp_msgs(l_msg_header, p_body_text) ;
548: END IF ;
549:
550: INSERT into xnp_msgs (
551: msg_id,
552: msg_code,
553: direction_indicator,
554: reference_id,

Line 612: -- and populate the denormalized columns in XNP_MSGS table.

608: END IF ;
609:
610: --
611: -- For incoming messages, decode header fields from the XML Message
612: -- and populate the denormalized columns in XNP_MSGS table.
613: --
614:
615: IF (p_commit_mode = C_IMMEDIATE) THEN
616: COMMIT ;

Line 731: ***** Purpose: Inserts a message into XNP_MSGS table

727: END push;
728:
729: /***************************************************************************
730: ***** Procedure: PUSH()
731: ***** Purpose: Inserts a message into XNP_MSGS table
732: ***** and enqueues the message on a specified Queue .
733: ****************************************************************************/
734:
735: PROCEDURE push(

Line 1131: UPDATE XNP_MSGS SET msg_status = p_status,

1127: -- mviswana 11/2001
1128: -- bug fix # 1882340 to populate send_rcv_date
1129:
1130: IF (p_order_id IS NULL) THEN
1131: UPDATE XNP_MSGS SET msg_status = p_status,
1132: send_rcv_date = SYSDATE,
1133: last_update_date = SYSDATE,
1134: description = description || p_error_desc
1135: WHERE msg_id = p_msg_id ;

Line 1137: UPDATE XNP_MSGS SET msg_status = p_status,

1133: last_update_date = SYSDATE,
1134: description = description || p_error_desc
1135: WHERE msg_id = p_msg_id ;
1136: ELSE
1137: UPDATE XNP_MSGS SET msg_status = p_status,
1138: send_rcv_date = SYSDATE,
1139: last_update_date = SYSDATE,
1140: description = description || p_error_desc,
1141: order_id = p_order_id,

Line 1167: SELECT msg_status FROM XNP_MSGS

1163: )
1164: IS
1165:
1166: CURSOR get_msg_status IS
1167: SELECT msg_status FROM XNP_MSGS
1168: WHERE msg_id = p_msg_id ;
1169:
1170: BEGIN
1171:

Line 1443: l_msg_id XNP_MSGS.MSG_ID%TYPE ;

1439: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
1440: l_msg_text VARCHAR2(32767) ;
1441:
1442: l_message SYSTEM.XNP_MESSAGE_TYPE ;
1443: l_msg_id XNP_MSGS.MSG_ID%TYPE ;
1444: my_enqueue_options dbms_aq.enqueue_options_t ;
1445: message_properties dbms_aq.message_properties_t ;
1446: message_handle RAW(16) ;
1447:

Line 1453: select msg_code into l_msg_header.message_code from xnp_msgs where msg_id = p_msg_id;

1449: l_feedback VARCHAR2(4000) := NULL ;
1450:
1451: BEGIN
1452:
1453: select msg_code into l_msg_header.message_code from xnp_msgs where msg_id = p_msg_id;
1454:
1455: UPDATE xnp_msgs SET msg_status = 'READY',
1456: last_update_date = SYSDATE,
1457: description = NULL

Line 1455: UPDATE xnp_msgs SET msg_status = 'READY',

1451: BEGIN
1452:
1453: select msg_code into l_msg_header.message_code from xnp_msgs where msg_id = p_msg_id;
1454:
1455: UPDATE xnp_msgs SET msg_status = 'READY',
1456: last_update_date = SYSDATE,
1457: description = NULL
1458: WHERE msg_id = p_msg_id ;
1459:

Line 1492: PROCEDURE : populate_xnp_msgs()

1488:
1489: END fix ;
1490:
1491: /*************************************************************************
1492: PROCEDURE : populate_xnp_msgs()
1493: PURPOSE : Decodes the header fields in the newly arrived XML message
1494: and populates the columns in XNP_MSGS table
1495: **************************************************************************/
1496:

Line 1494: and populates the columns in XNP_MSGS table

1490:
1491: /*************************************************************************
1492: PROCEDURE : populate_xnp_msgs()
1493: PURPOSE : Decodes the header fields in the newly arrived XML message
1494: and populates the columns in XNP_MSGS table
1495: **************************************************************************/
1496:
1497: PROCEDURE decode_xnp_msgs (
1498: p_msg_header IN OUT NOCOPY xnp_message.msg_header_rec_type,

Line 1497: PROCEDURE decode_xnp_msgs (

1493: PURPOSE : Decodes the header fields in the newly arrived XML message
1494: and populates the columns in XNP_MSGS table
1495: **************************************************************************/
1496:
1497: PROCEDURE decode_xnp_msgs (
1498: p_msg_header IN OUT NOCOPY xnp_message.msg_header_rec_type,
1499: p_body_text IN VARCHAR2
1500: ) IS
1501: l_creation_date VARCHAR2(512) ;

Line 1539: END decode_xnp_msgs ;

1535:
1536: xnp_xml_utils.decode (l_header, 'RECIPIENT_NAME',
1537: p_msg_header.recipient_name) ;
1538:
1539: END decode_xnp_msgs ;
1540:
1541:
1542: /***************************************************************************
1543: ***** Procedure: NOTIFY_FMC()

Line 1563: FROM xnp_msg_types_b xms, xnp_msgs xmg

1559: l_msg_id NUMBER ;
1560:
1561: CURSOR get_performer_name IS
1562: SELECT NVL(xms.role_name,'FND_RESP535:21704')
1563: FROM xnp_msg_types_b xms, xnp_msgs xmg
1564: WHERE xmg.msg_id = p_msg_id
1565: AND xms.msg_code = xmg.msg_code;
1566:
1567: BEGIN

Line 1876: FROM XNP_MSGS

1872: INTO l_count
1873: FROM DUAL
1874: WHERE EXISTS
1875: (SELECT 1
1876: FROM XNP_MSGS
1877: WHERE msg_code=p_msg_code);
1878:
1879: x_error_code := xnp_errors.g_run_time_data_exists ;
1880: FND_MESSAGE.set_name ('XNP', 'XNP_RUN_TIME_DATA_EXISTS') ;

Line 1922: FROM XNP_MSGS

1918: RETURN ;
1919: END IF;
1920:
1921: SELECT count(*) INTO l_count
1922: FROM XNP_MSGS
1923: WHERE msg_code=p_msg_code;
1924:
1925: IF (l_count <> 0) THEN
1926: x_error_code := xnp_errors.g_run_time_data_exists ;