DBA Data[Home] [Help]

APPS.XNP_EVENT dependencies on XNP_MESSAGE

Line 201: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;

197:
198: l_error_code NUMBER ;
199: l_error_message VARCHAR2(4000) ;
200:
201: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
202:
203: l_msg_text VARCHAR2(32767) ;
204: l_num_apps NUMBER := 0;
205: l_operation VARCHAR2(4000) := NULL ;

Line 247: xnp_message.pop (p_queue_name => p_queue_name,

243:
244: l_error_code := 0 ;
245: l_error_message := NULL ;
246:
247: xnp_message.pop (p_queue_name => p_queue_name,
248: x_msg_header => l_msg_header,
249: x_body_text => l_msg_text,
250: x_error_code => l_error_code,
251: x_error_message => l_error_message,

Line 261: xnp_message.validate ( l_msg_header,

257: DBMS_LOCK.sleep(5) ;
258: RETURN ;
259: END IF ;
260:
261: xnp_message.validate ( l_msg_header,
262: l_msg_text,
263: l_error_code,
264: l_error_message ) ;
265:

Line 288: xnp_message.process ( l_msg_header,

284: SAVEPOINT deliver_msg ;
285:
286: BEGIN
287:
288: xnp_message.process ( l_msg_header,
289: l_msg_text,
290: app.process_reference,
291: l_error_code,
292: l_error_message ) ;

Line 312: xnp_message.update_status(

308: RAISE e_MSG_DELIVERY_ERROR ;
309: END IF ;
310:
311:
312: xnp_message.update_status(
313: p_msg_id=>l_msg_header.message_id,
314: p_status=>'PROCESSED',
315: p_order_id=>l_order_id,
316: p_wi_instance_id=>l_wi_instance_id,

Line 333: xnp_message.update_status(

329: l_error_message) ;
330:
331: l_fnd_message:= fnd_message.get ;
332:
333: xnp_message.update_status(
334: p_msg_id=>l_msg_header.message_id,
335: p_status=>'FAILED',
336: p_error_desc=>l_fnd_message,
337: p_order_id=>l_order_id,

Line 354: xnp_message.update_status(

350: fnd_message.set_token ('ERROR_MESSAGE',
351: l_error_message) ;
352: l_fnd_message := fnd_message.get ;
353:
354: xnp_message.update_status(
355: p_msg_id=>l_msg_header.message_id,
356: p_status=>'FAILED',
357: p_error_desc=>l_fnd_message,
358: p_order_id=>l_order_id,

Line 374: xnp_message.update_statuS(

370: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
371: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
372: l_fnd_message:= FND_MESSAGE.get ;
373:
374: xnp_message.update_statuS(
375: p_msg_id=>l_msg_header.message_id,
376: p_status=>'FAILED',
377: p_error_desc=>l_fnd_message,
378: p_order_id=>l_order_id,

Line 391: xnp_message.default_process( l_msg_header,

387: -- If no apps have registered, execute the default processing logic
388:
389: IF ( l_num_apps = 0 ) THEN
390:
391: xnp_message.default_process( l_msg_header,
392: l_msg_text,
393: l_error_code,
394: l_error_message ) ;
395:

Line 400: xnp_message.update_status(

396: IF ( l_error_code <> 0 ) THEN
397: RAISE e_DEFAULT_PROCESSING_ERROR ;
398: END IF ;
399:
400: xnp_message.update_status(
401: p_msg_id=>l_msg_header.message_id,
402: p_status=>'PROCESSED',
403: p_order_id=>l_order_id,
404: p_wi_instance_id=>l_wi_instance_id,

Line 425: xnp_message.update_status(

421: l_error_message) ;
422: l_fnd_message:= FND_MESSAGE.get ;
423:
424:
425: xnp_message.update_status(
426: p_msg_id=>l_msg_header.message_id,
427: p_status=>'FAILED',
428: p_error_desc=>l_fnd_message,
429: p_order_id=>l_order_id,

Line 445: xnp_message.update_status(

441: fnd_message.set_token ('ERROR_MESSAGE',
442: l_error_message) ;
443: l_fnd_message:= FND_MESSAGE.get ;
444:
445: xnp_message.update_status(
446: p_msg_id=>l_msg_header.message_id,
447: p_status=>'FAILED',
448: p_error_desc=>l_fnd_message,
449: p_order_id=>l_order_id,

Line 466: xnp_message.update_status(

462: fnd_message.set_token ('ERROR_MESSAGE',
463: SQLERRM) ;
464: l_fnd_message:= FND_MESSAGE.get ;
465:
466: xnp_message.update_status(
467: p_msg_id=>l_msg_header.message_id,
468: p_status=>'FAILED',
469: p_error_desc=>l_fnd_message,
470: p_order_id=>l_order_id,

Line 514: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;

510:
511: l_error_code NUMBER ;
512: l_error_message VARCHAR2(4000) ;
513:
514: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
515:
516: l_msg_text VARCHAR2(32767) ;
517: l_num_apps NUMBER := 0;
518: l_operation VARCHAR2(4000) := NULL ;

Line 553: xnp_message.pop (p_queue_name => p_queue_name,

549:
550: l_error_code := 0 ;
551: l_error_message := NULL ;
552:
553: xnp_message.pop (p_queue_name => p_queue_name,
554: x_msg_header => l_msg_header,
555: x_body_text => l_msg_text,
556: x_error_code => l_error_code,
557: x_error_message => l_error_message,

Line 568: xnp_message.validate ( l_msg_header,

564: x_queue_timed_out := 'Y';
565: RETURN ;
566: END IF ;
567:
568: xnp_message.validate ( l_msg_header,
569: l_msg_text,
570: l_error_code,
571: l_error_message ) ;
572:

Line 595: xnp_message.process ( l_msg_header,

591: SAVEPOINT deliver_msg ;
592:
593: BEGIN
594:
595: xnp_message.process ( l_msg_header,
596: l_msg_text,
597: app.process_reference,
598: l_error_code,
599: l_error_message ) ;

Line 619: xnp_message.update_status(

615: RAISE e_MSG_DELIVERY_ERROR ;
616: END IF ;
617:
618:
619: xnp_message.update_status(
620: p_msg_id=>l_msg_header.message_id,
621: p_status=>'PROCESSED',
622: p_order_id=>l_order_id,
623: p_wi_instance_id=>l_wi_instance_id,

Line 640: xnp_message.update_status(

636: l_error_message) ;
637:
638: l_fnd_message:= fnd_message.get ;
639:
640: xnp_message.update_status(
641: p_msg_id=>l_msg_header.message_id,
642: p_status=>'FAILED',
643: p_error_desc=>l_fnd_message,
644: p_order_id=>l_order_id,

Line 661: xnp_message.update_status(

657: fnd_message.set_token ('ERROR_MESSAGE',
658: l_error_message) ;
659: l_fnd_message := fnd_message.get ;
660:
661: xnp_message.update_status(
662: p_msg_id=>l_msg_header.message_id,
663: p_status=>'FAILED',
664: p_error_desc=>l_fnd_message,
665: p_order_id=>l_order_id,

Line 679: xnp_message.update_statuS(

675: fnd_message.set_token ('ERROR_CODE', SQLCODE) ;
676: fnd_message.set_token ('ERROR_MESSAGE', SQLERRM) ;
677: l_fnd_message:= FND_MESSAGE.get ;
678:
679: xnp_message.update_statuS(
680: p_msg_id=>l_msg_header.message_id,
681: p_status=>'FAILED',
682: p_error_desc=>l_fnd_message,
683: p_order_id=>l_order_id,

Line 696: xnp_message.default_process( l_msg_header,

692: -- If no apps have registered, execute the default processing logic
693:
694: IF ( l_num_apps = 0 ) THEN
695:
696: xnp_message.default_process( l_msg_header,
697: l_msg_text,
698: l_error_code,
699: l_error_message ) ;
700:

Line 705: xnp_message.update_status(

701: IF ( l_error_code <> 0 ) THEN
702: RAISE e_DEFAULT_PROCESSING_ERROR ;
703: END IF ;
704:
705: xnp_message.update_status(
706: p_msg_id=>l_msg_header.message_id,
707: p_status=>'PROCESSED',
708: p_order_id=>l_order_id,
709: p_wi_instance_id=>l_wi_instance_id,

Line 730: xnp_message.update_status(

726: l_error_message) ;
727: l_fnd_message:= FND_MESSAGE.get ;
728:
729:
730: xnp_message.update_status(
731: p_msg_id=>l_msg_header.message_id,
732: p_status=>'FAILED',
733: p_error_desc=>l_fnd_message,
734: p_order_id=>l_order_id,

Line 750: xnp_message.update_status(

746: fnd_message.set_token ('ERROR_MESSAGE',
747: l_error_message) ;
748: l_fnd_message:= FND_MESSAGE.get ;
749:
750: xnp_message.update_status(
751: p_msg_id=>l_msg_header.message_id,
752: p_status=>'FAILED',
753: p_error_desc=>l_fnd_message,
754: p_order_id=>l_order_id,

Line 770: xnp_message.update_status(

766: fnd_message.set_token ('ERROR_MESSAGE',
767: SQLERRM) ;
768: l_fnd_message:= FND_MESSAGE.get ;
769:
770: xnp_message.update_status(
771: p_msg_id=>l_msg_header.message_id,
772: p_status=>'FAILED',
773: p_error_desc=>l_fnd_message,
774: p_order_id=>l_order_id,

Line 894: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;

890: -- Should change to CLOB later
891:
892: l_msg_text VARCHAR2(32767) ;
893:
894: l_msg_header XNP_MESSAGE.MSG_HEADER_REC_TYPE ;
895: l_sdp_result_code VARCHAR2(40) := NULL;
896: e_workflow_parameters_invalid EXCEPTION ;
897:
898: BEGIN

Line 920: xnp_message.get(

916: -- adabholk 03/2001
917: -- performance fix
918: -- new get() replaces two get calls
919:
920: xnp_message.get(
921: p_msg_id => p_message_id
922: ,x_msg_header => l_msg_header
923: ,x_msg_text => l_msg_text);
924:

Line 926: -- xnp_message.get_header(p_message_id, l_msg_header) ;

922: ,x_msg_header => l_msg_header
923: ,x_msg_text => l_msg_text);
924:
925: /*
926: -- xnp_message.get_header(p_message_id, l_msg_header) ;
927: --
928: -- xnp_message.get (p_message_id, l_msg_text) ;
929: --
930: */

Line 928: -- xnp_message.get (p_message_id, l_msg_text) ;

924:
925: /*
926: -- xnp_message.get_header(p_message_id, l_msg_header) ;
927: --
928: -- xnp_message.get (p_message_id, l_msg_text) ;
929: --
930: */
931:
932: /* Resume the workflow */

Line 962: xnp_message.update_status(p_message_id,

958: fnd_message.set_token ('MSG_ID', l_msg_header.message_id) ;
959: fnd_message.set_token ('P_REFERENCE', p_process_reference) ;
960: l_fnd_message := FND_MESSAGE.get ;
961:
962: xnp_message.update_status(p_message_id,
963: 'FAILED',
964: l_fnd_message) ;
965:
966: xnp_message.update_status(p_msg_id=>l_msg_header.message_id,

Line 966: xnp_message.update_status(p_msg_id=>l_msg_header.message_id,

962: xnp_message.update_status(p_message_id,
963: 'FAILED',
964: l_fnd_message) ;
965:
966: xnp_message.update_status(p_msg_id=>l_msg_header.message_id,
967: p_status=>'FAILED',
968: p_error_desc=>l_fnd_message) ;
969:
970: x_error_code := xnp_errors.g_invalid_workflow ;

Line 1041: l_msg_header xnp_message.msg_header_rec_type ;

1037: l_wf_type VARCHAR2(256) ;
1038: l_wf_key VARCHAR2(256) ;
1039: l_fnd_message VARCHAR2(4000) := NULL;
1040: l_msg_text VARCHAR2(32767) ;
1041: l_msg_header xnp_message.msg_header_rec_type ;
1042: l_sdp_result_code VARCHAR2(3) := NULL;
1043:
1044: l_result VARCHAR2(200) := NULL;
1045:

Line 1088: xnp_message.update_status(

1084: fnd_message.set_token ('P_REFERENCE',
1085: p_process_reference) ;
1086: l_fnd_message := FND_MESSAGE.get ;
1087:
1088: xnp_message.update_status(
1089: p_msg_id=>l_msg_header.message_id,
1090: p_status=>'FAILED',
1091: p_error_desc=>l_fnd_message);
1092: