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_PC_ASSOCIATION_PVT dependencies on FND_MSG_PUB

Line 51: FND_MSG_PUB.Initialize;

47:
48: -- Initialize message list if p_init_msg_list is set to TRUE
49: IF FND_API.To_Boolean(p_init_msg_list)
50: THEN
51: FND_MSG_PUB.Initialize;
52: END IF;
53:
54: -- Initialize API return status to success
55: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 67: x_msg_count := FND_MSG_PUB.count_msg;

63: VALIDATE_ASSOCIATION (p_x_assos_rec);
64: END IF;
65:
66: -- Check Error Message stack.
67: x_msg_count := FND_MSG_PUB.count_msg;
68: IF x_msg_count > 0 THEN
69: RAISE FND_API.G_EXC_ERROR;
70: END IF;
71:

Line 158: x_msg_count := FND_MSG_PUB.count_msg;

154:
155: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
156:
157: -- Check Error Message stack.
158: x_msg_count := FND_MSG_PUB.count_msg;
159: IF x_msg_count > 0 THEN
160: RAISE FND_API.G_EXC_ERROR;
161: END IF;
162:

Line 170: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

166: COMMIT WORK;
167: END IF;
168:
169: -- Standard call to get message count and if count is 1, get message info
170: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
171: p_data => x_msg_data,
172: p_encoded => fnd_api.g_false );
173:
174: EXCEPTION

Line 178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

174: EXCEPTION
175: WHEN FND_API.G_EXC_ERROR THEN
176: x_return_status := FND_API.G_RET_STS_ERROR;
177: Rollback to ATTACH_UNIT_PVT;
178: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
179: p_data => x_msg_data,
180: p_encoded => fnd_api.g_false );
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 185: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
183: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
184: Rollback to ATTACH_UNIT_PVT;
185: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
186: p_data => x_msg_data,
187: p_encoded => fnd_api.g_false );
188:
189: WHEN OTHERS THEN

Line 192: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

188:
189: WHEN OTHERS THEN
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: Rollback to ATTACH_UNIT_PVT;
192: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
193: THEN
194: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
195: p_procedure_name => 'ATTACH_UNIT',
196: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 194: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: Rollback to ATTACH_UNIT_PVT;
192: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
193: THEN
194: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
195: p_procedure_name => 'ATTACH_UNIT',
196: p_error_text => SUBSTR(SQLERRM,1,240) );
197: END IF;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

194: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
195: p_procedure_name => 'ATTACH_UNIT',
196: p_error_text => SUBSTR(SQLERRM,1,240) );
197: END IF;
198: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
199: p_data => x_msg_data,
200: p_encoded => fnd_api.g_false );
201:
202: END ATTACH_UNIT;

Line 246: FND_MSG_PUB.Initialize;

242:
243: -- Initialize message list if p_init_msg_list is set to TRUE
244: IF FND_API.To_Boolean(p_init_msg_list)
245: THEN
246: FND_MSG_PUB.Initialize;
247: END IF;
248:
249: -- Initialize API return status to success
250: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 259: x_msg_count := FND_MSG_PUB.count_msg;

255:
256: VALIDATE_ASSOCIATION (p_x_assos_rec);
257:
258: -- Check Error Message stack.
259: x_msg_count := FND_MSG_PUB.count_msg;
260: IF x_msg_count > 0 THEN
261: RAISE FND_API.G_EXC_ERROR;
262: END IF;
263:

Line 304: -- FND_MSG_PUB.ADD;

300: SET child_count = NVL(child_count, 1) - 1
301: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
302: --ELSE
303: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_DEL_HAS_ASSOS');
304: -- FND_MSG_PUB.ADD;
305: END IF;
306:
307: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
308:

Line 310: x_msg_count := FND_MSG_PUB.count_msg;

306:
307: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
308:
309: -- Check Error Message stack.
310: x_msg_count := FND_MSG_PUB.count_msg;
311: IF x_msg_count > 0 THEN
312: RAISE FND_API.G_EXC_ERROR;
313: END IF;
314:

Line 322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

318: COMMIT WORK;
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info
322: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
323: p_data => x_msg_data,
324: p_encoded => fnd_api.g_false );
325:
326: EXCEPTION

Line 330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR;
329: Rollback to DETACH_UNIT_PVT;
330: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
331: p_data => x_msg_data,
332: p_encoded => fnd_api.g_false );
333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

333:
334: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: Rollback to DETACH_UNIT_PVT;
337: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
338: p_data => x_msg_data,
339: p_encoded => fnd_api.g_false );
340:
341: WHEN OTHERS THEN

Line 344: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

340:
341: WHEN OTHERS THEN
342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: Rollback to DETACH_UNIT_PVT;
344: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
345: THEN
346: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
347: p_procedure_name => 'DETACH_UNIT',
348: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 346: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

342: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
343: Rollback to DETACH_UNIT_PVT;
344: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
345: THEN
346: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
347: p_procedure_name => 'DETACH_UNIT',
348: p_error_text => SUBSTR(SQLERRM,1,240) );
349: END IF;
350: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 350: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

346: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
347: p_procedure_name => 'DETACH_UNIT',
348: p_error_text => SUBSTR(SQLERRM,1,240) );
349: END IF;
350: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
351: p_data => x_msg_data,
352: p_encoded => fnd_api.g_false );
353:
354: END DETACH_UNIT;

Line 391: FND_MSG_PUB.Initialize;

387:
388: -- Initialize message list if p_init_msg_list is set to TRUE
389: IF FND_API.To_Boolean(p_init_msg_list)
390: THEN
391: FND_MSG_PUB.Initialize;
392: END IF;
393:
394: -- Initialize API return status to success
395: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 407: x_msg_count := FND_MSG_PUB.count_msg;

403: VALIDATE_ASSOCIATION (p_x_assos_rec);
404: END IF;
405:
406: -- Check Error Message stack.
407: x_msg_count := FND_MSG_PUB.count_msg;
408: IF x_msg_count > 0 THEN
409: RAISE FND_API.G_EXC_ERROR;
410: END IF;
411:

Line 499: x_msg_count := FND_MSG_PUB.count_msg;

495:
496: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
497:
498: -- Check Error Message stack.
499: x_msg_count := FND_MSG_PUB.count_msg;
500: IF x_msg_count > 0 THEN
501: RAISE FND_API.G_EXC_ERROR;
502: END IF;
503:

Line 511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

507: COMMIT WORK;
508: END IF;
509:
510: -- Standard call to get message count and if count is 1, get message info
511: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
512: p_data => x_msg_data,
513: p_encoded => fnd_api.g_false );
514:
515: EXCEPTION

Line 519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: x_return_status := FND_API.G_RET_STS_ERROR;
518: Rollback to ATTACH_ITEM_PVT;
519: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
520: p_data => x_msg_data,
521: p_encoded => fnd_api.g_false );
522:
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

522:
523: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
524: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
525: Rollback to ATTACH_ITEM_PVT;
526: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
527: p_data => x_msg_data,
528: p_encoded => fnd_api.g_false );
529:
530: WHEN OTHERS THEN

Line 533: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

529:
530: WHEN OTHERS THEN
531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: Rollback to ATTACH_ITEM_PVT;
533: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
534: THEN
535: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
536: p_procedure_name => 'ATTACH_ITEM',
537: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 535: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

531: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
532: Rollback to ATTACH_ITEM_PVT;
533: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
534: THEN
535: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
536: p_procedure_name => 'ATTACH_ITEM',
537: p_error_text => SUBSTR(SQLERRM,1,240) );
538: END IF;
539: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 539: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

535: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
536: p_procedure_name => 'ATTACH_ITEM',
537: p_error_text => SUBSTR(SQLERRM,1,240) );
538: END IF;
539: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
540: p_data => x_msg_data,
541: p_encoded => fnd_api.g_false );
542:
543: END ATTACH_ITEM;

Line 587: FND_MSG_PUB.Initialize;

583:
584: -- Initialize message list if p_init_msg_list is set to TRUE
585: IF FND_API.To_Boolean(p_init_msg_list)
586: THEN
587: FND_MSG_PUB.Initialize;
588: END IF;
589:
590: -- Initialize API return status to success
591: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 600: x_msg_count := FND_MSG_PUB.count_msg;

596:
597: VALIDATE_ASSOCIATION (p_x_assos_rec);
598:
599: -- Check Error Message stack.
600: x_msg_count := FND_MSG_PUB.count_msg;
601: IF x_msg_count > 0 THEN
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:

Line 650: -- FND_MSG_PUB.ADD;

646: SET child_count = NVL(child_count, 1) - 1
647: WHERE pc_node_id = p_x_assos_rec.pc_node_id;
648: --ELSE
649: -- FND_MESSAGE.Set_Name('AHL','AHL_PC_PART_DEL_HAS_ASSOS');
650: -- FND_MSG_PUB.ADD;
651: END IF;
652:
653: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
654:

Line 656: x_msg_count := FND_MSG_PUB.count_msg;

652:
653: SET_PC_HEADER_STATUS (p_x_assos_rec.pc_node_id);
654:
655: -- Check Error Message stack.
656: x_msg_count := FND_MSG_PUB.count_msg;
657: IF x_msg_count > 0 THEN
658: RAISE FND_API.G_EXC_ERROR;
659: END IF;
660:

Line 668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

664: COMMIT WORK;
665: END IF;
666:
667: -- Standard call to get message count and if count is 1, get message info
668: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
669: p_data => x_msg_data,
670: p_encoded => fnd_api.g_false );
671:
672: EXCEPTION

Line 676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

672: EXCEPTION
673: WHEN FND_API.G_EXC_ERROR THEN
674: x_return_status := FND_API.G_RET_STS_ERROR;
675: Rollback to DETACH_ITEM_PVT;
676: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
677: p_data => x_msg_data,
678: p_encoded => fnd_api.g_false );
679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 683: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

679:
680: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
681: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682: Rollback to DETACH_ITEM_PVT;
683: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
684: p_data => x_msg_data,
685: p_encoded => fnd_api.g_false );
686:
687: WHEN OTHERS THEN

Line 690: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

686:
687: WHEN OTHERS THEN
688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: Rollback to DETACH_ITEM_PVT;
690: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
691: THEN
692: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
693: p_procedure_name => 'DETACH_ITEM',
694: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 692: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

688: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
689: Rollback to DETACH_ITEM_PVT;
690: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
691: THEN
692: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
693: p_procedure_name => 'DETACH_ITEM',
694: p_error_text => SUBSTR(SQLERRM,1,240) );
695: END IF;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

692: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
693: p_procedure_name => 'DETACH_ITEM',
694: p_error_text => SUBSTR(SQLERRM,1,240) );
695: END IF;
696: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
697: p_data => x_msg_data,
698: p_encoded => fnd_api.g_false );
699:
700: END DETACH_ITEM;

Line 759: FND_MSG_PUB.Initialize;

755:
756: -- Initialize message list if p_init_msg_list is set to TRUE
757: IF FND_API.To_Boolean(p_init_msg_list)
758: THEN
759: FND_MSG_PUB.Initialize;
760: END IF;
761:
762: -- Initialize API return status to success
763: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 791: FND_MSG_PUB.ADD;

787: IF (p_x_assos_tbl(i).REVISION_NO IS NULL)
788: THEN
789: FND_MESSAGE.Set_Name('AHL','AHL_PC_DOC_NO_REV');
790: FND_MESSAGE.Set_Token('DOC',p_x_assos_tbl(i).DOCUMENT_NO);
791: FND_MSG_PUB.ADD;
792: RAISE FND_API.G_EXC_ERROR;
793: END IF;
794:
795: -- Check PC status for document association

Line 807: FND_MSG_PUB.ADD;

803: -- If PC is pending for approval, throw error
804: IF (l_status = 'APPROVAL_PENDING')
805: THEN
806: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
807: FND_MSG_PUB.ADD;
808: RAISE FND_API.G_EXC_ERROR;
809: -- If PC is in complete status, there are 2 cases...
810: -- 1. If it has a DRAFT version, allow document association
811: -- 2. If it has no DRAFT version, throw error

Line 823: FND_MSG_PUB.ADD;

819: THEN
820:
821: CLOSE check_draft_version_exists;
822: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
823: FND_MSG_PUB.ADD;
824: RAISE FND_API.G_EXC_ERROR;
825: ELSE
826:
827: CLOSE check_draft_version_exists;

Line 841: FND_MSG_PUB.ADD;

837: SET_PC_HEADER_STATUS(p_x_assos_tbl(i).ASO_OBJECT_ID);
838: ELSE
839: CLOSE check_node_exists;
840: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
841: FND_MSG_PUB.ADD;
842: RAISE FND_API.G_EXC_ERROR;
843: END IF;
844: END LOOP;
845: END IF;

Line 866: x_msg_count := FND_MSG_PUB.count_msg;

862: x_msg_data => x_msg_data
863: );
864:
865: -- Check Error Message stack.
866: x_msg_count := FND_MSG_PUB.count_msg;
867: IF x_msg_count > 0 THEN
868: RAISE FND_API.G_EXC_ERROR;
869: END IF;
870:

Line 878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

874: COMMIT WORK;
875: END IF;
876:
877: -- Standard call to get message count and if count is 1, get message info
878: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
879: p_data => x_msg_data,
880: p_encoded => fnd_api.g_false );
881:
882: EXCEPTION

Line 886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

882: EXCEPTION
883: WHEN FND_API.G_EXC_ERROR THEN
884: x_return_status := FND_API.G_RET_STS_ERROR;
885: Rollback to PROCESS_DOCUMENT_PVT;
886: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
887: p_data => x_msg_data,
888: p_encoded => fnd_api.g_false );
889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 893: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

889:
890: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
892: Rollback to PROCESS_DOCUMENT_PVT;
893: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
894: p_data => x_msg_data,
895: p_encoded => fnd_api.g_false );
896:
897: WHEN OTHERS THEN

Line 900: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )

896:
897: WHEN OTHERS THEN
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Rollback to PROCESS_DOCUMENT_PVT;
900: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
901: THEN
902: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
903: p_procedure_name => 'PROCESS_DOCUMENT',
904: p_error_text => SUBSTR(SQLERRM,1,240) );

Line 902: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,

898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: Rollback to PROCESS_DOCUMENT_PVT;
900: IF FND_MSG_PUB.check_msg_level( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR )
901: THEN
902: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
903: p_procedure_name => 'PROCESS_DOCUMENT',
904: p_error_text => SUBSTR(SQLERRM,1,240) );
905: END IF;
906: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

Line 906: FND_MSG_PUB.count_and_get( p_count => x_msg_count,

902: fnd_msg_pub.add_exc_msg( p_pkg_name => G_PKG_NAME,
903: p_procedure_name => 'PROCESS_DOCUMENT',
904: p_error_text => SUBSTR(SQLERRM,1,240) );
905: END IF;
906: FND_MSG_PUB.count_and_get( p_count => x_msg_count,
907: p_data => x_msg_data,
908: p_encoded => fnd_api.g_false );
909:
910: END PROCESS_DOCUMENT;

Line 1068: FND_MSG_PUB.ADD;

1064: CLOSE get_node_object_version;
1065: IF (l_object_version_number <> p_x_assos_rec.object_version_number)
1066: THEN
1067: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1068: FND_MSG_PUB.ADD;
1069: RAISE FND_API.G_EXC_ERROR;
1070: END IF;
1071: END IF;
1072:

Line 1082: FND_MSG_PUB.add;

1078: FETCH check_unit_quarantine INTO l_dummy;
1079: IF (check_unit_quarantine%FOUND)
1080: THEN
1081: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1082: FND_MSG_PUB.add;
1083: CLOSE check_unit_quarantine;
1084: RAISE FND_API.G_EXC_ERROR;
1085: END IF;
1086: CLOSE check_unit_quarantine;

Line 1097: FND_MSG_PUB.ADD;

1093: CLOSE get_pc_header_status;
1094: IF (l_status <> 'DRAFT' and l_status <> 'APPROVAL_REJECTED')
1095: THEN
1096: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
1097: FND_MSG_PUB.ADD;
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100: END IF;
1101:

Line 1111: FND_MSG_PUB.ADD;

1107: FETCH check_id_exists_in_PC INTO l_dummy;
1108: IF (check_id_exists_in_PC%NOTFOUND)
1109: THEN
1110: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');
1111: FND_MSG_PUB.ADD;
1112: CLOSE check_id_exists_in_PC;
1113: RAISE FND_API.G_EXC_ERROR;
1114: END IF;
1115: CLOSE check_id_exists_in_PC;

Line 1128: FND_MSG_PUB.ADD;

1124: IF (check_unit_item_exists%FOUND)
1125: THEN
1126: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1127: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1128: FND_MSG_PUB.ADD;
1129: CLOSE check_unit_item_exists;
1130: RAISE FND_API.G_EXC_ERROR;
1131: END IF;
1132: CLOSE check_unit_item_exists;

Line 1140: FND_MSG_PUB.ADD;

1136: IF (check_unit_item_at_same_level%FOUND)
1137: THEN
1138: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1139: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1140: FND_MSG_PUB.ADD;
1141: CLOSE check_unit_item_at_same_level;
1142: RAISE FND_API.G_EXC_ERROR;
1143: END IF;
1144: CLOSE check_unit_item_at_same_level;

Line 1154: FND_MSG_PUB.ADD;

1150: FETCH check_unit_exists INTO l_dummy;
1151: IF (check_unit_exists%NOTFOUND)
1152: THEN
1153: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
1154: FND_MSG_PUB.ADD;
1155: CLOSE check_unit_exists;
1156: RAISE FND_API.G_EXC_ERROR;
1157: END IF;
1158: CLOSE check_unit_exists;

Line 1166: FND_MSG_PUB.ADD;

1162: IF (check_unit_valid%NOTFOUND)
1163: THEN
1164: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1165: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1166: FND_MSG_PUB.ADD;
1167: CLOSE check_unit_valid;
1168: RAISE FND_API.G_EXC_ERROR;
1169: END IF;
1170: CLOSE check_unit_valid;

Line 1178: FND_MSG_PUB.ADD;

1174: FETCH check_item_exists INTO l_dummy;
1175: IF (check_item_exists%NOTFOUND)
1176: THEN
1177: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
1178: FND_MSG_PUB.ADD;
1179: CLOSE check_item_exists;
1180: RAISE FND_API.G_EXC_ERROR;
1181: END IF;
1182: CLOSE check_item_exists;

Line 1190: FND_MSG_PUB.ADD;

1186: IF (check_item_valid%NOTFOUND)
1187: THEN
1188: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1189: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1190: FND_MSG_PUB.ADD;
1191: CLOSE check_item_valid;
1192: RAISE FND_API.G_EXC_ERROR;
1193: END IF;
1194: CLOSE check_item_valid;

Line 1206: FND_MSG_PUB.ADD;

1202: FETCH check_child_node_exists INTO l_dummy;
1203: IF (check_child_node_exists%FOUND)
1204: THEN
1205: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');
1206: FND_MSG_PUB.ADD;
1207: CLOSE check_child_node_exists;
1208: RAISE FND_API.G_EXC_ERROR;
1209: END IF;
1210: CLOSE check_child_node_exists;