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.FND_FLEX_WORKFLOW_APIS dependencies on FND_FLEX_WORKFLOW

Line 1: PACKAGE BODY fnd_flex_workflow_apis AS

1: PACKAGE BODY fnd_flex_workflow_apis AS
2: /* $Header: AFFFWKAB.pls 120.1.12010000.1 2008/07/25 14:15:00 appldev ship $ */
3:
4: --
5: -- Global variables, initalized in package body init section.

Line 7: g_debug_fnd_flex_workflow_apis BOOLEAN := FALSE;

3:
4: --
5: -- Global variables, initalized in package body init section.
6: --
7: g_debug_fnd_flex_workflow_apis BOOLEAN := FALSE;
8:
9: chr_newline VARCHAR2(8);
10: complete VARCHAR2(30);
11: error VARCHAR2(30);

Line 388: IF (g_debug_fnd_flex_workflow_apis) THEN

384: l_vc2 VARCHAR2(32000) := p_debug || chr_newline;
385: l_line_size NUMBER := 75;
386: l_pos NUMBER;
387: BEGIN
388: IF (g_debug_fnd_flex_workflow_apis) THEN
389: WHILE (Nvl(Length(l_vc2),0) > 0) LOOP
390: l_pos := Instr(l_vc2, chr_newline, 1, 1);
391: IF (l_pos >= l_line_size) THEN
392: l_pos := l_line_size;

Line 406: IF (g_debug_fnd_flex_workflow_apis) THEN

402:
403: PROCEDURE report_wf_error(p_func_name IN VARCHAR2)
404: IS
405: BEGIN
406: IF (g_debug_fnd_flex_workflow_apis) THEN
407: debug('Account Generator failed in ' || p_func_name ||
408: ' with following error.' || chr_newline ||
409: 'ERROR_NAME : ' || wf_core.error_name || chr_newline ||
410: 'ERROR_MESSAGE : ' || wf_core.error_message || chr_newline ||

Line 480: IF (g_debug_fnd_flex_workflow_apis) THEN

476: BEGIN
477: --
478: -- Debug
479: --
480: IF (g_debug_fnd_flex_workflow_apis) THEN
481: debug('START FND_FLEX_WORKFLOW_APIS.SEGMENT_TO_INDEX');
482: debug('APPLICATION_ID = ' || To_char(p_application_id));
483: debug('CODE = ' || p_id_flex_code);
484: debug('NUM = ' || To_char(p_id_flex_num));

Line 481: debug('START FND_FLEX_WORKFLOW_APIS.SEGMENT_TO_INDEX');

477: --
478: -- Debug
479: --
480: IF (g_debug_fnd_flex_workflow_apis) THEN
481: debug('START FND_FLEX_WORKFLOW_APIS.SEGMENT_TO_INDEX');
482: debug('APPLICATION_ID = ' || To_char(p_application_id));
483: debug('CODE = ' || p_id_flex_code);
484: debug('NUM = ' || To_char(p_id_flex_num));
485: debug('SEGMENT IDENTIFIER = ' || p_segment_identifier_type || '/' || p_segment_identifier);

Line 613: IF (g_debug_fnd_flex_workflow_apis) THEN

609: fnd_message.set_token('CODE', p_id_flex_code);
610: RETURN FALSE;
611: END;
612:
613: IF (g_debug_fnd_flex_workflow_apis) THEN
614: debug('SEGMENT NAME/INDEX = ' || l_segment_name || '/' || l_segment_index);
615: END IF;
616:
617: x_segment_index := l_segment_index;

Line 641: IF (g_debug_fnd_flex_workflow_apis) THEN

637: IF (funcmode = 'RUN') THEN
638: --
639: -- Debug
640: --
641: IF (g_debug_fnd_flex_workflow_apis) THEN
642: debug('START FND_FLEX_WORKFLOW_APIS.START_GENERATION');
643: END IF;
644:
645: result := complete_no_result;

Line 642: debug('START FND_FLEX_WORKFLOW_APIS.START_GENERATION');

638: --
639: -- Debug
640: --
641: IF (g_debug_fnd_flex_workflow_apis) THEN
642: debug('START FND_FLEX_WORKFLOW_APIS.START_GENERATION');
643: END IF;
644:
645: result := complete_no_result;
646: RETURN;

Line 659: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'START_PROCESS',

655:
656: END IF;
657: EXCEPTION
658: WHEN OTHERS THEN
659: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'START_PROCESS',
660: itemtype, itemkey, TO_CHAR(actid), funcmode);
661: report_wf_error('FND_FLEX_WORKFLOW_APIS.START_GENERATION');
662: RAISE;
663: END start_generation;

Line 661: report_wf_error('FND_FLEX_WORKFLOW_APIS.START_GENERATION');

657: EXCEPTION
658: WHEN OTHERS THEN
659: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'START_PROCESS',
660: itemtype, itemkey, TO_CHAR(actid), funcmode);
661: report_wf_error('FND_FLEX_WORKFLOW_APIS.START_GENERATION');
662: RAISE;
663: END start_generation;
664:
665: -- ======================================================================

Line 686: l_key_flex fnd_flex_workflow.key_flex_type;

682: actid IN NUMBER,
683: funcmode IN VARCHAR2,
684: result OUT nocopy VARCHAR2)
685: IS
686: l_key_flex fnd_flex_workflow.key_flex_type;
687: l_segment_id_type VARCHAR2(30);
688: l_segment_id VARCHAR2(30);
689: l_segment_index NUMBER;
690: l_segment_value VARCHAR2(240);

Line 697: IF (g_debug_fnd_flex_workflow_apis) THEN

693: IF (funcmode = 'RUN') THEN
694: --
695: -- Debug
696: --
697: IF (g_debug_fnd_flex_workflow_apis) THEN
698: debug('START FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');
699: END IF;
700:
701: --

Line 698: debug('START FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');

694: --
695: -- Debug
696: --
697: IF (g_debug_fnd_flex_workflow_apis) THEN
698: debug('START FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');
699: END IF;
700:
701: --
702: -- Get the key flex.

Line 704: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

700:
701: --
702: -- Get the key flex.
703: --
704: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
705:
706: --
707: -- Get all the function activity attributes
708: --

Line 722: IF (g_debug_fnd_flex_workflow_apis) THEN

718:
719: --
720: -- Debug
721: --
722: IF (g_debug_fnd_flex_workflow_apis) THEN
723: debug('SEGMENT_IDENTIFIER = ' || l_segment_id_type);
724: debug('SEGMENT = ' || l_segment_id);
725: debug('VALUE = ' || l_segment_value);
726: debug('REPLACE_CURRENT_VALUE = ' || bool_to_char(l_replace_value));

Line 754: IF (g_debug_fnd_flex_workflow_apis) THEN

750:
751: --
752: -- Debug
753: --
754: IF (g_debug_fnd_flex_workflow_apis) THEN
755: debug('VALUE ASSIGNED IS ' || l_segment_value);
756: END IF;
757: ELSE
758: --

Line 761: IF (g_debug_fnd_flex_workflow_apis) THEN

757: ELSE
758: --
759: -- Debug
760: --
761: IF (g_debug_fnd_flex_workflow_apis) THEN
762: debug('VALUE NOT ASSIGNED');
763: END IF;
764: END IF;
765:

Line 793: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'ASSIGN_TO_SEGMENT',

789: RETURN;
790:
791: EXCEPTION
792: WHEN OTHERS THEN
793: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'ASSIGN_TO_SEGMENT',
794: itemtype, itemkey, TO_CHAR(actid), funcmode);
795:
796: report_wf_error('FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');
797: RAISE;

Line 796: report_wf_error('FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');

792: WHEN OTHERS THEN
793: wf_core.context('FND_FLEX_WORKFLOW_APIS', 'ASSIGN_TO_SEGMENT',
794: itemtype, itemkey, TO_CHAR(actid), funcmode);
795:
796: report_wf_error('FND_FLEX_WORKFLOW_APIS.ASSIGN_TO_SEGMENT');
797: RAISE;
798: END assign_to_segment;
799:
800: -- ======================================================================

Line 821: l_key_flex fnd_flex_workflow.key_flex_type;

817: actid IN NUMBER,
818: funcmode IN VARCHAR2,
819: result OUT nocopy VARCHAR2)
820: IS
821: l_key_flex fnd_flex_workflow.key_flex_type;
822: l_segment_id_type VARCHAR2(30);
823: l_segment_id VARCHAR2(30);
824: l_segment_index NUMBER;
825: l_ccid NUMBER;

Line 832: IF (g_debug_fnd_flex_workflow_apis) THEN

828: IF (funcmode = 'RUN') THEN
829: --
830: -- Debug
831: --
832: IF (g_debug_fnd_flex_workflow_apis) THEN
833: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');
834: END IF;
835:
836: --

Line 833: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');

829: --
830: -- Debug
831: --
832: IF (g_debug_fnd_flex_workflow_apis) THEN
833: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');
834: END IF;
835:
836: --
837: -- Get the key flex.

Line 839: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

835:
836: --
837: -- Get the key flex.
838: --
839: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
840:
841: --
842: -- Get all the function activity attributes
843: --

Line 856: IF (g_debug_fnd_flex_workflow_apis) THEN

852:
853: --
854: -- Debug
855: --
856: IF (g_debug_fnd_flex_workflow_apis) THEN
857: debug('SEGMENT_IDENTIFIER = ' || l_segment_id_type);
858: debug('SEGMENT = ' || l_segment_id);
859: debug('CCID = ' || TO_CHAR(l_ccid));
860: debug('RETURN_VALUE_ATTRIBUTE = ' || l_result_attr);

Line 894: IF (g_debug_fnd_flex_workflow_apis) THEN

890:
891: --
892: -- Debug
893: --
894: IF (g_debug_fnd_flex_workflow_apis) THEN
895: debug('VALUE ASSIGNED IS ' || idc_segment_value(l_segment_index));
896: END IF;
897:
898: result := complete_no_result;

Line 925: wf_core.context('FND_FLEX_WORKFLOW_APIS',

921: RETURN;
922:
923: EXCEPTION
924: WHEN OTHERS THEN
925: wf_core.context('FND_FLEX_WORKFLOW_APIS',
926: 'GET_VALUE_FROM_COMBINATION', itemtype, itemkey,
927: TO_CHAR(actid), funcmode);
928: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');
929: RAISE;

Line 928: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');

924: WHEN OTHERS THEN
925: wf_core.context('FND_FLEX_WORKFLOW_APIS',
926: 'GET_VALUE_FROM_COMBINATION', itemtype, itemkey,
927: TO_CHAR(actid), funcmode);
928: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION');
929: RAISE;
930: END get_value_from_combination;
931:
932: -- ======================================================================

Line 958: l_key_flex fnd_flex_workflow.key_flex_type;

954: actid IN NUMBER,
955: funcmode IN VARCHAR2,
956: result OUT nocopy VARCHAR2)
957: IS
958: l_key_flex fnd_flex_workflow.key_flex_type;
959: l_source_id_flex_num NUMBER;
960: l_segment_id_type VARCHAR2(30);
961: l_segment_id VARCHAR2(30);
962: l_source_segment_index NUMBER;

Line 970: IF (g_debug_fnd_flex_workflow_apis) THEN

966: IF (funcmode = 'RUN') THEN
967: --
968: -- Debug
969: --
970: IF (g_debug_fnd_flex_workflow_apis) THEN
971: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');
972: END IF;
973:
974: --

Line 971: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');

967: --
968: -- Debug
969: --
970: IF (g_debug_fnd_flex_workflow_apis) THEN
971: debug('START FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');
972: END IF;
973:
974: --
975: -- Get the original key flex.

Line 977: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

973:
974: --
975: -- Get the original key flex.
976: --
977: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
978:
979: --
980: -- Get all the function activity attributes
981: --

Line 996: IF (g_debug_fnd_flex_workflow_apis) THEN

992:
993: --
994: -- Debug
995: --
996: IF (g_debug_fnd_flex_workflow_apis) THEN
997: debug('SOURCE NUM = ' || TO_CHAR(l_source_id_flex_num));
998: debug('SEGMENT_IDENTIFIER = ' || l_segment_id_type);
999: debug('SEGMENT = ' || l_segment_id);
1000: debug('CCID = ' || TO_CHAR(l_ccid));

Line 1035: IF (g_debug_fnd_flex_workflow_apis) THEN

1031:
1032: --
1033: -- Debug
1034: --
1035: IF (g_debug_fnd_flex_workflow_apis) THEN
1036: debug('VALUE ASSIGNED IS ' || idc_segment_value(l_source_segment_index));
1037: END IF;
1038:
1039: result := complete_no_result;

Line 1066: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1062: RETURN;
1063:
1064: EXCEPTION
1065: WHEN OTHERS THEN
1066: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1067: 'GET_VALUE_FROM_COMBINATION2', itemtype, itemkey,
1068: TO_CHAR(actid), funcmode);
1069: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');
1070: RAISE;

Line 1069: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');

1065: WHEN OTHERS THEN
1066: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1067: 'GET_VALUE_FROM_COMBINATION2', itemtype, itemkey,
1068: TO_CHAR(actid), funcmode);
1069: report_wf_error('FND_FLEX_WORKFLOW_APIS.GET_VALUE_FROM_COMBINATION2');
1070: RAISE;
1071: END get_value_from_combination2;
1072:
1073: -- ======================================================================

Line 1090: l_key_flex fnd_flex_workflow.key_flex_type;

1086: actid IN NUMBER,
1087: funcmode IN VARCHAR2,
1088: result OUT nocopy VARCHAR2)
1089: IS
1090: l_key_flex fnd_flex_workflow.key_flex_type;
1091:
1092: l_ccid NUMBER;
1093: l_nsegments NUMBER;
1094: l_replace_value BOOLEAN;

Line 1100: IF (g_debug_fnd_flex_workflow_apis) THEN

1096: IF (funcmode = 'RUN') THEN
1097: --
1098: -- Debug
1099: --
1100: IF (g_debug_fnd_flex_workflow_apis) THEN
1101: debug('START FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');
1102: END IF;
1103:
1104: --

Line 1101: debug('START FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');

1097: --
1098: -- Debug
1099: --
1100: IF (g_debug_fnd_flex_workflow_apis) THEN
1101: debug('START FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');
1102: END IF;
1103:
1104: --
1105: -- Get the key flex.

Line 1107: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

1103:
1104: --
1105: -- Get the key flex.
1106: --
1107: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
1108:
1109: --
1110: -- Get all the function activity attributes
1111: --

Line 1120: IF (g_debug_fnd_flex_workflow_apis) THEN

1116: 'REPLACE_CURRENT_VALUE'));
1117: --
1118: -- Debug
1119: --
1120: IF (g_debug_fnd_flex_workflow_apis) THEN
1121: debug('CCID = ' || TO_CHAR(l_ccid));
1122: debug('REPLACE_CURRENT_VALUE = ' || bool_to_char(l_replace_value));
1123: END IF;
1124:

Line 1150: IF (g_debug_fnd_flex_workflow_apis) THEN

1146: idc_segment_value(i));
1147: --
1148: -- Debug
1149: --
1150: IF (g_debug_fnd_flex_workflow_apis) THEN
1151: debug('VALUE ASSIGNED TO SEGMENT ' || TO_CHAR(i) || ' IS ' ||
1152: idc_segment_value(i));
1153: END IF;
1154: END IF;

Line 1184: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1180: RETURN;
1181:
1182: EXCEPTION
1183: WHEN OTHERS THEN
1184: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1185: 'COPY_FROM_COMBINATION', itemtype, itemkey,
1186: TO_CHAR(actid), funcmode);
1187: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');
1188: RAISE;

Line 1187: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');

1183: WHEN OTHERS THEN
1184: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1185: 'COPY_FROM_COMBINATION', itemtype, itemkey,
1186: TO_CHAR(actid), funcmode);
1187: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_FROM_COMBINATION');
1188: RAISE;
1189: END copy_from_combination;
1190:
1191: -- ======================================================================

Line 1211: l_key_flex fnd_flex_workflow.key_flex_type;

1207: actid IN NUMBER,
1208: funcmode IN VARCHAR2,
1209: result OUT nocopy VARCHAR2)
1210: IS
1211: l_key_flex fnd_flex_workflow.key_flex_type;
1212: l_ccid NUMBER;
1213: l_segment_id_type VARCHAR2(30);
1214: l_segment_id VARCHAR2(30);
1215: l_segment_index NUMBER;

Line 1222: IF (g_debug_fnd_flex_workflow_apis) THEN

1218: IF (funcmode = 'RUN') THEN
1219: --
1220: -- Debug
1221: --
1222: IF (g_debug_fnd_flex_workflow_apis) THEN
1223: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');
1224: END IF;
1225:
1226: --

Line 1223: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');

1219: --
1220: -- Debug
1221: --
1222: IF (g_debug_fnd_flex_workflow_apis) THEN
1223: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');
1224: END IF;
1225:
1226: --
1227: -- Get the key flex.

Line 1229: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

1225:
1226: --
1227: -- Get the key flex.
1228: --
1229: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
1230:
1231: --
1232: -- Get all the function activity attributes
1233: --

Line 1247: IF (g_debug_fnd_flex_workflow_apis) THEN

1243:
1244: --
1245: -- Debug
1246: --
1247: IF (g_debug_fnd_flex_workflow_apis) THEN
1248: debug('SEGMENT_IDENTIFIER = ' || l_segment_id_type);
1249: debug('SEGMENT = ' || l_segment_id);
1250: debug('CCID = ' || TO_CHAR(l_ccid));
1251: debug('REPLACE_CURRENT_VALUE = ' || bool_to_char(l_replace_value));

Line 1290: IF (g_debug_fnd_flex_workflow_apis) THEN

1286: idc_segment_value(l_segment_index));
1287: --
1288: -- Debug
1289: --
1290: IF (g_debug_fnd_flex_workflow_apis) THEN
1291: debug('VALUE ASSIGNED : ' || idc_segment_value(l_segment_index));
1292: END IF;
1293: ELSE
1294: --

Line 1297: IF (g_debug_fnd_flex_workflow_apis) THEN

1293: ELSE
1294: --
1295: -- Debug
1296: --
1297: IF (g_debug_fnd_flex_workflow_apis) THEN
1298: debug('VALUE NOT ASSIGNED');
1299: END IF;
1300: END IF;
1301:

Line 1329: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1325: RETURN;
1326:
1327: EXCEPTION
1328: WHEN OTHERS THEN
1329: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1330: 'COPY_SEGMENT_FROM_COMBINATION', itemtype, itemkey,
1331: TO_CHAR(actid), funcmode);
1332: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');
1333: RAISE;

Line 1332: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');

1328: WHEN OTHERS THEN
1329: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1330: 'COPY_SEGMENT_FROM_COMBINATION', itemtype, itemkey,
1331: TO_CHAR(actid), funcmode);
1332: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION');
1333: RAISE;
1334: END copy_segment_from_combination;
1335:
1336: -- ======================================================================

Line 1362: l_key_flex fnd_flex_workflow.key_flex_type;

1358: actid IN NUMBER,
1359: funcmode IN VARCHAR2,
1360: result OUT nocopy VARCHAR2)
1361: IS
1362: l_key_flex fnd_flex_workflow.key_flex_type;
1363: l_source_id_flex_num NUMBER;
1364: l_destination_id_flex_num NUMBER;
1365: l_ccid NUMBER;
1366: l_segment_id_type VARCHAR2(30);

Line 1376: IF (g_debug_fnd_flex_workflow_apis) THEN

1372: IF (funcmode = 'RUN') THEN
1373: --
1374: -- Debug
1375: --
1376: IF (g_debug_fnd_flex_workflow_apis) THEN
1377: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');
1378: END IF;
1379:
1380: --

Line 1377: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');

1373: --
1374: -- Debug
1375: --
1376: IF (g_debug_fnd_flex_workflow_apis) THEN
1377: debug('START FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');
1378: END IF;
1379:
1380: --
1381: -- Get the original key flex.

Line 1383: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

1379:
1380: --
1381: -- Get the original key flex.
1382: --
1383: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
1384:
1385: --
1386: -- Get all the function activity attributes
1387: --

Line 1405: IF (g_debug_fnd_flex_workflow_apis) THEN

1401:
1402: --
1403: -- Debug
1404: --
1405: IF (g_debug_fnd_flex_workflow_apis) THEN
1406: debug('SOURCE NUM = ' || To_char(l_source_id_flex_num));
1407: debug('DEST NUM = ' || To_char(l_destination_id_flex_num));
1408: debug('SEGMENT_IDENTIFIER = ' || l_segment_id_type);
1409: debug('SEGMENT = ' || l_segment_id);

Line 1462: IF (g_debug_fnd_flex_workflow_apis) THEN

1458: idc_segment_value(l_source_segment_index));
1459: --
1460: -- Debug
1461: --
1462: IF (g_debug_fnd_flex_workflow_apis) THEN
1463: debug('VALUE ASSIGNED : ' || idc_segment_value(l_source_segment_index));
1464: END IF;
1465: ELSE
1466: --

Line 1469: IF (g_debug_fnd_flex_workflow_apis) THEN

1465: ELSE
1466: --
1467: -- Debug
1468: --
1469: IF (g_debug_fnd_flex_workflow_apis) THEN
1470: debug('VALUE NOT ASSIGNED');
1471: END IF;
1472: END IF;
1473:

Line 1501: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1497: RETURN;
1498:
1499: EXCEPTION
1500: WHEN OTHERS THEN
1501: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1502: 'COPY_SEGMENT_FROM_COMBINATION2', itemtype, itemkey,
1503: TO_CHAR(actid), funcmode);
1504: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');
1505: RAISE;

Line 1504: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');

1500: WHEN OTHERS THEN
1501: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1502: 'COPY_SEGMENT_FROM_COMBINATION2', itemtype, itemkey,
1503: TO_CHAR(actid), funcmode);
1504: report_wf_error('FND_FLEX_WORKFLOW_APIS.COPY_SEGMENT_FROM_COMBINATION2');
1505: RAISE;
1506: END copy_segment_from_combination2;
1507:
1508: -- ======================================================================

Line 1528: l_key_flex fnd_flex_workflow.key_flex_type;

1524: actid IN NUMBER,
1525: funcmode IN VARCHAR2,
1526: result OUT nocopy VARCHAR2)
1527: IS
1528: l_key_flex fnd_flex_workflow.key_flex_type;
1529: l_non_required_ok BOOLEAN;
1530: l_segment_index NUMBER;
1531:
1532: CURSOR cur(p_application_id IN NUMBER,

Line 1547: IF (g_debug_fnd_flex_workflow_apis) THEN

1543: IF (funcmode = 'RUN') THEN
1544: --
1545: -- Debug
1546: --
1547: IF (g_debug_fnd_flex_workflow_apis) THEN
1548: debug('START FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');
1549: END IF;
1550:
1551: --

Line 1548: debug('START FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');

1544: --
1545: -- Debug
1546: --
1547: IF (g_debug_fnd_flex_workflow_apis) THEN
1548: debug('START FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');
1549: END IF;
1550:
1551: --
1552: -- Get the key flex.

Line 1554: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

1550:
1551: --
1552: -- Get the key flex.
1553: --
1554: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
1555:
1556: --
1557: -- Get all the function activity attributes
1558: --

Line 1563: IF (g_debug_fnd_flex_workflow_apis) THEN

1559: l_non_required_ok := char_to_bool(wf_engine.GetActivityAttrText
1560: (itemtype, itemkey, actid,
1561: 'CHECK_ONLY_FOR_REQUIRED'));
1562:
1563: IF (g_debug_fnd_flex_workflow_apis) THEN
1564: debug('CHECK_ONLY_FOR_REQUIRED = ' || bool_to_char(l_non_required_ok));
1565: END IF;
1566:
1567: --

Line 1582: IF (g_debug_fnd_flex_workflow_apis) THEN

1578: (NOT l_non_required_ok))) THEN
1579: --
1580: -- Debug
1581: --
1582: IF (g_debug_fnd_flex_workflow_apis) THEN
1583: debug('COMBINATION NOT COMPLETE');
1584: END IF;
1585: result := complete_false;
1586: GOTO return_success;

Line 1593: IF (g_debug_fnd_flex_workflow_apis) THEN

1589:
1590: --
1591: -- Debug
1592: --
1593: IF (g_debug_fnd_flex_workflow_apis) THEN
1594: debug('COMBINATION COMPLETE');
1595: END IF;
1596:
1597: result := complete_true;

Line 1624: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1620: RETURN;
1621:
1622: EXCEPTION
1623: WHEN OTHERS THEN
1624: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1625: 'IS_COMBINATION_COMPLETE', itemtype, itemkey,
1626: TO_CHAR(actid), funcmode);
1627: report_wf_error('FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');
1628: RAISE;

Line 1627: report_wf_error('FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');

1623: WHEN OTHERS THEN
1624: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1625: 'IS_COMBINATION_COMPLETE', itemtype, itemkey,
1626: TO_CHAR(actid), funcmode);
1627: report_wf_error('FND_FLEX_WORKFLOW_APIS.IS_COMBINATION_COMPLETE');
1628: RAISE;
1629: END is_combination_complete;
1630:
1631: -- ======================================================================

Line 1652: l_key_flex fnd_flex_workflow.key_flex_type;

1648: actid IN NUMBER,
1649: funcmode IN VARCHAR2,
1650: result OUT nocopy VARCHAR2)
1651: IS
1652: l_key_flex fnd_flex_workflow.key_flex_type;
1653:
1654: l_insert_if_new BOOLEAN;
1655: l_dinserts_ok BOOLEAN;
1656: l_validation_type VARCHAR2(100);

Line 1673: IF (g_debug_fnd_flex_workflow_apis) THEN

1669: IF (funcmode = 'RUN') THEN
1670: --
1671: -- Debug
1672: --
1673: IF (g_debug_fnd_flex_workflow_apis) THEN
1674: debug('START FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');
1675: END IF;
1676:
1677: --

Line 1674: debug('START FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');

1670: --
1671: -- Debug
1672: --
1673: IF (g_debug_fnd_flex_workflow_apis) THEN
1674: debug('START FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');
1675: END IF;
1676:
1677: --
1678: -- Get the key flex.

Line 1680: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);

1676:
1677: --
1678: -- Get the key flex.
1679: --
1680: fnd_flex_workflow.get_key_flex(itemtype, itemkey, l_key_flex);
1681:
1682: --
1683: -- Get the item attributes
1684: --

Line 1716: IF (g_debug_fnd_flex_workflow_apis) THEN

1712:
1713: --
1714: -- Debug
1715: --
1716: IF (g_debug_fnd_flex_workflow_apis) THEN
1717: debug('INSERT IF NEW COMBINATION = ' || bool_to_char(l_insert_if_new));
1718: debug('DYNAMIC_INSERTS_ALLOWED = ' || bool_to_char(l_dinserts_ok));
1719: debug('VALIDATION_TYPE = ' || l_validation_type);
1720: debug('CHECK EXPIRATION = ' || l_check_expiration);

Line 1735: IF (g_debug_fnd_flex_workflow_apis) THEN

1731: 'FND_FLEX_SEGMENT' || TO_CHAR(i));
1732: --
1733: -- Debug
1734: --
1735: IF (g_debug_fnd_flex_workflow_apis) THEN
1736: debug('FND_FLEX_SEGMENT' || TO_CHAR(i) || ' IS ' ||
1737: l_segment_array(i));
1738: END IF;
1739: END LOOP;

Line 1757: IF (g_debug_fnd_flex_workflow_apis) THEN

1753:
1754: --
1755: -- Debug
1756: --
1757: IF (g_debug_fnd_flex_workflow_apis) THEN
1758: debug('CONCATENATED SEGMENTS TO BE VALIDATED IS ' || l_concat_segs);
1759: END IF;
1760:
1761: --

Line 1795: IF (g_debug_fnd_flex_workflow_apis) THEN

1791: IF (NOT l_keyval_status) THEN
1792: --
1793: -- Debug
1794: --
1795: IF (g_debug_fnd_flex_workflow_apis) THEN
1796: debug('VALIDATION FAILED');
1797: END IF;
1798:
1799: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_STATUS',

Line 1821: IF (g_debug_fnd_flex_workflow_apis) THEN

1817: ELSE
1818: --
1819: -- Debug
1820: --
1821: IF (g_debug_fnd_flex_workflow_apis) THEN
1822: debug('VALIDATION SUCCEEDED');
1823: debug('CCID IS ' || TO_CHAR(ccc_last_record.combination_id));
1824: END IF;
1825:

Line 1873: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1869: RETURN;
1870:
1871: EXCEPTION
1872: WHEN OTHERS THEN
1873: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1874: 'VALIDATE_COMBINATION', itemtype, itemkey,
1875: TO_CHAR(actid), funcmode);
1876: report_wf_error('FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');
1877: RAISE;

Line 1876: report_wf_error('FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');

1872: WHEN OTHERS THEN
1873: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1874: 'VALIDATE_COMBINATION', itemtype, itemkey,
1875: TO_CHAR(actid), funcmode);
1876: report_wf_error('FND_FLEX_WORKFLOW_APIS.VALIDATE_COMBINATION');
1877: RAISE;
1878: END validate_combination;
1879:
1880: -- ======================================================================

Line 1907: IF (g_debug_fnd_flex_workflow_apis) THEN

1903: IF (funcmode = 'RUN') THEN
1904: --
1905: -- Debug
1906: --
1907: IF (g_debug_fnd_flex_workflow_apis) THEN
1908: debug('START FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');
1909: END IF;
1910:
1911: --

Line 1908: debug('START FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');

1904: --
1905: -- Debug
1906: --
1907: IF (g_debug_fnd_flex_workflow_apis) THEN
1908: debug('START FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');
1909: END IF;
1910:
1911: --
1912: -- Get the function activity attribute

Line 1941: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1937: RETURN;
1938:
1939: EXCEPTION
1940: WHEN OTHERS THEN
1941: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1942: 'END_IN_FAILURE', itemtype, itemkey,
1943: TO_CHAR(actid), funcmode);
1944: report_wf_error('FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');
1945: RAISE;

Line 1944: report_wf_error('FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');

1940: WHEN OTHERS THEN
1941: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1942: 'END_IN_FAILURE', itemtype, itemkey,
1943: TO_CHAR(actid), funcmode);
1944: report_wf_error('FND_FLEX_WORKFLOW_APIS.ABORT_GENERATION');
1945: RAISE;
1946: END abort_generation;
1947:
1948: -- ======================================================================

Line 1970: IF (g_debug_fnd_flex_workflow_apis) THEN

1966: IF (funcmode = 'RUN') THEN
1967: --
1968: -- Debug
1969: --
1970: IF (g_debug_fnd_flex_workflow_apis) THEN
1971: debug('START FND_FLEX_WORKFLOW_APIS.END_GENERATION');
1972: END IF;
1973:
1974: result := complete_success;

Line 1971: debug('START FND_FLEX_WORKFLOW_APIS.END_GENERATION');

1967: --
1968: -- Debug
1969: --
1970: IF (g_debug_fnd_flex_workflow_apis) THEN
1971: debug('START FND_FLEX_WORKFLOW_APIS.END_GENERATION');
1972: END IF;
1973:
1974: result := complete_success;
1975: GOTO return_success;

Line 1992: wf_core.context('FND_FLEX_WORKFLOW_APIS',

1988: RETURN;
1989:
1990: EXCEPTION
1991: WHEN OTHERS THEN
1992: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1993: 'END_IN_SUCCESS', itemtype, itemkey,
1994: TO_CHAR(actid), funcmode);
1995: report_wf_error('FND_FLEX_WORKFLOW_APIS.END_GENERATION');
1996: RAISE;

Line 1995: report_wf_error('FND_FLEX_WORKFLOW_APIS.END_GENERATION');

1991: WHEN OTHERS THEN
1992: wf_core.context('FND_FLEX_WORKFLOW_APIS',
1993: 'END_IN_SUCCESS', itemtype, itemkey,
1994: TO_CHAR(actid), funcmode);
1995: report_wf_error('FND_FLEX_WORKFLOW_APIS.END_GENERATION');
1996: RAISE;
1997: END end_generation;
1998:
1999: -- ======================================================================

Line 2007: g_debug_fnd_flex_workflow_apis := TRUE;

2003: BEGIN
2004: execute immediate ('begin dbms' ||
2005: '_output' ||
2006: '.enable(1000000); end;');
2007: g_debug_fnd_flex_workflow_apis := TRUE;
2008: END debug_on;
2009:
2010: --
2011: -- Set the debug mode off

Line 2015: g_debug_fnd_flex_workflow_apis := FALSE;

2011: -- Set the debug mode off
2012: --
2013: PROCEDURE debug_off IS
2014: BEGIN
2015: g_debug_fnd_flex_workflow_apis := FALSE;
2016: END debug_off;
2017:
2018: BEGIN
2019: chr_newline := fnd_global.newline;

Line 2048: END fnd_flex_workflow_apis;

2044: ccc_cache_storage);
2045:
2046: idc_last_record.segment_values := fnd_plsql_cache.cache_varchar2_varray_type();
2047: idc_last_record.segment_values.EXTEND(fnd_plsql_cache.CACHE_MAX_NUMOF_KEYS);
2048: END fnd_flex_workflow_apis;