DBA Data[Home] [Help]

APPS.AMW_CONTROLS_PAGE_PKG dependencies on FND_MSG_PUB

Line 397: fnd_msg_pub.initialize;

393: END IF;
394:
395: -- initialize message list if p_init_msg_list is set to true
396: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
397: fnd_msg_pub.initialize;
398: end if;
399:
400: -- initialize return status to success
401: x_return_status := fnd_api.g_ret_sts_success;

Line 445: fnd_msg_pub.count_and_get(p_count => x_msg_count,

441: END IF;
442:
443: x_return_status := FND_API.G_RET_STS_ERROR;
444:
445: fnd_msg_pub.count_and_get(p_count => x_msg_count,
446: p_data => x_msg_data);
447:
448: WHEN OTHERS THEN
449: IF p_commit = FND_API.G_TRUE THEN

Line 455: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',

451: END IF;
452:
453: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
454:
455: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
456: p_procedure_name => 'PROCESS_OBJECTIVE',
457: p_error_text => SUBSTRB(SQLERRM,1,240));
458:
459: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 459: fnd_msg_pub.count_and_get(p_count => x_msg_count,

455: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
456: p_procedure_name => 'PROCESS_OBJECTIVE',
457: p_error_text => SUBSTRB(SQLERRM,1,240));
458:
459: fnd_msg_pub.count_and_get(p_count => x_msg_count,
460: p_data => x_msg_data);
461:
462:
463: END PROCESS_OBJECTIVE;

Line 491: fnd_msg_pub.initialize;

487: END IF;
488:
489: -- initialize message list if p_init_msg_list is set to true
490: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
491: fnd_msg_pub.initialize;
492: end if;
493:
494: -- initialize return status to success
495: x_return_status := fnd_api.g_ret_sts_success;

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

535: END IF;
536:
537: x_return_status := FND_API.G_RET_STS_ERROR;
538:
539: fnd_msg_pub.count_and_get(p_count => x_msg_count,
540: p_data => x_msg_data);
541:
542: WHEN OTHERS THEN
543: IF p_commit = FND_API.G_TRUE THEN

Line 549: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',

545: END IF;
546:
547: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
548:
549: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
550: p_procedure_name => 'PROCESS_ASSERTION',
551: p_error_text => SUBSTRB(SQLERRM,1,240));
552:
553: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 553: fnd_msg_pub.count_and_get(p_count => x_msg_count,

549: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
550: p_procedure_name => 'PROCESS_ASSERTION',
551: p_error_text => SUBSTRB(SQLERRM,1,240));
552:
553: fnd_msg_pub.count_and_get(p_count => x_msg_count,
554: p_data => x_msg_data);
555:
556:
557: END PROCESS_ASSERTION;

Line 585: fnd_msg_pub.initialize;

581: END IF;
582:
583: -- initialize message list if p_init_msg_list is set to true
584: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
585: fnd_msg_pub.initialize;
586: end if;
587:
588: -- initialize return status to success
589: x_return_status := fnd_api.g_ret_sts_success;

Line 638: fnd_msg_pub.count_and_get(p_count => x_msg_count,

634: END IF;
635:
636: x_return_status := FND_API.G_RET_STS_ERROR;
637:
638: fnd_msg_pub.count_and_get(p_count => x_msg_count,
639: p_data => x_msg_data);
640:
641: WHEN OTHERS THEN
642: IF p_commit = FND_API.G_TRUE THEN

Line 648: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',

644: END IF;
645:
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647:
648: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
649: p_procedure_name => 'PROCESS_COMPONENT',
650: p_error_text => SUBSTRB(SQLERRM,1,240));
651:
652: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 652: fnd_msg_pub.count_and_get(p_count => x_msg_count,

648: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
649: p_procedure_name => 'PROCESS_COMPONENT',
650: p_error_text => SUBSTRB(SQLERRM,1,240));
651:
652: fnd_msg_pub.count_and_get(p_count => x_msg_count,
653: p_data => x_msg_data);
654:
655:
656: END PROCESS_component;

Line 693: fnd_msg_pub.initialize;

689: END IF;
690:
691: -- initialize message list if p_init_msg_list is set to true
692: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
693: fnd_msg_pub.initialize;
694: end if;
695:
696: -- initialize return status to success
697: x_return_status := fnd_api.g_ret_sts_success;

Line 722: fnd_msg_pub.count_and_get(p_count => x_msg_count,

718: END IF;
719:
720: x_return_status := FND_API.G_RET_STS_ERROR;
721:
722: fnd_msg_pub.count_and_get(p_count => x_msg_count,
723: p_data => x_msg_data);
724:
725: WHEN OTHERS THEN
726: IF p_commit = FND_API.G_TRUE THEN

Line 732: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',

728: END IF;
729:
730: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
731:
732: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
733: p_procedure_name => 'UPDATE_CONTROL_ASSOCIATION',
734: p_error_text => SUBSTRB(SQLERRM,1,240));
735:
736: fnd_msg_pub.count_and_get(p_count => x_msg_count,

Line 736: fnd_msg_pub.count_and_get(p_count => x_msg_count,

732: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
733: p_procedure_name => 'UPDATE_CONTROL_ASSOCIATION',
734: p_error_text => SUBSTRB(SQLERRM,1,240));
735:
736: fnd_msg_pub.count_and_get(p_count => x_msg_count,
737: p_data => x_msg_data);
738:
739: END delete_control_association;
740:

Line 774: fnd_msg_pub.initialize;

770: END IF;
771:
772: -- initialize message list if p_init_msg_list is set to true
773: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
774: fnd_msg_pub.initialize;
775: end if;
776:
777: -- initialize return status to success
778: x_return_status := fnd_api.g_ret_sts_success;

Line 811: fnd_msg_pub.count_and_get(p_count => x_msg_count,

807: IF p_commit = FND_API.G_TRUE THEN
808: ROLLBACK TO delete_save_point;
809: END IF;
810: x_return_status := FND_API.G_RET_STS_ERROR;
811: fnd_msg_pub.count_and_get(p_count => x_msg_count,
812: p_data => x_msg_data);
813:
814: WHEN OTHERS THEN
815: IF p_commit = FND_API.G_TRUE THEN

Line 819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',

815: IF p_commit = FND_API.G_TRUE THEN
816: ROLLBACK TO create_prop_person_support;
817: END IF;
818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
820: p_procedure_name => 'UPDATE_CONTROL_ASSOCIATION',
821: p_error_text => SUBSTRB(SQLERRM,1,240));
822: fnd_msg_pub.count_and_get(p_count => x_msg_count,
823: p_data => x_msg_data);

Line 822: fnd_msg_pub.count_and_get(p_count => x_msg_count,

818: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
819: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PKG',
820: p_procedure_name => 'UPDATE_CONTROL_ASSOCIATION',
821: p_error_text => SUBSTRB(SQLERRM,1,240));
822: fnd_msg_pub.count_and_get(p_count => x_msg_count,
823: p_data => x_msg_data);
824:
825: END delete_obj_assert_comp;
826:

Line 918: FND_MSG_PUB.initialize;

914: L_DATE DATE;
915: BEGIN
916: x_return_status := FND_API.G_RET_STS_SUCCESS;
917: IF FND_API.to_Boolean( p_init_msg_list ) THEN
918: FND_MSG_PUB.initialize;
919: END IF;
920:
921: IF FND_GLOBAL.User_Id IS NULL THEN
922: AMW_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

Line 968: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

964: EXCEPTION
965: WHEN FND_API.G_EXC_ERROR THEN
966: ROLLBACK;
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
969:
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
971: ROLLBACK;
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 973: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

969:
970: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
971: ROLLBACK;
972: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
973: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
974:
975: WHEN OTHERS THEN
976: ROLLBACK;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

974:
975: WHEN OTHERS THEN
976: ROLLBACK;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
982: END IS_WKFLW_APPR_DISBLD;

Line 979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);

975: WHEN OTHERS THEN
976: ROLLBACK;
977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
982: END IS_WKFLW_APPR_DISBLD;
983:

Line 981: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);

977: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
978: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
979: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME,l_api_name);
980: END IF;
981: FND_MSG_PUB.Count_And_Get (p_encoded => FND_API.G_FALSE,p_count => x_msg_count,p_data => x_msg_data);
982: END IS_WKFLW_APPR_DISBLD;
983:
984: ---------------------------------------------------------------------
985: ----npanandi 12.02.2004: Added below function to get UnitOfMeasureTL

Line 1115: fnd_msg_pub.initialize;

1111: END IF;
1112:
1113: -- initialize message list if p_init_msg_list is set to true
1114: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
1115: fnd_msg_pub.initialize;
1116: end if;
1117:
1118: -- initialize return status to success
1119: x_return_status := fnd_api.g_ret_sts_success;

Line 1150: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

1146: IF p_commit = FND_API.G_TRUE THEN
1147: ROLLBACK TO process_PURPOSE_save_point;
1148: END IF;
1149: x_return_status := FND_API.G_RET_STS_ERROR;
1150: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1151: WHEN OTHERS THEN
1152: IF p_commit = FND_API.G_TRUE THEN
1153: ROLLBACK TO process_PURPOSE_save_point;
1154: END IF;

Line 1156: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PAGE_PKG',

1152: IF p_commit = FND_API.G_TRUE THEN
1153: ROLLBACK TO process_PURPOSE_save_point;
1154: END IF;
1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PAGE_PKG',
1157: p_procedure_name => 'PROCESS_PURPOSE',
1158: p_error_text => SUBSTRB(SQLERRM,1,240));
1159: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1160: END PROCESS_PURPOSE;

Line 1159: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);

1155: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1156: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_CONTROLS_PAGE_PKG',
1157: p_procedure_name => 'PROCESS_PURPOSE',
1158: p_error_text => SUBSTRB(SQLERRM,1,240));
1159: fnd_msg_pub.count_and_get(p_count => x_msg_count,p_data => x_msg_data);
1160: END PROCESS_PURPOSE;
1161:
1162:
1163: