985: wf_log_pkg.wf_debug_flag := TRUE;
986:
987:
988:
989: wf_event.AddParameterToList( p_name=>'FORWARD_TO_USERNAME',
990: p_value=>p_user_performer,
991: p_parameterlist=>l_parameterlist);
992:
993:
990: p_value=>p_user_performer,
991: p_parameterlist=>l_parameterlist);
992:
993:
994: wf_event.AddParameterToList( p_name=>'PLANNER',
995: p_value=>p_user_name,
996: p_parameterlist=>l_parameterlist);
997:
998:
995: p_value=>p_user_name,
996: p_parameterlist=>l_parameterlist);
997:
998:
999: wf_event.AddParameterToList( p_name=>'MESSAGE_NAME',
1000: p_value=>p_message_name,
1001: p_parameterlist=>l_parameterlist);
1002:
1003:
1000: p_value=>p_message_name,
1001: p_parameterlist=>l_parameterlist);
1002:
1003:
1004: wf_event.AddParameterToList( p_name=>'EXCEPTION_TYPE',
1005: p_value=>p_exception_type,
1006: p_parameterlist=>l_parameterlist);
1007:
1008:
1005: p_value=>p_exception_type,
1006: p_parameterlist=>l_parameterlist);
1007:
1008:
1009: wf_event.AddParameterToList( p_name=>'EXCEPTION_DESC',
1010: p_value=>p_exception_type_name,
1011: p_parameterlist=>l_parameterlist);
1012:
1013:
1010: p_value=>p_exception_type_name,
1011: p_parameterlist=>l_parameterlist);
1012:
1013:
1014: wf_event.AddParameterToList( p_name=>'COMPANY_ID',
1015: p_value=> p_company_id,
1016: p_parameterlist=>l_parameterlist);
1017:
1018: wf_event.AddParameterToList( p_name=>'COMPANY_NAME',
1014: wf_event.AddParameterToList( p_name=>'COMPANY_ID',
1015: p_value=> p_company_id,
1016: p_parameterlist=>l_parameterlist);
1017:
1018: wf_event.AddParameterToList( p_name=>'COMPANY_NAME',
1019: p_value=> p_company_name,
1020: p_parameterlist=>l_parameterlist);
1021:
1022:
1019: p_value=> p_company_name,
1020: p_parameterlist=>l_parameterlist);
1021:
1022:
1023: wf_event.AddParameterToList( p_name=>'COMPANY_SITE_ID',
1024: p_value=> p_company_site_id,
1025: p_parameterlist=>l_parameterlist);
1026:
1027:
1024: p_value=> p_company_site_id,
1025: p_parameterlist=>l_parameterlist);
1026:
1027:
1028: wf_event.AddParameterToList( p_name=>'COMPANY_SITE_NAME',
1029: p_value=> p_company_site_name,
1030: p_parameterlist=>l_parameterlist);
1031:
1032: wf_event.AddParameterToList( p_name=>'ITEM_ID',
1028: wf_event.AddParameterToList( p_name=>'COMPANY_SITE_NAME',
1029: p_value=> p_company_site_name,
1030: p_parameterlist=>l_parameterlist);
1031:
1032: wf_event.AddParameterToList( p_name=>'ITEM_ID',
1033: p_value=> p_item_id,
1034: p_parameterlist=>l_parameterlist);
1035:
1036:
1033: p_value=> p_item_id,
1034: p_parameterlist=>l_parameterlist);
1035:
1036:
1037: wf_event.AddParameterToList( p_name=>'ITEM_NAME',
1038: p_value=> p_item_name,
1039: p_parameterlist=>l_parameterlist);
1040:
1041: wf_event.AddParameterToList( p_name=>'ITEM_DESC',
1037: wf_event.AddParameterToList( p_name=>'ITEM_NAME',
1038: p_value=> p_item_name,
1039: p_parameterlist=>l_parameterlist);
1040:
1041: wf_event.AddParameterToList( p_name=>'ITEM_DESC',
1042: p_value=> p_item_description,
1043: p_parameterlist=>l_parameterlist);
1044:
1045: wf_event.AddParameterToList( p_name=>'SUPPLIER_ID',
1041: wf_event.AddParameterToList( p_name=>'ITEM_DESC',
1042: p_value=> p_item_description,
1043: p_parameterlist=>l_parameterlist);
1044:
1045: wf_event.AddParameterToList( p_name=>'SUPPLIER_ID',
1046: p_value=> p_supplier_id,
1047: p_parameterlist=>l_parameterlist);
1048:
1049:
1046: p_value=> p_supplier_id,
1047: p_parameterlist=>l_parameterlist);
1048:
1049:
1050: wf_event.AddParameterToList( p_name=>'SUPPLIER_NAME',
1051: p_value=> p_supplier_name,
1052: p_parameterlist=>l_parameterlist);
1053:
1054:
1051: p_value=> p_supplier_name,
1052: p_parameterlist=>l_parameterlist);
1053:
1054:
1055: wf_event.AddParameterToList( p_name=>'SUPPLIER_SITE_ID',
1056: p_value=> p_supplier_site_id,
1057: p_parameterlist=>l_parameterlist);
1058:
1059: wf_event.AddParameterToList( p_name=>'SUPPLIER_SITE_NAME',
1055: wf_event.AddParameterToList( p_name=>'SUPPLIER_SITE_ID',
1056: p_value=> p_supplier_site_id,
1057: p_parameterlist=>l_parameterlist);
1058:
1059: wf_event.AddParameterToList( p_name=>'SUPPLIER_SITE_NAME',
1060: p_value=> p_supplier_site_name,
1061: p_parameterlist=>l_parameterlist);
1062:
1063:
1060: p_value=> p_supplier_site_name,
1061: p_parameterlist=>l_parameterlist);
1062:
1063:
1064: wf_event.AddParameterToList( p_name=>'SUPPLIER_ITEM_NAME',
1065: p_value=> p_supplier_item_name,
1066: p_parameterlist=>l_parameterlist);
1067:
1068: wf_event.AddParameterToList( p_name=>'CUSTOMER_ID',
1064: wf_event.AddParameterToList( p_name=>'SUPPLIER_ITEM_NAME',
1065: p_value=> p_supplier_item_name,
1066: p_parameterlist=>l_parameterlist);
1067:
1068: wf_event.AddParameterToList( p_name=>'CUSTOMER_ID',
1069: p_value=> p_customer_id,
1070: p_parameterlist=>l_parameterlist);
1071:
1072:
1069: p_value=> p_customer_id,
1070: p_parameterlist=>l_parameterlist);
1071:
1072:
1073: wf_event.AddParameterToList( p_name=>'CUSTOMER_NAME',
1074: p_value=> p_customer_name,
1075: p_parameterlist=>l_parameterlist);
1076:
1077:
1074: p_value=> p_customer_name,
1075: p_parameterlist=>l_parameterlist);
1076:
1077:
1078: wf_event.AddParameterToList( p_name=>'CUSTOMER_SITE_ID',
1079: p_value=> p_customer_site_id,
1080: p_parameterlist=>l_parameterlist);
1081:
1082:
1079: p_value=> p_customer_site_id,
1080: p_parameterlist=>l_parameterlist);
1081:
1082:
1083: wf_event.AddParameterToList( p_name=>'CUSTOMER_SITE_NAME',
1084: p_value=> p_customer_site_name,
1085: p_parameterlist=>l_parameterlist);
1086:
1087:
1084: p_value=> p_customer_site_name,
1085: p_parameterlist=>l_parameterlist);
1086:
1087:
1088: wf_event.AddParameterToList( p_name=>'CUSTOMER_ITEM_NAME',
1089: p_value=> p_customer_item_name,
1090: p_parameterlist=>l_parameterlist);
1091:
1092:
1089: p_value=> p_customer_item_name,
1090: p_parameterlist=>l_parameterlist);
1091:
1092:
1093: wf_event.AddParameterToList( p_name=>'QUANTITY',
1094: p_value=> p_quantity,
1095: p_parameterlist=>l_parameterlist);
1096:
1097: wf_event.AddParameterToList( p_name=>'TRANSACTION_ID1',
1093: wf_event.AddParameterToList( p_name=>'QUANTITY',
1094: p_value=> p_quantity,
1095: p_parameterlist=>l_parameterlist);
1096:
1097: wf_event.AddParameterToList( p_name=>'TRANSACTION_ID1',
1098: p_value=> p_transaction_id1,
1099: p_parameterlist=>l_parameterlist);
1100:
1101:
1098: p_value=> p_transaction_id1,
1099: p_parameterlist=>l_parameterlist);
1100:
1101:
1102: wf_event.AddParameterToList( p_name=>'TRANSACTION_ID2',
1103: p_value=> p_transaction_id2,
1104: p_parameterlist=>l_parameterlist);
1105:
1106:
1103: p_value=> p_transaction_id2,
1104: p_parameterlist=>l_parameterlist);
1105:
1106:
1107: wf_event.AddParameterToList( p_name=>'QUANTITY1',
1108: p_value=> p_quantity1,
1109: p_parameterlist=>l_parameterlist);
1110:
1111:
1108: p_value=> p_quantity1,
1109: p_parameterlist=>l_parameterlist);
1110:
1111:
1112: wf_event.AddParameterToList( p_name=>'QUANTITY2',
1113: p_value=> p_quantity2,
1114: p_parameterlist=>l_parameterlist);
1115:
1116:
1113: p_value=> p_quantity2,
1114: p_parameterlist=>l_parameterlist);
1115:
1116:
1117: wf_event.AddParameterToList( p_name=>'THRESHOLD',
1118: p_value=> p_threshold,
1119: p_parameterlist=>l_parameterlist);
1120:
1121:
1118: p_value=> p_threshold,
1119: p_parameterlist=>l_parameterlist);
1120:
1121:
1122: wf_event.AddParameterToList( p_name=>'LEAD_TIME',
1123: p_value=> p_lead_time,
1124: p_parameterlist=>l_parameterlist);
1125:
1126:
1123: p_value=> p_lead_time,
1124: p_parameterlist=>l_parameterlist);
1125:
1126:
1127: wf_event.AddParameterToList( p_name=>'ITEM_MIN_QTY',
1128: p_value=> p_item_min_qty,
1129: p_parameterlist=>l_parameterlist);
1130:
1131: wf_event.AddParameterToList( p_name=>'ITEM_MAX_QTY',
1127: wf_event.AddParameterToList( p_name=>'ITEM_MIN_QTY',
1128: p_value=> p_item_min_qty,
1129: p_parameterlist=>l_parameterlist);
1130:
1131: wf_event.AddParameterToList( p_name=>'ITEM_MAX_QTY',
1132: p_value=> p_item_max_qty,
1133: p_parameterlist=>l_parameterlist);
1134:
1135:
1132: p_value=> p_item_max_qty,
1133: p_parameterlist=>l_parameterlist);
1134:
1135:
1136: wf_event.AddParameterToList( p_name=>'DATE1',
1137: p_value=> to_char(p_date1,wf_core.canonical_date_mask),
1138: p_parameterlist=>l_parameterlist);
1139:
1140:
1137: p_value=> to_char(p_date1,wf_core.canonical_date_mask),
1138: p_parameterlist=>l_parameterlist);
1139:
1140:
1141: wf_event.AddParameterToList( p_name=>'DATE2',
1142: p_value=> to_char(p_date2,wf_core.canonical_date_mask),
1143: p_parameterlist=>l_parameterlist);
1144:
1145:
1142: p_value=> to_char(p_date2,wf_core.canonical_date_mask),
1143: p_parameterlist=>l_parameterlist);
1144:
1145:
1146: wf_event.AddParameterToList( p_name=>'DATE3',
1147: p_value=> to_char(p_date3,wf_core.canonical_date_mask),
1148: p_parameterlist=>l_parameterlist);
1149:
1150: wf_event.AddParameterToList( p_name=>'DATE4',
1146: wf_event.AddParameterToList( p_name=>'DATE3',
1147: p_value=> to_char(p_date3,wf_core.canonical_date_mask),
1148: p_parameterlist=>l_parameterlist);
1149:
1150: wf_event.AddParameterToList( p_name=>'DATE4',
1151: p_value=> to_char(p_date4,wf_core.canonical_date_mask),
1152: p_parameterlist=>l_parameterlist);
1153:
1154:
1151: p_value=> to_char(p_date4,wf_core.canonical_date_mask),
1152: p_parameterlist=>l_parameterlist);
1153:
1154:
1155: wf_event.AddParameterToList( p_name=>'DATE5',
1156: p_value=> to_char(p_date5,wf_core.canonical_date_mask),
1157: p_parameterlist=>l_parameterlist);
1158:
1159: wf_event.AddParameterToList( p_name=>'ORDER_CREATION_DATE1',
1155: wf_event.AddParameterToList( p_name=>'DATE5',
1156: p_value=> to_char(p_date5,wf_core.canonical_date_mask),
1157: p_parameterlist=>l_parameterlist);
1158:
1159: wf_event.AddParameterToList( p_name=>'ORDER_CREATION_DATE1',
1160: p_value=> to_char(p_order_creation_date1,wf_core.canonical_date_mask),
1161: p_parameterlist=>l_parameterlist);
1162:
1163:
1160: p_value=> to_char(p_order_creation_date1,wf_core.canonical_date_mask),
1161: p_parameterlist=>l_parameterlist);
1162:
1163:
1164: wf_event.AddParameterToList( p_name=>'ORDER_CREATION_DATE2',
1165: p_value=> to_char(p_order_creation_date2,wf_core.canonical_date_mask),
1166: p_parameterlist=>l_parameterlist);
1167:
1168: wf_event.AddParameterToList( p_name=>'ORDER_NUMBER',
1164: wf_event.AddParameterToList( p_name=>'ORDER_CREATION_DATE2',
1165: p_value=> to_char(p_order_creation_date2,wf_core.canonical_date_mask),
1166: p_parameterlist=>l_parameterlist);
1167:
1168: wf_event.AddParameterToList( p_name=>'ORDER_NUMBER',
1169: p_value=> p_order_number,
1170: p_parameterlist=>l_parameterlist);
1171:
1172: wf_event.AddParameterToList( p_name=>'RELEASE_NUMBER',
1168: wf_event.AddParameterToList( p_name=>'ORDER_NUMBER',
1169: p_value=> p_order_number,
1170: p_parameterlist=>l_parameterlist);
1171:
1172: wf_event.AddParameterToList( p_name=>'RELEASE_NUMBER',
1173: p_value=> p_release_number,
1174: p_parameterlist=>l_parameterlist);
1175:
1176:
1173: p_value=> p_release_number,
1174: p_parameterlist=>l_parameterlist);
1175:
1176:
1177: wf_event.AddParameterToList( p_name=>'LINE_NUMBER',
1178: p_value=> p_line_number,
1179: p_parameterlist=>l_parameterlist);
1180:
1181:
1178: p_value=> p_line_number,
1179: p_parameterlist=>l_parameterlist);
1180:
1181:
1182: wf_event.AddParameterToList( p_name=>'END_ORDER_NUMBER',
1183: p_value=> p_end_order_number,
1184: p_parameterlist=>l_parameterlist);
1185:
1186:
1184: p_parameterlist=>l_parameterlist);
1185:
1186:
1187:
1188: wf_event.AddParameterToList( p_name=>'END_ORDER_REL_NUMBER',
1189: p_value=> p_end_order_rel_number,
1190: p_parameterlist=>l_parameterlist);
1191:
1192:
1189: p_value=> p_end_order_rel_number,
1190: p_parameterlist=>l_parameterlist);
1191:
1192:
1193: wf_event.AddParameterToList( p_name=>'END_ORDER_LINE_NUMBER',
1194: p_value=> p_end_order_line_number,
1195: p_parameterlist=>l_parameterlist);
1196:
1197: wf_event.AddParameterToList( p_name=>'EXCEPTION_BASIS',
1193: wf_event.AddParameterToList( p_name=>'END_ORDER_LINE_NUMBER',
1194: p_value=> p_end_order_line_number,
1195: p_parameterlist=>l_parameterlist);
1196:
1197: wf_event.AddParameterToList( p_name=>'EXCEPTION_BASIS',
1198: p_value=> p_exception_basis,
1199: p_parameterlist=>l_parameterlist);
1200:
1201: wf_event.raise(p_event_name => l_event_name,
1197: wf_event.AddParameterToList( p_name=>'EXCEPTION_BASIS',
1198: p_value=> p_exception_basis,
1199: p_parameterlist=>l_parameterlist);
1200:
1201: wf_event.raise(p_event_name => l_event_name,
1202: p_event_key => l_xml_event_key,
1203: p_parameters => l_parameterlist
1204: );
1205: