DBA Data[Home] [Help]

APPS.GMD_COMPOSITE_SPEC_DISP_PVT dependencies on GMD_API_PUB

Line 105: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');

101: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
102: WHERE composite_spec_disp_id = p_composite_spec_disp_id
103: ;
104: ELSE
105: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');
106: RETURN FALSE;
107: END IF;
108:
109: IF (SQL%FOUND) THEN

Line 112: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');

108:
109: IF (SQL%FOUND) THEN
110: RETURN TRUE;
111: ELSE
112: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');
113: RETURN FALSE;
114: END IF;
115:
116: EXCEPTION

Line 118: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

114: END IF;
115:
116: EXCEPTION
117: WHEN locked_by_other_user THEN
118: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
119: 'TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP',
120: 'RECORD','Inventory Spec Validity Rule',
121: 'KEY', p_composite_spec_disp_id);
122: RETURN FALSE;

Line 148: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');

144: FROM gmd_composite_spec_disp
145: WHERE composite_spec_disp_id = p_composite_spec_disp_id
146: FOR UPDATE NOWAIT;
147: ELSE
148: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');
149: RETURN FALSE;
150: END IF;
151:
152: RETURN TRUE;

Line 156: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

Line 185: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');

181: FROM gmd_composite_spec_disp
182: WHERE composite_spec_disp_id = p_composite_spec_disp.composite_spec_disp_id
183: ;
184: ELSE
185: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');
186: RETURN FALSE;
187: END IF;
188:
189: RETURN TRUE;

Line 194: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');

190:
191: EXCEPTION
192: WHEN NO_DATA_FOUND
193: THEN
194: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_SPEC_DISP');
195: RETURN FALSE;
196: WHEN OTHERS
197: THEN
198: fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_SPEC_DISP_PVT', 'FETCH_ROW');