DBA Data[Home] [Help]

APPS.QA_PLANS_PUB dependencies on QA_PLANS_API

Line 169: RETURN nvl(qa_plans_api.plan_id(p_name), -1);

165: -- the plan ID, if not return -1.
166: --
167: BEGIN
168:
169: RETURN nvl(qa_plans_api.plan_id(p_name), -1);
170:
171: END plan_exists;
172:
173:

Line 2710: l_org_id := qa_plans_api.get_org_id(p_organization_code);

2706: fnd_msg_pub.add();
2707: raise fnd_api.g_exc_error;
2708: END IF;
2709:
2710: l_org_id := qa_plans_api.get_org_id(p_organization_code);
2711: IF (l_org_id IS NULL) THEN
2712: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
2713: fnd_msg_pub.add();
2714: raise fnd_api.g_exc_error;

Line 2966: l_plan_id := qa_plans_api.plan_id(upper(p_plan_name));

2962: fnd_msg_pub.add();
2963: raise fnd_api.g_exc_error;
2964: END IF;
2965:
2966: l_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
2967: IF (l_plan_id IS NULL) THEN
2968: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
2969: fnd_msg_pub.add();
2970: raise fnd_api.g_exc_error;

Line 3271: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3267: raise fnd_api.g_exc_error;
3268: END IF;
3269:
3270: l_plan_name := upper(p_plan_name);
3271: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3272: IF (l_plan_id IS NULL) THEN
3273: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3274: fnd_msg_pub.add();
3275: raise fnd_api.g_exc_error;

Line 3383: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);

3379: -- An unusual case for copy plan. The template plans have
3380: -- mixed case, but all regular plans have upper case. So,
3381: -- try them both.
3382: --
3383: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);
3384: IF (l_from_plan_id IS NULL) THEN
3385: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
3386: IF (l_from_plan_id IS NULL) THEN
3387: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');

Line 3385: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));

3381: -- try them both.
3382: --
3383: l_from_plan_id := qa_plans_api.plan_id(p_plan_name);
3384: IF (l_from_plan_id IS NULL) THEN
3385: l_from_plan_id := qa_plans_api.plan_id(upper(p_plan_name));
3386: IF (l_from_plan_id IS NULL) THEN
3387: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3388: fnd_msg_pub.add();
3389: raise fnd_api.g_exc_error;

Line 3400: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);

3396: fnd_msg_pub.add();
3397: raise fnd_api.g_exc_error;
3398: END IF;
3399:
3400: l_to_org_id := qa_plans_api.get_org_id(p_to_organization_code);
3401: IF (l_to_org_id IS NULL) THEN
3402: fnd_message.set_name('QA', 'QA_API_INVALID_ORG_CODE');
3403: fnd_msg_pub.add();
3404: raise fnd_api.g_exc_error;

Line 3538: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3534: raise fnd_api.g_exc_error;
3535: END IF;
3536:
3537: l_plan_name := upper(p_plan_name);
3538: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3539: IF (l_plan_id IS NULL) THEN
3540: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3541: fnd_msg_pub.add();
3542: RAISE fnd_api.g_exc_error;

Line 3658: l_plan_id := qa_plans_api.plan_id(l_plan_name);

3654: raise fnd_api.g_exc_error;
3655: END IF;
3656:
3657: l_plan_name := upper(p_plan_name);
3658: l_plan_id := qa_plans_api.plan_id(l_plan_name);
3659: IF l_plan_id IS NULL THEN
3660: fnd_message.set_name('QA', 'QA_API_INVALID_PLAN');
3661: fnd_msg_pub.add();
3662: raise fnd_api.g_exc_error;