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 18: IF p_x_mr_relation_tbl(I).RELATIONSHIP_CODE= FND_API.G_MISS_CHAR

14: IF P_X_MR_relation_TBL.COUNT>0
15: THEN
16: FOR i IN P_X_MR_relation_TBL.FIRST.. P_X_MR_relation_TBL.LAST
17: LOOP
18: IF p_x_mr_relation_tbl(I).RELATIONSHIP_CODE= FND_API.G_MISS_CHAR
19: THEN
20: p_x_mr_relation_tbl(I).RELATIONSHIP_CODE:=NULL;
21: END IF;
22:

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

19: THEN
20: p_x_mr_relation_tbl(I).RELATIONSHIP_CODE:=NULL;
21: END IF;
22:
23: IF p_x_mr_relation_tbl(I).MR_HEADER_ID= FND_API.G_MISS_NUM
24: THEN
25: p_x_mr_relation_tbl(I).MR_HEADER_ID:=NULL;
26: END IF;
27:

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

24: THEN
25: p_x_mr_relation_tbl(I).MR_HEADER_ID:=NULL;
26: END IF;
27:
28: IF p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID= FND_API.G_MISS_NUM
29: THEN
30: p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID:=NULL;
31: END IF;
32:

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

29: THEN
30: p_x_mr_relation_tbl(I).RELATED_MR_HEADER_ID:=NULL;
31: END IF;
32:
33: IF p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID= FND_API.G_MISS_NUM
34: THEN
35: p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID:=NULL;
36: END IF;
37:

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

34: THEN
35: p_x_mr_relation_tbl(I).MR_RELATIONSHIP_ID:=NULL;
36: END IF;
37:
38: IF p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
39: THEN
40: IF p_x_mr_relation_tbl(i).dml_operation='C'
41: THEN
42: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;

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

44: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=NULL;
45: END IF;
46: END IF;
47:
48: IF p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
49: THEN
50: p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY:=NULL;
51: END IF;
52:

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

49: THEN
50: p_x_mr_relation_tbl(i).ATTRIBUTE_CATEGORY:=NULL;
51: END IF;
52:
53: IF p_x_mr_relation_tbl(i).ATTRIBUTE1=FND_API.G_MISS_CHAR
54: THEN
55: p_x_mr_relation_tbl(i).ATTRIBUTE1:=NULL;
56: END IF;
57:

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

54: THEN
55: p_x_mr_relation_tbl(i).ATTRIBUTE1:=NULL;
56: END IF;
57:
58: IF p_x_mr_relation_tbl(i).ATTRIBUTE2=FND_API.G_MISS_CHAR
59: THEN
60: p_x_mr_relation_tbl(i).ATTRIBUTE2:=NULL;
61: END IF;
62:

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

59: THEN
60: p_x_mr_relation_tbl(i).ATTRIBUTE2:=NULL;
61: END IF;
62:
63: IF p_x_mr_relation_tbl(i).ATTRIBUTE3=FND_API.G_MISS_CHAR
64: THEN
65: p_x_mr_relation_tbl(i).ATTRIBUTE3:=NULL;
66: END IF;
67:

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

64: THEN
65: p_x_mr_relation_tbl(i).ATTRIBUTE3:=NULL;
66: END IF;
67:
68: IF p_x_mr_relation_tbl(i).ATTRIBUTE4 IS NULL OR p_x_mr_relation_tbl(i).ATTRIBUTE4=FND_API.G_MISS_CHAR
69: THEN
70: p_x_mr_relation_tbl(i).ATTRIBUTE4:=NULL;
71: END IF;
72:

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

69: THEN
70: p_x_mr_relation_tbl(i).ATTRIBUTE4:=NULL;
71: END IF;
72:
73: IF p_x_mr_relation_tbl(i).ATTRIBUTE5=FND_API.G_MISS_CHAR
74: THEN
75: p_x_mr_relation_tbl(i).ATTRIBUTE5:=NULL;
76: END IF;
77:

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

74: THEN
75: p_x_mr_relation_tbl(i).ATTRIBUTE5:=NULL;
76: END IF;
77:
78: IF p_x_mr_relation_tbl(i).ATTRIBUTE6=FND_API.G_MISS_CHAR
79: THEN
80: p_x_mr_relation_tbl(i).ATTRIBUTE6:=NULL;
81: END IF;
82:

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

79: THEN
80: p_x_mr_relation_tbl(i).ATTRIBUTE6:=NULL;
81: END IF;
82:
83: IF p_x_mr_relation_tbl(i).ATTRIBUTE7=FND_API.G_MISS_CHAR
84: THEN
85: p_x_mr_relation_tbl(i).ATTRIBUTE7:=NULL;
86: END IF;
87:

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

84: THEN
85: p_x_mr_relation_tbl(i).ATTRIBUTE7:=NULL;
86: END IF;
87:
88: IF p_x_mr_relation_tbl(i).ATTRIBUTE8=FND_API.G_MISS_CHAR
89: THEN
90: p_x_mr_relation_tbl(i).ATTRIBUTE8:=NULL;
91: END IF;
92:

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

89: THEN
90: p_x_mr_relation_tbl(i).ATTRIBUTE8:=NULL;
91: END IF;
92:
93: IF p_x_mr_relation_tbl(i).ATTRIBUTE9=FND_API.G_MISS_CHAR
94: THEN
95: p_x_mr_relation_tbl(i).ATTRIBUTE9:=NULL;
96: END IF;
97:

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

94: THEN
95: p_x_mr_relation_tbl(i).ATTRIBUTE9:=NULL;
96: END IF;
97:
98: IF p_x_mr_relation_tbl(i).ATTRIBUTE10=FND_API.G_MISS_CHAR
99: THEN
100: p_x_mr_relation_tbl(i).ATTRIBUTE10:=NULL;
101: END IF;
102:

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

99: THEN
100: p_x_mr_relation_tbl(i).ATTRIBUTE10:=NULL;
101: END IF;
102:
103: IF p_x_mr_relation_tbl(i).ATTRIBUTE11=FND_API.G_MISS_CHAR
104: THEN
105: p_x_mr_relation_tbl(i).ATTRIBUTE11:=NULL;
106: END IF;
107:

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

104: THEN
105: p_x_mr_relation_tbl(i).ATTRIBUTE11:=NULL;
106: END IF;
107:
108: IF p_x_mr_relation_tbl(i).ATTRIBUTE12=FND_API.G_MISS_CHAR
109: THEN
110: p_x_mr_relation_tbl(i).ATTRIBUTE12:=NULL;
111: END IF;
112:

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

109: THEN
110: p_x_mr_relation_tbl(i).ATTRIBUTE12:=NULL;
111: END IF;
112:
113: IF p_x_mr_relation_tbl(i).ATTRIBUTE13=FND_API.G_MISS_CHAR
114: THEN
115: p_x_mr_relation_tbl(i).ATTRIBUTE13:=NULL;
116: END IF;
117:

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

114: THEN
115: p_x_mr_relation_tbl(i).ATTRIBUTE13:=NULL;
116: END IF;
117:
118: IF p_x_mr_relation_tbl(i).ATTRIBUTE14=FND_API.G_MISS_CHAR
119: THEN
120: p_x_mr_relation_tbl(i).ATTRIBUTE14:=NULL;
121: END IF;
122:

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

119: THEN
120: p_x_mr_relation_tbl(i).ATTRIBUTE14:=NULL;
121: END IF;
122:
123: IF p_x_mr_relation_tbl(i).ATTRIBUTE15=FND_API.G_MISS_CHAR
124: THEN
125: p_x_mr_relation_tbl(i).ATTRIBUTE15:=NULL;
126: END IF;
127: END LOOP;

Line 162: x_return_status:=FND_API.G_RET_STS_SUCCESS;

158: l_api_name VARCHAR2(30):='TRANS_VALUE_ID';
159: l_type_code AHL_MR_HEADERS_B.TYPE_CODE%TYPE;
160: l_title AHL_MR_HEADERS_B.TITLE%TYPE;
161: BEGIN
162: x_return_status:=FND_API.G_RET_STS_SUCCESS;
163:
164: IF G_DEBUG='Y' THEN
165: AHL_DEBUG_PUB.enable_debug;
166: 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 169: 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

165: AHL_DEBUG_PUB.enable_debug;
166: AHL_DEBUG_PUB.debug( 'p_x_mr_relation_rec.related_mr_header_id'||p_x_mr_relation_rec.related_mr_header_id,'+DEBUG_RELATIONS+');
167: END IF;
168:
169: 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
170: THEN
171: SELECT TYPE_CODE INTO L_TYPE_CODE
172: FROM AHL_MR_HEADERS_B
173: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;

Line 176: 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

172: FROM AHL_MR_HEADERS_B
173: WHERE MR_HEADER_ID=p_x_mr_relation_rec.MR_HEADER_ID;
174: END IF;
175:
176: 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
177: THEN
178: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_TITLE_NULL');
179: FND_MSG_PUB.ADD;
180: check_flag:='N';

Line 188: p_x_mr_relation_rec.related_mr_header_id<>fnd_api.g_miss_num

184:
185: IF check_flag='Y'
186: THEN
187: IF p_x_mr_relation_rec.related_mr_header_id is not null and
188: p_x_mr_relation_rec.related_mr_header_id<>fnd_api.g_miss_num
189: THEN
190: open c_mr_header_id_to_relmr_title(p_x_mr_relation_rec.related_mr_header_id,l_type_code);
191: fetch c_mr_header_id_to_relmr_title into l_title;
192: close c_mr_header_id_to_relmr_title;

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

220:
221: PROCEDURE NON_CYCLIC_ENF
222: (
223: p_api_version IN NUMBER:=1.0,
224: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
225: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,

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

221: PROCEDURE NON_CYCLIC_ENF
222: (
223: p_api_version IN NUMBER:=1.0,
224: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
225: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
226: x_return_status OUT NOCOPY VARCHAR2,
227: x_msg_count OUT NOCOPY NUMBER,
228: x_msg_data OUT NOCOPY VARCHAR2,
229: P_MR_HEADER_ID IN NUMBER,

Line 238: x_return_status:=FND_API.G_RET_STS_SUCCESS;

234: l_cyclic_loop EXCEPTION;
235: PRAGMA EXCEPTION_INIT(l_cyclic_loop,-1436);
236: l_counter NUMBER;
237: BEGIN
238: x_return_status:=FND_API.G_RET_STS_SUCCESS;
239:
240: SELECT COUNT(*) INTO l_counter
241: FROM AHL_MR_RELATIONSHIPS
242: START WITH RELATED_MR_HEADER_ID=P_RELATED_MR_HEADER_ID

Line 249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

245: WHEN l_cyclic_loop THEN
246: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATION_CYCLIC');
247: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
248: FND_MSG_PUB.ADD;
249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,

Line 250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

246: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATION_CYCLIC');
247: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
248: FND_MSG_PUB.ADD;
249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);

Line 251: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: FND_MESSAGE.SET_TOKEN('RECORD', P_RELATED_MR_TITLE ,false);
248: FND_MSG_PUB.ADD;
249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:

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

248: FND_MSG_PUB.ADD;
249: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
250: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_ERROR THEN

Line 256: WHEN FND_API.G_EXC_ERROR THEN

252: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: X_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => X_msg_data);

Line 257: X_return_status := FND_API.G_RET_STS_ERROR;

253: p_count => x_msg_count,
254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: X_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => X_msg_data);
261: WHEN OTHERS THEN

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

254: p_data => x_msg_data);
255:
256: WHEN FND_API.G_EXC_ERROR THEN
257: X_return_status := FND_API.G_RET_STS_ERROR;
258: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => X_msg_data);
261: WHEN OTHERS THEN
262: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 262: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

258: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
259: p_count => x_msg_count,
260: p_data => X_msg_data);
261: WHEN OTHERS THEN
262: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
264: THEN
265: fnd_msg_pub.add_exc_msg(p_pkg_name =>'AHL_FMP_MR_RELATION_PVT',
266: p_procedure_name =>'NON_CYCLIC_ENF',

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

265: fnd_msg_pub.add_exc_msg(p_pkg_name =>'AHL_FMP_MR_RELATION_PVT',
266: p_procedure_name =>'NON_CYCLIC_ENF',
267: p_error_text =>SUBSTR(SQLERRM,1,240));
268: END IF;
269: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
270: p_count => x_msg_count,
271: p_data => X_msg_data);
272: END;
273:

Line 318: x_return_status:=FND_API.G_RET_STS_SUCCESS;

314: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_MR_RELATION';
315: l_mr_header_id NUMBER:=0;
316: l_mr_check_flag VARCHAR2(1):='N';
317: BEGIN
318: x_return_status:=FND_API.G_RET_STS_SUCCESS;
319: IF G_DEBUG='Y' THEN
320: AHL_DEBUG_PUB.enable_debug;
321: END IF;
322: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or

Line 323: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM

319: IF G_DEBUG='Y' THEN
320: AHL_DEBUG_PUB.enable_debug;
321: END IF;
322: IF p_mr_relation_rec.MR_HEADER_ID IS NULL or
323: p_mr_relation_rec.MR_HEADER_ID=FND_API.G_MISS_NUM
324: THEN
325: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_HEADER_ID_NULL');
326: FND_MSG_PUB.ADD;
327: ELSE

Line 369: p_mr_relation_rec.RELATED_MR_HEADER_ID=FND_API.G_MISS_NUM

365: THEN
366: IF p_mr_relation_rec.dml_operation<>'D'
367: THEN
368: IF p_mr_relation_rec.RELATED_MR_HEADER_ID IS NULL OR
369: p_mr_relation_rec.RELATED_MR_HEADER_ID=FND_API.G_MISS_NUM
370: THEN
371: FND_MESSAGE.SET_NAME('AHL','AHL_MR_HEADER_ID_NULL');
372: FND_MSG_PUB.ADD;
373: ELSE

Line 414: p_mr_relation_rec.MR_RELATIONSHIP_ID=FND_API.G_MISS_NUM)

410:
411: IF p_mr_relation_rec.dml_operation<>'C'
412: THEN
413: IF (p_mr_relation_rec.MR_RELATIONSHIP_ID IS NULL OR
414: p_mr_relation_rec.MR_RELATIONSHIP_ID=FND_API.G_MISS_NUM)
415: THEN
416: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_MR_RELATIONSHIPID_NULL');
417: FND_MESSAGE.SET_TOKEN('RECORD', p_mr_relation_rec.RELATED_MR_TITLE,false);
418: FND_MSG_PUB.ADD;

Line 422: p_mr_relation_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_NUM)

418: FND_MSG_PUB.ADD;
419: END IF;
420:
421: IF (p_mr_relation_rec.OBJECT_VERSION_NUMBER IS NULL OR
422: p_mr_relation_rec.OBJECT_vERSION_NUMBER=FND_API.G_MISS_NUM)
423: THEN
424: FND_MESSAGE.SET_NAME('AHL','AHL_FMP_REL_OBJ_VERSION_NULL');
425: FND_MESSAGE.SET_TOKEN('RECORD', p_mr_relation_rec.RELATED_MR_TITLE,false);
426: FND_MSG_PUB.ADD;

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

477:
478: PROCEDURE PROCESS_MR_RELATION
479: (
480: p_api_version IN NUMBER:= 1.0,
481: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
484: p_default IN VARCHAR2:= FND_API.G_FALSE,
485: p_module_type IN VARCHAR2 := NULL,

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

478: PROCEDURE PROCESS_MR_RELATION
479: (
480: p_api_version IN NUMBER:= 1.0,
481: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
484: p_default IN VARCHAR2:= FND_API.G_FALSE,
485: p_module_type IN VARCHAR2 := NULL,
486: x_return_status OUT NOCOPY VARCHAR2,

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

479: (
480: p_api_version IN NUMBER:= 1.0,
481: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
484: p_default IN VARCHAR2:= FND_API.G_FALSE,
485: p_module_type IN VARCHAR2 := NULL,
486: x_return_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,

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

480: p_api_version IN NUMBER:= 1.0,
481: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
482: p_commit IN VARCHAR2 := FND_API.G_FALSE,
483: p_validation_level IN NUMBER:= FND_API.G_VALID_LEVEL_FULL,
484: p_default IN VARCHAR2:= FND_API.G_FALSE,
485: p_module_type IN VARCHAR2 := NULL,
486: x_return_status OUT NOCOPY VARCHAR2,
487: x_msg_count OUT NOCOPY NUMBER,
488: x_msg_data OUT NOCOPY VARCHAR2,

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

492: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_MR_RELATION';
493: l_api_version CONSTANT NUMBER := 1.0;
494: l_msg_count NUMBER;
495: l_msg_data VARCHAR2(2000);
496: l_init_msg_list VARCHAR2(10):=FND_API.G_FALSE;
497: l_mr_header_id NUMBER:=0;
498: l_mr_relation_rec MR_RELATION_REC;
499: BEGIN
500:

Line 504: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

500:
501:
502: SAVEPOINT PROCESS_MR_RELATION;
503:
504: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
505: p_api_version,
506: l_api_name,G_PKG_NAME) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;

Line 507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

503:
504: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
505: p_api_version,
506: l_api_name,G_PKG_NAME) THEN
507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510:
511: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 511: IF FND_API.to_boolean(p_init_msg_list) THEN

507: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
508: END IF;
509:
510:
511: IF FND_API.to_boolean(p_init_msg_list) THEN
512: FND_MSG_PUB.initialize;
513: END IF;
514:
515:

Line 516: x_return_status:=FND_API.G_RET_STS_SUCCESS;

512: FND_MSG_PUB.initialize;
513: END IF;
514:
515:
516: x_return_status:=FND_API.G_RET_STS_SUCCESS;
517:
518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.enable_debug;
520: END IF;

Line 522: IF FND_API.to_boolean(p_default)

518: IF G_DEBUG='Y' THEN
519: AHL_DEBUG_PUB.enable_debug;
520: END IF;
521: /*
522: IF FND_API.to_boolean(p_default)
523: THEN
524: DEFAULT_MISSING_ATTRIBS
525: (
526: p_x_mr_relation_tbl =>p_x_mr_relation_tbl

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

540: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
541: LOOP
542: IF (
543: p_x_mr_relation_tbl(i).mr_header_id IS NULL OR
544: p_x_mr_relation_tbl(i).mr_header_id = FND_API.G_MISS_NUM
545: )
546: THEN
547: -- Function to convert mr_title,mr_version_number to id
548: AHL_FMP_COMMON_PVT.mr_title_version_to_id(

Line 554: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

550: p_mr_version_number => p_x_mr_relation_tbl(i).mr_version_number,
551: x_mr_header_id => p_x_mr_relation_tbl(i).mr_header_id,
552: x_return_status => x_return_status
553: );
554: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
555: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
556: fnd_log.string
557: (
558: fnd_log.level_statement,

Line 563: RAISE FND_API.G_EXC_ERROR;

559: 'ahl.plsql.'||g_pkg_name||'.'||l_api_name||':',
560: 'Invalid MR Title, Version Number provided'
561: );
562: END IF;
563: RAISE FND_API.G_EXC_ERROR;
564: END IF;
565: END IF;
566: END LOOP;
567:

Line 569: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

565: END IF;
566: END LOOP;
567:
568: --Start of API Body
569: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
570: THEN
571:
572: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
573: LOOP

Line 592: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

588: l_msg_count := FND_MSG_PUB.count_msg;
589: IF l_msg_count > 0
590: THEN
591: X_msg_count := l_msg_count;
592: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: END IF;
596:

Line 593: RAISE FND_API.G_EXC_ERROR;

589: IF l_msg_count > 0
590: THEN
591: X_msg_count := l_msg_count;
592: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
593: RAISE FND_API.G_EXC_ERROR;
594: END IF;
595: END IF;
596:
597: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST

Line 600: x_return_status:=FND_API.G_RET_STS_SUCCESS;

596:
597: FOR i IN P_X_MR_RELATION_TBL.FIRST.. P_X_MR_RELATION_TBL.LAST
598: LOOP
599:
600: x_return_status:=FND_API.G_RET_STS_SUCCESS;
601:
602: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
603: THEN
604:

Line 602: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )

598: LOOP
599:
600: x_return_status:=FND_API.G_RET_STS_SUCCESS;
601:
602: IF (p_validation_level = FND_API.G_VALID_LEVEL_FULL )
603: THEN
604:
605: VALIDATE_MR_RELATION
606: (

Line 614: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

610: END IF;
611: l_msg_count := FND_MSG_PUB.count_msg;
612: IF l_msg_count > 0
613: THEN
614: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
615: END IF;
616:
617: IF p_x_mr_relation_tbl(i).DML_operation<>'D'
618: THEN

Line 646: IF x_return_status=FND_API.G_RET_STS_SUCCESS

642: end if;
643: ELSIF p_x_mr_relation_tbl(i).DML_operation='U'
644: then
645:
646: IF x_return_status=FND_API.G_RET_STS_SUCCESS
647: THEN
648:
649: update AHL_mr_RELATIONSHIPS
650: set MR_HEADER_ID = p_x_mr_relation_tbl(i).MR_HEADER_ID,

Line 692: IF x_return_status=FND_API.G_RET_STS_SUCCESS

688: FROM DUAL;
689:
690: p_x_mr_relation_tbl(i).OBJECT_VERSION_NUMBER:=1;
691:
692: IF x_return_status=FND_API.G_RET_STS_SUCCESS
693: THEN
694: insert into AHl_mr_RELATIONSHIPS(
695: MR_RELATIONSHIP_ID,
696: OBJECT_VERSION_NUMBER,

Line 771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

767:
768: l_msg_count := FND_MSG_PUB.count_msg;
769: IF l_msg_count > 0 THEN
770: X_msg_count := l_msg_count;
771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 772: RAISE FND_API.G_EXC_ERROR;

768: l_msg_count := FND_MSG_PUB.count_msg;
769: IF l_msg_count > 0 THEN
770: X_msg_count := l_msg_count;
771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF FND_API.TO_BOOLEAN(p_commit) THEN
776: COMMIT;

Line 775: IF FND_API.TO_BOOLEAN(p_commit) THEN

771: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
772: RAISE FND_API.G_EXC_ERROR;
773: END IF;
774:
775: IF FND_API.TO_BOOLEAN(p_commit) THEN
776: COMMIT;
777: END IF;
778:
779: IF G_DEBUG='Y' THEN

Line 784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

780: AHL_DEBUG_PUB.disable_debug;
781: END IF;
782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: ROLLBACK TO PROCESS_MR_RELATION;
786: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
788: p_count => x_msg_count,

Line 786: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782:
783: EXCEPTION
784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: ROLLBACK TO PROCESS_MR_RELATION;
786: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:

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

783: EXCEPTION
784: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
785: ROLLBACK TO PROCESS_MR_RELATION;
786: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:
791: WHEN FND_API.G_EXC_ERROR THEN

Line 791: WHEN FND_API.G_EXC_ERROR THEN

787: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
788: p_count => x_msg_count,
789: p_data => x_msg_data);
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: ROLLBACK TO PROCESS_MR_RELATION;
793: X_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
795: p_count => x_msg_count,

Line 793: X_return_status := FND_API.G_RET_STS_ERROR;

789: p_data => x_msg_data);
790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: ROLLBACK TO PROCESS_MR_RELATION;
793: X_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => X_msg_data);
797: WHEN OTHERS THEN

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

790:
791: WHEN FND_API.G_EXC_ERROR THEN
792: ROLLBACK TO PROCESS_MR_RELATION;
793: X_return_status := FND_API.G_RET_STS_ERROR;
794: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
795: p_count => x_msg_count,
796: p_data => X_msg_data);
797: WHEN OTHERS THEN
798: ROLLBACK TO PROCESS_MR_RELATION;

Line 799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

795: p_count => x_msg_count,
796: p_data => X_msg_data);
797: WHEN OTHERS THEN
798: ROLLBACK TO PROCESS_MR_RELATION;
799: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
800: IF G_DEBUG='Y' THEN
801: AHL_DEBUG_PUB.debug( 'PROCESS-->'||sqlerrm,'DEBUG RELATIONS');
802: END IF;
803: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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

805: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME,
806: p_procedure_name =>L_API_NAME,
807: p_error_text =>SUBSTR(SQLERRM,1,240));
808: END IF;
809: FND_MSG_PUB.count_and_get( p_encoded =>FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => X_msg_data);
812:
813: END;