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

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

19: x_record OUT NOCOPY VARCHAR2
20: )
21: as
22: Begin
23: If p_association_rec.document_no is not null and p_association_rec.document_no<>fnd_api.g_miss_char
24: Then
25: x_record:=x_record||nvl(p_association_rec.document_no,'')||' - ';
26: End if;
27:

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

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

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

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

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

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

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

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

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

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

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

48: Then
49: x_record:=x_record||nvl(p_association_rec.page,'');
50: End if;
51:
52: If p_association_rec.figure is not null and p_association_rec.figure<>fnd_api.g_miss_char
53: Then
54: x_record:=x_record||nvl(p_association_rec.figure,'')||' - ';
55: End if;
56: End;

Line 79: IF p_association_rec.DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM

75: OPEN GetDocDet(p_association_rec.DOC_TITLE_ASSO_ID);
76: FETCH GetDocDet into l_doc_assos_rec;
77: CLOSE GetDocDet;
78:
79: IF p_association_rec.DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM
80: THEN
81: x_association_rec.DOC_TITLE_ASSO_ID:=NULL;
82: ELSIF p_association_rec.DOC_TITLE_ASSO_ID IS NULL
83: THEN

Line 89: IF p_association_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM

85: ELSE
86: x_association_rec.DOC_TITLE_ASSO_ID:=p_association_rec.DOC_TITLE_ASSO_ID;
87: END IF;
88:
89: IF p_association_rec.OBJECT_VERSION_NUMBER= FND_API.G_MISS_NUM
90: THEN
91: x_association_rec.OBJECT_VERSION_NUMBER:=NULL;
92: ELSIF p_association_rec.OBJECT_VERSION_NUMBER IS NULL
93: THEN

Line 99: IF p_association_rec.DOC_REVISION_ID= FND_API.G_MISS_NUM

95: ELSE
96: x_association_rec.OBJECT_VERSION_NUMBER:=p_association_rec.OBJECT_VERSION_NUMBER;
97: END IF;
98:
99: IF p_association_rec.DOC_REVISION_ID= FND_API.G_MISS_NUM
100: THEN
101: x_association_rec.DOC_REVISION_ID:=NULL;
102: ELSIF p_association_rec.DOC_REVISION_ID IS NULL
103: THEN

Line 109: IF p_association_rec.ASO_OBJECT_TYPE_CODE= FND_API.G_MISS_CHAR

105: ELSE
106: x_association_rec.DOC_REVISION_ID:=p_association_rec.DOC_REVISION_ID;
107: END IF;
108:
109: IF p_association_rec.ASO_OBJECT_TYPE_CODE= FND_API.G_MISS_CHAR
110: THEN
111: x_association_rec.ASO_OBJECT_TYPE_CODE:=NULL;
112: ELSIF p_association_rec.ASO_OBJECT_TYPE_CODE IS NULL
113: THEN

Line 119: IF p_association_rec.ASO_OBJECT_ID= FND_API.G_MISS_NUM

115: ELSE
116: x_association_rec.ASO_OBJECT_TYPE_CODE:=p_association_rec.ASO_OBJECT_TYPE_CODE;
117: END IF;
118:
119: IF p_association_rec.ASO_OBJECT_ID= FND_API.G_MISS_NUM
120: THEN
121: x_association_rec.ASO_OBJECT_ID:=NULL;
122: ELSIF p_association_rec.ASO_OBJECT_ID IS NULL
123: THEN

Line 129: IF p_association_rec.DOCUMENT_ID= FND_API.G_MISS_NUM

125: ELSE
126: x_association_rec.ASO_OBJECT_ID:=p_association_rec.ASO_OBJECT_ID;
127: END IF;
128:
129: IF p_association_rec.DOCUMENT_ID= FND_API.G_MISS_NUM
130: THEN
131: x_association_rec.DOCUMENT_ID:=NULL;
132: ELSIF p_association_rec.DOCUMENT_ID IS NULL
133: THEN

Line 139: IF p_association_rec.USE_LATEST_REV_FLAG= FND_API.G_MISS_CHAR

135: ELSE
136: x_association_rec.DOCUMENT_ID:=p_association_rec.DOCUMENT_ID;
137: END IF;
138:
139: IF p_association_rec.USE_LATEST_REV_FLAG= FND_API.G_MISS_CHAR
140: THEN
141: x_association_rec.USE_LATEST_REV_FLAG:=NULL;
142: ELSIF p_association_rec.USE_LATEST_REV_FLAG IS NULL
143: THEN

Line 149: IF p_association_rec.SERIAL_NO= FND_API.G_MISS_CHAR

145: ELSE
146: x_association_rec.USE_LATEST_REV_FLAG:=p_association_rec.USE_LATEST_REV_FLAG;
147: END IF;
148:
149: IF p_association_rec.SERIAL_NO= FND_API.G_MISS_CHAR
150: THEN
151: x_association_rec.SERIAL_NO:=NULL;
152: ELSIF p_association_rec.SERIAL_NO IS NULL
153: THEN

Line 159: IF p_association_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR

155: ELSE
156: x_association_rec.SERIAL_NO:=p_association_rec.SERIAL_NO;
157: END IF;
158:
159: IF p_association_rec.ATTRIBUTE_CATEGORY= FND_API.G_MISS_CHAR
160: THEN
161: x_association_rec.ATTRIBUTE_CATEGORY:= NULL;
162: ELSIF p_association_rec.ATTRIBUTE_CATEGORY IS NULL
163: THEN

Line 169: IF p_association_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR

165: ELSE
166: x_association_rec.ATTRIBUTE_CATEGORY:=p_association_rec.ATTRIBUTE_CATEGORY;
167: END IF;
168:
169: IF p_association_rec.ATTRIBUTE1= FND_API.G_MISS_CHAR
170: THEN
171: x_association_rec.ATTRIBUTE1:=NULL;
172: ELSIF p_association_rec.ATTRIBUTE1 IS NULL
173: THEN

Line 179: IF p_association_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR

175: ELSE
176: x_association_rec.ATTRIBUTE1:=p_association_rec.ATTRIBUTE1;
177: END IF;
178:
179: IF p_association_rec.ATTRIBUTE2= FND_API.G_MISS_CHAR
180: THEN
181: x_association_rec.ATTRIBUTE2:=NULL;
182: ELSIF p_association_rec.ATTRIBUTE2 IS NULL
183: THEN

Line 189: IF p_association_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR

185: ELSE
186: x_association_rec.ATTRIBUTE2:=p_association_rec.ATTRIBUTE2;
187: END IF;
188:
189: IF p_association_rec.ATTRIBUTE3= FND_API.G_MISS_CHAR
190: THEN
191: x_association_rec.ATTRIBUTE3:=NULL;
192: ELSIF p_association_rec.ATTRIBUTE3 IS NULL
193: THEN

Line 199: IF p_association_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR

195: ELSE
196: x_association_rec.ATTRIBUTE3:=p_association_rec.ATTRIBUTE3;
197: END IF;
198:
199: IF p_association_rec.ATTRIBUTE4= FND_API.G_MISS_CHAR
200: THEN
201: x_association_rec.ATTRIBUTE4:=NULL;
202: ELSIF p_association_rec.ATTRIBUTE4 IS NULL
203: THEN

Line 209: IF p_association_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR

205: ELSE
206: x_association_rec.ATTRIBUTE4:=p_association_rec.ATTRIBUTE4;
207: END IF;
208:
209: IF p_association_rec.ATTRIBUTE5= FND_API.G_MISS_CHAR
210: THEN
211: x_association_rec.ATTRIBUTE5:=NULL;
212: ELSIF p_association_rec.ATTRIBUTE5 IS NULL
213: THEN

Line 219: IF p_association_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR

215: ELSE
216: x_association_rec.ATTRIBUTE5:=p_association_rec.ATTRIBUTE5;
217: END IF;
218:
219: IF p_association_rec.ATTRIBUTE6= FND_API.G_MISS_CHAR
220: THEN
221: x_association_rec.ATTRIBUTE6:=NULL;
222: ELSIF p_association_rec.ATTRIBUTE6 IS NULL
223: THEN

Line 229: IF p_association_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR

225: ELSE
226: x_association_rec.ATTRIBUTE6:=p_association_rec.ATTRIBUTE6;
227: END IF;
228:
229: IF p_association_rec.ATTRIBUTE7= FND_API.G_MISS_CHAR
230: THEN
231: x_association_rec.ATTRIBUTE7:=NULL;
232: ELSIF p_association_rec.ATTRIBUTE7 IS NULL
233: THEN

Line 239: IF p_association_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR

235: ELSE
236: x_association_rec.ATTRIBUTE7:=p_association_rec.ATTRIBUTE7;
237: END IF;
238:
239: IF p_association_rec.ATTRIBUTE8= FND_API.G_MISS_CHAR
240: THEN
241: x_association_rec.ATTRIBUTE8:=NULL;
242: ELSIF p_association_rec.ATTRIBUTE8 IS NULL
243: THEN

Line 249: IF p_association_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR

245: ELSE
246: x_association_rec.ATTRIBUTE8:=p_association_rec.ATTRIBUTE8;
247: END IF;
248:
249: IF p_association_rec.ATTRIBUTE9= FND_API.G_MISS_CHAR
250: THEN
251: x_association_rec.ATTRIBUTE9:=NULL;
252: ELSIF p_association_rec.ATTRIBUTE9 IS NULL
253: THEN

Line 259: IF p_association_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR

255: ELSE
256: x_association_rec.ATTRIBUTE9:=p_association_rec.ATTRIBUTE9;
257: END IF;
258:
259: IF p_association_rec.ATTRIBUTE10= FND_API.G_MISS_CHAR
260: THEN
261: x_association_rec.ATTRIBUTE10:=NULL;
262: ELSIF p_association_rec.ATTRIBUTE10 IS NULL
263: THEN

Line 268: IF p_association_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR

264: x_association_rec.ATTRIBUTE10:=l_doc_assos_rec.ATTRIBUTE10;
265: ELSE
266: x_association_rec.ATTRIBUTE10:=p_association_rec.ATTRIBUTE10;
267: END IF;
268: IF p_association_rec.ATTRIBUTE11= FND_API.G_MISS_CHAR
269: THEN
270: x_association_rec.ATTRIBUTE11:=NULL;
271: ELSIF p_association_rec.ATTRIBUTE11 IS NULL
272: THEN

Line 277: IF p_association_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR

273: x_association_rec.ATTRIBUTE11:=l_doc_assos_rec.ATTRIBUTE11;
274: ELSE
275: x_association_rec.ATTRIBUTE11:=p_association_rec.ATTRIBUTE11;
276: END IF;
277: IF p_association_rec.ATTRIBUTE12= FND_API.G_MISS_CHAR
278: THEN
279: x_association_rec.ATTRIBUTE12:=NULL;
280: ELSIF p_association_rec.ATTRIBUTE12 IS NULL
281: THEN

Line 286: IF p_association_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR

282: x_association_rec.ATTRIBUTE12:=l_doc_assos_rec.ATTRIBUTE12;
283: ELSE
284: x_association_rec.ATTRIBUTE12:=p_association_rec.ATTRIBUTE12;
285: END IF;
286: IF p_association_rec.ATTRIBUTE13= FND_API.G_MISS_CHAR
287: THEN
288: x_association_rec.ATTRIBUTE13:=NULL;
289: ELSIF p_association_rec.ATTRIBUTE13 IS NULL
290: THEN

Line 295: IF p_association_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR

291: x_association_rec.ATTRIBUTE13:=l_doc_assos_rec.ATTRIBUTE13;
292: ELSE
293: x_association_rec.ATTRIBUTE13:=p_association_rec.ATTRIBUTE13;
294: END IF;
295: IF p_association_rec.ATTRIBUTE14= FND_API.G_MISS_CHAR
296: THEN
297: x_association_rec.ATTRIBUTE14:=NULL;
298: ELSIF p_association_rec.ATTRIBUTE14 IS NULL
299: THEN

Line 304: IF p_association_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR

300: x_association_rec.ATTRIBUTE14:=l_doc_assos_rec.ATTRIBUTE14;
301: ELSE
302: x_association_rec.ATTRIBUTE14:=p_association_rec.ATTRIBUTE14;
303: END IF;
304: IF p_association_rec.ATTRIBUTE15= FND_API.G_MISS_CHAR
305: THEN
306: x_association_rec.ATTRIBUTE15:=NULL;
307: ELSIF p_association_rec.ATTRIBUTE15 IS NULL
308: THEN

Line 314: IF p_association_rec.SOURCE_REF_CODE= FND_API.G_MISS_CHAR

310: ELSE
311: x_association_rec.ATTRIBUTE15:=p_association_rec.ATTRIBUTE15;
312: END IF;
313:
314: IF p_association_rec.SOURCE_REF_CODE= FND_API.G_MISS_CHAR
315: THEN
316: x_association_rec.SOURCE_REF_CODE:=NULL;
317: ELSIF p_association_rec.SOURCE_REF_CODE IS NULL
318: THEN

Line 324: IF p_association_rec.DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM

320: ELSE
321: x_association_rec.SOURCE_REF_CODE:=p_association_rec.SOURCE_REF_CODE;
322: END IF;
323:
324: IF p_association_rec.DOC_TITLE_ASSO_ID= FND_API.G_MISS_NUM
325: THEN
326: x_association_rec.DOC_TITLE_ASSO_ID:=NULL;
327: ELSIF p_association_rec.DOC_TITLE_ASSO_ID IS NULL
328: THEN

Line 335: IF p_association_rec.CHAPTER= FND_API.G_MISS_CHAR

331: x_association_rec.DOC_TITLE_ASSO_ID:=p_association_rec.DOC_TITLE_ASSO_ID;
332: END IF;
333:
334:
335: IF p_association_rec.CHAPTER= FND_API.G_MISS_CHAR
336: THEN
337: x_association_rec.CHAPTER:=NULL;
338:
339: ELSIF p_association_rec.CHAPTER IS NULL

Line 347: IF p_association_rec.SECTION= FND_API.G_MISS_CHAR

343: x_association_rec.CHAPTER:=p_association_rec.CHAPTER;
344: END IF;
345:
346:
347: IF p_association_rec.SECTION= FND_API.G_MISS_CHAR
348: THEN
349:
350: x_association_rec.SECTION:=NULL;
351: ELSIF p_association_rec.SECTION IS NULL

Line 360: IF p_association_rec.SUBJECT= FND_API.G_MISS_CHAR

356: x_association_rec.SECTION:=p_association_rec.SECTION;
357: END IF;
358:
359:
360: IF p_association_rec.SUBJECT= FND_API.G_MISS_CHAR
361: THEN
362: x_association_rec.SUBJECT:=NULL;
363: ELSIF p_association_rec.SUBJECT IS NULL
364: THEN

Line 370: IF p_association_rec.PAGE= FND_API.G_MISS_CHAR

366: ELSE
367: x_association_rec.SUBJECT:=p_association_rec.SUBJECT;
368: END IF;
369:
370: IF p_association_rec.PAGE= FND_API.G_MISS_CHAR
371: THEN
372: x_association_rec.PAGE:=NULL;
373: ELSIF p_association_rec.PAGE IS NULL
374: THEN

Line 380: IF p_association_rec.FIGURE= FND_API.G_MISS_CHAR

376: ELSE
377: x_association_rec.PAGE:=p_association_rec.PAGE;
378: END IF;
379:
380: IF p_association_rec.FIGURE= FND_API.G_MISS_CHAR
381: THEN
382: x_association_rec.FIGURE:=NULL;
383: ELSIF p_association_rec.FIGURE IS NULL
384: THEN

Line 390: IF p_association_rec.NOTE= FND_API.G_MISS_CHAR

386: ELSE
387: x_association_rec.FIGURE:=p_association_rec.FIGURE;
388: END IF;
389:
390: IF p_association_rec.NOTE= FND_API.G_MISS_CHAR
391: THEN
392: x_association_rec.NOTE:=NULL;
393: ELSIF p_association_rec.NOTE IS NULL
394: THEN

Line 400: IF p_association_rec.dml_operation= FND_API.G_MISS_CHAR

396: ELSE
397: x_association_rec.NOTE:=p_association_rec.NOTE;
398: END IF;
399:
400: IF p_association_rec.dml_operation= FND_API.G_MISS_CHAR
401: THEN
402: x_association_rec.dml_operation:=NULL;
403: ELSE
404: x_association_rec.dml_operation:=p_association_rec.dml_operation;

Line 438: x_return_status := FND_API.G_RET_STS_SUCCESS;

434: AND meaning = p_meaning
435: AND sysdate between start_date_active
436: AND nvl(end_date_active,sysdate);
437: END IF;
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: EXCEPTION
440: WHEN no_data_found THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: WHEN too_many_rows THEN

Line 441: x_return_status := FND_API.G_RET_STS_ERROR;

437: END IF;
438: x_return_status := FND_API.G_RET_STS_SUCCESS;
439: EXCEPTION
440: WHEN no_data_found THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: WHEN too_many_rows THEN
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: WHEN OTHERS THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 443: x_return_status := FND_API.G_RET_STS_ERROR;

439: EXCEPTION
440: WHEN no_data_found THEN
441: x_return_status := FND_API.G_RET_STS_ERROR;
442: WHEN too_many_rows THEN
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: WHEN OTHERS THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: RAISE;
447: END;

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: x_return_status := FND_API.G_RET_STS_ERROR;
442: WHEN too_many_rows THEN
443: x_return_status := FND_API.G_RET_STS_ERROR;
444: WHEN OTHERS THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: RAISE;
447: END;
448:
449:

Line 494: x_return_status:=FND_API.G_RET_STS_SUCCESS;

490: l_record VARCHAR2(4000):='';
491: l_check_flag VARCHAR2(1):='Y';
492:
493: BEGIN
494: x_return_status:=FND_API.G_RET_STS_SUCCESS;
495:
496: IF G_DEBUG='Y' THEN
497: AHL_DEBUG_PUB.enable_debug;
498: END IF;

Line 511: p_association_rec.document_no=FND_API.G_MISS_CHAR)

507: l_check_flag := 'Y';
508:
509:
510: IF (p_association_rec.document_no IS NULL or
511: p_association_rec.document_no=FND_API.G_MISS_CHAR)
512: THEN
513: FND_MESSAGE.SET_NAME('AHL','AHL_DI_TAB_DOCUMENT_NO_NULL');
514: FND_MESSAGE.SET_TOKEN('RECORD',l_record);
515: FND_MSG_PUB.ADD;

Line 544: p_association_rec.revision_no=fnd_api.g_miss_char)

540:
541: IF(l_check_flag = 'Y')
542: THEN
543: IF (p_association_rec.revision_no is null or
544: p_association_rec.revision_no=fnd_api.g_miss_char)
545: THEN
546: IF(p_association_rec.aso_object_type_code NOT IN ('ROUTE', 'OPERATION'))
547: THEN
548:

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

609:
610: PROCEDURE PROCESS_ASSOCIATION
611: (
612: p_api_version IN NUMBER := 1.0,
613: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
614: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
615: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
616: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
617: p_module_type IN VARCHAR2 ,

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

610: PROCEDURE PROCESS_ASSOCIATION
611: (
612: p_api_version IN NUMBER := 1.0,
613: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
614: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
615: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
616: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
617: p_module_type IN VARCHAR2 ,
618: x_return_status OUT NOCOPY VARCHAR2,

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

611: (
612: p_api_version IN NUMBER := 1.0,
613: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
614: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
615: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
616: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
617: p_module_type IN VARCHAR2 ,
618: x_return_status OUT NOCOPY VARCHAR2,
619: x_msg_count OUT NOCOPY NUMBER,

Line 616: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,

612: p_api_version IN NUMBER := 1.0,
613: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
614: p_commit IN VARCHAR2 := FND_API.G_FALSE ,
615: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
616: p_validate_only IN VARCHAR2 := FND_API.G_FALSE,
617: p_module_type IN VARCHAR2 ,
618: x_return_status OUT NOCOPY VARCHAR2,
619: x_msg_count OUT NOCOPY NUMBER,
620: x_msg_data OUT NOCOPY VARCHAR2,

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

627: l_msg_data VARCHAR2(2000);
628: l_return_status VARCHAR2(1);
629: l_document_id NUMBER;
630: l_doc_revision_id NUMBER;
631: l_init_msg_list VARCHAR2(10) := FND_API.G_TRUE;
632: l_rowid VARCHAR2(30);
633: l_association_tbl AHL_DI_ASSO_DOC_GEN_PVT.ASSOCIATION_TBL;
634: l_record varchar2(4000);
635:

Line 654: IF FND_API.to_boolean(p_init_msg_list)

650:
651:
652:
653: -- Initialize message list if p_init_msg_list is set to TRUE.
654: IF FND_API.to_boolean(p_init_msg_list)
655: THEN
656: FND_MSG_PUB.initialize;
657: END IF;
658:

Line 664: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,

660:
661: x_return_status := 'S';
662:
663: -- Standard call to check for call compatibility.
664: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
665: p_api_version,
666: l_api_name,G_PKG_NAME)
667: THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

664: IF NOT FND_API.COMPATIBLE_API_CALL(l_api_version,
665: p_api_version,
666: l_api_name,G_PKG_NAME)
667: THEN
668: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
669: END IF;
670:
671:
672: --Module type is 'JSP' then make it null for the following fields

Line 701: IF FND_API.to_boolean(p_validate_only)

697: l_association_tbl(i).doc_title_asso_id := p_x_association_tbl(i).doc_title_asso_id;
698: l_association_tbl(i).object_version_number:= p_x_association_tbl(i).object_version_number;
699: l_association_tbl(i).dml_operation:= p_x_association_tbl(i).dml_operation;
700: ELSE
701: IF FND_API.to_boolean(p_validate_only)
702: THEN
703: RECORD_IDENTIFIER
704: (
705: p_association_rec =>p_x_association_tbl(i),

Line 770: p_x_association_tbl(i).aso_object_desc <> FND_API.G_MISS_CHAR

766:
767:
768:
769: IF p_x_association_tbl(i).aso_object_desc IS NOT NULL AND
770: p_x_association_tbl(i).aso_object_desc <> FND_API.G_MISS_CHAR
771: THEN
772:
773:
774: Check_lookup_name_Or_Id (

Line 789: p_x_association_tbl(i).aso_object_type_code <> FND_API.G_MISS_CHAR

785: END IF;
786: END IF;
787: -- If Type Code presents
788: IF p_x_association_tbl(i).aso_object_type_code IS NOT NULL AND
789: p_x_association_tbl(i).aso_object_type_code <> FND_API.G_MISS_CHAR
790: THEN
791: l_association_tbl(i).aso_object_type_code := p_x_association_tbl(i).aso_object_type_code;
792: --If both missing
793: ELSE

Line 804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

800: l_msg_count := FND_MSG_PUB.count_msg;
801:
802: IF l_msg_count > 0 THEN
803: x_msg_count := l_msg_count;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: -- RAISE FND_API.G_EXC_ERROR;
806: END IF;
807:
808: IF G_DEBUG='Y' THEN

Line 805: -- RAISE FND_API.G_EXC_ERROR;

801:
802: IF l_msg_count > 0 THEN
803: x_msg_count := l_msg_count;
804: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
805: -- RAISE FND_API.G_EXC_ERROR;
806: END IF;
807:
808: IF G_DEBUG='Y' THEN
809: AHL_DEBUG_PUB.debug( 'before modify');

Line 820: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

816: l_msg_count := FND_MSG_PUB.count_msg;
817:
818: IF l_msg_count > 0 THEN
819: X_msg_count := l_msg_count;
820: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824:

Line 821: RAISE FND_API.G_EXC_ERROR;

817:
818: IF l_msg_count > 0 THEN
819: X_msg_count := l_msg_count;
820: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
821: RAISE FND_API.G_EXC_ERROR;
822: END IF;
823:
824:
825:

Line 845: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

841: l_msg_count := FND_MSG_PUB.count_msg;
842:
843: IF l_msg_count > 0 THEN
844: X_msg_count := l_msg_count;
845: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: --Assign values

Line 846: RAISE FND_API.G_EXC_ERROR;

842:
843: IF l_msg_count > 0 THEN
844: X_msg_count := l_msg_count;
845: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848:
849: --Assign values
850: IF l_association_tbl.COUNT > 0

Line 859: IF FND_API.TO_BOOLEAN(p_commit) THEN

855: END LOOP;
856: END IF;
857: --Standard check for commit
858:
859: IF FND_API.TO_BOOLEAN(p_commit) THEN
860: COMMIT;
861: END IF;
862: -- Debug info
863: IF G_DEBUG='Y' THEN

Line 874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

870:
871: END IF;
872:
873: EXCEPTION
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO PROCESS_association;
876: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,

Line 876: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

872:
873: EXCEPTION
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO PROCESS_association;
876: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data);
880: --Debug Info

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

873: EXCEPTION
874: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
875: ROLLBACK TO PROCESS_association;
876: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
877: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
878: p_count => x_msg_count,
879: p_data => x_msg_data);
880: --Debug Info
881: IF G_DEBUG='Y' THEN

Line 890: WHEN FND_API.G_EXC_ERROR THEN

886: AHL_DEBUG_PUB.disable_debug;
887:
888: END IF;
889:
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO PROCESS_association;
892: X_return_status := FND_API.G_RET_STS_ERROR;
893: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
894: p_count => l_msg_count,

Line 892: X_return_status := FND_API.G_RET_STS_ERROR;

888: END IF;
889:
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO PROCESS_association;
892: X_return_status := FND_API.G_RET_STS_ERROR;
893: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
894: p_count => l_msg_count,
895: p_data => X_msg_data);
896: x_msg_count := l_msg_count;

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

889:
890: WHEN FND_API.G_EXC_ERROR THEN
891: ROLLBACK TO PROCESS_association;
892: X_return_status := FND_API.G_RET_STS_ERROR;
893: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
894: p_count => l_msg_count,
895: p_data => X_msg_data);
896: x_msg_count := l_msg_count;
897:

Line 910: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

906: END IF;
907:
908: WHEN OTHERS THEN
909: ROLLBACK TO PROCESS_association;
910: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
911: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
912: THEN
913: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PUB',
914: p_procedure_name => 'PROCESS_ASSOCIATION',

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

913: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AHL_DI_ASSO_DOC_GEN_PUB',
914: p_procedure_name => 'PROCESS_ASSOCIATION',
915: p_error_text => SUBSTR(SQLERRM,1,240));
916: END IF;
917: FND_MSG_PUB.count_and_get( p_encoded => FND_API.G_FALSE,
918: p_count => l_msg_count,
919: p_data => X_msg_data);
920: x_msg_count := l_msg_count;
921: -- Debug info.