DBA Data[Home] [Help]

APPS.EAM_REQUIREMENTS_PKG dependencies on FND_API

Line 782: IF p_commit = FND_API.G_TRUE THEN

778:
779:
780: BEGIN
781:
782: IF p_commit = FND_API.G_TRUE THEN
783: SAVEPOINT delete_row_ss;
784: END IF;
785:
786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

782: IF p_commit = FND_API.G_TRUE THEN
783: SAVEPOINT delete_row_ss;
784: END IF;
785:
786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 790: x_return_status := FND_API.G_RET_STS_SUCCESS;

786: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
787: FND_MSG_PUB.initialize;
788: END IF;
789:
790: x_return_status := FND_API.G_RET_STS_SUCCESS;
791:
792:
793:
794:

Line 869: (p_encoded => FND_API.G_FALSE,

865: -- if validate not passed then raise error
866: /* l_msg_count := FND_MSG_PUB.count_msg;
867: IF l_msg_count = 1 THEN
868: eam_execution_jsp.Get_Messages
869: (p_encoded => FND_API.G_FALSE,
870: p_msg_index => 1,
871: p_msg_count => l_msg_count,
872: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
873: p_data => l_data,

Line 872: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),

868: eam_execution_jsp.Get_Messages
869: (p_encoded => FND_API.G_FALSE,
870: p_msg_index => 1,
871: p_msg_count => l_msg_count,
872: p_msg_data => nvl(l_msg_data,FND_API.g_MISS_CHAR),
873: p_data => l_data,
874: p_msg_index_out => l_msg_index_out);
875: x_msg_count := l_msg_count;
876: x_msg_data := l_msg_data;

Line 882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

878: x_msg_count := l_msg_count;
879: END IF;
880:
881: IF l_msg_count > 0 THEN
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885: */
886:

Line 883: RAISE FND_API.G_EXC_ERROR;

879: END IF;
880:
881: IF l_msg_count > 0 THEN
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
883: RAISE FND_API.G_EXC_ERROR;
884: END IF;
885: */
886:
887:

Line 888: IF FND_API.TO_BOOLEAN(P_COMMIT)

884: END IF;
885: */
886:
887:
888: IF FND_API.TO_BOOLEAN(P_COMMIT)
889: AND x_return_status = 'S' THEN
890: COMMIT WORK;
891: END IF;
892:

Line 894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

890: COMMIT WORK;
891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 895: IF p_commit = FND_API.G_TRUE THEN

891: END IF;
892:
893: EXCEPTION
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN

Line 898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;

Line 899: WHEN FND_API.G_EXC_ERROR THEN

895: IF p_commit = FND_API.G_TRUE THEN
896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 900: IF p_commit = FND_API.G_TRUE THEN

896: ROLLBACK TO delete_row_ss;
897: END IF;
898: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN

Line 903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

899: WHEN FND_API.G_EXC_ERROR THEN
900: IF p_commit = FND_API.G_TRUE THEN
901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;

Line 905: IF p_commit = FND_API.G_TRUE THEN

901: ROLLBACK TO delete_row_ss;
902: END IF;
903: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:

Line 908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

904: WHEN OTHERS THEN
905: IF p_commit = FND_API.G_TRUE THEN
906: ROLLBACK TO delete_row_ss;
907: END IF;
908: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
909:
910: END Delete_Row_SS;
911:
912:

Line 983: IF p_commit = FND_API.G_TRUE THEN

979: l_out_eam_counter_prop_tbl EAM_PROCESS_WO_PUB.eam_counter_prop_tbl_type;
980:
981: BEGIN
982:
983: IF p_commit = FND_API.G_TRUE THEN
984: SAVEPOINT delete_desc_row_ss;
985: END IF;
986:
987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

Line 987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN

983: IF p_commit = FND_API.G_TRUE THEN
984: SAVEPOINT delete_desc_row_ss;
985: END IF;
986:
987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
988: FND_MSG_PUB.initialize;
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 991: x_return_status := FND_API.G_RET_STS_SUCCESS;

987: IF FND_API.TO_BOOLEAN(p_init_msg_list) THEN
988: FND_MSG_PUB.initialize;
989: END IF;
990:
991: x_return_status := FND_API.G_RET_STS_SUCCESS;
992: EAM_WORKORDER_UTIL_PKG.log_path(l_output_dir);
993:
994:
995: l_eam_direct_item_rec.transaction_type := EAM_PROCESS_WO_PUB.G_OPR_DELETE;

Line 1050: IF FND_API.TO_BOOLEAN(P_COMMIT)

1046: );
1047:
1048:
1049:
1050: IF FND_API.TO_BOOLEAN(P_COMMIT)
1051: AND x_return_status = 'S' THEN
1052: COMMIT WORK;
1053: END IF;
1054:

Line 1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1052: COMMIT WORK;
1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1057: IF p_commit = FND_API.G_TRUE THEN

1053: END IF;
1054:
1055: EXCEPTION
1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN

Line 1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;

Line 1061: WHEN FND_API.G_EXC_ERROR THEN

1057: IF p_commit = FND_API.G_TRUE THEN
1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1062: IF p_commit = FND_API.G_TRUE THEN

1058: ROLLBACK TO delete_desc_row_ss;
1059: END IF;
1060: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN

Line 1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1061: WHEN FND_API.G_EXC_ERROR THEN
1062: IF p_commit = FND_API.G_TRUE THEN
1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;

Line 1067: IF p_commit = FND_API.G_TRUE THEN

1063: ROLLBACK TO delete_desc_row_ss;
1064: END IF;
1065: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071:

Line 1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1066: WHEN OTHERS THEN
1067: IF p_commit = FND_API.G_TRUE THEN
1068: ROLLBACK TO delete_desc_row_ss;
1069: END IF;
1070: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1071:
1072: END Delete_Desc_Row_SS;
1073:
1074: