APPS.CSI_INV_TXN_HOOK_PKG dependencies on FND_MESSAGE

Line 308: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

304:
305: IF (l_error_message is not null) THEN
306: rollback to CSIISUHZ;
307: debug('Failed to publish event CSIISUHZ: ' || l_error_message);
308: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
309: fnd_message.set_token('EVENT','CSIISUHZ');
310: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
311: l_error_message := fnd_message.get;
312: raise HOOK_ERROR;

Line 309: fnd_message.set_token('EVENT','CSIISUHZ');

305: IF (l_error_message is not null) THEN
306: rollback to CSIISUHZ;
307: debug('Failed to publish event CSIISUHZ: ' || l_error_message);
308: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
309: fnd_message.set_token('EVENT','CSIISUHZ');
310: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
311: l_error_message := fnd_message.get;
312: raise HOOK_ERROR;
313: END IF;

Line 310: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

306: rollback to CSIISUHZ;
307: debug('Failed to publish event CSIISUHZ: ' || l_error_message);
308: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
309: fnd_message.set_token('EVENT','CSIISUHZ');
310: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
311: l_error_message := fnd_message.get;
312: raise HOOK_ERROR;
313: END IF;
314: ELSE

Line 311: l_error_message := fnd_message.get;

307: debug('Failed to publish event CSIISUHZ: ' || l_error_message);
308: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
309: fnd_message.set_token('EVENT','CSIISUHZ');
310: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
311: l_error_message := fnd_message.get;
312: raise HOOK_ERROR;
313: END IF;
314: ELSE
315: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 355: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

351:
352: if (l_error_message is not null) then
353: rollback to CSIMSRHZ;
354: debug('Failed to publish event CSIMSRHZ: ' || l_error_message);
355: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
356: fnd_message.set_token('EVENT','CSIMSRHZ');
357: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
358: l_error_message := fnd_message.get;
359: raise HOOK_ERROR;

Line 356: fnd_message.set_token('EVENT','CSIMSRHZ');

352: if (l_error_message is not null) then
353: rollback to CSIMSRHZ;
354: debug('Failed to publish event CSIMSRHZ: ' || l_error_message);
355: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
356: fnd_message.set_token('EVENT','CSIMSRHZ');
357: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
358: l_error_message := fnd_message.get;
359: raise HOOK_ERROR;
360: end if;

Line 357: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

353: rollback to CSIMSRHZ;
354: debug('Failed to publish event CSIMSRHZ: ' || l_error_message);
355: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
356: fnd_message.set_token('EVENT','CSIMSRHZ');
357: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
358: l_error_message := fnd_message.get;
359: raise HOOK_ERROR;
360: end if;
361: ELSE

Line 358: l_error_message := fnd_message.get;

354: debug('Failed to publish event CSIMSRHZ: ' || l_error_message);
355: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
356: fnd_message.set_token('EVENT','CSIMSRHZ');
357: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
358: l_error_message := fnd_message.get;
359: raise HOOK_ERROR;
360: end if;
361: ELSE
362: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 400: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

396:
397: if (l_error_message is not null) then
398: rollback to CSIMSIHZ;
399: debug('Failed to publish event CSIMSIHZ: ' || l_error_message);
400: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
401: fnd_message.set_token('EVENT','CSIMSIHZ');
402: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
403: l_error_message := fnd_message.get;
404: raise HOOK_ERROR;

Line 401: fnd_message.set_token('EVENT','CSIMSIHZ');

397: if (l_error_message is not null) then
398: rollback to CSIMSIHZ;
399: debug('Failed to publish event CSIMSIHZ: ' || l_error_message);
400: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
401: fnd_message.set_token('EVENT','CSIMSIHZ');
402: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
403: l_error_message := fnd_message.get;
404: raise HOOK_ERROR;
405: end if;

Line 402: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

398: rollback to CSIMSIHZ;
399: debug('Failed to publish event CSIMSIHZ: ' || l_error_message);
400: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
401: fnd_message.set_token('EVENT','CSIMSIHZ');
402: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
403: l_error_message := fnd_message.get;
404: raise HOOK_ERROR;
405: end if;
406: ELSE

Line 403: l_error_message := fnd_message.get;

399: debug('Failed to publish event CSIMSIHZ: ' || l_error_message);
400: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
401: fnd_message.set_token('EVENT','CSIMSIHZ');
402: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
403: l_error_message := fnd_message.get;
404: raise HOOK_ERROR;
405: end if;
406: ELSE
407: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 449: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

445:
446: if (l_error_message is not null) then
447: rollback to CSILOSHP;
448: debug('Failed to publish event CSILOSHP: ' || l_error_message);
449: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
450: fnd_message.set_token('EVENT','CSILOSHP');
451: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
452: l_error_message := fnd_message.get;
453: raise HOOK_ERROR;

Line 450: fnd_message.set_token('EVENT','CSILOSHP');

446: if (l_error_message is not null) then
447: rollback to CSILOSHP;
448: debug('Failed to publish event CSILOSHP: ' || l_error_message);
449: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
450: fnd_message.set_token('EVENT','CSILOSHP');
451: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
452: l_error_message := fnd_message.get;
453: raise HOOK_ERROR;
454: end if;

Line 451: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

447: rollback to CSILOSHP;
448: debug('Failed to publish event CSILOSHP: ' || l_error_message);
449: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
450: fnd_message.set_token('EVENT','CSILOSHP');
451: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
452: l_error_message := fnd_message.get;
453: raise HOOK_ERROR;
454: end if;
455: ELSE

Line 452: l_error_message := fnd_message.get;

448: debug('Failed to publish event CSILOSHP: ' || l_error_message);
449: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
450: fnd_message.set_token('EVENT','CSILOSHP');
451: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
452: l_error_message := fnd_message.get;
453: raise HOOK_ERROR;
454: end if;
455: ELSE
456: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||l_log_trx_id);

Line 494: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

490:
491: if (l_error_message is not null) then
492: rollback to CSIISUPT;
493: debug('Failed to publish event CSIISUPT: ' || l_error_message);
494: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
495: fnd_message.set_token('EVENT','CSIISUPT');
496: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
497: l_error_message := fnd_message.get;
498: raise HOOK_ERROR;

Line 495: fnd_message.set_token('EVENT','CSIISUPT');

491: if (l_error_message is not null) then
492: rollback to CSIISUPT;
493: debug('Failed to publish event CSIISUPT: ' || l_error_message);
494: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
495: fnd_message.set_token('EVENT','CSIISUPT');
496: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
497: l_error_message := fnd_message.get;
498: raise HOOK_ERROR;
499: end if;

Line 496: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

492: rollback to CSIISUPT;
493: debug('Failed to publish event CSIISUPT: ' || l_error_message);
494: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
495: fnd_message.set_token('EVENT','CSIISUPT');
496: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
497: l_error_message := fnd_message.get;
498: raise HOOK_ERROR;
499: end if;
500: ELSE

Line 497: l_error_message := fnd_message.get;

493: debug('Failed to publish event CSIISUPT: ' || l_error_message);
494: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
495: fnd_message.set_token('EVENT','CSIISUPT');
496: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
497: l_error_message := fnd_message.get;
498: raise HOOK_ERROR;
499: end if;
500: ELSE
501: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 539: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

535:
536: if (l_error_message is not null) then
537: rollback to CSIMSIPT;
538: debug('Failed to publish event CSIMSIPT: ' || l_error_message);
539: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
540: fnd_message.set_token('EVENT','CSIMSIPT');
541: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
542: l_error_message := fnd_message.get;
543: raise HOOK_ERROR;

Line 540: fnd_message.set_token('EVENT','CSIMSIPT');

536: if (l_error_message is not null) then
537: rollback to CSIMSIPT;
538: debug('Failed to publish event CSIMSIPT: ' || l_error_message);
539: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
540: fnd_message.set_token('EVENT','CSIMSIPT');
541: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
542: l_error_message := fnd_message.get;
543: raise HOOK_ERROR;
544: end if;

Line 541: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

537: rollback to CSIMSIPT;
538: debug('Failed to publish event CSIMSIPT: ' || l_error_message);
539: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
540: fnd_message.set_token('EVENT','CSIMSIPT');
541: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
542: l_error_message := fnd_message.get;
543: raise HOOK_ERROR;
544: end if;
545: ELSE

Line 542: l_error_message := fnd_message.get;

538: debug('Failed to publish event CSIMSIPT: ' || l_error_message);
539: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
540: fnd_message.set_token('EVENT','CSIMSIPT');
541: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
542: l_error_message := fnd_message.get;
543: raise HOOK_ERROR;
544: end if;
545: ELSE
546: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 584: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

580:
581: if (l_error_message is not null) then
582: rollback to CSIMSRPT;
583: debug('Failed to publish event CSIMSRPT: ' || l_error_message);
584: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
585: fnd_message.set_token('EVENT','CSIMSRPT');
586: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
587: l_error_message := fnd_message.get;
588: raise HOOK_ERROR;

Line 585: fnd_message.set_token('EVENT','CSIMSRPT');

581: if (l_error_message is not null) then
582: rollback to CSIMSRPT;
583: debug('Failed to publish event CSIMSRPT: ' || l_error_message);
584: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
585: fnd_message.set_token('EVENT','CSIMSRPT');
586: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
587: l_error_message := fnd_message.get;
588: raise HOOK_ERROR;
589: end if;

Line 586: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

582: rollback to CSIMSRPT;
583: debug('Failed to publish event CSIMSRPT: ' || l_error_message);
584: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
585: fnd_message.set_token('EVENT','CSIMSRPT');
586: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
587: l_error_message := fnd_message.get;
588: raise HOOK_ERROR;
589: end if;
590: ELSE

Line 587: l_error_message := fnd_message.get;

583: debug('Failed to publish event CSIMSRPT: ' || l_error_message);
584: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
585: fnd_message.set_token('EVENT','CSIMSRPT');
586: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
587: l_error_message := fnd_message.get;
588: raise HOOK_ERROR;
589: end if;
590: ELSE
591: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 633: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

629:
630: if (l_error_message is not null) then
631: rollback to CSIOKSHP;
632: debug('Failed to publish event CSIOKSHP: ' || l_error_message);
633: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
634: fnd_message.set_token('EVENT','CSIOKSHP');
635: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
636: l_error_message := fnd_message.get;
637: raise HOOK_ERROR;

Line 634: fnd_message.set_token('EVENT','CSIOKSHP');

630: if (l_error_message is not null) then
631: rollback to CSIOKSHP;
632: debug('Failed to publish event CSIOKSHP: ' || l_error_message);
633: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
634: fnd_message.set_token('EVENT','CSIOKSHP');
635: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
636: l_error_message := fnd_message.get;
637: raise HOOK_ERROR;
638: end if;

Line 635: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

631: rollback to CSIOKSHP;
632: debug('Failed to publish event CSIOKSHP: ' || l_error_message);
633: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
634: fnd_message.set_token('EVENT','CSIOKSHP');
635: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
636: l_error_message := fnd_message.get;
637: raise HOOK_ERROR;
638: end if;
639: ELSE

Line 636: l_error_message := fnd_message.get;

632: debug('Failed to publish event CSIOKSHP: ' || l_error_message);
633: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
634: fnd_message.set_token('EVENT','CSIOKSHP');
635: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
636: l_error_message := fnd_message.get;
637: raise HOOK_ERROR;
638: end if;
639: ELSE
640: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 682: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

678:
679: if (l_error_message is not null) then
680: rollback to CSISOSHP;
681: debug('Failed to publish event CSISOSHP: ' || l_error_message);
682: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
683: fnd_message.set_token('EVENT','CSISOSHP');
684: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
685: l_error_message := fnd_message.get;
686: raise HOOK_ERROR;

Line 683: fnd_message.set_token('EVENT','CSISOSHP');

679: if (l_error_message is not null) then
680: rollback to CSISOSHP;
681: debug('Failed to publish event CSISOSHP: ' || l_error_message);
682: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
683: fnd_message.set_token('EVENT','CSISOSHP');
684: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
685: l_error_message := fnd_message.get;
686: raise HOOK_ERROR;
687: end if;

Line 684: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

680: rollback to CSISOSHP;
681: debug('Failed to publish event CSISOSHP: ' || l_error_message);
682: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
683: fnd_message.set_token('EVENT','CSISOSHP');
684: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
685: l_error_message := fnd_message.get;
686: raise HOOK_ERROR;
687: end if;
688: ELSE

Line 685: l_error_message := fnd_message.get;

681: debug('Failed to publish event CSISOSHP: ' || l_error_message);
682: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
683: fnd_message.set_token('EVENT','CSISOSHP');
684: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
685: l_error_message := fnd_message.get;
686: raise HOOK_ERROR;
687: end if;
688: ELSE
689: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

726:
727: if (l_error_message is not null) then
728: rollback to CSIINTIS;
729: debug('Failed to publish event CSIINTIS: ' || l_error_message);
730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
731: fnd_message.set_token('EVENT','CSIINTIS');
732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
733: l_error_message := fnd_message.get;
734: raise HOOK_ERROR;

Line 731: fnd_message.set_token('EVENT','CSIINTIS');

727: if (l_error_message is not null) then
728: rollback to CSIINTIS;
729: debug('Failed to publish event CSIINTIS: ' || l_error_message);
730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
731: fnd_message.set_token('EVENT','CSIINTIS');
732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
733: l_error_message := fnd_message.get;
734: raise HOOK_ERROR;
735: end if;

Line 732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

728: rollback to CSIINTIS;
729: debug('Failed to publish event CSIINTIS: ' || l_error_message);
730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
731: fnd_message.set_token('EVENT','CSIINTIS');
732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
733: l_error_message := fnd_message.get;
734: raise HOOK_ERROR;
735: end if;
736: ELSE

Line 733: l_error_message := fnd_message.get;

729: debug('Failed to publish event CSIINTIS: ' || l_error_message);
730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
731: fnd_message.set_token('EVENT','CSIINTIS');
732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
733: l_error_message := fnd_message.get;
734: raise HOOK_ERROR;
735: end if;
736: ELSE
737: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 779: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

775:
776: if (l_error_message is not null) then
777: rollback to CSIRMARC;
778: debug('Failed to publish event CSIRMARC: ' || l_error_message);
779: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
780: fnd_message.set_token('EVENT','CSIRMARC');
781: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
782: l_error_message := fnd_message.get;
783: raise HOOK_ERROR;

Line 780: fnd_message.set_token('EVENT','CSIRMARC');

776: if (l_error_message is not null) then
777: rollback to CSIRMARC;
778: debug('Failed to publish event CSIRMARC: ' || l_error_message);
779: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
780: fnd_message.set_token('EVENT','CSIRMARC');
781: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
782: l_error_message := fnd_message.get;
783: raise HOOK_ERROR;
784: end if;

Line 781: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

777: rollback to CSIRMARC;
778: debug('Failed to publish event CSIRMARC: ' || l_error_message);
779: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
780: fnd_message.set_token('EVENT','CSIRMARC');
781: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
782: l_error_message := fnd_message.get;
783: raise HOOK_ERROR;
784: end if;
785: ELSE

Line 782: l_error_message := fnd_message.get;

778: debug('Failed to publish event CSIRMARC: ' || l_error_message);
779: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
780: fnd_message.set_token('EVENT','CSIRMARC');
781: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
782: l_error_message := fnd_message.get;
783: raise HOOK_ERROR;
784: end if;
785: ELSE
786: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 846: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

842:
843: if (l_error_message is not null) then
844: rollback to CSISUBTR;
845: debug('Failed to publish event CSISUBTR: ' || l_error_message);
846: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
847: fnd_message.set_token('EVENT','CSISUBTR');
848: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
849: l_error_message := fnd_message.get;
850: raise HOOK_ERROR;

Line 847: fnd_message.set_token('EVENT','CSISUBTR');

843: if (l_error_message is not null) then
844: rollback to CSISUBTR;
845: debug('Failed to publish event CSISUBTR: ' || l_error_message);
846: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
847: fnd_message.set_token('EVENT','CSISUBTR');
848: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
849: l_error_message := fnd_message.get;
850: raise HOOK_ERROR;
851: end if;

Line 848: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

844: rollback to CSISUBTR;
845: debug('Failed to publish event CSISUBTR: ' || l_error_message);
846: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
847: fnd_message.set_token('EVENT','CSISUBTR');
848: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
849: l_error_message := fnd_message.get;
850: raise HOOK_ERROR;
851: end if;
852: ELSE

Line 849: l_error_message := fnd_message.get;

845: debug('Failed to publish event CSISUBTR: ' || l_error_message);
846: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
847: fnd_message.set_token('EVENT','CSISUBTR');
848: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
849: l_error_message := fnd_message.get;
850: raise HOOK_ERROR;
851: end if;
852: ELSE
853: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 896: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

892:
893: if (l_error_message is not null) then
894: rollback to CSIORGTR;
895: debug('Failed to publish event CSIORGTR: ' || l_error_message);
896: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
897: fnd_message.set_token('EVENT','CSIORGTR');
898: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
899: l_error_message := fnd_message.get;
900: raise HOOK_ERROR;

Line 897: fnd_message.set_token('EVENT','CSIORGTR');

893: if (l_error_message is not null) then
894: rollback to CSIORGTR;
895: debug('Failed to publish event CSIORGTR: ' || l_error_message);
896: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
897: fnd_message.set_token('EVENT','CSIORGTR');
898: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
899: l_error_message := fnd_message.get;
900: raise HOOK_ERROR;
901: end if;

Line 898: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

894: rollback to CSIORGTR;
895: debug('Failed to publish event CSIORGTR: ' || l_error_message);
896: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
897: fnd_message.set_token('EVENT','CSIORGTR');
898: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
899: l_error_message := fnd_message.get;
900: raise HOOK_ERROR;
901: end if;
902: ELSE

Line 899: l_error_message := fnd_message.get;

895: debug('Failed to publish event CSIORGTR: ' || l_error_message);
896: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
897: fnd_message.set_token('EVENT','CSIORGTR');
898: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
899: l_error_message := fnd_message.get;
900: raise HOOK_ERROR;
901: end if;
902: ELSE
903: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 946: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

942:
943: if (l_error_message is not null) then
944: rollback to CSIORGTS;
945: debug('Failed to publish event CSIORGTS: ' || l_error_message);
946: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
947: fnd_message.set_token('EVENT','CSIORGTS');
948: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
949: l_error_message := fnd_message.get;
950: raise HOOK_ERROR;

Line 947: fnd_message.set_token('EVENT','CSIORGTS');

943: if (l_error_message is not null) then
944: rollback to CSIORGTS;
945: debug('Failed to publish event CSIORGTS: ' || l_error_message);
946: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
947: fnd_message.set_token('EVENT','CSIORGTS');
948: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
949: l_error_message := fnd_message.get;
950: raise HOOK_ERROR;
951: end if;

Line 948: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

944: rollback to CSIORGTS;
945: debug('Failed to publish event CSIORGTS: ' || l_error_message);
946: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
947: fnd_message.set_token('EVENT','CSIORGTS');
948: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
949: l_error_message := fnd_message.get;
950: raise HOOK_ERROR;
951: end if;
952: ELSE

Line 949: l_error_message := fnd_message.get;

945: debug('Failed to publish event CSIORGTS: ' || l_error_message);
946: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
947: fnd_message.set_token('EVENT','CSIORGTS');
948: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
949: l_error_message := fnd_message.get;
950: raise HOOK_ERROR;
951: end if;
952: ELSE
953: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 996: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

992:
993: if (l_error_message is not null) then
994: rollback to CSIORGDS;
995: debug('Failed to publish event CSIORGDS: ' || l_error_message);
996: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
997: fnd_message.set_token('EVENT','CSIORGDS');
998: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
999: l_error_message := fnd_message.get;
1000: raise HOOK_ERROR;

Line 997: fnd_message.set_token('EVENT','CSIORGDS');

993: if (l_error_message is not null) then
994: rollback to CSIORGDS;
995: debug('Failed to publish event CSIORGDS: ' || l_error_message);
996: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
997: fnd_message.set_token('EVENT','CSIORGDS');
998: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
999: l_error_message := fnd_message.get;
1000: raise HOOK_ERROR;
1001: end if;

Line 998: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

994: rollback to CSIORGDS;
995: debug('Failed to publish event CSIORGDS: ' || l_error_message);
996: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
997: fnd_message.set_token('EVENT','CSIORGDS');
998: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
999: l_error_message := fnd_message.get;
1000: raise HOOK_ERROR;
1001: end if;
1002: ELSE

Line 999: l_error_message := fnd_message.get;

995: debug('Failed to publish event CSIORGDS: ' || l_error_message);
996: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
997: fnd_message.set_token('EVENT','CSIORGDS');
998: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
999: l_error_message := fnd_message.get;
1000: raise HOOK_ERROR;
1001: end if;
1002: ELSE
1003: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1044: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1040:
1041: if (l_error_message is not null) then
1042: rollback to CSIINTSR;
1043: debug('Failed to publish event CSIINTSR: ' || l_error_message);
1044: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1045: fnd_message.set_token('EVENT','CSIINTSR');
1046: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1047: l_error_message := fnd_message.get;
1048: raise HOOK_ERROR;

Line 1045: fnd_message.set_token('EVENT','CSIINTSR');

1041: if (l_error_message is not null) then
1042: rollback to CSIINTSR;
1043: debug('Failed to publish event CSIINTSR: ' || l_error_message);
1044: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1045: fnd_message.set_token('EVENT','CSIINTSR');
1046: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1047: l_error_message := fnd_message.get;
1048: raise HOOK_ERROR;
1049: end if;

Line 1046: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1042: rollback to CSIINTSR;
1043: debug('Failed to publish event CSIINTSR: ' || l_error_message);
1044: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1045: fnd_message.set_token('EVENT','CSIINTSR');
1046: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1047: l_error_message := fnd_message.get;
1048: raise HOOK_ERROR;
1049: end if;
1050: ELSE

Line 1047: l_error_message := fnd_message.get;

1043: debug('Failed to publish event CSIINTSR: ' || l_error_message);
1044: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1045: fnd_message.set_token('EVENT','CSIINTSR');
1046: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1047: l_error_message := fnd_message.get;
1048: raise HOOK_ERROR;
1049: end if;
1050: ELSE
1051: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1093: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1089:
1090: if (l_error_message is not null) then
1091: rollback to CSIINTSS;
1092: debug('Failed to publish event CSIINTSS: ' || l_error_message);
1093: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1094: fnd_message.set_token('EVENT','CSIINTSS');
1095: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1096: l_error_message := fnd_message.get;
1097: raise HOOK_ERROR;

Line 1094: fnd_message.set_token('EVENT','CSIINTSS');

1090: if (l_error_message is not null) then
1091: rollback to CSIINTSS;
1092: debug('Failed to publish event CSIINTSS: ' || l_error_message);
1093: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1094: fnd_message.set_token('EVENT','CSIINTSS');
1095: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1096: l_error_message := fnd_message.get;
1097: raise HOOK_ERROR;
1098: end if;

Line 1095: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1091: rollback to CSIINTSS;
1092: debug('Failed to publish event CSIINTSS: ' || l_error_message);
1093: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1094: fnd_message.set_token('EVENT','CSIINTSS');
1095: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1096: l_error_message := fnd_message.get;
1097: raise HOOK_ERROR;
1098: end if;
1099: ELSE

Line 1096: l_error_message := fnd_message.get;

1092: debug('Failed to publish event CSIINTSS: ' || l_error_message);
1093: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1094: fnd_message.set_token('EVENT','CSIINTSS');
1095: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1096: l_error_message := fnd_message.get;
1097: raise HOOK_ERROR;
1098: end if;
1099: ELSE
1100: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1143: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1139:
1140: if (l_error_message is not null) then
1141: rollback to CSIINTDS;
1142: debug('Failed to publish event CSIINTDS: ' || l_error_message);
1143: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1144: fnd_message.set_token('EVENT','CSIINTSS');
1145: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1146: l_error_message := fnd_message.get;
1147: raise HOOK_ERROR;

Line 1144: fnd_message.set_token('EVENT','CSIINTSS');

1140: if (l_error_message is not null) then
1141: rollback to CSIINTDS;
1142: debug('Failed to publish event CSIINTDS: ' || l_error_message);
1143: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1144: fnd_message.set_token('EVENT','CSIINTSS');
1145: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1146: l_error_message := fnd_message.get;
1147: raise HOOK_ERROR;
1148: end if;

Line 1145: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1141: rollback to CSIINTDS;
1142: debug('Failed to publish event CSIINTDS: ' || l_error_message);
1143: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1144: fnd_message.set_token('EVENT','CSIINTSS');
1145: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1146: l_error_message := fnd_message.get;
1147: raise HOOK_ERROR;
1148: end if;
1149: ELSE

Line 1146: l_error_message := fnd_message.get;

1142: debug('Failed to publish event CSIINTDS: ' || l_error_message);
1143: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1144: fnd_message.set_token('EVENT','CSIINTSS');
1145: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1146: l_error_message := fnd_message.get;
1147: raise HOOK_ERROR;
1148: end if;
1149: ELSE
1150: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1193: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1189:
1190: if (l_error_message is not null) then
1191: rollback to CSIPOINV;
1192: debug('Failed to publish event CSIPOINV: ' || l_error_message);
1193: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1194: fnd_message.set_token('EVENT','CSIPOINV');
1195: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1196: l_error_message := fnd_message.get;
1197: raise HOOK_ERROR;

Line 1194: fnd_message.set_token('EVENT','CSIPOINV');

1190: if (l_error_message is not null) then
1191: rollback to CSIPOINV;
1192: debug('Failed to publish event CSIPOINV: ' || l_error_message);
1193: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1194: fnd_message.set_token('EVENT','CSIPOINV');
1195: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1196: l_error_message := fnd_message.get;
1197: raise HOOK_ERROR;
1198: end if;

Line 1195: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1191: rollback to CSIPOINV;
1192: debug('Failed to publish event CSIPOINV: ' || l_error_message);
1193: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1194: fnd_message.set_token('EVENT','CSIPOINV');
1195: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1196: l_error_message := fnd_message.get;
1197: raise HOOK_ERROR;
1198: end if;
1199: ELSE

Line 1196: l_error_message := fnd_message.get;

1192: debug('Failed to publish event CSIPOINV: ' || l_error_message);
1193: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1194: fnd_message.set_token('EVENT','CSIPOINV');
1195: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1196: l_error_message := fnd_message.get;
1197: raise HOOK_ERROR;
1198: end if;
1199: ELSE
1200: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1241: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1237:
1238: if (l_error_message is not null) then
1239: rollback to CSICYCNT;
1240: debug('Failed to publish event CSICYCNT: ' || l_error_message);
1241: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1242: fnd_message.set_token('EVENT','CSICYCNT');
1243: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1244: l_error_message := fnd_message.get;
1245: raise HOOK_ERROR;

Line 1242: fnd_message.set_token('EVENT','CSICYCNT');

1238: if (l_error_message is not null) then
1239: rollback to CSICYCNT;
1240: debug('Failed to publish event CSICYCNT: ' || l_error_message);
1241: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1242: fnd_message.set_token('EVENT','CSICYCNT');
1243: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1244: l_error_message := fnd_message.get;
1245: raise HOOK_ERROR;
1246: end if;

Line 1243: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1239: rollback to CSICYCNT;
1240: debug('Failed to publish event CSICYCNT: ' || l_error_message);
1241: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1242: fnd_message.set_token('EVENT','CSICYCNT');
1243: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1244: l_error_message := fnd_message.get;
1245: raise HOOK_ERROR;
1246: end if;
1247: ELSE

Line 1244: l_error_message := fnd_message.get;

1240: debug('Failed to publish event CSICYCNT: ' || l_error_message);
1241: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1242: fnd_message.set_token('EVENT','CSICYCNT');
1243: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1244: l_error_message := fnd_message.get;
1245: raise HOOK_ERROR;
1246: end if;
1247: ELSE
1248: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1289: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1285:
1286: if (l_error_message is not null) then
1287: rollback to CSIPHYIN;
1288: debug('Failed to publish event CSIPHYIN: ' || l_error_message);
1289: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1290: fnd_message.set_token('EVENT','CSIPHYIN');
1291: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1292: l_error_message := fnd_message.get;
1293: raise HOOK_ERROR;

Line 1290: fnd_message.set_token('EVENT','CSIPHYIN');

1286: if (l_error_message is not null) then
1287: rollback to CSIPHYIN;
1288: debug('Failed to publish event CSIPHYIN: ' || l_error_message);
1289: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1290: fnd_message.set_token('EVENT','CSIPHYIN');
1291: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1292: l_error_message := fnd_message.get;
1293: raise HOOK_ERROR;
1294: end if;

Line 1291: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1287: rollback to CSIPHYIN;
1288: debug('Failed to publish event CSIPHYIN: ' || l_error_message);
1289: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1290: fnd_message.set_token('EVENT','CSIPHYIN');
1291: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1292: l_error_message := fnd_message.get;
1293: raise HOOK_ERROR;
1294: end if;
1295:

Line 1292: l_error_message := fnd_message.get;

1288: debug('Failed to publish event CSIPHYIN: ' || l_error_message);
1289: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1290: fnd_message.set_token('EVENT','CSIPHYIN');
1291: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1292: l_error_message := fnd_message.get;
1293: raise HOOK_ERROR;
1294: end if;
1295:
1296: ELSE

Line 1354: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1350:
1351: if (l_error_message is not null) then
1352: rollback to CSIMSRCV;
1353: debug('Failed to publish event CSIMSRCV: ' || l_error_message);
1354: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1355: fnd_message.set_token('EVENT','CSIMSRCV');
1356: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1357: l_error_message := fnd_message.get;
1358: raise HOOK_ERROR;

Line 1355: fnd_message.set_token('EVENT','CSIMSRCV');

1351: if (l_error_message is not null) then
1352: rollback to CSIMSRCV;
1353: debug('Failed to publish event CSIMSRCV: ' || l_error_message);
1354: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1355: fnd_message.set_token('EVENT','CSIMSRCV');
1356: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1357: l_error_message := fnd_message.get;
1358: raise HOOK_ERROR;
1359: end if;

Line 1356: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1352: rollback to CSIMSRCV;
1353: debug('Failed to publish event CSIMSRCV: ' || l_error_message);
1354: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1355: fnd_message.set_token('EVENT','CSIMSRCV');
1356: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1357: l_error_message := fnd_message.get;
1358: raise HOOK_ERROR;
1359: end if;
1360:

Line 1357: l_error_message := fnd_message.get;

1353: debug('Failed to publish event CSIMSRCV: ' || l_error_message);
1354: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1355: fnd_message.set_token('EVENT','CSIMSRCV');
1356: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1357: l_error_message := fnd_message.get;
1358: raise HOOK_ERROR;
1359: end if;
1360:
1361: ELSE

Line 1431: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1427:
1428: if (l_error_message is not null) then
1429: rollback to CSIMSISU;
1430: debug('Failed to publish event CSIMSISU: ' || l_error_message);
1431: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1432: fnd_message.set_token('EVENT','CSIMSISU');
1433: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1434: l_error_message := fnd_message.get;
1435: raise HOOK_ERROR;

Line 1432: fnd_message.set_token('EVENT','CSIMSISU');

1428: if (l_error_message is not null) then
1429: rollback to CSIMSISU;
1430: debug('Failed to publish event CSIMSISU: ' || l_error_message);
1431: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1432: fnd_message.set_token('EVENT','CSIMSISU');
1433: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1434: l_error_message := fnd_message.get;
1435: raise HOOK_ERROR;
1436:

Line 1433: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1429: rollback to CSIMSISU;
1430: debug('Failed to publish event CSIMSISU: ' || l_error_message);
1431: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1432: fnd_message.set_token('EVENT','CSIMSISU');
1433: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1434: l_error_message := fnd_message.get;
1435: raise HOOK_ERROR;
1436:
1437: end if;

Line 1434: l_error_message := fnd_message.get;

1430: debug('Failed to publish event CSIMSISU: ' || l_error_message);
1431: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1432: fnd_message.set_token('EVENT','CSIMSISU');
1433: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1434: l_error_message := fnd_message.get;
1435: raise HOOK_ERROR;
1436:
1437: end if;
1438: ELSE

Line 1486: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1482:
1483: if (l_error_message is not null) then
1484: rollback to CSIWIPBR;
1485: debug('Failed to publish event CSIWIPBR: ' || l_error_message);
1486: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1487: fnd_message.set_token('EVENT','CSIWIPBR');
1488: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1489: l_error_message := fnd_message.get;
1490: raise HOOK_ERROR;

Line 1487: fnd_message.set_token('EVENT','CSIWIPBR');

1483: if (l_error_message is not null) then
1484: rollback to CSIWIPBR;
1485: debug('Failed to publish event CSIWIPBR: ' || l_error_message);
1486: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1487: fnd_message.set_token('EVENT','CSIWIPBR');
1488: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1489: l_error_message := fnd_message.get;
1490: raise HOOK_ERROR;
1491: end if;

Line 1488: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1484: rollback to CSIWIPBR;
1485: debug('Failed to publish event CSIWIPBR: ' || l_error_message);
1486: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1487: fnd_message.set_token('EVENT','CSIWIPBR');
1488: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1489: l_error_message := fnd_message.get;
1490: raise HOOK_ERROR;
1491: end if;
1492: ELSE

Line 1489: l_error_message := fnd_message.get;

1485: debug('Failed to publish event CSIWIPBR: ' || l_error_message);
1486: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1487: fnd_message.set_token('EVENT','CSIWIPBR');
1488: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1489: l_error_message := fnd_message.get;
1490: raise HOOK_ERROR;
1491: end if;
1492: ELSE
1493: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1528: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1524:
1525: if (l_error_message is not null) then
1526: rollback to CSIWIPAR;
1527: debug('Failed to publish event CSIWIPAR: ' || l_error_message);
1528: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1529: fnd_message.set_token('EVENT','CSIWIPAR');
1530: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1531: l_error_message := fnd_message.get;
1532: raise HOOK_ERROR;

Line 1529: fnd_message.set_token('EVENT','CSIWIPAR');

1525: if (l_error_message is not null) then
1526: rollback to CSIWIPAR;
1527: debug('Failed to publish event CSIWIPAR: ' || l_error_message);
1528: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1529: fnd_message.set_token('EVENT','CSIWIPAR');
1530: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1531: l_error_message := fnd_message.get;
1532: raise HOOK_ERROR;
1533: end if;

Line 1530: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1526: rollback to CSIWIPAR;
1527: debug('Failed to publish event CSIWIPAR: ' || l_error_message);
1528: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1529: fnd_message.set_token('EVENT','CSIWIPAR');
1530: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1531: l_error_message := fnd_message.get;
1532: raise HOOK_ERROR;
1533: end if;
1534: ELSE

Line 1531: l_error_message := fnd_message.get;

1527: debug('Failed to publish event CSIWIPAR: ' || l_error_message);
1528: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1529: fnd_message.set_token('EVENT','CSIWIPAR');
1530: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1531: l_error_message := fnd_message.get;
1532: raise HOOK_ERROR;
1533: end if;
1534: ELSE
1535: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1578: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1574:
1575: if (l_error_message is not null) then
1576: rollback to CSIWIPCI;
1577: debug('Failed to publish event CSIWIPCI: ' || l_error_message);
1578: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1579: fnd_message.set_token('EVENT','CSIWIPCI');
1580: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1581: l_error_message := fnd_message.get;
1582: raise HOOK_ERROR;

Line 1579: fnd_message.set_token('EVENT','CSIWIPCI');

1575: if (l_error_message is not null) then
1576: rollback to CSIWIPCI;
1577: debug('Failed to publish event CSIWIPCI: ' || l_error_message);
1578: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1579: fnd_message.set_token('EVENT','CSIWIPCI');
1580: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1581: l_error_message := fnd_message.get;
1582: raise HOOK_ERROR;
1583: end if;

Line 1580: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1576: rollback to CSIWIPCI;
1577: debug('Failed to publish event CSIWIPCI: ' || l_error_message);
1578: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1579: fnd_message.set_token('EVENT','CSIWIPCI');
1580: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1581: l_error_message := fnd_message.get;
1582: raise HOOK_ERROR;
1583: end if;
1584: ELSE

Line 1581: l_error_message := fnd_message.get;

1577: debug('Failed to publish event CSIWIPCI: ' || l_error_message);
1578: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1579: fnd_message.set_token('EVENT','CSIWIPCI');
1580: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1581: l_error_message := fnd_message.get;
1582: raise HOOK_ERROR;
1583: end if;
1584: ELSE
1585: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1627: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1623:
1624: if (l_error_message is not null) then
1625: rollback to CSIWIPNI;
1626: debug('Failed to publish event CSIWIPNI: ' || l_error_message);
1627: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1628: fnd_message.set_token('EVENT','CSIWIPNI');
1629: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1630: l_error_message := fnd_message.get;
1631: raise HOOK_ERROR;

Line 1628: fnd_message.set_token('EVENT','CSIWIPNI');

1624: if (l_error_message is not null) then
1625: rollback to CSIWIPNI;
1626: debug('Failed to publish event CSIWIPNI: ' || l_error_message);
1627: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1628: fnd_message.set_token('EVENT','CSIWIPNI');
1629: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1630: l_error_message := fnd_message.get;
1631: raise HOOK_ERROR;
1632: end if;

Line 1629: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1625: rollback to CSIWIPNI;
1626: debug('Failed to publish event CSIWIPNI: ' || l_error_message);
1627: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1628: fnd_message.set_token('EVENT','CSIWIPNI');
1629: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1630: l_error_message := fnd_message.get;
1631: raise HOOK_ERROR;
1632: end if;
1633: ELSE

Line 1630: l_error_message := fnd_message.get;

1626: debug('Failed to publish event CSIWIPNI: ' || l_error_message);
1627: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1628: fnd_message.set_token('EVENT','CSIWIPNI');
1629: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1630: l_error_message := fnd_message.get;
1631: raise HOOK_ERROR;
1632: end if;
1633: ELSE
1634: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1676: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1672:
1673: if (l_error_message is not null) then
1674: rollback to CSIWIPCR;
1675: debug('Failed to publish event CSIWIPCR: ' || l_error_message);
1676: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1677: fnd_message.set_token('EVENT','CSIWIPCR');
1678: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1679: l_error_message := fnd_message.get;
1680: raise HOOK_ERROR;

Line 1677: fnd_message.set_token('EVENT','CSIWIPCR');

1673: if (l_error_message is not null) then
1674: rollback to CSIWIPCR;
1675: debug('Failed to publish event CSIWIPCR: ' || l_error_message);
1676: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1677: fnd_message.set_token('EVENT','CSIWIPCR');
1678: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1679: l_error_message := fnd_message.get;
1680: raise HOOK_ERROR;
1681: end if;

Line 1678: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1674: rollback to CSIWIPCR;
1675: debug('Failed to publish event CSIWIPCR: ' || l_error_message);
1676: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1677: fnd_message.set_token('EVENT','CSIWIPCR');
1678: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1679: l_error_message := fnd_message.get;
1680: raise HOOK_ERROR;
1681: end if;
1682: ELSE

Line 1679: l_error_message := fnd_message.get;

1675: debug('Failed to publish event CSIWIPCR: ' || l_error_message);
1676: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1677: fnd_message.set_token('EVENT','CSIWIPCR');
1678: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1679: l_error_message := fnd_message.get;
1680: raise HOOK_ERROR;
1681: end if;
1682: ELSE
1683: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1726:
1727: if (l_error_message is not null) then
1728: rollback to CSIWIPBC;
1729: debug('Failed to publish event CSIWIPBC: ' || l_error_message);
1730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1731: fnd_message.set_token('EVENT','CSIWIPBC');
1732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1733: l_error_message := fnd_message.get;
1734: raise HOOK_ERROR;

Line 1731: fnd_message.set_token('EVENT','CSIWIPBC');

1727: if (l_error_message is not null) then
1728: rollback to CSIWIPBC;
1729: debug('Failed to publish event CSIWIPBC: ' || l_error_message);
1730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1731: fnd_message.set_token('EVENT','CSIWIPBC');
1732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1733: l_error_message := fnd_message.get;
1734: raise HOOK_ERROR;
1735: end if;

Line 1732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1728: rollback to CSIWIPBC;
1729: debug('Failed to publish event CSIWIPBC: ' || l_error_message);
1730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1731: fnd_message.set_token('EVENT','CSIWIPBC');
1732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1733: l_error_message := fnd_message.get;
1734: raise HOOK_ERROR;
1735: end if;
1736: ELSE

Line 1733: l_error_message := fnd_message.get;

1729: debug('Failed to publish event CSIWIPBC: ' || l_error_message);
1730: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1731: fnd_message.set_token('EVENT','CSIWIPBC');
1732: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1733: l_error_message := fnd_message.get;
1734: raise HOOK_ERROR;
1735: end if;
1736: ELSE
1737: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1771: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1767:
1768: if (l_error_message is not null) then
1769: rollback to CSIWIPAC;
1770: debug('Failed to publish event CSIWIPAC: ' || l_error_message);
1771: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1772: fnd_message.set_token('EVENT','CSIWIPAC');
1773: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1774: l_error_message := fnd_message.get;
1775: raise HOOK_ERROR;

Line 1772: fnd_message.set_token('EVENT','CSIWIPAC');

1768: if (l_error_message is not null) then
1769: rollback to CSIWIPAC;
1770: debug('Failed to publish event CSIWIPAC: ' || l_error_message);
1771: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1772: fnd_message.set_token('EVENT','CSIWIPAC');
1773: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1774: l_error_message := fnd_message.get;
1775: raise HOOK_ERROR;
1776: end if;

Line 1773: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1769: rollback to CSIWIPAC;
1770: debug('Failed to publish event CSIWIPAC: ' || l_error_message);
1771: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1772: fnd_message.set_token('EVENT','CSIWIPAC');
1773: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1774: l_error_message := fnd_message.get;
1775: raise HOOK_ERROR;
1776: end if;
1777: ELSE

Line 1774: l_error_message := fnd_message.get;

1770: debug('Failed to publish event CSIWIPAC: ' || l_error_message);
1771: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1772: fnd_message.set_token('EVENT','CSIWIPAC');
1773: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1774: l_error_message := fnd_message.get;
1775: raise HOOK_ERROR;
1776: end if;
1777: ELSE
1778: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1822: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');

1818:
1819: if (l_error_message is not null) then
1820: rollback to CSIWIPNR;
1821: debug('Failed to publish event CSIWIPNR: ' || l_error_message);
1822: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1823: fnd_message.set_token('EVENT','CSIWIPNR');
1824: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1825: l_error_message := fnd_message.get;
1826: raise HOOK_ERROR;

Line 1823: fnd_message.set_token('EVENT','CSIWIPNR');

1819: if (l_error_message is not null) then
1820: rollback to CSIWIPNR;
1821: debug('Failed to publish event CSIWIPNR: ' || l_error_message);
1822: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1823: fnd_message.set_token('EVENT','CSIWIPNR');
1824: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1825: l_error_message := fnd_message.get;
1826: raise HOOK_ERROR;
1827: end if;

Line 1824: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1820: rollback to CSIWIPNR;
1821: debug('Failed to publish event CSIWIPNR: ' || l_error_message);
1822: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1823: fnd_message.set_token('EVENT','CSIWIPNR');
1824: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1825: l_error_message := fnd_message.get;
1826: raise HOOK_ERROR;
1827: end if;
1828: ELSE

Line 1825: l_error_message := fnd_message.get;

1821: debug('Failed to publish event CSIWIPNR: ' || l_error_message);
1822: fnd_message.set_name('CSI','CSI_INV_HOOK_EVT_ERR');
1823: fnd_message.set_token('EVENT','CSIWIPNR');
1824: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1825: l_error_message := fnd_message.get;
1826: raise HOOK_ERROR;
1827: end if;
1828: ELSE
1829: debug(' bypassing the SFM queue '||l_source_type||' for transaction_id : '||p_transaction_id);

Line 1854: fnd_message.set_name('CSI','CSI_INV_HOOK_CLIENT_EXT');

1850: );
1851:
1852: if (l_return_status <> l_fnd_success) then
1853: debug('Error occurred in MTL Post Transaction Client Extension: ' || l_error_message);
1854: fnd_message.set_name('CSI','CSI_INV_HOOK_CLIENT_EXT');
1855: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1856: l_error_message := fnd_message.get;
1857: raise HOOK_ERROR;
1858: x_return_status := l_fnd_success;

Line 1855: fnd_message.set_token('ERROR_MESSAGE',l_error_message);

1851:
1852: if (l_return_status <> l_fnd_success) then
1853: debug('Error occurred in MTL Post Transaction Client Extension: ' || l_error_message);
1854: fnd_message.set_name('CSI','CSI_INV_HOOK_CLIENT_EXT');
1855: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1856: l_error_message := fnd_message.get;
1857: raise HOOK_ERROR;
1858: x_return_status := l_fnd_success;
1859: end if;

Line 1856: l_error_message := fnd_message.get;

1852: if (l_return_status <> l_fnd_success) then
1853: debug('Error occurred in MTL Post Transaction Client Extension: ' || l_error_message);
1854: fnd_message.set_name('CSI','CSI_INV_HOOK_CLIENT_EXT');
1855: fnd_message.set_token('ERROR_MESSAGE',l_error_message);
1856: l_error_message := fnd_message.get;
1857: raise HOOK_ERROR;
1858: x_return_status := l_fnd_success;
1859: end if;
1860:

Line 1920: fnd_message.set_name('CSI', 'CSI_INV_POST_TXN_EXCEPTION');

1916: x_return_status := l_fnd_success;
1917:
1918: WHEN OTHERS THEN
1919: x_return_status := l_fnd_success;
1920: fnd_message.set_name('CSI', 'CSI_INV_POST_TXN_EXCEPTION');
1921: fnd_message.set_token('SQL_ERROR', SQLERRM);
1922: l_error_message := fnd_message.get;
1923: debug('Raising OTHERS');
1924: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);

Line 1921: fnd_message.set_token('SQL_ERROR', SQLERRM);

1917:
1918: WHEN OTHERS THEN
1919: x_return_status := l_fnd_success;
1920: fnd_message.set_name('CSI', 'CSI_INV_POST_TXN_EXCEPTION');
1921: fnd_message.set_token('SQL_ERROR', SQLERRM);
1922: l_error_message := fnd_message.get;
1923: debug('Raising OTHERS');
1924: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1925: debug('Error Message: '||l_error_message);

Line 1922: l_error_message := fnd_message.get;

1918: WHEN OTHERS THEN
1919: x_return_status := l_fnd_success;
1920: fnd_message.set_name('CSI', 'CSI_INV_POST_TXN_EXCEPTION');
1921: fnd_message.set_token('SQL_ERROR', SQLERRM);
1922: l_error_message := fnd_message.get;
1923: debug('Raising OTHERS');
1924: debug('You have encountered an error in the CSI_INV_TXN_HOOK_PKG Procedure for Transaction: '||p_transaction_id);
1925: debug('Error Message: '||l_error_message);
1926: