DBA Data[Home] [Help]

APPS.GMD_ACTIVITIES_PVT dependencies on GMD_API_GRP

Line 70: IF NOT gmd_api_grp.setup_done THEN

66:
67: /* Initially let us assign the return status to success */
68: x_return_status := FND_API.g_ret_sts_success;
69:
70: IF NOT gmd_api_grp.setup_done THEN
71: gmd_api_grp.setup_done := gmd_api_grp.setup;
72: END IF;
73: IF NOT gmd_api_grp.setup_done THEN
74: RAISE setup_failure;

Line 71: gmd_api_grp.setup_done := gmd_api_grp.setup;

67: /* Initially let us assign the return status to success */
68: x_return_status := FND_API.g_ret_sts_success;
69:
70: IF NOT gmd_api_grp.setup_done THEN
71: gmd_api_grp.setup_done := gmd_api_grp.setup;
72: END IF;
73: IF NOT gmd_api_grp.setup_done THEN
74: RAISE setup_failure;
75: END IF;

Line 73: IF NOT gmd_api_grp.setup_done THEN

69:
70: IF NOT gmd_api_grp.setup_done THEN
71: gmd_api_grp.setup_done := gmd_api_grp.setup;
72: END IF;
73: IF NOT gmd_api_grp.setup_done THEN
74: RAISE setup_failure;
75: END IF;
76:
77: FOR i IN 1 .. p_activity_tbl.count LOOP

Line 89: gmd_api_grp.log_message ('GMD_DUPLICATE_ACTIVITY', 'ACTIVITY',p_activity_tbl(i).activity);

85: IF (Cur_check_activity%FOUND) THEN
86: IF (l_debug = 'Y') THEN
87: gmd_debug.put_line('duplicate activity');
88: END IF;
89: gmd_api_grp.log_message ('GMD_DUPLICATE_ACTIVITY', 'ACTIVITY',p_activity_tbl(i).activity);
90: CLOSE Cur_check_activity;
91: RAISE duplicate_activity;
92: END IF;
93: CLOSE Cur_check_activity;

Line 104: X_CREATED_BY => gmd_api_grp.user_id,

100: X_TEXT_CODE => p_activity_tbl(i).TEXT_CODE,
101: X_TRANS_CNT => p_activity_tbl(i).TRANS_CNT,
102: X_ACTIVITY_DESC => p_activity_tbl(i).ACTIVITY_DESC,
103: X_CREATION_DATE => sysdate,
104: X_CREATED_BY => gmd_api_grp.user_id,
105: X_LAST_UPDATE_DATE => sysdate,
106: X_LAST_UPDATED_BY => gmd_api_grp.user_id,
107: X_LAST_UPDATE_LOGIN => gmd_api_grp.user_id);
108: IF (l_debug = 'Y') THEN

Line 106: X_LAST_UPDATED_BY => gmd_api_grp.user_id,

102: X_ACTIVITY_DESC => p_activity_tbl(i).ACTIVITY_DESC,
103: X_CREATION_DATE => sysdate,
104: X_CREATED_BY => gmd_api_grp.user_id,
105: X_LAST_UPDATE_DATE => sysdate,
106: X_LAST_UPDATED_BY => gmd_api_grp.user_id,
107: X_LAST_UPDATE_LOGIN => gmd_api_grp.user_id);
108: IF (l_debug = 'Y') THEN
109: gmd_debug.put_line('End Loop - insert_activity private');
110: END IF;

Line 107: X_LAST_UPDATE_LOGIN => gmd_api_grp.user_id);

103: X_CREATION_DATE => sysdate,
104: X_CREATED_BY => gmd_api_grp.user_id,
105: X_LAST_UPDATE_DATE => sysdate,
106: X_LAST_UPDATED_BY => gmd_api_grp.user_id,
107: X_LAST_UPDATE_LOGIN => gmd_api_grp.user_id);
108: IF (l_debug = 'Y') THEN
109: gmd_debug.put_line('End Loop - insert_activity private');
110: END IF;
111: END LOOP;

Line 169: IF NOT gmd_api_grp.setup_done THEN

165:
166: /* Initially let us assign the return status to success */
167: x_return_status := FND_API.g_ret_sts_success;
168:
169: IF NOT gmd_api_grp.setup_done THEN
170: gmd_api_grp.setup_done := gmd_api_grp.setup;
171: END IF;
172: IF NOT gmd_api_grp.setup_done THEN
173: RAISE setup_failure;

Line 170: gmd_api_grp.setup_done := gmd_api_grp.setup;

166: /* Initially let us assign the return status to success */
167: x_return_status := FND_API.g_ret_sts_success;
168:
169: IF NOT gmd_api_grp.setup_done THEN
170: gmd_api_grp.setup_done := gmd_api_grp.setup;
171: END IF;
172: IF NOT gmd_api_grp.setup_done THEN
173: RAISE setup_failure;
174: END IF;

Line 172: IF NOT gmd_api_grp.setup_done THEN

168:
169: IF NOT gmd_api_grp.setup_done THEN
170: gmd_api_grp.setup_done := gmd_api_grp.setup;
171: END IF;
172: IF NOT gmd_api_grp.setup_done THEN
173: RAISE setup_failure;
174: END IF;
175:
176: OPEN retrieve_activity_table_values(p_activity);

Line 179: gmd_api_grp.log_message ('FM_INVACTIVITY');

175:
176: OPEN retrieve_activity_table_values(p_activity);
177: FETCH retrieve_activity_table_values INTO v_update_rec;
178: IF retrieve_activity_table_values%NOTFOUND THEN
179: gmd_api_grp.log_message ('FM_INVACTIVITY');
180: CLOSE retrieve_activity_table_values;
181: RAISE inv_activity_err;
182: END IF;
183: CLOSE retrieve_activity_table_values;

Line 210: ,X_LAST_UPDATED_BY => gmd_api_grp.user_id

206: ,X_TEXT_CODE => v_update_rec.text_code
207: ,X_TRANS_CNT => v_update_rec.trans_cnt
208: ,X_ACTIVITY_DESC => v_update_rec.activity_desc
209: ,X_LAST_UPDATE_DATE => sysdate
210: ,X_LAST_UPDATED_BY => gmd_api_grp.user_id
211: ,X_LAST_UPDATE_LOGIN => gmd_api_grp.login_id);
212:
213: IF (l_debug = 'Y') THEN
214: gmd_debug.put_line('END of update_activity private');

Line 211: ,X_LAST_UPDATE_LOGIN => gmd_api_grp.login_id);

207: ,X_TRANS_CNT => v_update_rec.trans_cnt
208: ,X_ACTIVITY_DESC => v_update_rec.activity_desc
209: ,X_LAST_UPDATE_DATE => sysdate
210: ,X_LAST_UPDATED_BY => gmd_api_grp.user_id
211: ,X_LAST_UPDATE_LOGIN => gmd_api_grp.login_id);
212:
213: IF (l_debug = 'Y') THEN
214: gmd_debug.put_line('END of update_activity private');
215: END IF;