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.CN_SCA_WF_PKG dependencies on WF_CORE

Line 533: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_BATCH_ID'));

529: -- ==============
530:
531: -- 1. p_sca_batch_id
532: IF (p_sca_batch_id = NULL) THEN
533: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_BATCH_ID'));
534: END IF;
535:
536: l_itemKey := p_sca_batch_id || '.' || wf_core.random;
537:

Line 536: l_itemKey := p_sca_batch_id || '.' || wf_core.random;

532: IF (p_sca_batch_id = NULL) THEN
533: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_BATCH_ID'));
534: END IF;
535:
536: l_itemKey := p_sca_batch_id || '.' || wf_core.random;
537:
538: -- 2. p_wf_process
539: IF UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR' THEN
540: wf_core.token('NAME',p_wf_process);

Line 540: wf_core.token('NAME',p_wf_process);

536: l_itemKey := p_sca_batch_id || '.' || wf_core.random;
537:
538: -- 2. p_wf_process
539: IF UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR' THEN
540: wf_core.token('NAME',p_wf_process);
541: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
542: END IF;
543:
544: l_process := p_wf_process;

Line 541: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));

537:
538: -- 2. p_wf_process
539: IF UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR' THEN
540: wf_core.token('NAME',p_wf_process);
541: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
542: END IF;
543:
544: l_process := p_wf_process;
545:

Line 548: wf_core.token('NAME',p_wf_item_type);

544: l_process := p_wf_process;
545:
546: -- 3. p_wf_item_type
547: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
548: wf_core.token('NAME',p_wf_item_type);
549: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
550: END IF;
551:
552: l_itemType := p_wf_item_type;

Line 549: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));

545:
546: -- 3. p_wf_item_type
547: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
548: wf_core.token('NAME',p_wf_item_type);
549: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
550: END IF;
551:
552: l_itemType := p_wf_item_type;
553:

Line 594: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_TRX_SRC'));

590:
591: -- if not found, raise exception
592: EXCEPTION
593: WHEN NO_DATA_FOUND THEN
594: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_TRX_SRC'));
595: END;
596:
597: -- set item attribute
598: wf_engine.setitemattrtext(itemtype => l_itemType,

Line 627: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));

623: server_id => fnd_global.server_id);
624:
625: -- if not found, raise exception
626: IF (l_revFunc = NULL) THEN
627: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));
628: END IF;
629:
630: -- set item attribute
631: wf_engine.setitemattrtext(itemtype => l_itemType,

Line 649: wf_core.context('CN_SCA_WF_PKG',

645: -- End of API body
646:
647: EXCEPTION
648: WHEN OTHERS THEN
649: wf_core.context('CN_SCA_WF_PKG',
650: 'CN_SCA_REV_DIST_PR',
651: l_itemKey);
652: RAISE;
653:

Line 710: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ST_HEADER_ID'));

706: -- ==============
707:
708: -- 1. p_start_header_id
709: IF (p_start_header_id = NULL) THEN
710: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ST_HEADER_ID'));
711: END IF;
712:
713: -- 2. p_end_header_id
714: IF (p_end_header_id = NULL) THEN

Line 715: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_END_HEADER_ID'));

711: END IF;
712:
713: -- 2. p_end_header_id
714: IF (p_end_header_id = NULL) THEN
715: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_END_HEADER_ID'));
716: END IF;
717:
718: -- 3. p_trx_source
719: IF (p_trx_source = NULL) THEN

Line 720: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_TRX_SRC'));

716: END IF;
717:
718: -- 3. p_trx_source
719: IF (p_trx_source = NULL) THEN
720: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_TRX_SRC'));
721: END IF;
722:
723: -- 4. p_wf_process
724: IF (UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR') THEN

Line 725: wf_core.token('NAME',p_wf_process);

721: END IF;
722:
723: -- 4. p_wf_process
724: IF (UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR') THEN
725: wf_core.token('NAME',p_wf_process);
726: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
727: END IF;
728:
729: l_process := p_wf_process;

Line 726: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));

722:
723: -- 4. p_wf_process
724: IF (UPPER(p_wf_process) <> 'CN_SCA_REV_DIST_PR') THEN
725: wf_core.token('NAME',p_wf_process);
726: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
727: END IF;
728:
729: l_process := p_wf_process;
730:

Line 733: wf_core.token('NAME',p_wf_item_type);

729: l_process := p_wf_process;
730:
731: -- 5. p_wf_item_type
732: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
733: wf_core.token('NAME',p_wf_item_type);
734: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
735: END IF;
736:
737: l_itemType := p_wf_item_type;

Line 734: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));

730:
731: -- 5. p_wf_item_type
732: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
733: wf_core.token('NAME',p_wf_item_type);
734: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
735: END IF;
736:
737: l_itemType := p_wf_item_type;
738:

Line 742: wf_core.random;

738:
739: -- Create WF Process
740: -- =================
741: l_itemKey := p_start_header_id || '-' || p_end_header_id || '.' ||
742: wf_core.random;
743:
744: wf_engine.createprocess(itemtype => p_wf_item_type,
745: itemkey => l_itemKey,
746: process => p_wf_process);

Line 808: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));

804: server_id => fnd_global.server_id);
805:
806: -- if not found, raise exception
807: IF (l_revFunc = NULL) THEN
808: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_NO_PROFILE_VAL'));
809: END IF;
810:
811: -- set item attribute
812: wf_engine.setitemattrtext(itemtype => l_itemType,

Line 834: wf_core.context('CN_SCA_WF_PKG',

830: -- End of API body
831:
832: EXCEPTION
833: WHEN OTHERS THEN
834: wf_core.context('CN_SCA_WF_PKG',
835: 'CN_SCA_REV_DIST_PR',
836: l_itemKey);
837: RAISE;
838:

Line 898: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_TRX_SRC'));

894: -- Start/End Date validation is handled by caller
895:
896: -- 1. p_trx_source
897: IF (p_trx_source = NULL) THEN
898: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_TRX_SRC'));
899: END IF;
900:
901: -- 2. p_wf_process
902: IF (UPPER(p_wf_process) <> 'CN_SCA_TRX_LOAD_PR') THEN

Line 903: wf_core.token('NAME',p_wf_process);

899: END IF;
900:
901: -- 2. p_wf_process
902: IF (UPPER(p_wf_process) <> 'CN_SCA_TRX_LOAD_PR') THEN
903: wf_core.token('NAME',p_wf_process);
904: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
905: END IF;
906:
907: l_process := p_wf_process;

Line 904: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));

900:
901: -- 2. p_wf_process
902: IF (UPPER(p_wf_process) <> 'CN_SCA_TRX_LOAD_PR') THEN
903: wf_core.token('NAME',p_wf_process);
904: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_PR_NAME'));
905: END IF;
906:
907: l_process := p_wf_process;
908:

Line 911: wf_core.token('NAME',p_wf_item_type);

907: l_process := p_wf_process;
908:
909: -- 3. p_wf_item_type
910: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
911: wf_core.token('NAME',p_wf_item_type);
912: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
913: END IF;
914:
915: l_itemType := p_wf_item_type;

Line 912: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));

908:
909: -- 3. p_wf_item_type
910: IF UPPER(p_wf_item_type) <> 'CNSCARPR' THEN
911: wf_core.token('NAME',p_wf_item_type);
912: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
913: END IF;
914:
915: l_itemType := p_wf_item_type;
916:

Line 926: wf_core.random;

922: -- Create WF Process
923: -- =================
924: l_itemKey := TO_CHAR(p_start_date,'YYYY/MM/DD') || '-' ||
925: TO_CHAR(p_end_date,'YYYY/MM/DD') || '.' ||
926: wf_core.random;
927:
928: wf_engine.createprocess(itemtype => p_wf_item_type,
929: itemkey => l_itemKey,
930: process => p_wf_process);

Line 987: wf_core.context('CN_SCA_WF_PKG',

983:
984: EXCEPTION
985:
986: WHEN OTHERS THEN
987: wf_core.context('CN_SCA_WF_PKG',
988: 'CN_SCA_TRX_LOAD_PR',
989: l_itemKey);
990: RAISE;
991:

Line 1034: wf_core.token('NAME',itemType);

1030: RETURN;
1031: ELSE
1032: resultOut := wf_engine.eng_error || ':' || wf_engine.eng_null;
1033: -- we do NOT return control to WF, but rather propagate an exception
1034: wf_core.token('NAME',itemType);
1035: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
1036: END IF;
1037: END IF;
1038:

Line 1035: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));

1031: ELSE
1032: resultOut := wf_engine.eng_error || ':' || wf_engine.eng_null;
1033: -- we do NOT return control to WF, but rather propagate an exception
1034: wf_core.token('NAME',itemType);
1035: wf_core.raise(FND_MESSAGE.get_string('CN','CN_SCA_WF_INVLD_ITEM_TYPE'));
1036: END IF;
1037: END IF;
1038:
1039: -- ANY OTHER mode (NOT implemented)

Line 1046: wf_core.context('CN_SCA_WF_PKG',

1042:
1043: EXCEPTION
1044: -- Any other mode but RUN
1045: WHEN OTHERS THEN
1046: wf_core.context('CN_SCA_WF_PKG',
1047: 'CN_SCA_REV_DIST_PR',
1048: 'SELECTOR',
1049: itemType,
1050: itemKey,

Line 1122: wf_core.context('CN_SCA_WF_PKG',

1118: RETURN;
1119:
1120: EXCEPTION
1121: WHEN OTHERS THEN
1122: wf_core.context('CN_SCA_WF_PKG',
1123: 'CN_SCA_REV_DIST_PR',
1124: 'REV_DIST_SELECT',
1125: itemType,
1126: itemKey,

Line 1245: wf_core.context('CN_SCA_WF_PKG',

1241: RETURN;
1242:
1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: wf_core.context('CN_SCA_WF_PKG',
1246: 'CN_SCA_REV_DIST_PR',
1247: 'EVEN_REV_DIST',
1248: itemType,
1249: itemKey,

Line 1369: wf_core.context('CN_SCA_WF_PKG',

1365: RETURN;
1366:
1367: EXCEPTION
1368: WHEN OTHERS THEN
1369: wf_core.context('CN_SCA_WF_PKG',
1370: 'CN_SCA_REV_DIST_PR',
1371: 'WTD_REV_DIST',
1372: itemType,
1373: itemKey,

Line 1449: wf_core.context('CN_SCA_WF_PKG',

1445: RETURN;
1446:
1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: wf_core.context('CN_SCA_WF_PKG',
1450: 'CN_SCA_TRX_LOAD_PR',
1451: 'TRX_LOAD_SELECT',
1452: itemType,
1453: itemKey,

Line 1569: wf_core.context('CN_SCA_WF_PKG',

1565: RETURN;
1566:
1567: EXCEPTION
1568: WHEN OTHERS THEN
1569: wf_core.context('CN_SCA_WF_PKG',
1570: 'CN_SCA_TRX_LOAD_PR',
1571: 'CN_TRX_LOAD',
1572: itemType,
1573: itemKey,