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

Line 32: x_return_Status:= FND_API.G_RET_STS_UNEXP_ERROR;

28: OPEN get_lookup_type_code(p_lookup_code,p_lookup_type);
29: FETCH get_lookup_type_code INTO l_lookup_code;
30: IF get_lookup_type_code%NOTFOUND
31: THEN
32: x_return_Status:= FND_API.G_RET_STS_UNEXP_ERROR;
33: END IF;
34: close GET_LOOKUP_TYPE_CODE;
35: end;
36:

Line 46: IF p_x_mr_relation_tbl(I).RELATIONSHIP_CODE= FND_API.G_MISS_CHAR

42: IF P_X_MR_relation_TBL.COUNT>0
43: THEN
44: FOR i IN P_X_MR_relation_TBL.FIRST.. P_X_MR_relation_TBL.LAST
45: LOOP
46: IF p_x_mr_relation_tbl(I).RELATIONSHIP_CODE= FND_API.G_MISS_CHAR
47: THEN
48: p_x_mr_relation_tbl(I).RELATIONSHIP_CODE:=NULL;
49: END IF;
50:

Line 51: IF p_x_mr_relation_tbl(I).MR_HEADER_ID= FND_API.G_MISS_NUM

47: THEN
48: p_x_mr_relation_tbl(I).RELATIONSHIP_CODE:=NULL;
49: END IF;
50:
51: IF p_x_mr_relation_tbl(I).MR_HEADER_ID= FND_API.G_MISS_NUM
52: THEN
53: p_x_mr_relation_tbl(I).MR_HEADER_ID:=NULL;
54: END IF;
55:

Line 56: IF p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID= FND_API.G_MISS_NUM

52: THEN
53: p_x_mr_relation_tbl(I).MR_HEADER_ID:=NULL;
54: END IF;
55:
56: IF p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID= FND_API.G_MISS_NUM
57: THEN
58: p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID:=NULL;
59: END IF;
60:

Line 61: IF p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID= FND_API.G_MISS_NUM

57: THEN
58: p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID:=NULL;
59: END IF;
60:
61: IF p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID= FND_API.G_MISS_NUM
62: THEN
63: p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID:=NULL;
64: END IF;
65:

Line 66: IF p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

62: THEN
63: p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID:=NULL;
64: END IF;
65:
66: IF p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
67: THEN
68: IF p_x_mr_relation_tbl(i).dml_operation='C'
69: THEN
70: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;

Line 76: IF p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

72: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=NULL;
73: END IF;
74: END IF;
75:
76: IF p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
77: THEN
78: p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY:=NULL;
79: END IF;
80:

Line 81: IF p_x_mr_relation_tbl(i).ATTRIBUTE1=FND_API.G_MISS_CHAR

77: THEN
78: p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY:=NULL;
79: END IF;
80:
81: IF p_x_mr_relation_tbl(i).ATTRIBUTE1=FND_API.G_MISS_CHAR
82: THEN
83: p_x_mr_relation_tbl(i).ATTRIBUTE1:=NULL;
84: END IF;
85:

Line 86: IF p_x_mr_relation_tbl(i).ATTRIBUTE2=FND_API.G_MISS_CHAR

82: THEN
83: p_x_mr_relation_tbl(i).ATTRIBUTE1:=NULL;
84: END IF;
85:
86: IF p_x_mr_relation_tbl(i).ATTRIBUTE2=FND_API.G_MISS_CHAR
87: THEN
88: p_x_mr_relation_tbl(i).ATTRIBUTE2:=NULL;
89: END IF;
90:

Line 91: IF p_x_mr_relation_tbl(i).ATTRIBUTE3=FND_API.G_MISS_CHAR

87: THEN
88: p_x_mr_relation_tbl(i).ATTRIBUTE2:=NULL;
89: END IF;
90:
91: IF p_x_mr_relation_tbl(i).ATTRIBUTE3=FND_API.G_MISS_CHAR
92: THEN
93: p_x_mr_relation_tbl(i).ATTRIBUTE3:=NULL;
94: END IF;
95:

Line 96: IF p_x_mr_relation_tbl(i).ATTRIBUTE4 IS NULL OR p_x_mr_relation_tbl(i).ATTRIBUTE4=FND_API.G_MISS_CHAR

92: THEN
93: p_x_mr_relation_tbl(i).ATTRIBUTE3:=NULL;
94: END IF;
95:
96: IF p_x_mr_relation_tbl(i).ATTRIBUTE4 IS NULL OR p_x_mr_relation_tbl(i).ATTRIBUTE4=FND_API.G_MISS_CHAR
97: THEN
98: p_x_mr_relation_tbl(i).ATTRIBUTE4:=NULL;
99: END IF;
100:

Line 101: IF p_x_mr_relation_tbl(i).ATTRIBUTE5=FND_API.G_MISS_CHAR

97: THEN
98: p_x_mr_relation_tbl(i).ATTRIBUTE4:=NULL;
99: END IF;
100:
101: IF p_x_mr_relation_tbl(i).ATTRIBUTE5=FND_API.G_MISS_CHAR
102: THEN
103: p_x_mr_relation_tbl(i).ATTRIBUTE5:=NULL;
104: END IF;
105:

Line 106: IF p_x_mr_relation_tbl(i).ATTRIBUTE6=FND_API.G_MISS_CHAR

102: THEN
103: p_x_mr_relation_tbl(i).ATTRIBUTE5:=NULL;
104: END IF;
105:
106: IF p_x_mr_relation_tbl(i).ATTRIBUTE6=FND_API.G_MISS_CHAR
107: THEN
108: p_x_mr_relation_tbl(i).ATTRIBUTE6:=NULL;
109: END IF;
110:

Line 111: IF p_x_mr_relation_tbl(i).ATTRIBUTE7=FND_API.G_MISS_CHAR

107: THEN
108: p_x_mr_relation_tbl(i).ATTRIBUTE6:=NULL;
109: END IF;
110:
111: IF p_x_mr_relation_tbl(i).ATTRIBUTE7=FND_API.G_MISS_CHAR
112: THEN
113: p_x_mr_relation_tbl(i).ATTRIBUTE7:=NULL;
114: END IF;
115:

Line 116: IF p_x_mr_relation_tbl(i).ATTRIBUTE8=FND_API.G_MISS_CHAR

112: THEN
113: p_x_mr_relation_tbl(i).ATTRIBUTE7:=NULL;
114: END IF;
115:
116: IF p_x_mr_relation_tbl(i).ATTRIBUTE8=FND_API.G_MISS_CHAR
117: THEN
118: p_x_mr_relation_tbl(i).ATTRIBUTE8:=NULL;
119: END IF;
120:

Line 121: IF p_x_mr_relation_tbl(i).ATTRIBUTE9=FND_API.G_MISS_CHAR

117: THEN
118: p_x_mr_relation_tbl(i).ATTRIBUTE8:=NULL;
119: END IF;
120:
121: IF p_x_mr_relation_tbl(i).ATTRIBUTE9=FND_API.G_MISS_CHAR
122: THEN
123: p_x_mr_relation_tbl(i).ATTRIBUTE9:=NULL;
124: END IF;
125:

Line 126: IF p_x_mr_relation_tbl(i).ATTRIBUTE10=FND_API.G_MISS_CHAR

122: THEN
123: p_x_mr_relation_tbl(i).ATTRIBUTE9:=NULL;
124: END IF;
125:
126: IF p_x_mr_relation_tbl(i).ATTRIBUTE10=FND_API.G_MISS_CHAR
127: THEN
128: p_x_mr_relation_tbl(i).ATTRIBUTE10:=NULL;
129: END IF;
130:

Line 131: IF p_x_mr_relation_tbl(i).ATTRIBUTE11=FND_API.G_MISS_CHAR

127: THEN
128: p_x_mr_relation_tbl(i).ATTRIBUTE10:=NULL;
129: END IF;
130:
131: IF p_x_mr_relation_tbl(i).ATTRIBUTE11=FND_API.G_MISS_CHAR
132: THEN
133: p_x_mr_relation_tbl(i).ATTRIBUTE11:=NULL;
134: END IF;
135:

Line 136: IF p_x_mr_relation_tbl(i).ATTRIBUTE12=FND_API.G_MISS_CHAR

132: THEN
133: p_x_mr_relation_tbl(i).ATTRIBUTE11:=NULL;
134: END IF;
135:
136: IF p_x_mr_relation_tbl(i).ATTRIBUTE12=FND_API.G_MISS_CHAR
137: THEN
138: p_x_mr_relation_tbl(i).ATTRIBUTE12:=NULL;
139: END IF;
140:

Line 141: IF p_x_mr_relation_tbl(i).ATTRIBUTE13=FND_API.G_MISS_CHAR

137: THEN
138: p_x_mr_relation_tbl(i).ATTRIBUTE12:=NULL;
139: END IF;
140:
141: IF p_x_mr_relation_tbl(i).ATTRIBUTE13=FND_API.G_MISS_CHAR
142: THEN
143: p_x_mr_relation_tbl(i).ATTRIBUTE13:=NULL;
144: END IF;
145:

Line 146: IF p_x_mr_relation_tbl(i).ATTRIBUTE14=FND_API.G_MISS_CHAR

142: THEN
143: p_x_mr_relation_tbl(i).ATTRIBUTE13:=NULL;
144: END IF;
145:
146: IF p_x_mr_relation_tbl(i).ATTRIBUTE14=FND_API.G_MISS_CHAR
147: THEN
148: p_x_mr_relation_tbl(i).ATTRIBUTE14:=NULL;
149: END IF;
150:

Line 151: IF p_x_mr_relation_tbl(i).ATTRIBUTE15=FND_API.G_MISS_CHAR

147: THEN
148: p_x_mr_relation_tbl(i).ATTRIBUTE14:=NULL;
149: END IF;
150:
151: IF p_x_mr_relation_tbl(i).ATTRIBUTE15=FND_API.G_MISS_CHAR
152: THEN
153: p_x_mr_relation_tbl(i).ATTRIBUTE15:=NULL;
154: END IF;
155: END LOOP;

Line 190: x_return_status:=FND_API.G_RET_STS_SUCCESS;

186: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
187: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
188: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
189: BEGIN
190: x_return_status:=FND_API.G_RET_STS_SUCCESS;
191:
192: IF G_DEBUG='Y' THEN
193: AHL_DEBUG_PUB.enable_debug;
194: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');

Line 197: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM

193: AHL_DEBUG_PUB.enable_debug;
194: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
195: END IF;
196:
197: IF p_x_mr_relation_rec.MR_HEADER_ID IS NOT NULL OR p_x_mr_relation_rec.MR_HEADER_ID<>FND_API.G_MISS_NUM
198: THEN
199: SELECT TYPE_CODE INTO L_TYPE_CODE
200: FROM AHL_MR_HEADERS_B
201: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;

Line 204: IF p_x_mr_relation_rec.RELATED_MR_TITLE IS NULL OR p_x_mr_relation_rec.RELATED_MR_TITLE=FND_API.G_MISS_CHAR

200: FROM AHL_MR_HEADERS_B
201: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
202: END IF;
203:
204: IF p_x_mr_relation_rec.RELATED_MR_TITLE IS NULL OR p_x_mr_relation_rec.RELATED_MR_TITLE=FND_API.G_MISS_CHAR
205: THEN
206: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TITLE_NULL');
207: FND_MSG_PUB.ADD;
208: check_flag:='N';

Line 216: p_x_mr_relation_rec.related_mr_header_id<>fnd_api.g_miss_num

212:
213: IF check_flag='Y'
214: THEN
215: IF p_x_mr_relation_rec.related_mr_header_id is not null and
216: p_x_mr_relation_rec.related_mr_header_id<>fnd_api.g_miss_num
217: THEN
218: open c_mr_header_id_to_relmr_title(p_x_mr_relation_rec.related_mr_header_id,l_type_code);
219: fetch c_mr_header_id_to_relmr_title into l_title;
220: close c_mr_header_id_to_relmr_title;

Line 252: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

248:
249: PROCEDURE NON_CYCLIC_ENF
250: (
251: p_api_version IN NUMBER:=1.0,
252: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
253: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,

Line 253: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,

249: PROCEDURE NON_CYCLIC_ENF
250: (
251: p_api_version IN NUMBER:=1.0,
252: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
253: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
254: x_return_status OUT NOCOPY VARCHAR2,
255: x_msg_count OUT NOCOPY NUMBER,
256: x_msg_data OUT NOCOPY VARCHAR2,
257: P_MR_HEADER_ID IN NUMBER,

Line 268: x_return_status:=FND_API.G_RET_STS_SUCCESS;

264: l_cyclic_loop EXCEPTION;
265: PRAGMA EXCEPTION_INIT(l_cyclic_loop,-1436);
266: l_counter NUMBER;
267: BEGIN
268: x_return_status:=FND_API.G_RET_STS_SUCCESS;
269:
270: SELECT COUNT(*) INTO l_counter
271: FROM AHL_MR_RELATIONSHIPS
272: WHERE RELATIONSHIP_CODE = P_RELATIONSHIP_CODE -- pdoki added for SBE Project

Line 280: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

276: WHEN l_cyclic_loop THEN
277: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATION_CYCLIC');
278: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
279: FND_MSG_PUB.ADD;
280: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,

Line 281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

277: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATION_CYCLIC');
278: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
279: FND_MSG_PUB.ADD;
280: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);

Line 282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

278: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
279: FND_MSG_PUB.ADD;
280: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:

Line 283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

279: FND_MSG_PUB.ADD;
280: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
281: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
282: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:
287: WHEN FND_API.G_EXC_ERROR THEN

Line 287: WHEN FND_API.G_EXC_ERROR THEN

283: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:
287: WHEN FND_API.G_EXC_ERROR THEN
288: X_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => X_msg_data);

Line 288: X_return_status := FND_API.G_RET_STS_ERROR;

284: p_count => x_msg_count,
285: p_data => x_msg_data);
286:
287: WHEN FND_API.G_EXC_ERROR THEN
288: X_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => X_msg_data);
292: WHEN OTHERS THEN

Line 289: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

285: p_data => x_msg_data);
286:
287: WHEN FND_API.G_EXC_ERROR THEN
288: X_return_status := FND_API.G_RET_STS_ERROR;
289: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => X_msg_data);
292: WHEN OTHERS THEN
293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

289: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
290: p_count => x_msg_count,
291: p_data => X_msg_data);
292: WHEN OTHERS THEN
293: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
294: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
295: THEN
296: fnd_msg_pub.add_exc_msg(p_pkg_name =>'AHL_FMP_MR_RELATION_PVT',
297: p_procedure_name =>'NON_CYCLIC_ENF',

Line 300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,

296: fnd_msg_pub.add_exc_msg(p_pkg_name =>'AHL_FMP_MR_RELATION_PVT',
297: p_procedure_name =>'NON_CYCLIC_ENF',
298: p_error_text =>SUBSTR(SQLERRM,1,240));
299: END IF;
300: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
301: p_count => x_msg_count,
302: p_data => X_msg_data);
303: END;
304:

Line 411: x_return_status:=FND_API.G_RET_STS_SUCCESS;

407: l_mr_header_id NUMBER:=0;
408: l_mr_check_flag VARCHAR2(1):='N';
409: l_return_status VARCHAR2(1);
410: BEGIN
411: x_return_status:=FND_API.G_RET_STS_SUCCESS;
412: IF G_DEBUG='Y' THEN
413: AHL_DEBUG_PUB.enable_debug;
414: END IF;
415: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or

Line 416: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM

412: IF G_DEBUG='Y' THEN
413: AHL_DEBUG_PUB.enable_debug;
414: END IF;
415: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or
416: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
417: THEN
418: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
419: FND_MSG_PUB.ADD;
420: ELSE

Line 462: p_mr_relation_rec.RELATED_MR_HEADER_ID=FND_API.G_MISS_NUM

458: THEN
459: IF p_mr_relation_rec.dml_operation<>'D'
460: THEN
461: IF p_mr_relation_rec.RELATED_MR_HEADER_ID IS NULL OR
462: p_mr_relation_rec.RELATED_MR_HEADER_ID=FND_API.G_MISS_NUM
463: THEN
464: FND_MESSAGE.SET_NAME('AHL','AHL_MR_HEADER_ID_NULL');
465: FND_MSG_PUB.ADD;
466: ELSE

Line 507: p_mr_relation_rec.MR_RELATIONSHIP_ID=FND_API.G_MISS_NUM)

503:
504: IF p_mr_relation_rec.dml_operation<>'C'
505: THEN
506: IF (p_mr_relation_rec.MR_RELATIONSHIP_ID IS NULL OR
507: p_mr_relation_rec.MR_RELATIONSHIP_ID=FND_API.G_MISS_NUM)
508: THEN
509: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATIONSHIPID_NULL');
510: FND_MESSAGE.SET_TOKEN('RECORD', p_mr_relation_rec.RELATED_MR_TITLE,false);
511: FND_MSG_PUB.ADD;

Line 515: p_mr_relation_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_NUM)

511: FND_MSG_PUB.ADD;
512: END IF;
513:
514: IF (p_mr_relation_rec.OBJECT_VERSION_NUMBER IS NULL OR
515: p_mr_relation_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_NUM)
516: THEN
517: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_REL_OBJ_VERSION_NULL');
518: FND_MESSAGE.SET_TOKEN('RECORD', p_mr_relation_rec.RELATED_MR_TITLE,false);
519: FND_MSG_PUB.ADD;

Line 527: IF p_mr_relation_rec.relationship_code IS NOT NULL OR p_mr_relation_rec.relationship_code<>FND_API.G_MISS_CHAR

523:
524: IF p_mr_relation_rec.dml_operation<>'D'
525: THEN
526: -- pdoki added for SBE Project, Start.
527: IF p_mr_relation_rec.relationship_code IS NOT NULL OR p_mr_relation_rec.relationship_code<>FND_API.G_MISS_CHAR
528: THEN
529:
530: CHECK_LOOKUP_CODE
531: (

Line 837: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,

833:
834: PROCEDURE PROCESS_MR_RELATION
835: (
836: p_api_version IN NUMBER:= 1.0,
837: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
839: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
840: p_default IN VARCHAR2:= FND_API.G_FALSE,
841: p_module_type IN VARCHAR2 := NULL,

Line 838: p_commit IN VARCHAR2 := FND_API.G_FALSE,

834: PROCEDURE PROCESS_MR_RELATION
835: (
836: p_api_version IN NUMBER:= 1.0,
837: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
839: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
840: p_default IN VARCHAR2:= FND_API.G_FALSE,
841: p_module_type IN VARCHAR2 := NULL,
842: x_return_status OUT NOCOPY VARCHAR2,

Line 839: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,

835: (
836: p_api_version IN NUMBER:= 1.0,
837: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
839: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
840: p_default IN VARCHAR2:= FND_API.G_FALSE,
841: p_module_type IN VARCHAR2 := NULL,
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,

Line 840: p_default IN VARCHAR2:= FND_API.G_FALSE,

836: p_api_version IN NUMBER:= 1.0,
837: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
838: p_commit IN VARCHAR2 := FND_API.G_FALSE,
839: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
840: p_default IN VARCHAR2:= FND_API.G_FALSE,
841: p_module_type IN VARCHAR2 := NULL,
842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_count OUT NOCOPY NUMBER,
844: x_msg_data OUT NOCOPY VARCHAR2,

Line 852: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;

848: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MR_RELATION';
849: l_api_version CONSTANT NUMBER := 1.0;
850: l_msg_count NUMBER;
851: l_msg_data VARCHAR2(2000);
852: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
853: l_mr_header_id NUMBER:=0;
854: l_mr_relation_rec MR_RELATION_REC;
855: l_mr_title AHL_MR_HEADERS_B.TITLE%TYPE;
856: BEGIN

Line 861: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

857:
858:
859: SAVEPOINT PROCESS_MR_RELATION;
860:
861: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
862: p_api_version,
863: l_api_name,G_PKG_NAME) THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;

Line 864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

860:
861: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
862: p_api_version,
863: l_api_name,G_PKG_NAME) THEN
864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867:
868: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 868: IF FND_API.to_boolean(p_init_msg_list) THEN

864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
865: END IF;
866:
867:
868: IF FND_API.to_boolean(p_init_msg_list) THEN
869: FND_MSG_PUB.initialize;
870: END IF;
871:
872:

Line 873: x_return_status:=FND_API.G_RET_STS_SUCCESS;

869: FND_MSG_PUB.initialize;
870: END IF;
871:
872:
873: x_return_status:=FND_API.G_RET_STS_SUCCESS;
874:
875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.enable_debug;
877: END IF;

Line 879: IF FND_API.to_boolean(p_default)

875: IF G_DEBUG='Y' THEN
876: AHL_DEBUG_PUB.enable_debug;
877: END IF;
878: /*
879: IF FND_API.to_boolean(p_default)
880: THEN
881: DEFAULT_MISSING_ATTRIBS
882: (
883: p_x_mr_relation_tbl =>p_x_mr_relation_tbl

Line 901: p_x_mr_relation_tbl(i).mr_header_id = FND_API.G_MISS_NUM

897: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
898: LOOP
899: IF (
900: p_x_mr_relation_tbl(i).mr_header_id IS NULL OR
901: p_x_mr_relation_tbl(i).mr_header_id = FND_API.G_MISS_NUM
902: )
903: THEN
904: -- Function to convert mr_title,mr_version_number to id
905: AHL_FMP_COMMON_PVT.mr_title_version_to_id(

Line 911: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

907: p_mr_version_number => p_x_mr_relation_tbl(i).mr_version_number,
908: x_mr_header_id => p_x_mr_relation_tbl(i).mr_header_id,
909: x_return_status => x_return_status
910: );
911: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
912: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
913: fnd_log.string
914: (
915: fnd_log.level_statement,

Line 920: RAISE FND_API.G_EXC_ERROR;

916: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
917: 'Invalid MR Title, Version Number provided'
918: );
919: END IF;
920: RAISE FND_API.G_EXC_ERROR;
921: END IF;
922: END IF;
923: END LOOP;
924:

Line 926: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

922: END IF;
923: END LOOP;
924:
925: --Start of API Body
926: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
927: THEN
928:
929: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
930: LOOP

Line 949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

945: l_msg_count := FND_MSG_PUB.count_msg;
946: IF l_msg_count > 0
947: THEN
948: X_msg_count := l_msg_count;
949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: END IF;
953:

Line 950: RAISE FND_API.G_EXC_ERROR;

946: IF l_msg_count > 0
947: THEN
948: X_msg_count := l_msg_count;
949: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
950: RAISE FND_API.G_EXC_ERROR;
951: END IF;
952: END IF;
953:
954: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST

Line 957: x_return_status:=FND_API.G_RET_STS_SUCCESS;

953:
954: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
955: LOOP
956:
957: x_return_status:=FND_API.G_RET_STS_SUCCESS;
958:
959: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
960: THEN
961:

Line 959: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

955: LOOP
956:
957: x_return_status:=FND_API.G_RET_STS_SUCCESS;
958:
959: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
960: THEN
961:
962: VALIDATE_MR_RELATION
963: (

Line 971: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

967: END IF;
968: l_msg_count := FND_MSG_PUB.count_msg;
969: IF l_msg_count > 0
970: THEN
971: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
972: END IF;
973:
974: IF p_x_mr_relation_tbl(i).DML_operation<>'D'
975: THEN

Line 1027: IF x_return_status=FND_API.G_RET_STS_SUCCESS

1023: end if;
1024: ELSIF p_x_mr_relation_tbl(i).DML_operation='U'
1025: then
1026:
1027: IF x_return_status=FND_API.G_RET_STS_SUCCESS
1028: THEN
1029:
1030: update AHL_mr_RELATIONSHIPS
1031: set MR_HEADER_ID = p_x_mr_relation_tbl(i).MR_HEADER_ID,

Line 1073: IF x_return_status=FND_API.G_RET_STS_SUCCESS

1069: FROM DUAL;
1070:
1071: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;
1072:
1073: IF x_return_status=FND_API.G_RET_STS_SUCCESS
1074: THEN
1075: insert into AHl_mr_RELATIONSHIPS(
1076: MR_RELATIONSHIP_ID,
1077: OBJECT_VERSION_NUMBER,

Line 1154: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1150:
1151: l_msg_count := FND_MSG_PUB.count_msg;
1152: IF l_msg_count > 0 THEN
1153: X_msg_count := l_msg_count;
1154: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:
1158: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1155: RAISE FND_API.G_EXC_ERROR;

1151: l_msg_count := FND_MSG_PUB.count_msg;
1152: IF l_msg_count > 0 THEN
1153: X_msg_count := l_msg_count;
1154: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:
1158: IF FND_API.TO_BOOLEAN(p_commit) THEN
1159: COMMIT;

Line 1158: IF FND_API.TO_BOOLEAN(p_commit) THEN

1154: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1155: RAISE FND_API.G_EXC_ERROR;
1156: END IF;
1157:
1158: IF FND_API.TO_BOOLEAN(p_commit) THEN
1159: COMMIT;
1160: END IF;
1161:
1162: IF G_DEBUG='Y' THEN

Line 1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1163: AHL_DEBUG_PUB.disable_debug;
1164: END IF;
1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO PROCESS_MR_RELATION;
1169: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1171: p_count => x_msg_count,

Line 1169: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1165:
1166: EXCEPTION
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO PROCESS_MR_RELATION;
1169: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:

Line 1170: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1166: EXCEPTION
1167: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1168: ROLLBACK TO PROCESS_MR_RELATION;
1169: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1170: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN

Line 1174: WHEN FND_API.G_EXC_ERROR THEN

1170: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1171: p_count => x_msg_count,
1172: p_data => x_msg_data);
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO PROCESS_MR_RELATION;
1176: X_return_status := FND_API.G_RET_STS_ERROR;
1177: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1178: p_count => x_msg_count,

Line 1176: X_return_status := FND_API.G_RET_STS_ERROR;

1172: p_data => x_msg_data);
1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO PROCESS_MR_RELATION;
1176: X_return_status := FND_API.G_RET_STS_ERROR;
1177: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => X_msg_data);
1180: WHEN OTHERS THEN

Line 1177: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1173:
1174: WHEN FND_API.G_EXC_ERROR THEN
1175: ROLLBACK TO PROCESS_MR_RELATION;
1176: X_return_status := FND_API.G_RET_STS_ERROR;
1177: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1178: p_count => x_msg_count,
1179: p_data => X_msg_data);
1180: WHEN OTHERS THEN
1181: ROLLBACK TO PROCESS_MR_RELATION;

Line 1182: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1178: p_count => x_msg_count,
1179: p_data => X_msg_data);
1180: WHEN OTHERS THEN
1181: ROLLBACK TO PROCESS_MR_RELATION;
1182: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1183: IF G_DEBUG='Y' THEN
1184: AHL_DEBUG_PUB.debug( 'PROCESS-->'||sqlerrm,'DEBUG RELATIONS');
1185: END IF;
1186: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1192: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,

1188: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
1189: p_procedure_name =>L_API_NAME,
1190: p_error_text =>SUBSTR(SQLERRM,1,240));
1191: END IF;
1192: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
1193: p_count => x_msg_count,
1194: p_data => X_msg_data);
1195:
1196: END;