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_SCREDIT_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_Scredit_Security';
8:
9: g_header_id NUMBER := FND_API.G_MISS_NUM;
10:
11: -- LOCAL PROCEDURES
12:
13: FUNCTION Is_Op_Constrained

Line 79: RAISE FND_API.G_EXC_ERROR;

75: FROM oe_pc_constraints
76: WHERE constraint_id = l_constraint_id;
77: if l_constrained_column is null then
78: oe_debug_pub.add('There is an UPDATE constraint on all columns - Error',1);
79: RAISE FND_API.G_EXC_ERROR;
80: end if;
81: END IF;
82:
83: elsif l_result = OE_PC_GLOBALS.ERROR then

Line 85: raise FND_API.G_EXC_UNEXPECTED_ERROR;

81: END IF;
82:
83: elsif l_result = OE_PC_GLOBALS.ERROR then
84:
85: raise FND_API.G_EXC_UNEXPECTED_ERROR;
86:
87: end if;
88:
89: g_check_all_cols_constraint := 'N';

Line 738: x_return_status := FND_API.G_RET_STS_SUCCESS;

734: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ENTITY' , 1 ) ;
735: END IF;
736:
737: -- Initializing return status to SUCCESS
738: x_return_status := FND_API.G_RET_STS_SUCCESS;
739:
740: IF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_CREATE THEN
741: l_operation := OE_PC_GLOBALS.CREATE_OP;
742: ELSIF p_HEADER_SCREDIT_rec.operation = OE_GLOBALS.G_OPR_UPDATE THEN

Line 750: RAISE FND_API.G_EXC_ERROR;

746: ELSE
747: IF l_debug_level > 0 THEN
748: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
749: END IF;
750: RAISE FND_API.G_EXC_ERROR;
751: END IF;
752:
753: OE_Header_Scredit_Util.API_Rec_To_Rowtype_Rec
754: (p_HEADER_SCREDIT_rec,

Line 772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

768: END IF;
769:
770: EXCEPTION
771: WHEN OTHERS THEN
772: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
774: OE_MSG_PUB.Add_Exc_Msg
775: ( G_PKG_NAME
776: , 'Entity'

Line 806: x_return_status := FND_API.G_RET_STS_SUCCESS;

802: oe_debug_pub.add( 'ENTER OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
803: END IF;
804:
805: -- Initializing return status to SUCCESS
806: x_return_status := FND_API.G_RET_STS_SUCCESS;
807:
808: -- Initializing out result to NOT CONSTRAINED
809: x_result := OE_PC_GLOBALS.NO;
810:

Line 835: RAISE FND_API.G_EXC_ERROR;

831: ELSE
832: IF l_debug_level > 0 THEN
833: oe_debug_pub.add( 'INVALID OPERATION' , 1 ) ;
834: END IF;
835: RAISE FND_API.G_EXC_ERROR;
836: END IF;
837:
838: OE_Header_Scredit_Util.API_Rec_To_Rowtype_Rec
839: (p_HEADER_SCREDIT_rec,

Line 848: IF p_header_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;

844:
845: -- Compare the new and old entity records and
846: -- check constraints for all the changed attributes.
847:
848: IF p_header_scredit_rec.percent = FND_API.G_MISS_NUM THEN NULL;
849: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.percent,p_old_header_scredit_rec.percent) THEN
850:
851: l_result := PERCENT
852: (p_operation => l_operation

Line 864: IF p_header_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;

860: END IF;
861:
862: END IF;
863:
864: IF p_header_scredit_rec.salesrep_id = FND_API.G_MISS_NUM THEN NULL;
865: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.salesrep_id,p_old_header_scredit_rec.salesrep_id) THEN
866:
867: l_result := SALESREP
868: (p_operation => l_operation

Line 880: IF p_header_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;

876: END IF;
877:
878: END IF;
879:
880: IF p_header_scredit_rec.dw_update_advice_flag = FND_API.G_MISS_CHAR THEN NULL;
881: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.dw_update_advice_flag, p_old_header_scredit_rec.dw_update_advice_flag) THEN
882:
883: l_result := DW_UPDATE_ADVICE
884: (p_operation => l_operation

Line 896: IF p_header_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;

892:
893: END IF;
894:
895:
896: IF p_header_scredit_rec.wh_update_date = FND_API.G_MISS_DATE THEN NULL;
897: ELSIF NOT OE_GLOBALS.Equal(p_header_scredit_rec.wh_update_date, p_old_header_scredit_rec.wh_update_date) THEN
898:
899: l_result := WH_UPDATE_DATE
900: (p_operation => l_operation

Line 928: IF p_header_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;

924: l_check_all_cols_constraint := g_check_all_cols_constraint;
925: g_check_all_cols_constraint := 'N';
926: END IF;
927:
928: IF p_header_scredit_rec.context = FND_API.G_MISS_CHAR THEN NULL;
929: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.context,p_old_header_scredit_rec.context) THEN
930:
931: l_result := CONTEXT
932: (p_operation => l_operation

Line 944: IF p_header_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;

940: END IF;
941:
942: END IF;
943:
944: IF p_header_scredit_rec.attribute1 = FND_API.G_MISS_CHAR THEN NULL;
945: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute1,p_old_header_scredit_rec.attribute1) THEN
946:
947: l_result := ATTRIBUTE1
948: (p_operation => l_operation

Line 960: IF p_header_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;

956: END IF;
957:
958: END IF;
959:
960: IF p_header_scredit_rec.attribute10 = FND_API.G_MISS_CHAR THEN NULL;
961: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute10,p_old_header_scredit_rec.attribute10) THEN
962:
963: l_result := ATTRIBUTE10
964: (p_operation => l_operation

Line 976: IF p_header_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;

972: END IF;
973:
974: END IF;
975:
976: IF p_header_scredit_rec.attribute11 = FND_API.G_MISS_CHAR THEN NULL;
977: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute11,p_old_header_scredit_rec.attribute11) THEN
978:
979: l_result := ATTRIBUTE11
980: (p_operation => l_operation

Line 992: IF p_header_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;

988: END IF;
989:
990: END IF;
991:
992: IF p_header_scredit_rec.attribute12 = FND_API.G_MISS_CHAR THEN NULL;
993: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute12,p_old_header_scredit_rec.attribute12) THEN
994:
995: l_result := ATTRIBUTE12
996: (p_operation => l_operation

Line 1008: IF p_header_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;

1004: END IF;
1005:
1006: END IF;
1007:
1008: IF p_header_scredit_rec.attribute13 = FND_API.G_MISS_CHAR THEN NULL;
1009: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute13,p_old_header_scredit_rec.attribute13) THEN
1010:
1011: l_result := ATTRIBUTE13
1012: (p_operation => l_operation

Line 1024: IF p_header_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;

1020: END IF;
1021:
1022: END IF;
1023:
1024: IF p_header_scredit_rec.attribute14 = FND_API.G_MISS_CHAR THEN NULL;
1025: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute14,p_old_header_scredit_rec.attribute14) THEN
1026:
1027: l_result := ATTRIBUTE14
1028: (p_operation => l_operation

Line 1040: IF p_header_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;

1036: END IF;
1037:
1038: END IF;
1039:
1040: IF p_header_scredit_rec.attribute15 = FND_API.G_MISS_CHAR THEN NULL;
1041: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute15,p_old_header_scredit_rec.attribute15) THEN
1042:
1043: l_result := ATTRIBUTE15
1044: (p_operation => l_operation

Line 1056: IF p_header_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;

1052: END IF;
1053:
1054: END IF;
1055:
1056: IF p_header_scredit_rec.attribute2 = FND_API.G_MISS_CHAR THEN NULL;
1057: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute2,p_old_header_scredit_rec.attribute2) THEN
1058:
1059: l_result := ATTRIBUTE2
1060: (p_operation => l_operation

Line 1072: IF p_header_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;

1068: END IF;
1069:
1070: END IF;
1071:
1072: IF p_header_scredit_rec.attribute3 = FND_API.G_MISS_CHAR THEN NULL;
1073: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute3,p_old_header_scredit_rec.attribute3) THEN
1074:
1075: l_result := ATTRIBUTE3
1076: (p_operation => l_operation

Line 1088: IF p_header_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;

1084: END IF;
1085:
1086: END IF;
1087:
1088: IF p_header_scredit_rec.attribute4 = FND_API.G_MISS_CHAR THEN NULL;
1089: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute4,p_old_header_scredit_rec.attribute4) THEN
1090:
1091: l_result := ATTRIBUTE4
1092: (p_operation => l_operation

Line 1104: IF p_header_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;

1100: END IF;
1101:
1102: END IF;
1103:
1104: IF p_header_scredit_rec.attribute5 = FND_API.G_MISS_CHAR THEN NULL;
1105: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute5,p_old_header_scredit_rec.attribute5) THEN
1106:
1107: l_result := ATTRIBUTE5
1108: (p_operation => l_operation

Line 1120: IF p_header_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;

1116: END IF;
1117:
1118: END IF;
1119:
1120: IF p_header_scredit_rec.attribute6 = FND_API.G_MISS_CHAR THEN NULL;
1121: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute6,p_old_header_scredit_rec.attribute6) THEN
1122:
1123: l_result := ATTRIBUTE6
1124: (p_operation => l_operation

Line 1136: IF p_header_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;

1132: END IF;
1133:
1134: END IF;
1135:
1136: IF p_header_scredit_rec.attribute7 = FND_API.G_MISS_CHAR THEN NULL;
1137: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute7,p_old_header_scredit_rec.attribute7) THEN
1138:
1139: l_result := ATTRIBUTE7
1140: (p_operation => l_operation

Line 1152: IF p_header_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;

1148: END IF;
1149:
1150: END IF;
1151:
1152: IF p_header_scredit_rec.attribute8 = FND_API.G_MISS_CHAR THEN NULL;
1153: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute8,p_old_header_scredit_rec.attribute8) THEN
1154:
1155: l_result := ATTRIBUTE8
1156: (p_operation => l_operation

Line 1168: IF p_header_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;

1164: END IF;
1165:
1166: END IF;
1167:
1168: IF p_header_scredit_rec.attribute9 = FND_API.G_MISS_CHAR THEN NULL;
1169: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.attribute9,p_old_header_scredit_rec.attribute9) THEN
1170:
1171: l_result := ATTRIBUTE9
1172: (p_operation => l_operation

Line 1184: IF p_header_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;

1180: END IF;
1181:
1182: END IF;
1183:
1184: IF p_header_scredit_rec.sales_credit_type_id = FND_API.G_MISS_NUM THEN NULL;
1185: ELSIF NOT OE_GLOBALS.EQUAL(p_header_scredit_rec.sales_credit_type_id,p_old_header_scredit_rec.sales_credit_type_id) THEN
1186:
1187: l_result := SALES_CREDIT_TYPE
1188: (p_operation => l_operation

Line 1216: WHEN FND_API.G_EXC_ERROR THEN

1212: oe_debug_pub.add( 'EXIT OE_HEADER_SCREDIT_SECURITY.ATTRIBUTES' , 1 ) ;
1213: END IF;
1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: WHEN OTHERS THEN
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR;

1213: END IF;
1214:
1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: WHEN OTHERS THEN
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1221: OE_MSG_PUB.Add_Exc_Msg

Line 1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1215: EXCEPTION
1216: WHEN FND_API.G_EXC_ERROR THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: WHEN OTHERS THEN
1219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1220: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1221: OE_MSG_PUB.Add_Exc_Msg
1222: ( G_PKG_NAME
1223: , 'Attributes'