DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on WF_EVENT

Line 1038: wf_event.AddParameterToList(p_name => 'REFUND MISC CASH RECEIPT ID',

1034: -- Add Context values to the list
1035: AddParamEnvToList(l_list);
1036:
1037: -- add more parameters to the parameters list
1038: wf_event.AddParameterToList(p_name => 'REFUND MISC CASH RECEIPT ID',
1039: p_value => p_misc_cash_receipt_id,
1040: p_parameterlist => l_list);
1041: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1042: p_value => p_cc_error_code,

Line 1041: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',

1037: -- add more parameters to the parameters list
1038: wf_event.AddParameterToList(p_name => 'REFUND MISC CASH RECEIPT ID',
1039: p_value => p_misc_cash_receipt_id,
1040: p_parameterlist => l_list);
1041: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1042: p_value => p_cc_error_code,
1043: p_parameterlist => l_list);
1044: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1045: p_value => p_cc_error_desc,

Line 1044: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',

1040: p_parameterlist => l_list);
1041: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1042: p_value => p_cc_error_code,
1043: p_parameterlist => l_list);
1044: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1045: p_value => p_cc_error_desc,
1046: p_parameterlist => l_list);
1047: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1048: p_value => p_cc_trx_number,

Line 1047: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',

1043: p_parameterlist => l_list);
1044: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1045: p_value => p_cc_error_desc,
1046: p_parameterlist => l_list);
1047: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1048: p_value => p_cc_trx_number,
1049: p_parameterlist => l_list);
1050: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1051: p_value => p_cc_trx_currency,

Line 1050: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',

1046: p_parameterlist => l_list);
1047: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1048: p_value => p_cc_trx_number,
1049: p_parameterlist => l_list);
1050: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1051: p_value => p_cc_trx_currency,
1052: p_parameterlist => l_list);
1053: wf_event.AddParameterToList(p_name => 'AMOUNT',
1054: p_value => p_cc_trx_amount,

Line 1053: wf_event.AddParameterToList(p_name => 'AMOUNT',

1049: p_parameterlist => l_list);
1050: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1051: p_value => p_cc_trx_currency,
1052: p_parameterlist => l_list);
1053: wf_event.AddParameterToList(p_name => 'AMOUNT',
1054: p_value => p_cc_trx_amount,
1055: p_parameterlist => l_list);
1056: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1057: p_value => p_cc_trx_date,

Line 1056: wf_event.AddParameterToList(p_name => 'REFUND DATE',

1052: p_parameterlist => l_list);
1053: wf_event.AddParameterToList(p_name => 'AMOUNT',
1054: p_value => p_cc_trx_amount,
1055: p_parameterlist => l_list);
1056: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1057: p_value => p_cc_trx_date,
1058: p_parameterlist => l_list);
1059: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1060: p_value => p_customer_name,

Line 1059: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',

1055: p_parameterlist => l_list);
1056: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1057: p_value => p_cc_trx_date,
1058: p_parameterlist => l_list);
1059: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1060: p_value => p_customer_name,
1061: p_parameterlist => l_list);
1062: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1063: p_value => p_customer_number,

Line 1062: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',

1058: p_parameterlist => l_list);
1059: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1060: p_value => p_customer_name,
1061: p_parameterlist => l_list);
1062: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1063: p_value => p_customer_number,
1064: p_parameterlist => l_list);
1065: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1066: p_value => p_customer_location,

Line 1065: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',

1061: p_parameterlist => l_list);
1062: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1063: p_value => p_customer_number,
1064: p_parameterlist => l_list);
1065: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1066: p_value => p_customer_location,
1067: p_parameterlist => l_list);
1068: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1069: p_value => p_cc_number,

Line 1068: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',

1064: p_parameterlist => l_list);
1065: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1066: p_value => p_customer_location,
1067: p_parameterlist => l_list);
1068: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1069: p_value => p_cc_number,
1070: p_parameterlist => l_list);
1071: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1072: p_value => p_approval_code,

Line 1071: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',

1067: p_parameterlist => l_list);
1068: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1069: p_value => p_cc_number,
1070: p_parameterlist => l_list);
1071: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1072: p_value => p_approval_code,
1073: p_parameterlist => l_list);
1074: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1075: p_value => p_payment_server_id,

Line 1074: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',

1070: p_parameterlist => l_list);
1071: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1072: p_value => p_approval_code,
1073: p_parameterlist => l_list);
1074: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1075: p_value => p_payment_server_id,
1076: p_parameterlist => l_list);
1077: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1078: p_value => p_collector,

Line 1077: wf_event.AddParameterToList(p_name => 'COLLECTOR',

1073: p_parameterlist => l_list);
1074: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1075: p_value => p_payment_server_id,
1076: p_parameterlist => l_list);
1077: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1078: p_value => p_collector,
1079: p_parameterlist => l_list);
1080: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1081: p_value => p_payment_method_name,

Line 1080: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',

1076: p_parameterlist => l_list);
1077: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1078: p_value => p_collector,
1079: p_parameterlist => l_list);
1080: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1081: p_value => p_payment_method_name,
1082: p_parameterlist => l_list);
1083: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1084: p_value => p_source_receipt_id,

Line 1083: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',

1079: p_parameterlist => l_list);
1080: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1081: p_value => p_payment_method_name,
1082: p_parameterlist => l_list);
1083: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1084: p_value => p_source_receipt_id,
1085: p_parameterlist => l_list);
1086: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1087: p_value => p_source_receipt_num,

Line 1086: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',

1082: p_parameterlist => l_list);
1083: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1084: p_value => p_source_receipt_id,
1085: p_parameterlist => l_list);
1086: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1087: p_value => p_source_receipt_num,
1088: p_parameterlist => l_list);
1089: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1090: p_value => p_error_notes,

Line 1089: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',

1085: p_parameterlist => l_list);
1086: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1087: p_value => p_source_receipt_num,
1088: p_parameterlist => l_list);
1089: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1090: p_value => p_error_notes,
1091: p_parameterlist => l_list);
1092: -- Raise Event
1093: raise_event(

Line 1202: wf_event.AddParameterToList(p_name => 'CREDIT CARD TRANSACTION ID',

1198: -- Add Context values to the list
1199: AddParamEnvToList(l_list);
1200:
1201: -- add more parameters to the parameters list
1202: wf_event.AddParameterToList(p_name => 'CREDIT CARD TRANSACTION ID',
1203: p_value => p_cc_trx_id,
1204: p_parameterlist => l_list);
1205: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1206: p_value => p_cc_error_code,

Line 1205: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',

1201: -- add more parameters to the parameters list
1202: wf_event.AddParameterToList(p_name => 'CREDIT CARD TRANSACTION ID',
1203: p_value => p_cc_trx_id,
1204: p_parameterlist => l_list);
1205: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1206: p_value => p_cc_error_code,
1207: p_parameterlist => l_list);
1208: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1209: p_value => p_cc_error_desc,

Line 1208: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',

1204: p_parameterlist => l_list);
1205: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1206: p_value => p_cc_error_code,
1207: p_parameterlist => l_list);
1208: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1209: p_value => p_cc_error_desc,
1210: p_parameterlist => l_list);
1211: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1212: p_value => p_cc_trx_category_dsp,

Line 1211: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',

1207: p_parameterlist => l_list);
1208: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1209: p_value => p_cc_error_desc,
1210: p_parameterlist => l_list);
1211: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1212: p_value => p_cc_trx_category_dsp,
1213: p_parameterlist => l_list);
1214: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1215: p_value => p_cc_trx_number,

Line 1214: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',

1210: p_parameterlist => l_list);
1211: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1212: p_value => p_cc_trx_category_dsp,
1213: p_parameterlist => l_list);
1214: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1215: p_value => p_cc_trx_number,
1216: p_parameterlist => l_list);
1217: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1218: p_value => p_cc_trx_currency,

Line 1217: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',

1213: p_parameterlist => l_list);
1214: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1215: p_value => p_cc_trx_number,
1216: p_parameterlist => l_list);
1217: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1218: p_value => p_cc_trx_currency,
1219: p_parameterlist => l_list);
1220: wf_event.AddParameterToList(p_name => 'AMOUNT',
1221: p_value => p_cc_trx_amount,

Line 1220: wf_event.AddParameterToList(p_name => 'AMOUNT',

1216: p_parameterlist => l_list);
1217: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1218: p_value => p_cc_trx_currency,
1219: p_parameterlist => l_list);
1220: wf_event.AddParameterToList(p_name => 'AMOUNT',
1221: p_value => p_cc_trx_amount,
1222: p_parameterlist => l_list);
1223: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1224: p_value => p_cc_trx_date,

Line 1223: wf_event.AddParameterToList(p_name => 'REFUND DATE',

1219: p_parameterlist => l_list);
1220: wf_event.AddParameterToList(p_name => 'AMOUNT',
1221: p_value => p_cc_trx_amount,
1222: p_parameterlist => l_list);
1223: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1224: p_value => p_cc_trx_date,
1225: p_parameterlist => l_list);
1226: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1227: p_value => p_customer_name,

Line 1226: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',

1222: p_parameterlist => l_list);
1223: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1224: p_value => p_cc_trx_date,
1225: p_parameterlist => l_list);
1226: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1227: p_value => p_customer_name,
1228: p_parameterlist => l_list);
1229: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1230: p_value => p_customer_number,

Line 1229: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',

1225: p_parameterlist => l_list);
1226: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1227: p_value => p_customer_name,
1228: p_parameterlist => l_list);
1229: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1230: p_value => p_customer_number,
1231: p_parameterlist => l_list);
1232: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1233: p_value => p_customer_location,

Line 1232: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',

1228: p_parameterlist => l_list);
1229: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1230: p_value => p_customer_number,
1231: p_parameterlist => l_list);
1232: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1233: p_value => p_customer_location,
1234: p_parameterlist => l_list);
1235: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1236: p_value => p_cc_number,

Line 1235: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',

1231: p_parameterlist => l_list);
1232: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1233: p_value => p_customer_location,
1234: p_parameterlist => l_list);
1235: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1236: p_value => p_cc_number,
1237: p_parameterlist => l_list);
1238: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1239: p_value => p_approval_code,

Line 1238: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',

1234: p_parameterlist => l_list);
1235: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1236: p_value => p_cc_number,
1237: p_parameterlist => l_list);
1238: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1239: p_value => p_approval_code,
1240: p_parameterlist => l_list);
1241: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1242: p_value => p_payment_server_id,

Line 1241: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',

1237: p_parameterlist => l_list);
1238: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1239: p_value => p_approval_code,
1240: p_parameterlist => l_list);
1241: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1242: p_value => p_payment_server_id,
1243: p_parameterlist => l_list);
1244: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1245: p_value => p_collector,

Line 1244: wf_event.AddParameterToList(p_name => 'COLLECTOR',

1240: p_parameterlist => l_list);
1241: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1242: p_value => p_payment_server_id,
1243: p_parameterlist => l_list);
1244: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1245: p_value => p_collector,
1246: p_parameterlist => l_list);
1247: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1248: p_value => p_payment_method_name,

Line 1247: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',

1243: p_parameterlist => l_list);
1244: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1245: p_value => p_collector,
1246: p_parameterlist => l_list);
1247: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1248: p_value => p_payment_method_name,
1249: p_parameterlist => l_list);
1250: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1251: p_value => p_error_notes,

Line 1250: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',

1246: p_parameterlist => l_list);
1247: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1248: p_value => p_payment_method_name,
1249: p_parameterlist => l_list);
1250: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1251: p_value => p_error_notes,
1252: p_parameterlist => l_list);
1253: IF p_source_receipt_id IS NOT NULL THEN
1254: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',

Line 1254: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',

1250: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1251: p_value => p_error_notes,
1252: p_parameterlist => l_list);
1253: IF p_source_receipt_id IS NOT NULL THEN
1254: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1255: p_value => p_source_receipt_id,
1256: p_parameterlist => l_list);
1257: END IF;
1258: IF p_source_receipt_num IS NOT NULL THEN

Line 1259: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',

1255: p_value => p_source_receipt_id,
1256: p_parameterlist => l_list);
1257: END IF;
1258: IF p_source_receipt_num IS NOT NULL THEN
1259: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1260: p_value => p_source_receipt_num,
1261: p_parameterlist => l_list);
1262: END IF;
1263: IF p_billto_contact IS NOT NULL THEN

Line 1264: wf_event.AddParameterToList(p_name => 'BILL TO CONTACT',

1260: p_value => p_source_receipt_num,
1261: p_parameterlist => l_list);
1262: END IF;
1263: IF p_billto_contact IS NOT NULL THEN
1264: wf_event.AddParameterToList(p_name => 'BILL TO CONTACT',
1265: p_value => p_billto_contact,
1266: p_parameterlist => l_list);
1267: END IF;
1268: IF p_salesrep_name IS NOT NULL THEN

Line 1269: wf_event.AddParameterToList(p_name => 'SALES REP NAME',

1265: p_value => p_billto_contact,
1266: p_parameterlist => l_list);
1267: END IF;
1268: IF p_salesrep_name IS NOT NULL THEN
1269: wf_event.AddParameterToList(p_name => 'SALES REP NAME',
1270: p_value => p_salesrep_name,
1271: p_parameterlist => l_list);
1272: END IF;
1273:

Line 1400: FROM wf_events

1396: IS
1397: RetEvent VARCHAR2(240);
1398: CURSOR get_event IS
1399: SELECT name
1400: FROM wf_events
1401: WHERE name = p_event_name;
1402: BEGIN
1403: OPEN get_event;
1404:

Line 1441: Wf_Event.Raise

1437: IF SUBSTRB(l_event,1,31) <> 'oracle.apps.ar.ccerrorhandling.' THEN
1438: RAISE EventNotARCC;
1439: END IF;
1440:
1441: Wf_Event.Raise
1442: ( p_event_name => l_event,
1443: p_event_key => p_event_key,
1444: p_parameters => p_parameters,
1445: p_event_data => p_data);