DBA Data[Home] [Help]

APPS.OE_LINE_PAYMENT_SECURITY dependencies on OE_GLOBALS

Line 882: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

878:
879: -- Initializing return status to SUCCESS
880: x_return_status := FND_API.G_RET_STS_SUCCESS;
881:
882: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
883: l_operation := OE_PC_GLOBALS.CREATE_OP;
884: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
885: l_operation := OE_PC_GLOBALS.UPDATE_OP;
886: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

Line 884: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

880: x_return_status := FND_API.G_RET_STS_SUCCESS;
881:
882: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
883: l_operation := OE_PC_GLOBALS.CREATE_OP;
884: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
885: l_operation := OE_PC_GLOBALS.UPDATE_OP;
886: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
887: l_operation := OE_PC_GLOBALS.DELETE_OP;
888: ELSE

Line 886: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN

882: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
883: l_operation := OE_PC_GLOBALS.CREATE_OP;
884: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
885: l_operation := OE_PC_GLOBALS.UPDATE_OP;
886: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_DELETE THEN
887: l_operation := OE_PC_GLOBALS.DELETE_OP;
888: ELSE
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 954: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN

950: -- Initializing out result to NOT CONSTRAINED
951: x_result := OE_PC_GLOBALS.NO;
952:
953: -- Get the operation code to be passed to the security framework API
954: IF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
955:
956: l_operation := OE_PC_GLOBALS.CREATE_OP;
957:
958: -- Bug 1755817: if there are no attribute-specific insert

Line 971: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

967: THEN
968: RETURN;
969: END IF;
970:
971: ELSIF p_LINE_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN
972: l_operation := OE_PC_GLOBALS.UPDATE_OP;
973: ELSE
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;

Line 991: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.payment_level_code,p_old_line_payment_rec.payment_level_code) THEN

987: -- Compare the new and old entity records and
988: -- check constraints for all the changed attributes.
989:
990: IF p_line_payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN NULL;
991: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.payment_level_code,p_old_line_payment_rec.payment_level_code) THEN
992:
993: l_result := PAYMENT_LEVEL_CODE
994: (p_operation => l_operation
995: ,p_record => l_rowtype_rec

Line 1007: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.payment_type_code,p_old_line_payment_rec.payment_type_code) THEN

1003:
1004: END IF;
1005:
1006: IF p_line_payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
1007: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.payment_type_code,p_old_line_payment_rec.payment_type_code) THEN
1008:
1009: l_result := PAYMENT_TYPE_CODE
1010: (p_operation => l_operation
1011: ,p_record => l_rowtype_rec

Line 1023: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.payment_trx_id, p_old_line_payment_rec.payment_trx_id) THEN

1019:
1020: END IF;
1021:
1022: IF p_line_payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN NULL;
1023: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.payment_trx_id, p_old_line_payment_rec.payment_trx_id) THEN
1024:
1025: l_result := PAYMENT_TRX
1026: (p_operation => l_operation
1027: ,p_record => l_rowtype_rec

Line 1039: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.receipt_method_id, p_old_line_payment_rec.receipt_method_id) THEN

1035: END IF;
1036:
1037:
1038: IF p_line_payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN NULL;
1039: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.receipt_method_id, p_old_line_payment_rec.receipt_method_id) THEN
1040:
1041: l_result := RECEIPT_METHOD
1042: (p_operation => l_operation
1043: ,p_record => l_rowtype_rec

Line 1055: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.payment_collection_event, p_old_line_payment_rec.payment_collection_event) THEN

1051: END IF;
1052:
1053:
1054: IF p_line_payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN NULL;
1055: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.payment_collection_event, p_old_line_payment_rec.payment_collection_event) THEN
1056:
1057: l_result := PAYMENT_COLLECTION_EVENT
1058: (p_operation => l_operation
1059: ,p_record => l_rowtype_rec

Line 1071: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.check_number, p_old_line_payment_rec.check_number) THEN

1067: END IF;
1068:
1069:
1070: IF p_line_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
1071: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.check_number, p_old_line_payment_rec.check_number) THEN
1072:
1073: l_result := CHECK_NUMBER
1074: (p_operation => l_operation
1075: ,p_record => l_rowtype_rec

Line 1087: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.commitment_applied_amount, p_old_line_payment_rec.commitment_applied_amount) THEN

1083: END IF;
1084:
1085:
1086: IF p_line_payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN NULL;
1087: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.commitment_applied_amount, p_old_line_payment_rec.commitment_applied_amount) THEN
1088:
1089: l_result := COMMITMENT_APPLIED_AMOUNT
1090: (p_operation => l_operation
1091: ,p_record => l_rowtype_rec

Line 1103: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_code, p_old_line_payment_rec.credit_card_code) THEN

1099: END IF;
1100:
1101:
1102: IF p_line_payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
1103: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_code, p_old_line_payment_rec.credit_card_code) THEN
1104:
1105: l_result := CREDIT_CARD
1106: (p_operation => l_operation
1107: ,p_record => l_rowtype_rec

Line 1127: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_payment_rec.credit_card_number,

1123: IF l_debug_level > 0 THEN
1124: oe_debug_pub.add('Before calling is_same_Credit_card');
1125: oe_debug_pub.add('Old and new cc number'||p_old_line_Payment_rec.credit_card_number||'and'||p_line_payment_rec.credit_Card_number);
1126: END IF;
1127: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_line_payment_rec.credit_card_number,
1128: p_line_payment_rec.credit_card_number,
1129: p_old_line_payment_rec.cc_instrument_id,
1130: p_line_payment_rec.cc_instrument_id)
1131: THEN

Line 1147: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_holder_name, p_old_line_payment_rec.credit_card_holder_name) THEN

1143: END IF;
1144:
1145:
1146: IF p_line_payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
1147: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_holder_name, p_old_line_payment_rec.credit_card_holder_name) THEN
1148:
1149: l_result := CREDIT_CARD_HOLDER_NAME
1150: (p_operation => l_operation
1151: ,p_record => l_rowtype_rec

Line 1163: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_expiration_date, p_old_line_payment_rec.credit_card_expiration_date) THEN

1159: END IF;
1160:
1161:
1162: IF p_line_payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
1163: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_expiration_date, p_old_line_payment_rec.credit_card_expiration_date) THEN
1164:
1165: l_result := CREDIT_CARD_EXPIRATION_DATE
1166: (p_operation => l_operation
1167: ,p_record => l_rowtype_rec

Line 1179: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_approval_code, p_old_line_payment_rec.credit_card_approval_code) THEN

1175: END IF;
1176:
1177:
1178: IF p_line_payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN NULL;
1179: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_approval_code, p_old_line_payment_rec.credit_card_approval_code) THEN
1180:
1181: l_result := CREDIT_CARD_APPROVAL
1182: (p_operation => l_operation
1183: ,p_record => l_rowtype_rec

Line 1195: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_approval_date, p_old_line_payment_rec.credit_card_approval_date) THEN

1191: END IF;
1192:
1193:
1194: IF p_line_payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN NULL;
1195: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.credit_card_approval_date, p_old_line_payment_rec.credit_card_approval_date) THEN
1196:
1197: l_result := CREDIT_CARD_APPROVAL_DATE
1198: (p_operation => l_operation
1199: ,p_record => l_rowtype_rec

Line 1211: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.check_number, p_old_line_payment_rec.check_number) THEN

1207: END IF;
1208:
1209:
1210: IF p_line_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
1211: ELSIF NOT OE_GLOBALS.Equal(p_line_payment_rec.check_number, p_old_line_payment_rec.check_number) THEN
1212:
1213: l_result := CHECK_NUMBER
1214: (p_operation => l_operation
1215: ,p_record => l_rowtype_rec

Line 1243: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.context,p_old_line_payment_rec.context) THEN

1239: g_check_all_cols_constraint := 'N';
1240: END IF;
1241:
1242: IF p_line_payment_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1243: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.context,p_old_line_payment_rec.context) THEN
1244:
1245: l_result := CONTEXT
1246: (p_operation => l_operation
1247: ,p_record => l_rowtype_rec

Line 1259: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute1,p_old_line_payment_rec.attribute1) THEN

1255:
1256: END IF;
1257:
1258: IF p_line_payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1259: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute1,p_old_line_payment_rec.attribute1) THEN
1260:
1261: l_result := ATTRIBUTE1
1262: (p_operation => l_operation
1263: ,p_record => l_rowtype_rec

Line 1275: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute10,p_old_line_payment_rec.attribute10) THEN

1271:
1272: END IF;
1273:
1274: IF p_line_payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1275: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute10,p_old_line_payment_rec.attribute10) THEN
1276:
1277: l_result := ATTRIBUTE10
1278: (p_operation => l_operation
1279: ,p_record => l_rowtype_rec

Line 1291: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute11,p_old_line_payment_rec.attribute11) THEN

1287:
1288: END IF;
1289:
1290: IF p_line_payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1291: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute11,p_old_line_payment_rec.attribute11) THEN
1292:
1293: l_result := ATTRIBUTE11
1294: (p_operation => l_operation
1295: ,p_record => l_rowtype_rec

Line 1307: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute12,p_old_line_payment_rec.attribute12) THEN

1303:
1304: END IF;
1305:
1306: IF p_line_payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1307: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute12,p_old_line_payment_rec.attribute12) THEN
1308:
1309: l_result := ATTRIBUTE12
1310: (p_operation => l_operation
1311: ,p_record => l_rowtype_rec

Line 1323: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute13,p_old_line_payment_rec.attribute13) THEN

1319:
1320: END IF;
1321:
1322: IF p_line_payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1323: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute13,p_old_line_payment_rec.attribute13) THEN
1324:
1325: l_result := ATTRIBUTE13
1326: (p_operation => l_operation
1327: ,p_record => l_rowtype_rec

Line 1339: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute14,p_old_line_payment_rec.attribute14) THEN

1335:
1336: END IF;
1337:
1338: IF p_line_payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1339: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute14,p_old_line_payment_rec.attribute14) THEN
1340:
1341: l_result := ATTRIBUTE14
1342: (p_operation => l_operation
1343: ,p_record => l_rowtype_rec

Line 1355: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute15,p_old_line_payment_rec.attribute15) THEN

1351:
1352: END IF;
1353:
1354: IF p_line_payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1355: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute15,p_old_line_payment_rec.attribute15) THEN
1356:
1357: l_result := ATTRIBUTE15
1358: (p_operation => l_operation
1359: ,p_record => l_rowtype_rec

Line 1371: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute2,p_old_line_payment_rec.attribute2) THEN

1367:
1368: END IF;
1369:
1370: IF p_line_payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1371: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute2,p_old_line_payment_rec.attribute2) THEN
1372:
1373: l_result := ATTRIBUTE2
1374: (p_operation => l_operation
1375: ,p_record => l_rowtype_rec

Line 1387: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute3,p_old_line_payment_rec.attribute3) THEN

1383:
1384: END IF;
1385:
1386: IF p_line_payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1387: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute3,p_old_line_payment_rec.attribute3) THEN
1388:
1389: l_result := ATTRIBUTE3
1390: (p_operation => l_operation
1391: ,p_record => l_rowtype_rec

Line 1403: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute4,p_old_line_payment_rec.attribute4) THEN

1399:
1400: END IF;
1401:
1402: IF p_line_payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1403: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute4,p_old_line_payment_rec.attribute4) THEN
1404:
1405: l_result := ATTRIBUTE4
1406: (p_operation => l_operation
1407: ,p_record => l_rowtype_rec

Line 1419: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute5,p_old_line_payment_rec.attribute5) THEN

1415:
1416: END IF;
1417:
1418: IF p_line_payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1419: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute5,p_old_line_payment_rec.attribute5) THEN
1420:
1421: l_result := ATTRIBUTE5
1422: (p_operation => l_operation
1423: ,p_record => l_rowtype_rec

Line 1435: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute6,p_old_line_payment_rec.attribute6) THEN

1431:
1432: END IF;
1433:
1434: IF p_line_payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1435: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute6,p_old_line_payment_rec.attribute6) THEN
1436:
1437: l_result := ATTRIBUTE6
1438: (p_operation => l_operation
1439: ,p_record => l_rowtype_rec

Line 1451: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute7,p_old_line_payment_rec.attribute7) THEN

1447:
1448: END IF;
1449:
1450: IF p_line_payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1451: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute7,p_old_line_payment_rec.attribute7) THEN
1452:
1453: l_result := ATTRIBUTE7
1454: (p_operation => l_operation
1455: ,p_record => l_rowtype_rec

Line 1467: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute8,p_old_line_payment_rec.attribute8) THEN

1463:
1464: END IF;
1465:
1466: IF p_line_payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1467: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute8,p_old_line_payment_rec.attribute8) THEN
1468:
1469: l_result := ATTRIBUTE8
1470: (p_operation => l_operation
1471: ,p_record => l_rowtype_rec

Line 1483: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute9,p_old_line_payment_rec.attribute9) THEN

1479:
1480: END IF;
1481:
1482: IF p_line_payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1483: ELSIF NOT OE_GLOBALS.EQUAL(p_line_payment_rec.attribute9,p_old_line_payment_rec.attribute9) THEN
1484:
1485: l_result := ATTRIBUTE9
1486: (p_operation => l_operation
1487: ,p_record => l_rowtype_rec