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 WF_ENGINE

Line 709: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

705:
706: --
707: -- Get all the function activity attributes
708: --
709: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
710: 'SEGMENT_IDENTIFIER');
711: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
712: 'SEGMENT');
713: l_segment_value := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 711: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

707: -- Get all the function activity attributes
708: --
709: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
710: 'SEGMENT_IDENTIFIER');
711: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
712: 'SEGMENT');
713: l_segment_value := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
714: 'VALUE');
715: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

Line 713: l_segment_value := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

709: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
710: 'SEGMENT_IDENTIFIER');
711: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
712: 'SEGMENT');
713: l_segment_value := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
714: 'VALUE');
715: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
716: (itemtype, itemkey, actid,
717: 'REPLACE_CURRENT_VALUE'));

Line 715: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

711: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
712: 'SEGMENT');
713: l_segment_value := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
714: 'VALUE');
715: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
716: (itemtype, itemkey, actid,
717: 'REPLACE_CURRENT_VALUE'));
718:
719: --

Line 745: (wf_engine.GetItemAttrText(itemtype, itemkey,

741: -- If the replace flag is true or the current value is NULL then
742: -- replace the current value, else don't touch it.
743: --
744: IF ((l_replace_value) OR
745: (wf_engine.GetItemAttrText(itemtype, itemkey,
746: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index)) IS NULL)) THEN
747: wf_engine.SetItemAttrText(itemtype, itemkey,
748: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index),
749: l_segment_value);

Line 747: wf_engine.SetItemAttrText(itemtype, itemkey,

743: --
744: IF ((l_replace_value) OR
745: (wf_engine.GetItemAttrText(itemtype, itemkey,
746: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index)) IS NULL)) THEN
747: wf_engine.SetItemAttrText(itemtype, itemkey,
748: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index),
749: l_segment_value);
750:
751: --

Line 786: wf_engine.SetItemAttrText(itemtype, itemkey,

782: <>
783: --
784: -- Fatal error abort!
785: --
786: wf_engine.SetItemAttrText(itemtype, itemkey,
787: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
788: result := error || 'ASSIGN_TO_SEGMENT';
789: RETURN;
790:

Line 844: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

840:
841: --
842: -- Get all the function activity attributes
843: --
844: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
845: 'SEGMENT_IDENTIFIER');
846: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
847: 'SEGMENT');
848: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

Line 846: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

842: -- Get all the function activity attributes
843: --
844: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
845: 'SEGMENT_IDENTIFIER');
846: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
847: 'SEGMENT');
848: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
849: 'CODE_COMBINATION_ID');
850: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 848: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

844: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
845: 'SEGMENT_IDENTIFIER');
846: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
847: 'SEGMENT');
848: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
849: 'CODE_COMBINATION_ID');
850: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
851: 'RETURN_VALUE_ATTRIBUTE');
852:

Line 850: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

846: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
847: 'SEGMENT');
848: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
849: 'CODE_COMBINATION_ID');
850: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
851: 'RETURN_VALUE_ATTRIBUTE');
852:
853: --
854: -- Debug

Line 888: wf_engine.SetItemAttrText(itemtype, itemkey, l_result_attr,

884:
885: --
886: -- Return the value that was asked for.
887: --
888: wf_engine.SetItemAttrText(itemtype, itemkey, l_result_attr,
889: idc_segment_value(l_segment_index));
890:
891: --
892: -- Debug

Line 918: wf_engine.SetItemAttrText(itemtype, itemkey,

914: <>
915: --
916: -- Fatal error abort!
917: --
918: wf_engine.SetItemAttrText(itemtype, itemkey,
919: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
920: result := error || 'GET_VALUE_FROM_COMBINATION';
921: RETURN;
922:

Line 982: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

978:
979: --
980: -- Get all the function activity attributes
981: --
982: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
983: 'STRUCTURE_NUMBER');
984: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
985: 'SEGMENT_IDENTIFIER');
986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 984: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

980: -- Get all the function activity attributes
981: --
982: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
983: 'STRUCTURE_NUMBER');
984: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
985: 'SEGMENT_IDENTIFIER');
986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
987: 'SEGMENT');
988: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

Line 986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

982: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
983: 'STRUCTURE_NUMBER');
984: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
985: 'SEGMENT_IDENTIFIER');
986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
987: 'SEGMENT');
988: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
989: 'CODE_COMBINATION_ID');
990: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 988: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

984: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
985: 'SEGMENT_IDENTIFIER');
986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
987: 'SEGMENT');
988: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
989: 'CODE_COMBINATION_ID');
990: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
991: 'RETURN_VALUE_ATTRIBUTE');
992:

Line 990: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

986: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
987: 'SEGMENT');
988: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
989: 'CODE_COMBINATION_ID');
990: l_result_attr := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
991: 'RETURN_VALUE_ATTRIBUTE');
992:
993: --
994: -- Debug

Line 1029: wf_engine.SetItemAttrText(itemtype, itemkey, l_result_attr,

1025:
1026: --
1027: -- Return the value that was asked for.
1028: --
1029: wf_engine.SetItemAttrText(itemtype, itemkey, l_result_attr,
1030: idc_segment_value(l_source_segment_index));
1031:
1032: --
1033: -- Debug

Line 1059: wf_engine.SetItemAttrText(itemtype, itemkey,

1055: <>
1056: --
1057: -- Fatal error abort!
1058: --
1059: wf_engine.SetItemAttrText(itemtype, itemkey,
1060: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1061: result := error || 'GET_VALUE_FROM_COMBINATION2';
1062: RETURN;
1063:

Line 1112: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

1108:
1109: --
1110: -- Get all the function activity attributes
1111: --
1112: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1113: 'CODE_COMBINATION_ID');
1114: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1115: (itemtype, itemkey, actid,
1116: 'REPLACE_CURRENT_VALUE'));

Line 1114: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

1110: -- Get all the function activity attributes
1111: --
1112: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1113: 'CODE_COMBINATION_ID');
1114: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1115: (itemtype, itemkey, actid,
1116: 'REPLACE_CURRENT_VALUE'));
1117: --
1118: -- Debug

Line 1142: (wf_engine.GetItemAttrText(itemtype, itemkey,

1138: --
1139: l_nsegments := idc_segment_count();
1140: FOR i IN 1..l_nsegments LOOP
1141: IF (l_replace_value OR
1142: (wf_engine.GetItemAttrText(itemtype, itemkey,
1143: 'FND_FLEX_SEGMENT' || TO_CHAR(i)) IS NULL)) THEN
1144: wf_engine.SetItemAttrText(itemtype, itemkey,
1145: 'FND_FLEX_SEGMENT' || TO_CHAR(i),
1146: idc_segment_value(i));

Line 1144: wf_engine.SetItemAttrText(itemtype, itemkey,

1140: FOR i IN 1..l_nsegments LOOP
1141: IF (l_replace_value OR
1142: (wf_engine.GetItemAttrText(itemtype, itemkey,
1143: 'FND_FLEX_SEGMENT' || TO_CHAR(i)) IS NULL)) THEN
1144: wf_engine.SetItemAttrText(itemtype, itemkey,
1145: 'FND_FLEX_SEGMENT' || TO_CHAR(i),
1146: idc_segment_value(i));
1147: --
1148: -- Debug

Line 1177: wf_engine.SetItemAttrText(itemtype, itemkey,

1173: <>
1174: --
1175: -- Fatal error abort!
1176: --
1177: wf_engine.SetItemAttrText(itemtype, itemkey,
1178: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1179: result := error || 'COPY_FROM_COMBINATION';
1180: RETURN;
1181:

Line 1234: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

1230:
1231: --
1232: -- Get all the function activity attributes
1233: --
1234: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1235: 'SEGMENT_IDENTIFIER');
1236: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1237: 'SEGMENT');
1238: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

Line 1236: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

1232: -- Get all the function activity attributes
1233: --
1234: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1235: 'SEGMENT_IDENTIFIER');
1236: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1237: 'SEGMENT');
1238: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1239: 'CODE_COMBINATION_ID');
1240: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

Line 1238: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

1234: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1235: 'SEGMENT_IDENTIFIER');
1236: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1237: 'SEGMENT');
1238: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1239: 'CODE_COMBINATION_ID');
1240: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1241: (itemtype, itemkey, actid,
1242: 'REPLACE_CURRENT_VALUE'));

Line 1240: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

1236: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1237: 'SEGMENT');
1238: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1239: 'CODE_COMBINATION_ID');
1240: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1241: (itemtype, itemkey, actid,
1242: 'REPLACE_CURRENT_VALUE'));
1243:
1244: --

Line 1281: (wf_engine.GetItemAttrText(itemtype, itemkey,

1277: -- now assign the required value to the segment
1278: -- attribute after checking the replace segment flag.
1279: --
1280: IF (l_replace_value OR
1281: (wf_engine.GetItemAttrText(itemtype, itemkey,
1282: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index))
1283: IS NULL)) THEN
1284: wf_engine.SetItemAttrText(itemtype, itemkey,
1285: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index),

Line 1284: wf_engine.SetItemAttrText(itemtype, itemkey,

1280: IF (l_replace_value OR
1281: (wf_engine.GetItemAttrText(itemtype, itemkey,
1282: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index))
1283: IS NULL)) THEN
1284: wf_engine.SetItemAttrText(itemtype, itemkey,
1285: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index),
1286: idc_segment_value(l_segment_index));
1287: --
1288: -- Debug

Line 1322: wf_engine.SetItemAttrText(itemtype, itemkey,

1318: <>
1319: --
1320: -- Fatal error abort!
1321: --
1322: wf_engine.SetItemAttrText(itemtype, itemkey,
1323: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1324: result := error || 'COPY_SEGMENT_FROM_COMBINATION';
1325: RETURN;
1326:

Line 1388: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

1384:
1385: --
1386: -- Get all the function activity attributes
1387: --
1388: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1389: 'STRUCTURE_NUMBER');
1390: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1391: 'SEGMENT_IDENTIFIER');
1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

Line 1390: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

1386: -- Get all the function activity attributes
1387: --
1388: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1389: 'STRUCTURE_NUMBER');
1390: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1391: 'SEGMENT_IDENTIFIER');
1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1393: 'SEGMENT');
1394: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

Line 1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

1388: l_source_id_flex_num := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1389: 'STRUCTURE_NUMBER');
1390: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1391: 'SEGMENT_IDENTIFIER');
1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1393: 'SEGMENT');
1394: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1395: 'CODE_COMBINATION_ID');
1396: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

Line 1394: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,

1390: l_segment_id_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1391: 'SEGMENT_IDENTIFIER');
1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1393: 'SEGMENT');
1394: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1395: 'CODE_COMBINATION_ID');
1396: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1397: (itemtype, itemkey, actid,
1398: 'REPLACE_CURRENT_VALUE'));

Line 1396: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText

1392: l_segment_id := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1393: 'SEGMENT');
1394: l_ccid := wf_engine.GetActivityAttrNumber(itemtype, itemkey, actid,
1395: 'CODE_COMBINATION_ID');
1396: l_replace_value := char_to_bool(wf_engine.GetActivityAttrText
1397: (itemtype, itemkey, actid,
1398: 'REPLACE_CURRENT_VALUE'));
1399:
1400: l_destination_id_flex_num := l_key_flex.id_flex_num;

Line 1453: (wf_engine.GetItemAttrText(itemtype, itemkey,

1449: -- Now assign the required value to the destination segment
1450: -- attribute after checking the replace segment flag.
1451: --
1452: IF (l_replace_value OR
1453: (wf_engine.GetItemAttrText(itemtype, itemkey,
1454: 'FND_FLEX_SEGMENT' || TO_CHAR(l_destination_segment_index))
1455: IS NULL)) THEN
1456: wf_engine.SetItemAttrText(itemtype, itemkey,
1457: 'FND_FLEX_SEGMENT' || TO_CHAR(l_destination_segment_index),

Line 1456: wf_engine.SetItemAttrText(itemtype, itemkey,

1452: IF (l_replace_value OR
1453: (wf_engine.GetItemAttrText(itemtype, itemkey,
1454: 'FND_FLEX_SEGMENT' || TO_CHAR(l_destination_segment_index))
1455: IS NULL)) THEN
1456: wf_engine.SetItemAttrText(itemtype, itemkey,
1457: 'FND_FLEX_SEGMENT' || TO_CHAR(l_destination_segment_index),
1458: idc_segment_value(l_source_segment_index));
1459: --
1460: -- Debug

Line 1494: wf_engine.SetItemAttrText(itemtype, itemkey,

1490: <>
1491: --
1492: -- Fatal error abort!
1493: --
1494: wf_engine.SetItemAttrText(itemtype, itemkey,
1495: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1496: result := error || 'COPY_SEGMENT_FROM_COMBINATION2';
1497: RETURN;
1498:

Line 1559: l_non_required_ok := char_to_bool(wf_engine.GetActivityAttrText

1555:
1556: --
1557: -- Get all the function activity attributes
1558: --
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

Line 1575: IF ((wf_engine.GetItemAttrText(itemtype, itemkey,

1571: FOR cur_rec IN cur(l_key_flex.application_id,
1572: l_key_flex.id_flex_code,
1573: l_key_flex.id_flex_num) LOOP
1574: l_segment_index := l_segment_index + 1;
1575: IF ((wf_engine.GetItemAttrText(itemtype, itemkey,
1576: 'FND_FLEX_SEGMENT' || TO_CHAR(l_segment_index)) IS NULL) AND
1577: ((cur_rec.required_flag = 'Y') OR
1578: (NOT l_non_required_ok))) THEN
1579: --

Line 1617: wf_engine.SetItemAttrText(itemtype, itemkey,

1613: <>
1614: --
1615: -- Fatal error abort!
1616: --
1617: wf_engine.SetItemAttrText(itemtype, itemkey,
1618: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1619: result := error || 'IS_COMBINATION_COMPLETE';
1620: RETURN;
1621:

Line 1685: l_insert_if_new := char_to_bool(wf_engine.GetItemAttrText

1681:
1682: --
1683: -- Get the item attributes
1684: --
1685: l_insert_if_new := char_to_bool(wf_engine.GetItemAttrText
1686: (itemtype, itemkey,
1687: 'FND_FLEX_INSERT'));
1688: --
1689: -- Get all the function activity attributes

Line 1691: l_dinserts_ok := char_to_bool(wf_engine.GetActivityAttrText

1687: 'FND_FLEX_INSERT'));
1688: --
1689: -- Get all the function activity attributes
1690: --
1691: l_dinserts_ok := char_to_bool(wf_engine.GetActivityAttrText
1692: (itemtype, itemkey, actid,
1693: 'DYNAMIC_INSERTS_ALLOWED'));
1694: l_validation_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1695: 'VALIDATION_TYPE');

Line 1694: l_validation_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,

1690: --
1691: l_dinserts_ok := char_to_bool(wf_engine.GetActivityAttrText
1692: (itemtype, itemkey, actid,
1693: 'DYNAMIC_INSERTS_ALLOWED'));
1694: l_validation_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1695: 'VALIDATION_TYPE');
1696: l_check_expiration := Nvl(wf_engine.GetActivityAttrText
1697: (itemtype, itemkey, actid,
1698: 'CHECK_EXPIRATION',TRUE), 'Y');

Line 1696: l_check_expiration := Nvl(wf_engine.GetActivityAttrText

1692: (itemtype, itemkey, actid,
1693: 'DYNAMIC_INSERTS_ALLOWED'));
1694: l_validation_type := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,
1695: 'VALIDATION_TYPE');
1696: l_check_expiration := Nvl(wf_engine.GetActivityAttrText
1697: (itemtype, itemkey, actid,
1698: 'CHECK_EXPIRATION',TRUE), 'Y');
1699:
1700: --

Line 1706: l_validation_date := Nvl(wf_engine.GetActivityAttrDate

1702: -- IF check_expiration is turned off then set validation_date
1703: -- to NULL, this will turn off the vdate check in SSV engine.
1704: --
1705: IF (l_check_expiration = 'Y') THEN
1706: l_validation_date := Nvl(wf_engine.GetActivityAttrDate
1707: (itemtype, itemkey, actid,
1708: 'VALIDATION_DATE',TRUE), Sysdate);
1709: ELSE
1710: l_validation_date := NULL;

Line 1730: wf_engine.GetItemAttrText(itemtype, itemkey,

1726: -- Populate the segment array with the segment values
1727: --
1728: FOR i IN 1..l_key_flex.numof_segments LOOP
1729: l_segment_array(i) :=
1730: wf_engine.GetItemAttrText(itemtype, itemkey,
1731: 'FND_FLEX_SEGMENT' || TO_CHAR(i));
1732: --
1733: -- Debug
1734: --

Line 1799: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_STATUS',

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',
1800: 'INVALID');
1801: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_MESSAGE',
1802: ccc_last_record.encoded_error_message);
1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',

Line 1801: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_MESSAGE',

1797: END IF;
1798:
1799: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_STATUS',
1800: 'INVALID');
1801: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_MESSAGE',
1802: ccc_last_record.encoded_error_message);
1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1804: '0');
1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',

Line 1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',

1799: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_STATUS',
1800: 'INVALID');
1801: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_MESSAGE',
1802: ccc_last_record.encoded_error_message);
1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1804: '0');
1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1806: l_concat_segs);
1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',

Line 1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',

1801: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_MESSAGE',
1802: ccc_last_record.encoded_error_message);
1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1804: '0');
1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1806: l_concat_segs);
1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1808: '');
1809: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',

Line 1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',

1803: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1804: '0');
1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1806: l_concat_segs);
1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1808: '');
1809: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1810: '');
1811: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_NEW',

Line 1809: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',

1805: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1806: l_concat_segs);
1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1808: '');
1809: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1810: '');
1811: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_NEW',
1812: 'N');
1813:

Line 1811: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_NEW',

1807: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1808: '');
1809: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1810: '');
1811: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_NEW',
1812: 'N');
1813:
1814: result := complete_no_result;
1815: GOTO return_success;

Line 1826: wf_engine.SetItemAttrText

1822: debug('VALIDATION SUCCEEDED');
1823: debug('CCID IS ' || TO_CHAR(ccc_last_record.combination_id));
1824: END IF;
1825:
1826: wf_engine.SetItemAttrText
1827: (itemtype, itemkey, 'FND_FLEX_STATUS', 'VALID');
1828: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1829: To_char(ccc_last_record.combination_id));
1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',

Line 1828: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',

1824: END IF;
1825:
1826: wf_engine.SetItemAttrText
1827: (itemtype, itemkey, 'FND_FLEX_STATUS', 'VALID');
1828: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1829: To_char(ccc_last_record.combination_id));
1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1831: ccc_last_record.concatenated_values);
1832: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',

Line 1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',

1826: wf_engine.SetItemAttrText
1827: (itemtype, itemkey, 'FND_FLEX_STATUS', 'VALID');
1828: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1829: To_char(ccc_last_record.combination_id));
1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1831: ccc_last_record.concatenated_values);
1832: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1833: ccc_last_record.concatenated_ids);
1834: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',

Line 1832: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',

1828: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_CCID',
1829: To_char(ccc_last_record.combination_id));
1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1831: ccc_last_record.concatenated_values);
1832: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1833: ccc_last_record.concatenated_ids);
1834: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1835: ccc_last_record.concatenated_descriptions);
1836: IF (l_keyval_mode = 'CREATE_COMBINATION' AND

Line 1834: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',

1830: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_SEGMENTS',
1831: ccc_last_record.concatenated_values);
1832: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DATA',
1833: ccc_last_record.concatenated_ids);
1834: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1835: ccc_last_record.concatenated_descriptions);
1836: IF (l_keyval_mode = 'CREATE_COMBINATION' AND
1837: ccc_last_record.new_combination) THEN
1838: wf_engine.SetItemAttrText

Line 1838: wf_engine.SetItemAttrText

1834: wf_engine.SetItemAttrText(itemtype, itemkey, 'FND_FLEX_DESCRIPTIONS',
1835: ccc_last_record.concatenated_descriptions);
1836: IF (l_keyval_mode = 'CREATE_COMBINATION' AND
1837: ccc_last_record.new_combination) THEN
1838: wf_engine.SetItemAttrText
1839: (itemtype, itemkey, 'FND_FLEX_NEW', 'Y');
1840: ELSE
1841: wf_engine.SetItemAttrText
1842: (itemtype, itemkey, 'FND_FLEX_NEW', 'N');

Line 1841: wf_engine.SetItemAttrText

1837: ccc_last_record.new_combination) THEN
1838: wf_engine.SetItemAttrText
1839: (itemtype, itemkey, 'FND_FLEX_NEW', 'Y');
1840: ELSE
1841: wf_engine.SetItemAttrText
1842: (itemtype, itemkey, 'FND_FLEX_NEW', 'N');
1843: END IF;
1844:
1845: result := complete_no_result;

Line 1866: wf_engine.SetItemAttrText(itemtype, itemkey,

1862: <>
1863: --
1864: -- Fatal error abort!
1865: --
1866: wf_engine.SetItemAttrText(itemtype, itemkey,
1867: 'FND_FLEX_MESSAGE', fnd_message.get_encoded);
1868: result := error || 'VALIDATE_COMBINATION';
1869: RETURN;
1870:

Line 1914: l_errmsg := wf_engine.GetActivityAttrText(itemtype, itemkey,

1910:
1911: --
1912: -- Get the function activity attribute
1913: --
1914: l_errmsg := wf_engine.GetActivityAttrText(itemtype, itemkey,
1915: actid, 'ERROR_MESSAGE');
1916:
1917: --
1918: -- Save the error message passed in.

Line 1920: wf_engine.SetItemAttrText(itemtype, itemkey,

1916:
1917: --
1918: -- Save the error message passed in.
1919: --
1920: wf_engine.SetItemAttrText(itemtype, itemkey,
1921: 'FND_FLEX_MESSAGE', l_errmsg);
1922:
1923: result := complete_failure;
1924: GOTO return_success;

Line 2020: complete := wf_engine.eng_completed;

2016: END debug_off;
2017:
2018: BEGIN
2019: chr_newline := fnd_global.newline;
2020: complete := wf_engine.eng_completed;
2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';

Line 2021: error := wf_engine.eng_error || ':';

2017:
2018: BEGIN
2019: chr_newline := fnd_global.newline;
2020: complete := wf_engine.eng_completed;
2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';

Line 2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;

2018: BEGIN
2019: chr_newline := fnd_global.newline;
2020: complete := wf_engine.eng_completed;
2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';

Line 2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;

2019: chr_newline := fnd_global.newline;
2020: complete := wf_engine.eng_completed;
2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';

Line 2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';

2020: complete := wf_engine.eng_completed;
2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';
2028:

Line 2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';

2021: error := wf_engine.eng_error || ':';
2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';
2028:
2029:

Line 2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';

2022: complete_no_result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';
2028:
2029:
2030: fnd_plsql_cache.generic_1to1_init('WKA.UQS',

Line 2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';

2023: complete_error := wf_engine.eng_completed || ':' || wf_engine.eng_error;
2024: complete_true := wf_engine.eng_completed || ':' || 'TRUE';
2025: complete_false := wf_engine.eng_completed || ':' || 'FALSE';
2026: complete_failure := wf_engine.eng_completed || ':' || 'FAILURE';
2027: complete_success := wf_engine.eng_completed || ':' || 'SUCCESS';
2028:
2029:
2030: fnd_plsql_cache.generic_1to1_init('WKA.UQS',
2031: uqs_cache_controller,