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_LINE_PAYMENT_SECURITY dependencies on FND_API

Line 9: g_line_id NUMBER := FND_API.G_MISS_NUM;

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

Line 68: RAISE FND_API.G_EXC_ERROR;

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

Line 74: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 880: x_return_status := FND_API.G_RET_STS_SUCCESS;

876: oe_debug_pub.add( 'ENTER OE_LINE_PAYMENT_SECURITY.ENTITY' , 1 ) ;
877: END IF;
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

Line 892: RAISE FND_API.G_EXC_ERROR;

888: ELSE
889: IF l_debug_level > 0 THEN
890: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
891: END IF;
892: RAISE FND_API.G_EXC_ERROR;
893: END IF;
894:
895: OE_Line_Payment_Util.API_Rec_To_Rowtype_Rec
896: (p_LINE_PAYMENT_rec,

Line 914: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 948: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 977: RAISE FND_API.G_EXC_ERROR;

973: ELSE
974: IF l_debug_level > 0 THEN
975: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
976: END IF;
977: RAISE FND_API.G_EXC_ERROR;
978: END IF;
979:
980: OE_Line_Payment_Util.API_Rec_To_Rowtype_Rec
981: (p_LINE_PAYMENT_rec,

Line 990: IF p_line_payment_rec.payment_level_code = FND_API.G_MISS_CHAR THEN NULL;

986:
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

Line 1006: IF p_line_payment_rec.payment_type_code = FND_API.G_MISS_CHAR THEN NULL;

1002: END IF;
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

Line 1022: IF p_line_payment_rec.payment_trx_id = FND_API.G_MISS_NUM THEN NULL;

1018: END IF;
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

Line 1038: IF p_line_payment_rec.receipt_method_id = FND_API.G_MISS_NUM THEN NULL;

1034:
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

Line 1054: IF p_line_payment_rec.payment_collection_event = FND_API.G_MISS_CHAR THEN NULL;

1050:
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

Line 1070: IF p_line_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;

1066:
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

Line 1086: IF p_line_payment_rec.commitment_applied_amount = FND_API.G_MISS_NUM THEN NULL;

1082:
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

Line 1102: IF p_line_payment_rec.credit_card_code = FND_API.G_MISS_CHAR THEN NULL;

1098:
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

Line 1118: IF p_line_payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;

1114:
1115: END IF;
1116:
1117:
1118: IF p_line_payment_rec.credit_card_number = FND_API.G_MISS_CHAR THEN NULL;
1119: --R12 CC Encryption
1120: --Since the credit card numbers are encrypted, calling
1121: --the function same credit card to determine whether the old
1122: --and new card numbers are equal.

Line 1146: IF p_line_payment_rec.credit_card_holder_name = FND_API.G_MISS_CHAR THEN NULL;

1142:
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

Line 1162: IF p_line_payment_rec.credit_card_expiration_date = FND_API.G_MISS_DATE THEN NULL;

1158:
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

Line 1178: IF p_line_payment_rec.credit_card_approval_code = FND_API.G_MISS_CHAR THEN NULL;

1174:
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

Line 1194: IF p_line_payment_rec.credit_card_approval_date = FND_API.G_MISS_DATE THEN NULL;

1190:
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

Line 1210: IF p_line_payment_rec.check_number = FND_API.G_MISS_CHAR THEN NULL;

1206:
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

Line 1242: IF p_line_payment_rec.context = FND_API.G_MISS_CHAR THEN NULL;

1238: l_check_all_cols_constraint := g_check_all_cols_constraint;
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

Line 1258: IF p_line_payment_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

1254: END IF;
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

Line 1274: IF p_line_payment_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

1270: END IF;
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

Line 1290: IF p_line_payment_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

1286: END IF;
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

Line 1306: IF p_line_payment_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

1302: END IF;
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

Line 1322: IF p_line_payment_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

1318: END IF;
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

Line 1338: IF p_line_payment_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

1334: END IF;
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

Line 1354: IF p_line_payment_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

1350: END IF;
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

Line 1370: IF p_line_payment_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

1366: END IF;
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

Line 1386: IF p_line_payment_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

1382: END IF;
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

Line 1402: IF p_line_payment_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

1398: END IF;
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

Line 1418: IF p_line_payment_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

1414: END IF;
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

Line 1434: IF p_line_payment_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

1430: END IF;
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

Line 1450: IF p_line_payment_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

1446: END IF;
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

Line 1466: IF p_line_payment_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

1462: END IF;
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

Line 1482: IF p_line_payment_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

1478: END IF;
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

Line 1514: WHEN FND_API.G_EXC_ERROR THEN

1510: oe_debug_pub.add( 'EXIT OE_LINE_PAYMENT_SECURITY.ATTRIBUTES' , 1 ) ;
1511: END IF;
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1515: x_return_status := FND_API.G_RET_STS_ERROR;

1511: END IF;
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1519: OE_MSG_PUB.Add_Exc_Msg

Line 1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: x_return_status := FND_API.G_RET_STS_ERROR;
1516: WHEN OTHERS THEN
1517: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1518: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1519: OE_MSG_PUB.Add_Exc_Msg
1520: ( G_PKG_NAME
1521: , 'Attributes'