APPS.AMS_COPYELEMENTS_PVT dependencies on AMS_ACT_PRODUCTS

Line 87: FROM ams_act_products

83: l_lookup_meaning VARCHAR2 (80);
84: -- select all products of the calling activity
85: CURSOR prod_cur IS
86: SELECT *
87: FROM ams_act_products
88: WHERE act_product_used_by_id = p_src_act_id
89: AND arc_act_product_used_by = p_src_act_type;
90: BEGIN
91:

Line 117: SAVEPOINT ams_act_products;

113:
114: FOR prod_rec IN prod_cur
115: LOOP
116: BEGIN
117: SAVEPOINT ams_act_products;
118: l_api_version := 1.0;
119: l_act_product_id := 0;
120: l_act_prod_rec := temp_act_prod_rec;
121: l_act_prod_rec.act_product_used_by_id := p_new_act_id;

Line 182: ROLLBACK TO ams_act_products;

178: 'ERROR'
179: );
180: END LOOP;
181: ---- if error then right a copy log message to the log table
182: ROLLBACK TO ams_act_products;
183: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR2');
184: fnd_message.set_token ('ELEMENTS', l_lookup_meaning, TRUE);
185: l_mesg_text := fnd_message.get;
186: p_errmsg := SUBSTR ( l_mesg_text || ' - ' ||

Line 199: ROLLBACK TO ams_act_products;

195: END IF;
196: EXCEPTION
197: WHEN OTHERS
198: THEN
199: ROLLBACK TO ams_act_products;
200: p_errcode := SQLCODE;
201: p_errnum := 3;
202: l_stmt_num := 4;
203: fnd_message.set_name ('AMS', 'AMS_COPY_ERROR');