DBA Data[Home] [Help]

APPS.GMD_COMPOSITE_RESULT_ASSOC_PVT dependencies on GMD_API_PUB

Line 102: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');

98: WHERE composite_result_id = p_composite_result_id
99: AND result_id = p_result_id
100: ;
101: ELSE
102: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');
103: RETURN FALSE;
104: END IF;
105:
106: IF (SQL%FOUND) THEN

Line 109: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');

105:
106: IF (SQL%FOUND) THEN
107: RETURN TRUE;
108: ELSE
109: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');
110: RETURN FALSE;
111: END IF;
112:
113: EXCEPTION

Line 115: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

111: END IF;
112:
113: EXCEPTION
114: WHEN locked_by_other_user THEN
115: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
116: 'TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC',
117: 'RECORD','Inventory Spec Validity Rule',
118: 'KEY', p_composite_result_id);
119: RETURN FALSE;

Line 149: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');

145: WHERE composite_result_id = p_composite_result_id
146: AND result_id = p_result_id
147: FOR UPDATE NOWAIT;
148: ELSE
149: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');
150: RETURN FALSE;
151: END IF;
152:
153: RETURN TRUE;

Line 157: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

153: RETURN TRUE;
154:
155: EXCEPTION
156: WHEN locked_by_other_user THEN
157: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
158: 'TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC',
159: 'RECORD','Inventory Spec Validity Rule',
160: 'KEY', p_composite_result_id);
161: RETURN FALSE;

Line 188: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');

184: WHERE composite_result_id = p_composite_result_assoc.composite_result_id
185: AND result_id = p_composite_result_assoc.result_id
186: ;
187: ELSE
188: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');
189: RETURN FALSE;
190: END IF;
191:
192: RETURN TRUE;

Line 197: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');

193:
194: EXCEPTION
195: WHEN NO_DATA_FOUND
196: THEN
197: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULT_ASSOC');
198: RETURN FALSE;
199: WHEN OTHERS
200: THEN
201: fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULT_ASSOC_PVT', 'FETCH_ROW');