DBA Data[Home] [Help]

APPS.ARP_CORRECT_CC_ERRORS dependencies on WF_EVENT

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

1042: -- Add Context values to the list
1043: AddParamEnvToList(l_list);
1044:
1045: -- add more parameters to the parameters list
1046: wf_event.AddParameterToList(p_name => 'REFUND MISC CASH RECEIPT ID',
1047: p_value => p_misc_cash_receipt_id,
1048: p_parameterlist => l_list);
1049: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1050: p_value => p_cc_error_code,

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

1045: -- add more parameters to the parameters list
1046: wf_event.AddParameterToList(p_name => 'REFUND MISC CASH RECEIPT ID',
1047: p_value => p_misc_cash_receipt_id,
1048: p_parameterlist => l_list);
1049: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1050: p_value => p_cc_error_code,
1051: p_parameterlist => l_list);
1052: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1053: p_value => p_cc_error_desc,

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

1048: p_parameterlist => l_list);
1049: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1050: p_value => p_cc_error_code,
1051: p_parameterlist => l_list);
1052: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1053: p_value => p_cc_error_desc,
1054: p_parameterlist => l_list);
1055: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1056: p_value => p_cc_trx_number,

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

1051: p_parameterlist => l_list);
1052: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1053: p_value => p_cc_error_desc,
1054: p_parameterlist => l_list);
1055: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1056: p_value => p_cc_trx_number,
1057: p_parameterlist => l_list);
1058: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1059: p_value => p_cc_trx_currency,

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

1054: p_parameterlist => l_list);
1055: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1056: p_value => p_cc_trx_number,
1057: p_parameterlist => l_list);
1058: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1059: p_value => p_cc_trx_currency,
1060: p_parameterlist => l_list);
1061: wf_event.AddParameterToList(p_name => 'AMOUNT',
1062: p_value => p_cc_trx_amount,

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

1057: p_parameterlist => l_list);
1058: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1059: p_value => p_cc_trx_currency,
1060: p_parameterlist => l_list);
1061: wf_event.AddParameterToList(p_name => 'AMOUNT',
1062: p_value => p_cc_trx_amount,
1063: p_parameterlist => l_list);
1064: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1065: p_value => p_cc_trx_date,

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

1060: p_parameterlist => l_list);
1061: wf_event.AddParameterToList(p_name => 'AMOUNT',
1062: p_value => p_cc_trx_amount,
1063: p_parameterlist => l_list);
1064: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1065: p_value => p_cc_trx_date,
1066: p_parameterlist => l_list);
1067: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1068: p_value => p_customer_name,

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

1063: p_parameterlist => l_list);
1064: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1065: p_value => p_cc_trx_date,
1066: p_parameterlist => l_list);
1067: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1068: p_value => p_customer_name,
1069: p_parameterlist => l_list);
1070: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1071: p_value => p_customer_number,

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

1066: p_parameterlist => l_list);
1067: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1068: p_value => p_customer_name,
1069: p_parameterlist => l_list);
1070: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1071: p_value => p_customer_number,
1072: p_parameterlist => l_list);
1073: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1074: p_value => p_customer_location,

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

1069: p_parameterlist => l_list);
1070: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1071: p_value => p_customer_number,
1072: p_parameterlist => l_list);
1073: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1074: p_value => p_customer_location,
1075: p_parameterlist => l_list);
1076: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1077: p_value => p_cc_number,

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

1072: p_parameterlist => l_list);
1073: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1074: p_value => p_customer_location,
1075: p_parameterlist => l_list);
1076: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1077: p_value => p_cc_number,
1078: p_parameterlist => l_list);
1079: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1080: p_value => p_approval_code,

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

1075: p_parameterlist => l_list);
1076: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1077: p_value => p_cc_number,
1078: p_parameterlist => l_list);
1079: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1080: p_value => p_approval_code,
1081: p_parameterlist => l_list);
1082: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1083: p_value => p_payment_trxn_extension_id,

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

1078: p_parameterlist => l_list);
1079: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1080: p_value => p_approval_code,
1081: p_parameterlist => l_list);
1082: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1083: p_value => p_payment_trxn_extension_id,
1084: p_parameterlist => l_list);
1085: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1086: p_value => p_collector,

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

1081: p_parameterlist => l_list);
1082: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1083: p_value => p_payment_trxn_extension_id,
1084: p_parameterlist => l_list);
1085: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1086: p_value => p_collector,
1087: p_parameterlist => l_list);
1088: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1089: p_value => p_payment_method_name,

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

1084: p_parameterlist => l_list);
1085: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1086: p_value => p_collector,
1087: p_parameterlist => l_list);
1088: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1089: p_value => p_payment_method_name,
1090: p_parameterlist => l_list);
1091: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1092: p_value => p_source_receipt_id,

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

1087: p_parameterlist => l_list);
1088: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1089: p_value => p_payment_method_name,
1090: p_parameterlist => l_list);
1091: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1092: p_value => p_source_receipt_id,
1093: p_parameterlist => l_list);
1094: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1095: p_value => p_source_receipt_num,

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

1090: p_parameterlist => l_list);
1091: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1092: p_value => p_source_receipt_id,
1093: p_parameterlist => l_list);
1094: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1095: p_value => p_source_receipt_num,
1096: p_parameterlist => l_list);
1097: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1098: p_value => p_error_notes,

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

1093: p_parameterlist => l_list);
1094: wf_event.AddParameterToList(p_name => 'SOURCE RECEIPT NUMBER',
1095: p_value => p_source_receipt_num,
1096: p_parameterlist => l_list);
1097: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1098: p_value => p_error_notes,
1099: p_parameterlist => l_list);
1100: -- Raise Event
1101: raise_event(

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

1203: -- Add Context values to the list
1204: AddParamEnvToList(l_list);
1205:
1206: -- add more parameters to the parameters list
1207: wf_event.AddParameterToList(p_name => 'CREDIT CARD TRANSACTION ID',
1208: p_value => p_cc_trx_id,
1209: p_parameterlist => l_list);
1210: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1211: p_value => p_cc_error_code,

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

1206: -- add more parameters to the parameters list
1207: wf_event.AddParameterToList(p_name => 'CREDIT CARD TRANSACTION ID',
1208: p_value => p_cc_trx_id,
1209: p_parameterlist => l_list);
1210: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1211: p_value => p_cc_error_code,
1212: p_parameterlist => l_list);
1213: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1214: p_value => p_cc_error_desc,

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

1209: p_parameterlist => l_list);
1210: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR CODE',
1211: p_value => p_cc_error_code,
1212: p_parameterlist => l_list);
1213: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1214: p_value => p_cc_error_desc,
1215: p_parameterlist => l_list);
1216: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1217: p_value => p_cc_trx_category_dsp,

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

1212: p_parameterlist => l_list);
1213: wf_event.AddParameterToList(p_name => 'CREDIT CARD ERROR DESCRIPTION',
1214: p_value => p_cc_error_desc,
1215: p_parameterlist => l_list);
1216: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1217: p_value => p_cc_trx_category_dsp,
1218: p_parameterlist => l_list);
1219: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1220: p_value => p_cc_trx_number,

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

1215: p_parameterlist => l_list);
1216: wf_event.AddParameterToList(p_name => 'TRANSACTION CATEGORY',
1217: p_value => p_cc_trx_category_dsp,
1218: p_parameterlist => l_list);
1219: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1220: p_value => p_cc_trx_number,
1221: p_parameterlist => l_list);
1222: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1223: p_value => p_cc_trx_currency,

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

1218: p_parameterlist => l_list);
1219: wf_event.AddParameterToList(p_name => 'REFUD MISC RECEIPT NUMBER',
1220: p_value => p_cc_trx_number,
1221: p_parameterlist => l_list);
1222: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1223: p_value => p_cc_trx_currency,
1224: p_parameterlist => l_list);
1225: wf_event.AddParameterToList(p_name => 'AMOUNT',
1226: p_value => p_cc_trx_amount,

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

1221: p_parameterlist => l_list);
1222: wf_event.AddParameterToList(p_name => 'CURRENCY CODE',
1223: p_value => p_cc_trx_currency,
1224: p_parameterlist => l_list);
1225: wf_event.AddParameterToList(p_name => 'AMOUNT',
1226: p_value => p_cc_trx_amount,
1227: p_parameterlist => l_list);
1228: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1229: p_value => p_cc_trx_date,

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

1224: p_parameterlist => l_list);
1225: wf_event.AddParameterToList(p_name => 'AMOUNT',
1226: p_value => p_cc_trx_amount,
1227: p_parameterlist => l_list);
1228: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1229: p_value => p_cc_trx_date,
1230: p_parameterlist => l_list);
1231: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1232: p_value => p_customer_name,

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

1227: p_parameterlist => l_list);
1228: wf_event.AddParameterToList(p_name => 'REFUND DATE',
1229: p_value => p_cc_trx_date,
1230: p_parameterlist => l_list);
1231: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1232: p_value => p_customer_name,
1233: p_parameterlist => l_list);
1234: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1235: p_value => p_customer_number,

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

1230: p_parameterlist => l_list);
1231: wf_event.AddParameterToList(p_name => 'CUSTOMER NAME',
1232: p_value => p_customer_name,
1233: p_parameterlist => l_list);
1234: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1235: p_value => p_customer_number,
1236: p_parameterlist => l_list);
1237: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1238: p_value => p_customer_location,

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

1233: p_parameterlist => l_list);
1234: wf_event.AddParameterToList(p_name => 'CUSTOMER NUMBER',
1235: p_value => p_customer_number,
1236: p_parameterlist => l_list);
1237: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1238: p_value => p_customer_location,
1239: p_parameterlist => l_list);
1240: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1241: p_value => p_cc_number,

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

1236: p_parameterlist => l_list);
1237: wf_event.AddParameterToList(p_name => 'CUSTOMER LOCATION',
1238: p_value => p_customer_location,
1239: p_parameterlist => l_list);
1240: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1241: p_value => p_cc_number,
1242: p_parameterlist => l_list);
1243: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1244: p_value => p_approval_code,

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

1239: p_parameterlist => l_list);
1240: wf_event.AddParameterToList(p_name => 'CREDIT CARD NUMBER',
1241: p_value => p_cc_number,
1242: p_parameterlist => l_list);
1243: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1244: p_value => p_approval_code,
1245: p_parameterlist => l_list);
1246: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1247: p_value => p_payment_trxn_extension_id,

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

1242: p_parameterlist => l_list);
1243: wf_event.AddParameterToList(p_name => 'APPROVAL CODE',
1244: p_value => p_approval_code,
1245: p_parameterlist => l_list);
1246: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1247: p_value => p_payment_trxn_extension_id,
1248: p_parameterlist => l_list);
1249: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1250: p_value => p_collector,

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

1245: p_parameterlist => l_list);
1246: wf_event.AddParameterToList(p_name => 'PAYMENT SERVER ID',
1247: p_value => p_payment_trxn_extension_id,
1248: p_parameterlist => l_list);
1249: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1250: p_value => p_collector,
1251: p_parameterlist => l_list);
1252: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1253: p_value => p_payment_method_name,

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

1248: p_parameterlist => l_list);
1249: wf_event.AddParameterToList(p_name => 'COLLECTOR',
1250: p_value => p_collector,
1251: p_parameterlist => l_list);
1252: wf_event.AddParameterToList(p_name => 'PAYMENT METHOD NAME',
1253: p_value => p_payment_method_name,
1254: p_parameterlist => l_list);
1255: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1256: p_value => p_error_notes,

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

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

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

1255: wf_event.AddParameterToList(p_name => 'CREDIT CARD CORRECTION NOTES',
1256: p_value => p_error_notes,
1257: p_parameterlist => l_list);
1258: IF p_source_receipt_id IS NOT NULL THEN
1259: wf_event.AddParameterToList(p_name => 'SOURCE CASH RECEIPT ID',
1260: p_value => p_source_receipt_id,
1261: p_parameterlist => l_list);
1262: END IF;
1263: IF p_source_receipt_num IS NOT NULL THEN

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

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

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

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

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

1270: p_value => p_billto_contact,
1271: p_parameterlist => l_list);
1272: END IF;
1273: IF p_salesrep_name IS NOT NULL THEN
1274: wf_event.AddParameterToList(p_name => 'SALES REP NAME',
1275: p_value => p_salesrep_name,
1276: p_parameterlist => l_list);
1277: END IF;
1278:

Line 1405: FROM wf_events

1401: IS
1402: RetEvent VARCHAR2(240);
1403: CURSOR get_event IS
1404: SELECT name
1405: FROM wf_events
1406: WHERE name = p_event_name;
1407: BEGIN
1408: OPEN get_event;
1409:

Line 1446: Wf_Event.Raise

1442: IF SUBSTRB(l_event,1,31) <> 'oracle.apps.ar.ccerrorhandling.' THEN
1443: RAISE EventNotARCC;
1444: END IF;
1445:
1446: Wf_Event.Raise
1447: ( p_event_name => l_event,
1448: p_event_key => p_event_key,
1449: p_parameters => p_parameters,
1450: p_event_data => p_data);