eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_PARENT_CHILD_COPY_PKG dependencies on FND_API

Line 73: x_return_status := fnd_api.g_true;

69: X_Last_Update_Login => fnd_global.user_id);
70:
71: --return a value of success
72: x_old_plan_relationship_id := c1_rec.plan_relationship_id;
73: x_return_status := fnd_api.g_true;
74: END;
75:
76: --this procedure copies all element relationships pertaining to p_old_relationship_id
77: --to p_new_plan_relationship_id. returns a status value to indicate success/failure.

Line 105: x_return_status := fnd_api.g_true;

101: x_element_relationship_id => l_new_element_relationship_id);
102: END LOOP;
103:
104: --return a value of success if we make it this far
105: x_return_status := fnd_api.g_true;
106: END;
107:
108: --this procedure copies all criteria pertaining to p_old_plan_relationship_id to
109: --p_new_plan_relationship_id. returns a return_status value to indicate success/failure

Line 135: x_return_status := fnd_api.g_true;

131: x_criteria_id => l_new_criteria_id);
132: END LOOP;
133:
134: --return a value of success if we make it this far
135: x_return_status := fnd_api.g_true;
136:
137: END;
138:
139: --this is a helper procedure that calls the UI mapping code for a given plan_id, x_return_status is

Line 140: --fnd_api.g_true on success, fnd_api.g_false on failure

136:
137: END;
138:
139: --this is a helper procedure that calls the UI mapping code for a given plan_id, x_return_status is
140: --fnd_api.g_true on success, fnd_api.g_false on failure
141: --this function assumes that fnd_global.apps_initialize has already been called
142:
143: -- anagarwa Tue Dec 24 11:44:52 PST 2002
144: -- Bug 2725466

Line 163: x_return_status := fnd_api.g_true;

159: argument3 => to_char(p_plan_id));
160: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
161: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
162: 'qapccpb.pls', 'copy_all, add ak generation request #'||l_request_id);
163: x_return_status := fnd_api.g_true;
164: end if;
165: ELSE
166: x_return_status := fnd_api.g_false;
167: END IF;

Line 166: x_return_status := fnd_api.g_false;

162: 'qapccpb.pls', 'copy_all, add ak generation request #'||l_request_id);
163: x_return_status := fnd_api.g_true;
164: end if;
165: ELSE
166: x_return_status := fnd_api.g_false;
167: END IF;
168: END;
169:
170: PROCEDURE COPY_ALL(p_source_parent_plan_id IN NUMBER,

Line 192: IF l_return_status <> fnd_api.g_true OR l_old_plan_relationship_id = -1 THEN

188: p_target_child_plan_id,
189: l_old_plan_relationship_id,
190: l_new_plan_relationship_id,
191: l_return_status);
192: IF l_return_status <> fnd_api.g_true OR l_old_plan_relationship_id = -1 THEN
193: x_return_status := fnd_api.g_false;
194: RETURN;
195: END IF;
196:

Line 193: x_return_status := fnd_api.g_false;

189: l_old_plan_relationship_id,
190: l_new_plan_relationship_id,
191: l_return_status);
192: IF l_return_status <> fnd_api.g_true OR l_old_plan_relationship_id = -1 THEN
193: x_return_status := fnd_api.g_false;
194: RETURN;
195: END IF;
196:
197: --attempt to copy element relationships next

Line 201: IF l_return_status <> fnd_api.g_true THEN

197: --attempt to copy element relationships next
198: copy_element_rel(l_old_plan_relationship_id,
199: l_new_plan_relationship_id,
200: l_return_status);
201: IF l_return_status <> fnd_api.g_true THEN
202: ROLLBACK TO copy_all_pub;
203: x_return_status := fnd_api.g_false;
204: RETURN;
205: END IF;

Line 203: x_return_status := fnd_api.g_false;

199: l_new_plan_relationship_id,
200: l_return_status);
201: IF l_return_status <> fnd_api.g_true THEN
202: ROLLBACK TO copy_all_pub;
203: x_return_status := fnd_api.g_false;
204: RETURN;
205: END IF;
206:
207: --attempt to copy criteria lastly

Line 211: IF l_return_status <> fnd_api.g_true THEN

207: --attempt to copy criteria lastly
208: copy_criteria(l_old_plan_relationship_id,
209: l_new_plan_relationship_id,
210: l_return_status);
211: IF l_return_status <> fnd_api.g_true THEN
212: ROLLBACK TO copy_all_pub;
213: x_return_status := fnd_api.g_false;
214: RETURN;
215: END IF;

Line 213: x_return_status := fnd_api.g_false;

209: l_new_plan_relationship_id,
210: l_return_status);
211: IF l_return_status <> fnd_api.g_true THEN
212: ROLLBACK TO copy_all_pub;
213: x_return_status := fnd_api.g_false;
214: RETURN;
215: END IF;
216:
217: --see if we need to call the mapping functions

Line 218: IF p_call_mapping = fnd_api.g_true THEN

214: RETURN;
215: END IF;
216:
217: --see if we need to call the mapping functions
218: IF p_call_mapping = fnd_api.g_true THEN
219: --initialize the app for creating the UI mappings for these plans
220: fnd_global.apps_initialize(user_id => fnd_global.user_id,
221: resp_id => 20561,
222: resp_appl_id => 250);

Line 226: IF x_return_status <> fnd_api.g_true THEN

222: resp_appl_id => 250);
223:
224:
225: map_ui_from_plan_id(p_target_parent_plan_id, x_return_status);
226: IF x_return_status <> fnd_api.g_true THEN
227: RETURN;
228: END IF;
229:
230: map_ui_from_plan_id(p_target_child_plan_id, x_return_status);

Line 231: IF x_return_status <> fnd_api.g_true THEN

227: RETURN;
228: END IF;
229:
230: map_ui_from_plan_id(p_target_child_plan_id, x_return_status);
231: IF x_return_status <> fnd_api.g_true THEN
232: RETURN;
233: END IF;
234: END IF;
235:

Line 237: x_return_status := fnd_api.g_true;

233: END IF;
234: END IF;
235:
236: --otherwise everything was successfull so return TRUE
237: x_return_status := fnd_api.g_true;
238: END;
239:
240: --this function gets the organization_code from an org id
241: FUNCTION get_org_code_from_orgid(p_orgid IN NUMBER)

Line 490: --the actions associated with the NCM project. it returns either fnd_api.g_true or fnd_api.g_false

486: END LOOP;
487: END;
488:
489: --this function is one of the helper functions to execute_spec_proc_requests. It updates all
490: --the actions associated with the NCM project. it returns either fnd_api.g_true or fnd_api.g_false
491: --in x_return_status and uses x_msg_data for any return code reason.
492: PROCEDURE execute_NCM_spec_proc_request(p_src_org_id IN VARCHAR2,
493: p_dest_org_code IN VARCHAR2,
494: p_phtable IN plan_htable,

Line 577: x_return_status := fnd_api.g_true;

573: l_src_plan_id := p_phtable.NEXT(l_src_plan_id);
574: END LOOP;
575:
576: --return that we succceeded in action processing
577: x_return_status := fnd_api.g_true;
578: EXCEPTION
579: WHEN OTHERS THEN
580: x_msg_data := 'Special Processing Request "'||SP_NCM||'" encountered an error: Code('||SQLCODE||'), Message("'||SQLERRM||'")';
581: x_return_status := fnd_api.g_false;

Line 581: x_return_status := fnd_api.g_false;

577: x_return_status := fnd_api.g_true;
578: EXCEPTION
579: WHEN OTHERS THEN
580: x_msg_data := 'Special Processing Request "'||SP_NCM||'" encountered an error: Code('||SQLCODE||'), Message("'||SQLERRM||'")';
581: x_return_status := fnd_api.g_false;
582: RETURN;
583: END;
584:
585: --this function takes the p_src_org_id, p_dest_org_code, and p_phtable representing

Line 590: --x_return_status = fnd_api.g_true on success, fnd_api.g_false on failure

586: --the source and duplicate schema information and applies all special processing requests in
587: --the p_special_proc_field string and returns a success/failure indicator in x_return_status and an
588: --optional failure message in x_msg_data
589: --p_special_proc_field is of the form @@...
590: --x_return_status = fnd_api.g_true on success, fnd_api.g_false on failure
591: PROCEDURE execute_spec_proc_requests(p_src_org_id IN VARCHAR2,
592: p_dest_org_code IN VARCHAR2,
593: p_phtable IN plan_htable,
594: p_special_proc_field IN VARCHAR2,

Line 626: x_return_status := fnd_api.g_false;

622: p_phtable => p_phtable,
623: x_msg_data => x_msg_data,
624: x_return_status => x_return_status);
625: ELSE
626: x_return_status := fnd_api.g_false;
627: x_msg_data := 'Error while executing special processing requests! Special Processing Request Identifier "'||token||'" invalid.';
628: RETURN;
629: END IF;
630:

Line 632: IF x_return_status <> fnd_api.g_true THEN

628: RETURN;
629: END IF;
630:
631: --see if the special processing function returned ok, if not return
632: IF x_return_status <> fnd_api.g_true THEN
633: RETURN;
634: END IF;
635:
636: END LOOP;

Line 639: x_return_status := fnd_api.g_true;

635:
636: END LOOP;
637:
638: --x_msg_data := '';
639: x_return_status := fnd_api.g_true;
640: END;
641:
642: --this function is used by setup_plans to make sure that there isn't a duplicate plan name.
643: --instead of checking the full name, however, it checks the first 25 characters since the view names

Line 680: --x_return_status = fnd_api.g_true on success, fnd_api.g_false on failure

676: --To handle capturing an eSignature for each newly created plan, we have a parameter that
677: --forces all new plans to be created as disabled. This is implemented by moving the
678: --Effective To and Effective From dates to something which makes sense.
679: --optional failure message in x_msg_data
680: --x_return_status = fnd_api.g_true on success, fnd_api.g_false on failure
681: PROCEDURE disable_plans(p_phtable IN plan_htable,
682: x_msg_data OUT NOCOPY VARCHAR2,
683: x_return_status OUT NOCOPY VARCHAR2)
684: IS

Line 703: x_return_status := fnd_api.g_true;

699: BEGIN
700: --sanity check
701: IF p_phtable.COUNT < 1 THEN
702: x_msg_data := '';
703: x_return_status := fnd_api.g_true;
704: RETURN;
705: END IF;
706:
707: --init the sql string

Line 751: x_return_status := fnd_api.g_false;

747:
748: --make sure we got everything
749: IF id_table.COUNT <> n THEN
750: x_msg_data := 'Invalid fetch count('||id_table.COUNT||'), expecting('||n||').';
751: x_return_status := fnd_api.g_false;
752: RETURN;
753: END IF;
754:
755: --now go through each plan_id and modify the dates

Line 778: x_return_status := fnd_api.g_true;

774: dbms_sql.close_cursor(c2);
775:
776: --return success
777: x_msg_data := '';
778: x_return_status := fnd_api.g_true;
779:
780: exception when others then
781: if dbms_sql.is_open(c1) then
782: dbms_sql.close_cursor(c1);

Line 788: x_return_status := fnd_api.g_false;

784: if dbms_sql.is_open(c2) then
785: dbms_sql.close_cursor(c2);
786: end if;
787: x_msg_data := 'unexpected error: Code('||SQLCODE||'), Message("'||SQLERRM||'")';
788: x_return_status := fnd_api.g_false;
789: RETURN;
790: END;
791:
792: FUNCTION SETUP_PLANS(p_src_org_id IN VARCHAR2,

Line 909: IF l_return_status <> fnd_api.g_ret_sts_success THEN

905: x_to_plan_id => phtable(src_id).dest_id,
906: x_msg_count => l_msg_count,
907: x_msg_data => l_msg_data,
908: x_return_status => l_return_status);
909: IF l_return_status <> fnd_api.g_ret_sts_success THEN
910: ROLLBACK TO setup_plans_pub;
911: x_return_msg := 'setup_plans,copy collection_plan: src_plan('||
912: phtable(src_id).src_name||'), dest_plan('||phtable(src_id).dest_name||
913: ') returned with an error.';

Line 935: p_call_mapping => fnd_api.g_false,

931: copy_all(p_source_parent_plan_id => src_id,
932: p_source_child_plan_id => child_id,
933: p_target_parent_plan_id => phtable(src_id).dest_id,
934: p_target_child_plan_id => phtable(child_id).dest_id,
935: p_call_mapping => fnd_api.g_false,
936: x_return_status => l_return_status);
937: IF l_return_status <> fnd_api.g_true THEN
938: x_return_msg := 'setup_plans, copy_all: src_parent_id('||src_id||
939: '),src_child_id('||child_id||'), dest_parent_id('||

Line 937: IF l_return_status <> fnd_api.g_true THEN

933: p_target_parent_plan_id => phtable(src_id).dest_id,
934: p_target_child_plan_id => phtable(child_id).dest_id,
935: p_call_mapping => fnd_api.g_false,
936: x_return_status => l_return_status);
937: IF l_return_status <> fnd_api.g_true THEN
938: x_return_msg := 'setup_plans, copy_all: src_parent_id('||src_id||
939: '),src_child_id('||child_id||'), dest_parent_id('||
940: phtable(src_id).dest_id||'), dest_child_id('||phtable(child_id).dest_id||
941: ') failed.';

Line 991: IF l_return_status <> fnd_api.g_true THEN

987: p_phtable => phtable,
988: p_special_proc_field => p_special_proc_field,
989: x_msg_data => l_msg_data,
990: x_return_status => l_return_status);
991: IF l_return_status <> fnd_api.g_true THEN
992: ROLLBACK TO setup_plans_pub;
993: x_return_msg := 'setup_plans,execute special processing requests: returned "'||l_msg_data||'"';
994: RETURN -1;
995: END IF;

Line 1003: IF l_return_status <> fnd_api.g_true THEN

999: IF p_disable_plans IS NOT NULL and p_disable_plans = 'Y' THEN
1000: disable_plans(p_phtable => phtable,
1001: x_msg_data => l_msg_data,
1002: x_return_status => l_return_status);
1003: IF l_return_status <> fnd_api.g_true THEN
1004: ROLLBACK TO setup_plans_pub;
1005: x_return_msg := 'setup_plans,execute disable_plans: returned "'||l_msg_data||'"';
1006: RETURN -1;
1007: END IF;