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.OE_HEADER_PAYMENT_SECURITY dependencies on FND_API

Line 9: g_header_id NUMBER := FND_API.G_MISS_NUM;

5: -- Global constant holding the package name
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'OE_Header_Payment_Security';
8:
9: g_header_id NUMBER := FND_API.G_MISS_NUM;
10:
11: -- LOCAL PROCEDURES
12:
13: FUNCTION Is_Op_Constrained

Line 66: RAISE FND_API.G_EXC_ERROR;

62: FROM oe_pc_constraints
63: WHERE constraint_id = l_constraint_id;
64: if l_constrained_column is null AND x_on_operation_action = 0 then
65: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
66: RAISE FND_API.G_EXC_ERROR;
67: end if;
68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then

Line 72: raise FND_API.G_EXC_UNEXPECTED_ERROR;

68: END IF;
69:
70: elsif l_result = OE_PC_GLOBALS.ERROR then
71:
72: raise FND_API.G_EXC_UNEXPECTED_ERROR;
73:
74: end if;
75:
76: g_check_all_cols_constraint := 'N';

Line 877: x_return_status := FND_API.G_RET_STS_SUCCESS;

873: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ENTITY' , 1 ) ;
874: END IF;
875:
876: -- Initializing return status to SUCCESS
877: x_return_status := FND_API.G_RET_STS_SUCCESS;
878:
879: IF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
880: l_operation := OE_PC_GLOBALS.CREATE_OP;
881: ELSIF p_HEADER_PAYMENT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 889: RAISE FND_API.G_EXC_ERROR;

885: ELSE
886: IF l_debug_level > 0 THEN
887: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
888: END IF;
889: RAISE FND_API.G_EXC_ERROR;
890: END IF;
891:
892: OE_Header_Payment_Util.API_Rec_To_Rowtype_Rec
893: (p_HEADER_PAYMENT_rec,

Line 911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

907: END IF;
908:
909: EXCEPTION
910: WHEN OTHERS THEN
911: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: OE_MSG_PUB.Add_Exc_Msg
914: ( G_PKG_NAME
915: , 'Entity'

Line 945: x_return_status := FND_API.G_RET_STS_SUCCESS;

941: oe_debug_pub.add( 'ENTER OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
942: END IF;
943:
944: -- Initializing return status to SUCCESS
945: x_return_status := FND_API.G_RET_STS_SUCCESS;
946:
947: -- Initializing out result to NOT CONSTRAINED
948: x_result := OE_PC_GLOBALS.NO;
949:

Line 974: RAISE FND_API.G_EXC_ERROR;

970: ELSE
971: IF l_debug_level > 0 THEN
972: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
973: END IF;
974: RAISE FND_API.G_EXC_ERROR;
975: END IF;
976:
977: OE_Header_Payment_Util.API_Rec_To_Rowtype_Rec
978: (p_HEADER_PAYMENT_rec,

Line 987: IF p_header_payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN NULL;

983:
984: -- Compare the new and old entity records and
985: -- check constraints for all the changed attributes.
986:
987: IF p_header_payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN NULL;
988: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_level_code,p_old_header_payment_rec.payment_level_code) THEN
989:
990: l_result := PAYMENT_LEVEL_CODE
991: (p_operation => l_operation

Line 1003: IF p_header_payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN NULL;

999: END IF;
1000:
1001: END IF;
1002:
1003: IF p_header_payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN NULL;
1004: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.commitment_applied_amount,p_old_header_payment_rec.commitment_applied_amount) THEN
1005:
1006: l_result := COMMITMENT_APPLIED_AMOUNT
1007: (p_operation => l_operation

Line 1019: IF p_header_payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;

1015: END IF;
1016:
1017: END IF;
1018:
1019: IF p_header_payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;
1020: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_code,p_old_header_payment_rec.credit_card_code) THEN
1021:
1022: l_result := CREDIT_CARD
1023: (p_operation => l_operation

Line 1039: IF p_header_payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;

1035: --Since the credit card numbers are encrypted, calling
1036: --the function same credit card to determine whether the old
1037: --and new card numbers are equal.
1038:
1039: IF p_header_payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;
1040: ELSIF NOT OE_GLOBALS.Is_Same_Credit_Card(p_old_header_payment_rec.credit_card_number,
1041: p_header_payment_rec.credit_card_number,
1042: p_old_header_payment_rec.cc_instrument_id,
1043: p_header_payment_rec.cc_instrument_id)

Line 1058: IF p_header_payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;

1054: END IF;
1055:
1056: END IF;
1057:
1058: IF p_header_payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;
1059: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_holder_name,p_old_header_payment_rec.credit_card_holder_name) THEN
1060:
1061: l_result := CREDIT_CARD_HOLDER_NAME
1062: (p_operation => l_operation

Line 1074: IF p_header_payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;

1070: END IF;
1071:
1072: END IF;
1073:
1074: IF p_header_payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;
1075: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_expiration_date,p_old_header_payment_rec.credit_card_expiration_date) THEN
1076:
1077: l_result := CREDIT_CARD_EXPIRATION_DATE
1078: (p_operation => l_operation

Line 1090: IF p_header_payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN NULL;

1086: END IF;
1087:
1088: END IF;
1089:
1090: IF p_header_payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN NULL;
1091: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_code,p_old_header_payment_rec.credit_card_approval_code) THEN
1092:
1093: l_result := CREDIT_CARD_APPROVAL
1094: (p_operation => l_operation

Line 1106: IF p_header_payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN NULL;

1102: END IF;
1103:
1104: END IF;
1105:
1106: IF p_header_payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN NULL;
1107: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.credit_card_approval_date,p_old_header_payment_rec.credit_card_approval_date) THEN
1108:
1109: l_result := CREDIT_CARD_APPROVAL_DATE
1110: (p_operation => l_operation

Line 1122: IF p_header_payment_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;

1118: END IF;
1119:
1120: END IF;
1121:
1122: IF p_header_payment_rec.payment_amount = FND_API.G_MISS_NUM THEN NULL;
1123: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_amount,p_old_header_payment_rec.payment_amount) THEN
1124:
1125: l_result := PAYMENT_AMOUNT
1126: (p_operation => l_operation

Line 1138: IF p_header_payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;

1134: END IF;
1135:
1136: END IF;
1137:
1138: IF p_header_payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;
1139: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.payment_type_code,p_old_header_payment_rec.payment_type_code) THEN
1140:
1141: l_result := PAYMENT_TYPE_CODE
1142: (p_operation => l_operation

Line 1154: IF p_header_payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN NULL;

1150: END IF;
1151:
1152: END IF;
1153:
1154: IF p_header_payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN NULL;
1155: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_trx_id, p_old_header_payment_rec.payment_trx_id) THEN
1156:
1157: l_result := PAYMENT_TRX
1158: (p_operation => l_operation

Line 1170: IF p_header_payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN NULL;

1166:
1167: END IF;
1168:
1169:
1170: IF p_header_payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN NULL;
1171: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.receipt_method_id, p_old_header_payment_rec.receipt_method_id) THEN
1172:
1173: l_result := RECEIPT_METHOD
1174: (p_operation => l_operation

Line 1186: IF p_header_payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN NULL;

1182:
1183: END IF;
1184:
1185:
1186: IF p_header_payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN NULL;
1187: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.payment_collection_event, p_old_header_payment_rec.payment_collection_event) THEN
1188:
1189: l_result := PAYMENT_COLLECTION_EVENT
1190: (p_operation => l_operation

Line 1201: IF p_header_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;

1197: END IF;
1198:
1199: END IF;
1200:
1201: IF p_header_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;
1202: ELSIF NOT OE_GLOBALS.Equal(p_header_payment_rec.check_number, p_old_header_payment_rec.check_number) THEN
1203:
1204: l_result := CHECK_NUMBER
1205: (p_operation => l_operation

Line 1232: IF p_header_payment_rec.context = FND_API.G_MISS_CHAR THEN NULL;

1228: l_check_all_cols_constraint := g_check_all_cols_constraint;
1229: g_check_all_cols_constraint := 'N';
1230: END IF;
1231:
1232: IF p_header_payment_rec.context = FND_API.G_MISS_CHAR THEN NULL;
1233: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.context,p_old_header_payment_rec.context) THEN
1234:
1235: l_result := CONTEXT
1236: (p_operation => l_operation

Line 1248: IF p_header_payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

1244: END IF;
1245:
1246: END IF;
1247:
1248: IF p_header_payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
1249: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute1,p_old_header_payment_rec.attribute1) THEN
1250:
1251: l_result := ATTRIBUTE1
1252: (p_operation => l_operation

Line 1264: IF p_header_payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

1260: END IF;
1261:
1262: END IF;
1263:
1264: IF p_header_payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
1265: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute10,p_old_header_payment_rec.attribute10) THEN
1266:
1267: l_result := ATTRIBUTE10
1268: (p_operation => l_operation

Line 1280: IF p_header_payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

1276: END IF;
1277:
1278: END IF;
1279:
1280: IF p_header_payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
1281: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute11,p_old_header_payment_rec.attribute11) THEN
1282:
1283: l_result := ATTRIBUTE11
1284: (p_operation => l_operation

Line 1296: IF p_header_payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

1292: END IF;
1293:
1294: END IF;
1295:
1296: IF p_header_payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
1297: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute12,p_old_header_payment_rec.attribute12) THEN
1298:
1299: l_result := ATTRIBUTE12
1300: (p_operation => l_operation

Line 1312: IF p_header_payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

1308: END IF;
1309:
1310: END IF;
1311:
1312: IF p_header_payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1313: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute13,p_old_header_payment_rec.attribute13) THEN
1314:
1315: l_result := ATTRIBUTE13
1316: (p_operation => l_operation

Line 1328: IF p_header_payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

1324: END IF;
1325:
1326: END IF;
1327:
1328: IF p_header_payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1329: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute14,p_old_header_payment_rec.attribute14) THEN
1330:
1331: l_result := ATTRIBUTE14
1332: (p_operation => l_operation

Line 1344: IF p_header_payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

1340: END IF;
1341:
1342: END IF;
1343:
1344: IF p_header_payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1345: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute15,p_old_header_payment_rec.attribute15) THEN
1346:
1347: l_result := ATTRIBUTE15
1348: (p_operation => l_operation

Line 1360: IF p_header_payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

1356: END IF;
1357:
1358: END IF;
1359:
1360: IF p_header_payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1361: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute2,p_old_header_payment_rec.attribute2) THEN
1362:
1363: l_result := ATTRIBUTE2
1364: (p_operation => l_operation

Line 1376: IF p_header_payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

1372: END IF;
1373:
1374: END IF;
1375:
1376: IF p_header_payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1377: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute3,p_old_header_payment_rec.attribute3) THEN
1378:
1379: l_result := ATTRIBUTE3
1380: (p_operation => l_operation

Line 1392: IF p_header_payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

1388: END IF;
1389:
1390: END IF;
1391:
1392: IF p_header_payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1393: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute4,p_old_header_payment_rec.attribute4) THEN
1394:
1395: l_result := ATTRIBUTE4
1396: (p_operation => l_operation

Line 1408: IF p_header_payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

1404: END IF;
1405:
1406: END IF;
1407:
1408: IF p_header_payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1409: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute5,p_old_header_payment_rec.attribute5) THEN
1410:
1411: l_result := ATTRIBUTE5
1412: (p_operation => l_operation

Line 1424: IF p_header_payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

1420: END IF;
1421:
1422: END IF;
1423:
1424: IF p_header_payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1425: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute6,p_old_header_payment_rec.attribute6) THEN
1426:
1427: l_result := ATTRIBUTE6
1428: (p_operation => l_operation

Line 1440: IF p_header_payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

1436: END IF;
1437:
1438: END IF;
1439:
1440: IF p_header_payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1441: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute7,p_old_header_payment_rec.attribute7) THEN
1442:
1443: l_result := ATTRIBUTE7
1444: (p_operation => l_operation

Line 1456: IF p_header_payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

1452: END IF;
1453:
1454: END IF;
1455:
1456: IF p_header_payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1457: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute8,p_old_header_payment_rec.attribute8) THEN
1458:
1459: l_result := ATTRIBUTE8
1460: (p_operation => l_operation

Line 1472: IF p_header_payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

1468: END IF;
1469:
1470: END IF;
1471:
1472: IF p_header_payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1473: ELSIF NOT OE_GLOBALS.EQUAL(p_header_payment_rec.attribute9,p_old_header_payment_rec.attribute9) THEN
1474:
1475: l_result := ATTRIBUTE9
1476: (p_operation => l_operation

Line 1504: WHEN FND_API.G_EXC_ERROR THEN

1500: oe_debug_pub.add( 'EXIT OE_HEADER_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
1501: END IF;
1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: WHEN OTHERS THEN
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1505: x_return_status := FND_API.G_RET_STS_ERROR;

1501: END IF;
1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: WHEN OTHERS THEN
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1509: OE_MSG_PUB.Add_Exc_Msg

Line 1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: WHEN OTHERS THEN
1507: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1508: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1509: OE_MSG_PUB.Add_Exc_Msg
1510: ( G_PKG_NAME
1511: , 'Attributes'