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 824: -- FND_MSG_PUB.ADD;

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

Line 845: FND_MSG_PUB.ADD;

841: END IF;
842: ELSE
843: CLOSE check_node_exists;
844: FND_MESSAGE.Set_Name('AHL','AHL_PC_NODE_NOT_FOUND');
845: FND_MSG_PUB.ADD;
846: RAISE FND_API.G_EXC_ERROR;
847: END IF;
848: END LOOP;
849: END IF;

Line 870: x_msg_count := FND_MSG_PUB.count_msg;

866: x_msg_data => x_msg_data
867: );
868:
869: -- Check Error Message stack.
870: x_msg_count := FND_MSG_PUB.count_msg;
871: IF x_msg_count > 0 THEN
872: RAISE FND_API.G_EXC_ERROR;
873: END IF;
874:

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

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

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

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

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

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

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

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

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

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

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

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

Line 1074: FND_MSG_PUB.ADD;

1070: CLOSE get_node_object_version;
1071: IF (l_object_version_number <> p_x_assos_rec.object_version_number)
1072: THEN
1073: FND_MESSAGE.Set_Name('AHL','AHL_COM_RECORD_CHANGED');
1074: FND_MSG_PUB.ADD;
1075: RAISE FND_API.G_EXC_ERROR;
1076: END IF;
1077: END IF;
1078:

Line 1088: FND_MSG_PUB.add;

1084: FETCH check_unit_quarantine INTO l_dummy;
1085: IF (check_unit_quarantine%FOUND)
1086: THEN
1087: FND_MESSAGE.set_name( 'AHL','AHL_UC_INVALID_Q_ACTION' );
1088: FND_MSG_PUB.add;
1089: CLOSE check_unit_quarantine;
1090: RAISE FND_API.G_EXC_ERROR;
1091: END IF;
1092: CLOSE check_unit_quarantine;

Line 1103: FND_MSG_PUB.ADD;

1099: CLOSE get_pc_header_status;
1100: IF (l_status <> 'DRAFT' and l_status <> 'APPROVAL_REJECTED')
1101: THEN
1102: FND_MESSAGE.Set_Name('AHL','AHL_PC_STATUS_COMPLETE');
1103: FND_MSG_PUB.ADD;
1104: RAISE FND_API.G_EXC_ERROR;
1105: END IF;
1106: END IF;
1107:

Line 1117: FND_MSG_PUB.ADD;

1113: FETCH check_id_exists_in_PC INTO l_dummy;
1114: IF (check_id_exists_in_PC%NOTFOUND)
1115: THEN
1116: FND_MESSAGE.Set_Name('AHL','AHL_PC_ASSOS_NOT_FOUND');
1117: FND_MSG_PUB.ADD;
1118: CLOSE check_id_exists_in_PC;
1119: RAISE FND_API.G_EXC_ERROR;
1120: END IF;
1121: CLOSE check_id_exists_in_PC;

Line 1134: FND_MSG_PUB.ADD;

1130: IF (check_unit_item_exists%FOUND)
1131: THEN
1132: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_ITEM_EXISTS');
1133: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1134: FND_MSG_PUB.ADD;
1135: CLOSE check_unit_item_exists;
1136: RAISE FND_API.G_EXC_ERROR;
1137: END IF;
1138: CLOSE check_unit_item_exists;

Line 1146: FND_MSG_PUB.ADD;

1142: IF (check_unit_item_at_same_level%FOUND)
1143: THEN
1144: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_PART_EXISTS_AT_LVL'); -- SATHAPLI BUG:5576835:Changed to correct message code
1145: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1146: FND_MSG_PUB.ADD;
1147: CLOSE check_unit_item_at_same_level;
1148: RAISE FND_API.G_EXC_ERROR;
1149: END IF;
1150: CLOSE check_unit_item_at_same_level;

Line 1160: FND_MSG_PUB.ADD;

1156: FETCH check_unit_exists INTO l_dummy;
1157: IF (check_unit_exists%NOTFOUND)
1158: THEN
1159: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_FOUND');
1160: FND_MSG_PUB.ADD;
1161: CLOSE check_unit_exists;
1162: RAISE FND_API.G_EXC_ERROR;
1163: END IF;
1164: CLOSE check_unit_exists;

Line 1172: FND_MSG_PUB.ADD;

1168: IF (check_unit_valid%NOTFOUND)
1169: THEN
1170: FND_MESSAGE.Set_Name('AHL','AHL_PC_UNIT_NOT_VALID');
1171: FND_MESSAGE.Set_Token('UNIT_NAME',p_x_assos_rec.unit_item_name);
1172: FND_MSG_PUB.ADD;
1173: CLOSE check_unit_valid;
1174: RAISE FND_API.G_EXC_ERROR;
1175: END IF;
1176: CLOSE check_unit_valid;

Line 1184: FND_MSG_PUB.ADD;

1180: FETCH check_item_exists INTO l_dummy;
1181: IF (check_item_exists%NOTFOUND)
1182: THEN
1183: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_FOUND');
1184: FND_MSG_PUB.ADD;
1185: CLOSE check_item_exists;
1186: RAISE FND_API.G_EXC_ERROR;
1187: END IF;
1188: CLOSE check_item_exists;

Line 1196: FND_MSG_PUB.ADD;

1192: IF (check_item_valid%NOTFOUND)
1193: THEN
1194: FND_MESSAGE.Set_Name('AHL','AHL_PC_ITEM_NOT_VALID');
1195: FND_MESSAGE.Set_Token('ITEM_NAME',p_x_assos_rec.unit_item_name);
1196: FND_MSG_PUB.ADD;
1197: CLOSE check_item_valid;
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200: CLOSE check_item_valid;

Line 1212: FND_MSG_PUB.ADD;

1208: FETCH check_child_node_exists INTO l_dummy;
1209: IF (check_child_node_exists%FOUND)
1210: THEN
1211: FND_MESSAGE.Set_Name('AHL','AHL_PC_ATTACH_LEAF_ONLY');
1212: FND_MSG_PUB.ADD;
1213: CLOSE check_child_node_exists;
1214: RAISE FND_API.G_EXC_ERROR;
1215: END IF;
1216: CLOSE check_child_node_exists;