APPS.GMD_SPEC_TESTS_PVT dependencies on GMD_API_PUB

Line 841: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

837: if (sql%notfound) then
838: raise no_data_found;
839: end if;
840: ELSE
841: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
842: RETURN FALSE;
843: END IF;
844:
845: RETURN TRUE;

Line 850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

846:
847: EXCEPTION
848: WHEN NO_DATA_FOUND
849: THEN
850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
851: RETURN FALSE;
852: WHEN OTHERS
853: THEN
854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

850: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
851: RETURN FALSE;
852: WHEN OTHERS
853: THEN
854: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.DELETE_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
855: RETURN FALSE;
856: end DELETE_ROW;
857:
858:

Line 941: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

937: INTO x_spec_tests
938: FROM gmd_spec_tests
939: WHERE spec_id = p_spec_tests.spec_id and test_id = p_spec_tests.test_id;
940: ELSE
941: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
942: RETURN FALSE;
943: END IF;
944: RETURN TRUE;
945:

Line 949: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

945:
946: EXCEPTION
947: WHEN NO_DATA_FOUND
948: THEN
949: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
950: RETURN FALSE;
951: WHEN OTHERS
952: THEN
953: fnd_msg_pub.add_exc_msg ('GMD_SPEC_TESTS_PVT', 'FETCH_ROW');

Line 975: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');

971: WHERE spec_id = p_spec_id
972: AND test_id = p_test_id
973: FOR UPDATE OF spec_id NOWAIT ;
974: ELSE
975: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_TESTS');
976: RETURN FALSE;
977: END IF;
978:
979: RETURN TRUE;

Line 984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');

980:
981: EXCEPTION
982: WHEN NO_DATA_FOUND
983: THEN
984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
985: RETURN FALSE;
986: WHEN OTHERS
987: THEN
988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

Line 988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');

984: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_TESTS');
985: RETURN FALSE;
986: WHEN OTHERS
987: THEN
988: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_SPEC_TESTS_PVT.LOCK_ROW','ERROR',SUBSTR(SQLERRM,1,100),'POSITION','010');
989: RETURN FALSE;
990: END lock_row;
991:
992: FUNCTION INSERT_ROW(p_spec_tests IN OUT NOCOPY GMD_SPEC_TESTS%ROWTYPE)

Line 1085: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QC_TESTS_PVT.INSERT_ROW','ERROR',

1081:
1082: return TRUE;
1083:
1084: EXCEPTION WHEN OTHERS THEN
1085: gmd_api_pub.log_message('GMD_API_ERROR','PACKAGE','GMD_QC_TESTS_PVT.INSERT_ROW','ERROR',
1086: SUBSTR(SQLERRM,1,100),'POSITION','010');
1087: RETURN FALSE;
1088:
1089: END INSERT_ROW;