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

Line 69: RAISE FND_API.G_EXC_ERROR;

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

Line 75: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 728: x_return_status := FND_API.G_RET_STS_SUCCESS;

724: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ENTITY' , 1 ) ;
725: END IF;
726:
727: -- Initializing return status to SUCCESS
728: x_return_status := FND_API.G_RET_STS_SUCCESS;
729:
730: IF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
731: l_operation := OE_PC_GLOBALS.CREATE_OP;
732: ELSIF p_LINE_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 740: RAISE FND_API.G_EXC_ERROR;

736: ELSE
737: IF l_debug_level > 0 THEN
738: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
739: END IF;
740: RAISE FND_API.G_EXC_ERROR;
741: END IF;
742:
743: OE_Line_Scredit_Util.API_Rec_To_Rowtype_Rec
744: (p_LINE_SCREDIT_rec

Line 762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

758: END IF;
759:
760: EXCEPTION
761: WHEN OTHERS THEN
762: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
763: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
764: OE_MSG_PUB.Add_Exc_Msg
765: ( G_PKG_NAME
766: , 'Entity'

Line 796: x_return_status := FND_API.G_RET_STS_SUCCESS;

792: oe_debug_pub.add( 'ENTER OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
793: END IF;
794:
795: -- Initializing return status to SUCCESS
796: x_return_status := FND_API.G_RET_STS_SUCCESS;
797:
798: -- Initializing out result to NOT CONSTRAINED
799: x_result := OE_PC_GLOBALS.NO;
800:

Line 825: RAISE FND_API.G_EXC_ERROR;

821: ELSE
822: IF l_debug_level > 0 THEN
823: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
824: END IF;
825: RAISE FND_API.G_EXC_ERROR;
826: END IF;
827:
828: OE_Line_Scredit_Util.API_Rec_To_Rowtype_Rec
829: (p_LINE_SCREDIT_rec

Line 839: IF p_line_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;

835: -- Compare the new and old entity records and
836: -- check constraints for all the changed attributes.
837:
838:
839: IF p_line_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;
840: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.percent,p_old_line_scredit_rec.percent) THEN
841:
842: l_result := PERCENT
843: (p_operation => l_operation

Line 855: IF p_line_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;

851: END IF;
852:
853: END IF;
854:
855: IF p_line_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
856: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.salesrep_id,p_old_line_scredit_rec.salesrep_id) THEN
857:
858: l_result := SALESREP
859: (p_operation => l_operation

Line 871: IF p_line_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;

867: END IF;
868:
869: END IF;
870:
871: IF p_line_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;
872: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.dw_update_advice_flag, p_old_line_scredit_rec.dw_update_advice_flag) THEN
873:
874: l_result := DW_UPDATE_ADVICE
875: (p_operation => l_operation

Line 886: IF p_line_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;

882: END IF;
883:
884: END IF;
885:
886: IF p_line_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;
887: ELSIF NOT OE_GLOBALS.Equal(p_line_scredit_rec.wh_update_date, p_old_line_scredit_rec.wh_update_date) THEN
888:
889: l_result := WH_UPDATE_DATE
890: (p_operation => l_operation

Line 918: IF p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;

914: l_check_all_cols_constraint := g_check_all_cols_constraint;
915: g_check_all_cols_constraint := 'N';
916: END IF;
917:
918: IF p_line_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;
919: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.context,p_old_line_scredit_rec.context) THEN
920:
921: l_result := CONTEXT
922: (p_operation => l_operation

Line 934: IF p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

930: END IF;
931:
932: END IF;
933:
934: IF p_line_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
935: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute1,p_old_line_scredit_rec.attribute1) THEN
936:
937: l_result := ATTRIBUTE1
938: (p_operation => l_operation

Line 950: IF p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

946: END IF;
947:
948: END IF;
949:
950: IF p_line_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
951: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute10,p_old_line_scredit_rec.attribute10) THEN
952:
953: l_result := ATTRIBUTE10
954: (p_operation => l_operation

Line 966: IF p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

962: END IF;
963:
964: END IF;
965:
966: IF p_line_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
967: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute11,p_old_line_scredit_rec.attribute11) THEN
968:
969: l_result := ATTRIBUTE11
970: (p_operation => l_operation

Line 982: IF p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

978: END IF;
979:
980: END IF;
981:
982: IF p_line_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
983: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute12,p_old_line_scredit_rec.attribute12) THEN
984:
985: l_result := ATTRIBUTE12
986: (p_operation => l_operation

Line 998: IF p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

994: END IF;
995:
996: END IF;
997:
998: IF p_line_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
999: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute13,p_old_line_scredit_rec.attribute13) THEN
1000:
1001: l_result := ATTRIBUTE13
1002: (p_operation => l_operation

Line 1014: IF p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

1010: END IF;
1011:
1012: END IF;
1013:
1014: IF p_line_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1015: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute14,p_old_line_scredit_rec.attribute14) THEN
1016:
1017: l_result := ATTRIBUTE14
1018: (p_operation => l_operation

Line 1030: IF p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

1026: END IF;
1027:
1028: END IF;
1029:
1030: IF p_line_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1031: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute15,p_old_line_scredit_rec.attribute15) THEN
1032:
1033: l_result := ATTRIBUTE15
1034: (p_operation => l_operation

Line 1046: IF p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

1042: END IF;
1043:
1044: END IF;
1045:
1046: IF p_line_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1047: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute2,p_old_line_scredit_rec.attribute2) THEN
1048:
1049: l_result := ATTRIBUTE2
1050: (p_operation => l_operation

Line 1062: IF p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

1058: END IF;
1059:
1060: END IF;
1061:
1062: IF p_line_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1063: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute3,p_old_line_scredit_rec.attribute3) THEN
1064:
1065: l_result := ATTRIBUTE3
1066: (p_operation => l_operation

Line 1078: IF p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

1074: END IF;
1075:
1076: END IF;
1077:
1078: IF p_line_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1079: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute4,p_old_line_scredit_rec.attribute4) THEN
1080:
1081: l_result := ATTRIBUTE4
1082: (p_operation => l_operation

Line 1094: IF p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

1090: END IF;
1091:
1092: END IF;
1093:
1094: IF p_line_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1095: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute5,p_old_line_scredit_rec.attribute5) THEN
1096:
1097: l_result := ATTRIBUTE5
1098: (p_operation => l_operation

Line 1110: IF p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

1106: END IF;
1107:
1108: END IF;
1109:
1110: IF p_line_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1111: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute6,p_old_line_scredit_rec.attribute6) THEN
1112:
1113: l_result := ATTRIBUTE6
1114: (p_operation => l_operation

Line 1126: IF p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

1122: END IF;
1123:
1124: END IF;
1125:
1126: IF p_line_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1127: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute7,p_old_line_scredit_rec.attribute7) THEN
1128:
1129: l_result := ATTRIBUTE7
1130: (p_operation => l_operation

Line 1142: IF p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

1138: END IF;
1139:
1140: END IF;
1141:
1142: IF p_line_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1143: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute8,p_old_line_scredit_rec.attribute8) THEN
1144:
1145: l_result := ATTRIBUTE8
1146: (p_operation => l_operation

Line 1158: IF p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

1154: END IF;
1155:
1156: END IF;
1157:
1158: IF p_line_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1159: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.attribute9,p_old_line_scredit_rec.attribute9) THEN
1160:
1161: l_result := ATTRIBUTE9
1162: (p_operation => l_operation

Line 1174: IF p_line_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;

1170: END IF;
1171:
1172: END IF;
1173:
1174: IF p_line_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;
1175: ELSIF NOT OE_GLOBALS.EQUAL(p_line_scredit_rec.sales_credit_type_id,p_old_line_scredit_rec.sales_credit_type_id) THEN
1176:
1177: l_result := SALES_CREDIT_TYPE
1178: (p_operation => l_operation

Line 1206: WHEN FND_API.G_EXC_ERROR THEN

1202: oe_debug_pub.add( 'EXIT OE_LINE_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
1203: END IF;
1204:
1205: EXCEPTION
1206: WHEN FND_API.G_EXC_ERROR THEN
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1207: x_return_status := FND_API.G_RET_STS_ERROR;

1203: END IF;
1204:
1205: EXCEPTION
1206: WHEN FND_API.G_EXC_ERROR THEN
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1211: OE_MSG_PUB.Add_Exc_Msg

Line 1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1205: EXCEPTION
1206: WHEN FND_API.G_EXC_ERROR THEN
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: WHEN OTHERS THEN
1209: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1210: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1211: OE_MSG_PUB.Add_Exc_Msg
1212: ( G_PKG_NAME
1213: , 'Attributes'