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

Line 16: If p_association_rec.document_no is not null and p_association_rec.document_no<>fnd_api.g_miss_char

12: as
13: Begin
14: IF p_association_rec.aso_object_type_code = 'OPERATION'
15: THEN
16: If p_association_rec.document_no is not null and p_association_rec.document_no<>fnd_api.g_miss_char
17: Then
18: x_record:=x_record||nvl(p_association_rec.document_no,'')||' - ';
19: End if;
20:

Line 21: If p_association_rec.revision_no is not null and p_association_rec.revision_no<>fnd_api.g_miss_char

17: Then
18: x_record:=x_record||nvl(p_association_rec.document_no,'')||' - ';
19: End if;
20:
21: If p_association_rec.revision_no is not null and p_association_rec.revision_no<>fnd_api.g_miss_char
22: Then
23: x_record:=x_record||nvl(p_association_rec.revision_no,'')||' - ';
24: End if;
25:

Line 26: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char

22: Then
23: x_record:=x_record||nvl(p_association_rec.revision_no,'')||' - ';
24: End if;
25:
26: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char
27: Then
28: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
29: End if;
30:

Line 31: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char

27: Then
28: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
29: End if;
30:
31: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char
32: Then
33: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
34: End if;
35:

Line 36: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char

32: Then
33: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
34: End if;
35:
36: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char
37: Then
38: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
39: End if;
40:

Line 41: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char

37: Then
38: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
39: End if;
40:
41: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char
42: Then
43: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
44: End if;
45:

Line 46: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char

42: Then
43: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
44: End if;
45:
46: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char
47: Then
48: x_record:=x_record||nvl(p_association_rec.page,'');
49: End if;
50: ELSIF p_association_rec.aso_object_type_code = 'MR'

Line 53: If p_association_rec.document_no is not null and p_association_rec.document_no<>fnd_api.g_miss_char

49: End if;
50: ELSIF p_association_rec.aso_object_type_code = 'MR'
51: THEN
52:
53: If p_association_rec.document_no is not null and p_association_rec.document_no<>fnd_api.g_miss_char
54: Then
55: x_record:=x_record||nvl(p_association_rec.document_no,'')||' - ';
56: End if;
57:

Line 58: If p_association_rec.revision_no is not null and p_association_rec.revision_no<>fnd_api.g_miss_char

54: Then
55: x_record:=x_record||nvl(p_association_rec.document_no,'')||' - ';
56: End if;
57:
58: If p_association_rec.revision_no is not null and p_association_rec.revision_no<>fnd_api.g_miss_char
59: Then
60: x_record:=x_record||nvl(p_association_rec.revision_no,'')||' - ';
61: End if;
62:

Line 63: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char

59: Then
60: x_record:=x_record||nvl(p_association_rec.revision_no,'')||' - ';
61: End if;
62:
63: If p_association_rec.chapter is not null and p_association_rec.chapter<>fnd_api.g_miss_char
64: Then
65: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
66: End if;
67:

Line 68: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char

64: Then
65: x_record:=x_record||nvl(p_association_rec.chapter,'')||' - ';
66: End if;
67:
68: If p_association_rec.section is not null and p_association_rec.section<>fnd_api.g_miss_char
69: Then
70: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
71: End if;
72:

Line 73: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char

69: Then
70: x_record:=x_record||nvl(p_association_rec.section,'')||' - ';
71: End if;
72:
73: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char
74: Then
75: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
76: End if;
77: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char

Line 77: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char

73: If p_association_rec.subject is not null and p_association_rec.subject<>fnd_api.g_miss_char
74: Then
75: x_record:=x_record||nvl(p_association_rec.subject,'')||' - ';
76: End if;
77: If p_association_rec.page is not null and p_association_rec.page<>fnd_api.g_miss_char
78: Then
79: x_record:=x_record||nvl(p_association_rec.page,'');
80: End if;
81:

Line 82: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char

78: Then
79: x_record:=x_record||nvl(p_association_rec.page,'');
80: End if;
81:
82: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char
83: Then
84: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
85: End if;
86: END IF;

Line 117: IF p_x_association_tbl(I).DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM

113: OPEN GetDocDet(p_x_association_tbl(i).DOC_TITLE_ASSO_ID);
114: FETCH GetDocDet into l_doc_assos_rec;
115: CLOSE GetDocDet;
116:
117: IF p_x_association_tbl(I).DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM
118: THEN
119: p_x_association_tbl(I).DOC_TITLE_ASSO_ID:=NULL;
120: ELSIF p_x_association_tbl(I).DOC_TITLE_ASSO_ID IS NULL
121: THEN

Line 125: IF p_x_association_tbl(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

121: THEN
122: p_x_association_tbl(I).DOC_TITLE_ASSO_ID:=l_doc_assos_rec.DOC_TITLE_ASSO_ID;
123: END IF;
124:
125: IF p_x_association_tbl(I).OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
126: THEN
127: p_x_association_tbl(I).OBJECT_VERSION_NUMBER:=NULL;
128: ELSIF p_x_association_tbl(I).OBJECT_VERSION_NUMBER IS NULL
129: THEN

Line 133: IF p_x_association_tbl(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE

129: THEN
130: p_x_association_tbl(I).OBJECT_VERSION_NUMBER:=l_doc_assos_rec.OBJECT_VERSION_NUMBER;
131: END IF;
132:
133: IF p_x_association_tbl(I).LAST_UPDATE_DATE=FND_API.G_MISS_DATE
134: THEN
135: p_x_association_tbl(I).LAST_UPDATE_DATE:=NULL;
136: ELSIF p_x_association_tbl(I).LAST_UPDATE_DATE IS NULL
137: THEN

Line 141: IF p_x_association_tbl(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM

137: THEN
138: p_x_association_tbl(I).LAST_UPDATE_DATE:=l_doc_assos_rec.LAST_UPDATE_DATE;
139: END IF;
140:
141: IF p_x_association_tbl(I).LAST_UPDATED_BY= FND_API.G_MISS_NUM
142: THEN
143: p_x_association_tbl(I).LAST_UPDATED_BY:=NULL;
144: ELSIF p_x_association_tbl(I).LAST_UPDATED_BY IS NULL
145: THEN

Line 149: IF p_x_association_tbl(I).CREATION_DATE=FND_API.G_MISS_DATE

145: THEN
146: p_x_association_tbl(I).LAST_UPDATED_BY:=l_doc_assos_rec.LAST_UPDATED_BY;
147: END IF;
148:
149: IF p_x_association_tbl(I).CREATION_DATE=FND_API.G_MISS_DATE
150: THEN
151: p_x_association_tbl(I).CREATION_DATE:=NULL;
152: ELSIF p_x_association_tbl(I).CREATION_DATE IS NULL
153: THEN

Line 157: IF p_x_association_tbl(I).CREATED_BY= FND_API.G_MISS_NUM

153: THEN
154: p_x_association_tbl(I).CREATION_DATE:=l_doc_assos_rec.CREATION_DATE;
155: END IF;
156:
157: IF p_x_association_tbl(I).CREATED_BY= FND_API.G_MISS_NUM
158: THEN
159: p_x_association_tbl(I).CREATED_BY:=NULL;
160: ELSIF p_x_association_tbl(I).CREATED_BY IS NULL
161: THEN

Line 164: IF p_x_association_tbl(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM

160: ELSIF p_x_association_tbl(I).CREATED_BY IS NULL
161: THEN
162: p_x_association_tbl(I).CREATED_BY:=l_doc_assos_rec.CREATED_BY;
163: END IF;
164: IF p_x_association_tbl(I).LAST_UPDATE_LOGIN= FND_API.G_MISS_NUM
165: THEN
166: p_x_association_tbl(I).LAST_UPDATE_LOGIN:=NULL;
167: ELSIF p_x_association_tbl(I).LAST_UPDATE_LOGIN IS NULL
168: THEN

Line 172: IF p_x_association_tbl(I).DOC_REVISION_ID= FND_API.G_MISS_NUM

168: THEN
169: p_x_association_tbl(I).LAST_UPDATE_LOGIN:=l_doc_assos_rec.LAST_UPDATE_LOGIN;
170: END IF;
171:
172: IF p_x_association_tbl(I).DOC_REVISION_ID= FND_API.G_MISS_NUM
173: THEN
174: p_x_association_tbl(I).DOC_REVISION_ID:=NULL;
175: ELSIF p_x_association_tbl(I).DOC_REVISION_ID IS NULL
176: THEN

Line 180: IF p_x_association_tbl(I).ASO_OBJECT_TYPE_CODE= FND_API.G_MISS_CHAR

176: THEN
177: p_x_association_tbl(I).DOC_REVISION_ID:=l_doc_assos_rec.DOC_REVISION_ID;
178: END IF;
179:
180: IF p_x_association_tbl(I).ASO_OBJECT_TYPE_CODE= FND_API.G_MISS_CHAR
181: THEN
182: p_x_association_tbl(I).ASO_OBJECT_TYPE_CODE:=NULL;
183: ELSIF p_x_association_tbl(I).ASO_OBJECT_TYPE_CODE IS NULL
184: THEN

Line 188: IF p_x_association_tbl(I).ASO_OBJECT_ID= FND_API.G_MISS_NUM

184: THEN
185: p_x_association_tbl(I).ASO_OBJECT_TYPE_CODE:=l_doc_assos_rec.ASO_OBJECT_TYPE_CODE;
186: END IF;
187:
188: IF p_x_association_tbl(I).ASO_OBJECT_ID= FND_API.G_MISS_NUM
189: THEN
190: p_x_association_tbl(I).ASO_OBJECT_ID:=NULL;
191: ELSIF p_x_association_tbl(I).ASO_OBJECT_ID IS NULL
192: THEN

Line 196: IF p_x_association_tbl(I).DOCUMENT_ID= FND_API.G_MISS_NUM

192: THEN
193: p_x_association_tbl(I).ASO_OBJECT_ID:=l_doc_assos_rec.ASO_OBJECT_ID;
194: END IF;
195:
196: IF p_x_association_tbl(I).DOCUMENT_ID= FND_API.G_MISS_NUM
197: THEN
198: p_x_association_tbl(I).DOCUMENT_ID:=NULL;
199: ELSIF p_x_association_tbl(I).DOCUMENT_ID IS NULL
200: THEN

Line 204: IF p_x_association_tbl(I).USE_LATEST_REV_FLAG= FND_API.G_MISS_CHAR

200: THEN
201: p_x_association_tbl(I).DOCUMENT_ID:=l_doc_assos_rec.DOCUMENT_ID;
202: END IF;
203:
204: IF p_x_association_tbl(I).USE_LATEST_REV_FLAG= FND_API.G_MISS_CHAR
205: THEN
206: p_x_association_tbl(I).USE_LATEST_REV_FLAG:=NULL;
207: ELSIF p_x_association_tbl(I).USE_LATEST_REV_FLAG IS NULL
208: THEN

Line 212: IF p_x_association_tbl(I).SERIAL_NO= FND_API.G_MISS_CHAR

208: THEN
209: p_x_association_tbl(I).USE_LATEST_REV_FLAG:=l_doc_assos_rec.USE_LATEST_REV_FLAG;
210: END IF;
211:
212: IF p_x_association_tbl(I).SERIAL_NO= FND_API.G_MISS_CHAR
213: THEN
214: p_x_association_tbl(I).SERIAL_NO:=NULL;
215: ELSIF p_x_association_tbl(I).SERIAL_NO IS NULL
216: THEN

Line 220: IF p_x_association_tbl(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

216: THEN
217: p_x_association_tbl(I).SERIAL_NO:=l_doc_assos_rec.SERIAL_NO;
218: END IF;
219:
220: IF p_x_association_tbl(I).ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
221: THEN
222: p_x_association_tbl(I).ATTRIBUTE_CATEGORY:=NULL;
223: ELSIF p_x_association_tbl(I).ATTRIBUTE_CATEGORY IS NULL
224: THEN

Line 228: IF p_x_association_tbl(I).ATTRIBUTE1= FND_API.G_MISS_CHAR

224: THEN
225: p_x_association_tbl(I).ATTRIBUTE_CATEGORY:=l_doc_assos_rec.ATTRIBUTE_CATEGORY;
226: END IF;
227:
228: IF p_x_association_tbl(I).ATTRIBUTE1= FND_API.G_MISS_CHAR
229: THEN
230: p_x_association_tbl(I).ATTRIBUTE1:=NULL;
231: ELSIF p_x_association_tbl(I).ATTRIBUTE1 IS NULL
232: THEN

Line 236: IF p_x_association_tbl(I).ATTRIBUTE2= FND_API.G_MISS_CHAR

232: THEN
233: p_x_association_tbl(I).ATTRIBUTE1:=l_doc_assos_rec.ATTRIBUTE1;
234: END IF;
235:
236: IF p_x_association_tbl(I).ATTRIBUTE2= FND_API.G_MISS_CHAR
237: THEN
238: p_x_association_tbl(I).ATTRIBUTE2:=NULL;
239: ELSIF p_x_association_tbl(I).ATTRIBUTE2 IS NULL
240: THEN

Line 244: IF p_x_association_tbl(I).ATTRIBUTE3= FND_API.G_MISS_CHAR

240: THEN
241: p_x_association_tbl(I).ATTRIBUTE2:=l_doc_assos_rec.ATTRIBUTE2;
242: END IF;
243:
244: IF p_x_association_tbl(I).ATTRIBUTE3= FND_API.G_MISS_CHAR
245: THEN
246: p_x_association_tbl(I).ATTRIBUTE3:=NULL;
247: ELSIF p_x_association_tbl(I).ATTRIBUTE3 IS NULL
248: THEN

Line 252: IF p_x_association_tbl(I).ATTRIBUTE4= FND_API.G_MISS_CHAR

248: THEN
249: p_x_association_tbl(I).ATTRIBUTE3:=l_doc_assos_rec.ATTRIBUTE3;
250: END IF;
251:
252: IF p_x_association_tbl(I).ATTRIBUTE4= FND_API.G_MISS_CHAR
253: THEN
254: p_x_association_tbl(I).ATTRIBUTE4:=NULL;
255: ELSIF p_x_association_tbl(I).ATTRIBUTE4 IS NULL
256: THEN

Line 260: IF p_x_association_tbl(I).ATTRIBUTE5= FND_API.G_MISS_CHAR

256: THEN
257: p_x_association_tbl(I).ATTRIBUTE4:=l_doc_assos_rec.ATTRIBUTE4;
258: END IF;
259:
260: IF p_x_association_tbl(I).ATTRIBUTE5= FND_API.G_MISS_CHAR
261: THEN
262: p_x_association_tbl(I).ATTRIBUTE5:=NULL;
263: ELSIF p_x_association_tbl(I).ATTRIBUTE5 IS NULL
264: THEN

Line 268: IF p_x_association_tbl(I).ATTRIBUTE6= FND_API.G_MISS_CHAR

264: THEN
265: p_x_association_tbl(I).ATTRIBUTE5:=l_doc_assos_rec.ATTRIBUTE5;
266: END IF;
267:
268: IF p_x_association_tbl(I).ATTRIBUTE6= FND_API.G_MISS_CHAR
269: THEN
270: p_x_association_tbl(I).ATTRIBUTE6:=NULL;
271: ELSIF p_x_association_tbl(I).ATTRIBUTE6 IS NULL
272: THEN

Line 276: IF p_x_association_tbl(I).ATTRIBUTE7= FND_API.G_MISS_CHAR

272: THEN
273: p_x_association_tbl(I).ATTRIBUTE6:=l_doc_assos_rec.ATTRIBUTE6;
274: END IF;
275:
276: IF p_x_association_tbl(I).ATTRIBUTE7= FND_API.G_MISS_CHAR
277: THEN
278: p_x_association_tbl(I).ATTRIBUTE7:=NULL;
279: ELSIF p_x_association_tbl(I).ATTRIBUTE7 IS NULL
280: THEN

Line 284: IF p_x_association_tbl(I).ATTRIBUTE8= FND_API.G_MISS_CHAR

280: THEN
281: p_x_association_tbl(I).ATTRIBUTE7:=l_doc_assos_rec.ATTRIBUTE7;
282: END IF;
283:
284: IF p_x_association_tbl(I).ATTRIBUTE8= FND_API.G_MISS_CHAR
285: THEN
286: p_x_association_tbl(I).ATTRIBUTE8:=NULL;
287: ELSIF p_x_association_tbl(I).ATTRIBUTE8 IS NULL
288: THEN

Line 292: IF p_x_association_tbl(I).ATTRIBUTE9= FND_API.G_MISS_CHAR

288: THEN
289: p_x_association_tbl(I).ATTRIBUTE8:=l_doc_assos_rec.ATTRIBUTE8;
290: END IF;
291:
292: IF p_x_association_tbl(I).ATTRIBUTE9= FND_API.G_MISS_CHAR
293: THEN
294: p_x_association_tbl(I).ATTRIBUTE9:=NULL;
295: ELSIF p_x_association_tbl(I).ATTRIBUTE9 IS NULL
296: THEN

Line 300: IF p_x_association_tbl(I).ATTRIBUTE10= FND_API.G_MISS_CHAR

296: THEN
297: p_x_association_tbl(I).ATTRIBUTE9:=l_doc_assos_rec.ATTRIBUTE9;
298: END IF;
299:
300: IF p_x_association_tbl(I).ATTRIBUTE10= FND_API.G_MISS_CHAR
301: THEN
302: p_x_association_tbl(I).ATTRIBUTE10:=NULL;
303: ELSIF p_x_association_tbl(I).ATTRIBUTE10 IS NULL
304: THEN

Line 307: IF p_x_association_tbl(I).ATTRIBUTE11= FND_API.G_MISS_CHAR

303: ELSIF p_x_association_tbl(I).ATTRIBUTE10 IS NULL
304: THEN
305: p_x_association_tbl(I).ATTRIBUTE10:=l_doc_assos_rec.ATTRIBUTE10;
306: END IF;
307: IF p_x_association_tbl(I).ATTRIBUTE11= FND_API.G_MISS_CHAR
308: THEN
309: p_x_association_tbl(I).ATTRIBUTE11:=NULL;
310: ELSIF p_x_association_tbl(I).ATTRIBUTE11 IS NULL
311: THEN

Line 314: IF p_x_association_tbl(I).ATTRIBUTE12= FND_API.G_MISS_CHAR

310: ELSIF p_x_association_tbl(I).ATTRIBUTE11 IS NULL
311: THEN
312: p_x_association_tbl(I).ATTRIBUTE11:=l_doc_assos_rec.ATTRIBUTE11;
313: END IF;
314: IF p_x_association_tbl(I).ATTRIBUTE12= FND_API.G_MISS_CHAR
315: THEN
316: p_x_association_tbl(I).ATTRIBUTE12:=NULL;
317: ELSIF p_x_association_tbl(I).ATTRIBUTE12 IS NULL
318: THEN

Line 321: IF p_x_association_tbl(I).ATTRIBUTE13= FND_API.G_MISS_CHAR

317: ELSIF p_x_association_tbl(I).ATTRIBUTE12 IS NULL
318: THEN
319: p_x_association_tbl(I).ATTRIBUTE12:=l_doc_assos_rec.ATTRIBUTE12;
320: END IF;
321: IF p_x_association_tbl(I).ATTRIBUTE13= FND_API.G_MISS_CHAR
322: THEN
323: p_x_association_tbl(I).ATTRIBUTE13:=NULL;
324: ELSIF p_x_association_tbl(I).ATTRIBUTE13 IS NULL
325: THEN

Line 328: IF p_x_association_tbl(I).ATTRIBUTE14= FND_API.G_MISS_CHAR

324: ELSIF p_x_association_tbl(I).ATTRIBUTE13 IS NULL
325: THEN
326: p_x_association_tbl(I).ATTRIBUTE13:=l_doc_assos_rec.ATTRIBUTE13;
327: END IF;
328: IF p_x_association_tbl(I).ATTRIBUTE14= FND_API.G_MISS_CHAR
329: THEN
330: p_x_association_tbl(I).ATTRIBUTE14:=NULL;
331: ELSIF p_x_association_tbl(I).ATTRIBUTE14 IS NULL
332: THEN

Line 335: IF p_x_association_tbl(I).ATTRIBUTE15= FND_API.G_MISS_CHAR

331: ELSIF p_x_association_tbl(I).ATTRIBUTE14 IS NULL
332: THEN
333: p_x_association_tbl(I).ATTRIBUTE14:=l_doc_assos_rec.ATTRIBUTE14;
334: END IF;
335: IF p_x_association_tbl(I).ATTRIBUTE15= FND_API.G_MISS_CHAR
336: THEN
337: p_x_association_tbl(I).ATTRIBUTE15:=NULL;
338: ELSIF p_x_association_tbl(I).ATTRIBUTE15 IS NULL
339: THEN

Line 343: IF p_x_association_tbl(I).SOURCE_REF_CODE= FND_API.G_MISS_CHAR

339: THEN
340: p_x_association_tbl(I).ATTRIBUTE15:=l_doc_assos_rec.ATTRIBUTE15;
341: END IF;
342:
343: IF p_x_association_tbl(I).SOURCE_REF_CODE= FND_API.G_MISS_CHAR
344: THEN
345: p_x_association_tbl(I).SOURCE_REF_CODE:=NULL;
346: ELSIF p_x_association_tbl(I).SOURCE_REF_CODE IS NULL
347: THEN

Line 350: IF p_x_association_tbl(I).DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM

346: ELSIF p_x_association_tbl(I).SOURCE_REF_CODE IS NULL
347: THEN
348: p_x_association_tbl(I).SOURCE_REF_CODE:=l_doc_assos_rec.SOURCE_REF_CODE;
349: END IF;
350: IF p_x_association_tbl(I).DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM
351: THEN
352: p_x_association_tbl(I).DOC_TITLE_ASSO_ID:=NULL;
353: ELSIF p_x_association_tbl(I).DOC_TITLE_ASSO_ID IS NULL
354: THEN

Line 357: IF p_x_association_tbl(I).CHAPTER= FND_API.G_MISS_CHAR

353: ELSIF p_x_association_tbl(I).DOC_TITLE_ASSO_ID IS NULL
354: THEN
355: p_x_association_tbl(I).DOC_TITLE_ASSO_ID:=l_doc_assos_rec.DOC_TITLE_ASSO_ID;
356: END IF;
357: IF p_x_association_tbl(I).CHAPTER= FND_API.G_MISS_CHAR
358: THEN
359: p_x_association_tbl(I).CHAPTER:=NULL;
360: ELSIF p_x_association_tbl(I).CHAPTER IS NULL
361: THEN

Line 364: IF p_x_association_tbl(I).SECTION= FND_API.G_MISS_CHAR

360: ELSIF p_x_association_tbl(I).CHAPTER IS NULL
361: THEN
362: p_x_association_tbl(I).CHAPTER:=l_doc_assos_rec.CHAPTER;
363: END IF;
364: IF p_x_association_tbl(I).SECTION= FND_API.G_MISS_CHAR
365: THEN
366: p_x_association_tbl(I).SECTION:=NULL;
367: ELSIF p_x_association_tbl(I).SECTION IS NULL
368: THEN

Line 371: IF p_x_association_tbl(I).SUBJECT= FND_API.G_MISS_CHAR

367: ELSIF p_x_association_tbl(I).SECTION IS NULL
368: THEN
369: p_x_association_tbl(I).SECTION:=l_doc_assos_rec.SECTION;
370: END IF;
371: IF p_x_association_tbl(I).SUBJECT= FND_API.G_MISS_CHAR
372: THEN
373: p_x_association_tbl(I).SUBJECT:=NULL;
374: ELSIF p_x_association_tbl(I).SUBJECT IS NULL
375: THEN

Line 379: IF p_x_association_tbl(I).PAGE= FND_API.G_MISS_CHAR

375: THEN
376: p_x_association_tbl(I).SUBJECT:=l_doc_assos_rec.SUBJECT;
377: END IF;
378:
379: IF p_x_association_tbl(I).PAGE= FND_API.G_MISS_CHAR
380: THEN
381: p_x_association_tbl(I).PAGE:=NULL;
382: ELSIF p_x_association_tbl(I).PAGE IS NULL
383: THEN

Line 387: IF p_x_association_tbl(I).FIGURE= FND_API.G_MISS_CHAR

383: THEN
384: p_x_association_tbl(I).PAGE:=l_doc_assos_rec.PAGE;
385: END IF;
386:
387: IF p_x_association_tbl(I).FIGURE= FND_API.G_MISS_CHAR
388: THEN
389: p_x_association_tbl(I).FIGURE:=NULL;
390: ELSIF p_x_association_tbl(I).FIGURE IS NULL
391: THEN

Line 395: IF p_x_association_tbl(I).NOTE= FND_API.G_MISS_CHAR

391: THEN
392: p_x_association_tbl(I).FIGURE:=l_doc_assos_rec.FIGURE;
393: END IF;
394:
395: IF p_x_association_tbl(I).NOTE= FND_API.G_MISS_CHAR
396: THEN
397: p_x_association_tbl(I).NOTE:=NULL;
398: ELSIF p_x_association_tbl(I).NOTE IS NULL
399: THEN

Line 487: x_return_status:=FND_API.G_RET_STS_SUCCESS;

483: l_counter3 NUMBER:=0;
484: l_check_flag VARCHAR2(1):='Y';
485: l_record VARCHAR2(4000):='';
486: BEGIN
487: x_return_status:=FND_API.G_RET_STS_SUCCESS;
488:
489: IF G_DEBUG='Y' THEN
490: AHL_DEBUG_PUB.enable_debug;
491: END IF;

Line 505: p_x_association_tbl(i).aso_object_type_code = FND_API.G_MISS_CHAR

501:
502: IF p_x_association_tbl(i).DML_OPERATION<>'D'
503: THEN
504: IF p_x_association_tbl(i).aso_object_type_code IS NULL or
505: p_x_association_tbl(i).aso_object_type_code = FND_API.G_MISS_CHAR
506: Then
507: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJ_TYP_NOT_EXISTS');
508: FND_MSG_PUB.ADD;
509: END IF;

Line 523: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)

519: THEN
520: IF p_x_association_tbl(i).aso_object_type_code<>'MR'
521: THEN
522: IF (p_x_association_tbl(i).document_no IS NULL or
523: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
524: THEN
525: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
526: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
527: FND_MSG_PUB.ADD;

Line 535: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)

531: l_check_flag:='N';
532: END IF;
533: ELSE
534: IF (p_x_association_tbl(i).document_no IS NULL or
535: p_x_association_tbl(i).document_no=FND_API.G_MISS_CHAR)
536: THEN
537: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
538: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
539: FND_MSG_PUB.ADD;

Line 587: p_x_association_tbl(i).revision_no=fnd_api.g_miss_char)

583:
584: IF l_check_flag='Y'
585: THEN
586: IF (p_x_association_tbl(i).revision_no is null or
587: p_x_association_tbl(i).revision_no=fnd_api.g_miss_char)
588: THEN
589: IF l_counter2<>1
590: THEN
591: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_REVISION_NO_NULL');

Line 819: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;

815: l_num_rec NUMBER;
816: l_msg_count NUMBER;
817: l_msg_data VARCHAR2(2000);
818: l_return_status VARCHAR2(1);
819: l_init_msg_list VARCHAR2(10):=FND_API.G_TRUE;
820: l_counter NUMBER:=0;
821: l_counter1 NUMBER:=0;
822: l_lookup_code VARCHAR2(30):='';
823: l_record VARCHAR2(4000):='';

Line 827: x_return_status:=FND_API.G_RET_STS_SUCCESS;

823: l_record VARCHAR2(4000):='';
824: l_type_code VARCHAR2(30);
825:
826: BEGIN
827: x_return_status:=FND_API.G_RET_STS_SUCCESS;
828: IF G_DEBUG='Y' THEN
829: AHL_DEBUG_PUB.enable_debug;
830: END IF;
831:

Line 853: IF p_association_rec.ASO_OBJECT_ID IS NOT NULL OR p_association_rec.ASO_OBJECT_ID<>FND_API.G_MISS_NUM

849: THEN
850: IF g_pm_install<>'Y'
851: THEN
852:
853: IF p_association_rec.ASO_OBJECT_ID IS NOT NULL OR p_association_rec.ASO_OBJECT_ID<>FND_API.G_MISS_NUM
854: THEN
855: SELECT TYPE_CODE INTO l_type_code
856: FROM AHL_MR_HEADERS_B
857: WHERE MR_HEADER_ID=p_association_rec.ASO_OBJECT_ID;

Line 873: IF p_association_rec.doc_title_asso_id IS NOT NULL AND p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM

869:
870: END IF;
871:
872:
873: IF p_association_rec.doc_title_asso_id IS NOT NULL AND p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM
874: THEN
875: OPEN get_doc_assos_rec_b_info(p_association_rec.doc_title_asso_id);
876: FETCH get_doc_assos_rec_b_info INTO l_document_id,
877: l_doc_revision_id,

Line 913: IF p_association_rec.doc_revision_id IS NOT NULL and p_association_rec.doc_revision_id <> FND_API.G_MISS_NUM

909: RETURN;
910: END IF;
911: END IF;
912:
913: IF p_association_rec.doc_revision_id IS NOT NULL and p_association_rec.doc_revision_id <> FND_API.G_MISS_NUM
914: THEN
915: OPEN GetRevDet(p_association_rec.doc_revision_id);
916: FETCH GetRevDet INTO l_rev_rec1;
917: IF GetRevDet%notfound

Line 940: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND

936: END IF;
937:
938:
939: IF ((p_association_rec.doc_title_asso_id IS NULL OR
940: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
941: (p_association_rec.document_id IS NULL OR p_association_rec.document_id = FND_API.G_MISS_NUM))
942: OR
943: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
944: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)

Line 941: (p_association_rec.document_id IS NULL OR p_association_rec.document_id = FND_API.G_MISS_NUM))

937:
938:
939: IF ((p_association_rec.doc_title_asso_id IS NULL OR
940: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
941: (p_association_rec.document_id IS NULL OR p_association_rec.document_id = FND_API.G_MISS_NUM))
942: OR
943: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
944: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
945: THEN

Line 944: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)

940: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
941: (p_association_rec.document_id IS NULL OR p_association_rec.document_id = FND_API.G_MISS_NUM))
942: OR
943: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
944: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_document_id IS NULL)
945: THEN
946: FND_MESSAGE.SET_NAME('AHL','AHL_DI_DOCUMENT_ID_NULL');
947: FND_MSG_PUB.ADD;
948: END IF;

Line 953: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND

949:
950: -- This condition checks for Aso Object Type Code is Null
951:
952: IF ((p_association_rec.doc_title_asso_id IS NULL OR
953: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
954: (p_association_rec.aso_object_type_code IS NULL OR
955: p_association_rec.aso_object_type_code = FND_API.G_MISS_CHAR))
956: OR
957: ((p_association_rec.doc_title_asso_id IS NOT NULL OR

Line 955: p_association_rec.aso_object_type_code = FND_API.G_MISS_CHAR))

951:
952: IF ((p_association_rec.doc_title_asso_id IS NULL OR
953: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
954: (p_association_rec.aso_object_type_code IS NULL OR
955: p_association_rec.aso_object_type_code = FND_API.G_MISS_CHAR))
956: OR
957: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
958: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM)
959: AND l_aso_object_type_code IS NULL)

Line 958: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM)

954: (p_association_rec.aso_object_type_code IS NULL OR
955: p_association_rec.aso_object_type_code = FND_API.G_MISS_CHAR))
956: OR
957: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
958: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM)
959: AND l_aso_object_type_code IS NULL)
960: THEN
961: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_TYPE_NULL');
962: FND_MSG_PUB.ADD;

Line 967: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND

963: END IF;
964:
965: -- This condiiton checks for Aso Object Id Value Is Null
966: IF ((p_association_rec.doc_title_asso_id IS NULL OR
967: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
968: (p_association_rec.aso_object_id IS NULL OR
969: p_association_rec.aso_object_id = FND_API.G_MISS_NUM))
970: OR
971: ((p_association_rec.doc_title_asso_id IS NOT NULL OR

Line 969: p_association_rec.aso_object_id = FND_API.G_MISS_NUM))

965: -- This condiiton checks for Aso Object Id Value Is Null
966: IF ((p_association_rec.doc_title_asso_id IS NULL OR
967: p_association_rec.doc_title_asso_id = FND_API.G_MISS_NUM) AND
968: (p_association_rec.aso_object_id IS NULL OR
969: p_association_rec.aso_object_id = FND_API.G_MISS_NUM))
970: OR
971: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
972: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
973: THEN

Line 972: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)

968: (p_association_rec.aso_object_id IS NULL OR
969: p_association_rec.aso_object_id = FND_API.G_MISS_NUM))
970: OR
971: ((p_association_rec.doc_title_asso_id IS NOT NULL OR
972: p_association_rec.doc_title_asso_id <> FND_API.G_MISS_NUM) AND l_aso_object_id IS NULL)
973: THEN
974: FND_MESSAGE.SET_NAME('AHL','AHL_DI_ASO_OBJECT_ID_NULL');
975: FND_MSG_PUB.ADD;
976: END IF;

Line 981: p_association_rec.aso_object_type_code <> FND_API.G_MISS_CHAR

977:
978: --Check for Aso Object Type Code in fnd lookups
979:
980: IF p_association_rec.aso_object_type_code IS NOT NULL AND
981: p_association_rec.aso_object_type_code <> FND_API.G_MISS_CHAR
982: THEN
983: OPEN get_aso_obj_type_code(p_association_rec.aso_object_type_code);
984: FETCH get_aso_obj_type_code INTO l_dummy;
985: IF get_aso_obj_type_code%NOTFOUND

Line 1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1081: IF G_DEBUG='Y' THEN
1082: AHL_DEBUG_PUB.debug( 'exit ahl_di_asso_doc_aso_pub.VALIDATE_DOC_ASSOCIATION','+DOBJASS+');
1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);

Line 1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1082: AHL_DEBUG_PUB.debug( 'exit ahl_di_asso_doc_aso_pub.VALIDATE_DOC_ASSOCIATION','+DOBJASS+');
1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN

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

1083: END IF;
1084: EXCEPTION
1085: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;

Line 1090: WHEN FND_API.G_EXC_ERROR THEN

1086: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => X_msg_data);

Line 1091: X_return_status := FND_API.G_RET_STS_ERROR;

1087: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => X_msg_data);
1095: WHEN OTHERS THEN

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

1088: p_count => x_msg_count,
1089: p_data => x_msg_data);
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: X_return_status := FND_API.G_RET_STS_ERROR;
1092: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => X_msg_data);
1095: WHEN OTHERS THEN
1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1092: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1093: p_count => x_msg_count,
1094: p_data => X_msg_data);
1095: WHEN OTHERS THEN
1096: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1097: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1098: THEN
1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
1100: p_procedure_name =>'VALIDATE_DOC_ASSOCIATION',

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

1099: fnd_msg_pub.add_exc_msg(p_pkg_name =>g_pkg_name,
1100: p_procedure_name =>'VALIDATE_DOC_ASSOCIATION',
1101: p_error_text =>SUBSTR(SQLERRM,1,240));
1102: END IF;
1103: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1104: p_count => x_msg_count,
1105: p_data => X_msg_data);
1106: END;
1107:

Line 1112: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1108:
1109: PROCEDURE PROCESS_ASSOCIATION
1110: (
1111: p_api_version IN NUMBER := 1.0,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: p_default IN VARCHAR2 := FND_API.G_FALSE,
1116: p_module_type IN VARCHAR2 ,

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

1109: PROCEDURE PROCESS_ASSOCIATION
1110: (
1111: p_api_version IN NUMBER := 1.0,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: p_default IN VARCHAR2 := FND_API.G_FALSE,
1116: p_module_type IN VARCHAR2 ,
1117: x_return_status OUT NOCOPY VARCHAR2,

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

1110: (
1111: p_api_version IN NUMBER := 1.0,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: p_default IN VARCHAR2 := FND_API.G_FALSE,
1116: p_module_type IN VARCHAR2 ,
1117: x_return_status OUT NOCOPY VARCHAR2,
1118: x_msg_count OUT NOCOPY NUMBER,

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

1111: p_api_version IN NUMBER := 1.0,
1112: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1113: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
1114: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1115: p_default IN VARCHAR2 := FND_API.G_FALSE,
1116: p_module_type IN VARCHAR2 ,
1117: x_return_status OUT NOCOPY VARCHAR2,
1118: x_msg_count OUT NOCOPY NUMBER,
1119: x_msg_data OUT NOCOPY VARCHAR2,

Line 1158: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;

1154: l_msg_data VARCHAR2(2000);
1155: l_return_status VARCHAR2(1);
1156: l_document_id NUMBER;
1157: l_doc_revision_id NUMBER;
1158: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
1159: l_rowid VARCHAR2(30);
1160: l_found_flag VARCHAR2(5) := 'N';
1161: l_doc_title_asso_id NUMBER;
1162: l_record VARCHAR2(4000):='';

Line 1180: IF FND_API.to_boolean(p_init_msg_list)

1176: AHL_DEBUG_PUB.debug( 'enter ahl_di_asso_doc_aso_pub.Process Association','+DOBJASS+');
1177: END IF;
1178:
1179: -- Initialize message list if p_init_msg_list is set to TRUE.
1180: IF FND_API.to_boolean(p_init_msg_list)
1181: THEN
1182: FND_MSG_PUB.initialize;
1183: END IF;
1184:

Line 1190: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

1186:
1187: x_return_status := 'S';
1188:
1189: -- Standard call to check for call compatibility.
1190: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1191: p_api_version,
1192: l_api_name,G_PKG_NAME)
1193: THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1190: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
1191: p_api_version,
1192: l_api_name,G_PKG_NAME)
1193: THEN
1194: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1195: END IF;
1196:
1197:
1198: --Module type is 'JSP' then make it null for the following fields

Line 1212: IF FND_API.to_boolean(p_default)

1208: END IF;
1209: END IF;
1210: END LOOP;
1211:
1212: IF FND_API.to_boolean(p_default)
1213: THEN
1214: DEFAULT_MISSING_ATTRIBS
1215: (
1216: p_x_association_tbl =>p_x_association_tbl

Line 1230: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1226: l_msg_count := FND_MSG_PUB.count_msg;
1227:
1228: IF l_msg_count > 0 THEN
1229: X_msg_count := l_msg_count;
1230: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233:
1234: IF G_DEBUG='Y' THEN

Line 1231: RAISE FND_API.G_EXC_ERROR;

1227:
1228: IF l_msg_count > 0 THEN
1229: X_msg_count := l_msg_count;
1230: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1231: RAISE FND_API.G_EXC_ERROR;
1232: END IF;
1233:
1234: IF G_DEBUG='Y' THEN
1235: AHL_DEBUG_PUB.debug( 'before modify');

Line 1240: l_return_status := FND_API.G_RET_STS_SUCCESS;

1236: END IF;
1237:
1238: FOR i IN p_x_association_tbl.FIRST..p_x_association_tbl.LAST
1239: LOOP
1240: l_return_status := FND_API.G_RET_STS_SUCCESS;
1241: l_msg_count:=0;
1242: IF l_msg_count > 0 THEN
1243: l_msg_count := FND_MSG_PUB.count_msg;
1244: l_msg_count := l_msg_count;

Line 1245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1241: l_msg_count:=0;
1242: IF l_msg_count > 0 THEN
1243: l_msg_count := FND_MSG_PUB.count_msg;
1244: l_msg_count := l_msg_count;
1245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1246: END IF;
1247:
1248: VALIDATE_DOC_ASSOCIATION
1249: (

Line 1307: RAISE FND_API.G_EXC_ERROR;

1303: );
1304:
1305: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1306: FND_MSG_PUB.ADD;
1307: RAISE FND_API.G_EXC_ERROR;
1308:
1309: END IF;
1310: END IF;
1311:

Line 1326: RAISE FND_API.G_EXC_ERROR;

1322: );
1323:
1324: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
1325: FND_MSG_PUB.ADD;
1326: RAISE FND_API.G_EXC_ERROR;
1327: END IF;
1328:
1329: END IF;
1330:

Line 1334: IF l_return_status= FND_API.G_RET_STS_SUCCESS

1330:
1331: CLOSE dup_Rec;
1332: END IF;
1333:
1334: IF l_return_status= FND_API.G_RET_STS_SUCCESS
1335: THEN
1336:
1337: IF p_x_association_tbl(i).DML_OPERATION ='D'
1338: THEN

Line 1467: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1463: l_msg_count := FND_MSG_PUB.count_msg;
1464:
1465: IF l_msg_count > 0 THEN
1466: X_msg_count := l_msg_count;
1467: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470:
1471: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 1468: RAISE FND_API.G_EXC_ERROR;

1464:
1465: IF l_msg_count > 0 THEN
1466: X_msg_count := l_msg_count;
1467: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470:
1471: IF FND_API.TO_BOOLEAN(p_commit) THEN
1472: COMMIT;

Line 1471: IF FND_API.TO_BOOLEAN(p_commit) THEN

1467: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1468: RAISE FND_API.G_EXC_ERROR;
1469: END IF;
1470:
1471: IF FND_API.TO_BOOLEAN(p_commit) THEN
1472: COMMIT;
1473: END IF;
1474:
1475: -- Check if API is called in debug mode. If yes, disable debug.

Line 1485: WHEN FND_API.G_EXC_ERROR THEN

1481: AHL_DEBUG_PUB.disable_debug;
1482: END IF;
1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: ROLLBACK TO PROCESS_association;
1487: X_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1489: p_count => x_msg_count,

Line 1487: X_return_status := FND_API.G_RET_STS_ERROR;

1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: ROLLBACK TO PROCESS_association;
1487: X_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1489: p_count => x_msg_count,
1490: p_data => X_msg_data);
1491: -- Debug info.

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

1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: ROLLBACK TO PROCESS_association;
1487: X_return_status := FND_API.G_RET_STS_ERROR;
1488: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1489: p_count => x_msg_count,
1490: p_data => X_msg_data);
1491: -- Debug info.
1492: IF G_DEBUG='Y' THEN

Line 1500: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1496: END IF;
1497:
1498: WHEN OTHERS THEN
1499: ROLLBACK TO PROCESS_association;
1500: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1501: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1502: THEN
1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
1504: p_procedure_name => 'PROCESS_ASSOCIATION',

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

1503: fnd_msg_pub.add_exc_msg(p_pkg_name =>G_PKG_NAME ,
1504: p_procedure_name => 'PROCESS_ASSOCIATION',
1505: p_error_text => SUBSTR(SQLERRM,1,240));
1506: END IF;
1507: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
1508: p_count => x_msg_count,
1509: p_data => X_msg_data);
1510:
1511: END PROCESS_ASSOCIATION;