[Home] [Help]
272: | Purpose: Checks PO flag and number at contract level.
273: | If PO flag is 'Y' then po number is required.
274: |
275: | In Parameters: p_chr_id the contract id
276: | Out Parameters: x_return_status standard return status
277: |
278: +============================================================================*/
279: PROCEDURE Check_PO_Flag
280: (
351: | If service PO flag is 'Y' then service po number is
352: | required.
353: |
354: | In Parameters: p_chr_id the contract id
355: | Out Parameters: x_return_status standard return status
356: |
357: +============================================================================*/
358: PROCEDURE Check_Service_PO_Flag
359: (
411: |
412: | Purpose:
413: |
414: | In Parameters: p_chr_id the contract id
415: | Out Parameters: x_return_status standard return status
416: |
417: +============================================================================*/
418: PROCEDURE Check_Currency_Conv_Type
419: (
479: |
480: | Purpose:
481: |
482: | In Parameters: p_chr_id the contract id
483: | Out Parameters: x_return_status standard return status
484: |
485: +============================================================================*/
486:
487: -- GCHADHA --
703: |
704: | Purpose:
705: |
706: | In Parameters: p_chr_id the contract id
707: | Out Parameters: x_return_status standard return status
708: |
709: +============================================================================*/
710: PROCEDURE Check_Inv_Trx
711: (
810: |
811: | Purpose:
812: |
813: | In Parameters: p_chr_id the contract id
814: | Out Parameters: x_return_status standard return status
815: |
816: +============================================================================*/
817: PROCEDURE check_required_values
818: (
952: | Purpose: function to validate credit card - Hari 02/14/2001
953: | Returns 0' failure, 1' success
954: |
955: | In Parameters: p_chr_id the contract id
956: | Out Parameters: x_return_status standard return status
957: |
958: +============================================================================*/
959: FUNCTION val_credit_card (
960: p_cc_num_stripped IN VARCHAR2
1033: | covered lines of an existing contract. The existing
1034: | contract should not be cancelled, terminated or expired.
1035: |
1036: | In Parameters: p_chr_id the contract id
1037: | Out Parameters: x_return_status standard return status
1038: |
1039: +============================================================================*/
1040: PROCEDURE check_overlap
1041: (
1179: | contract. The existing contract should not be
1180: | cancelled, terminated or expired.
1181: |
1182: | In Parameters: p_chr_id the contract id
1183: | Out Parameters: x_return_status standard return status
1184: |
1185: +============================================================================*/
1186: PROCEDURE check_covlvl_Overlap
1187: (
1534: |
1535: | Purpose:
1536: |
1537: | In Parameters: p_chr_id the contract id
1538: | Out Parameters: x_return_status standard return status
1539: |
1540: +============================================================================*/
1541: PROCEDURE check_covered_levels(
1542: x_return_status OUT NOCOPY VARCHAR2,
2023: | Modified: mkhayer -- to support merchant and subscriber for
2024: | subscription contracts
2025: |
2026: | In Parameters: p_chr_id the contract id
2027: | Out Parameters: x_return_status standard return status
2028: |
2029: +============================================================================*/
2030: PROCEDURE check_req_values(
2031: x_return_status OUT NOCOPY VARCHAR2,
2815: | if the line start date is not between the satrt date and
2816: | end date of the tax exemption.
2817: |
2818: | In Parameters: p_chr_id the contract id
2819: | Out Parameters: x_return_status standard return status
2820: |
2821: +============================================================================*/
2822: PROCEDURE check_tax_exemption(
2823: x_return_status OUT NOCOPY VARCHAR2,
3679: |
3680: | Purpose: Checks if the customer is on credit hold.
3681: |
3682: | In Parameters: p_chr_id the contract id
3683: | Out Parameters: x_return_status standard return status
3684: |
3685: +============================================================================*/
3686: PROCEDURE check_cust_credit_hold(
3687: x_return_status OUT NOCOPY VARCHAR2,
3767: | 2. Checks if bill to address is active for service, usage
3768: | and extended warranty lines.
3769: |
3770: | In Parameters: p_chr_id the contract id
3771: | Out Parameters: x_return_status standard return status
3772: |
3773: +============================================================================*/
3774: PROCEDURE check_address(
3775: x_return_status OUT NOCOPY VARCHAR2,
4188: | 6. Checks if covered system status is active.
4189: | 7. Checks if covered site status is active.
4190: |
4191: | In Parameters: p_chr_id the contract id
4192: | Out Parameters: x_return_status standard return status
4193: |
4194: +============================================================================*/
4195: PROCEDURE check_item_effectivity
4196: (
4667: | Purpose: Returns Payment Method Details for a given Receipt
4668: | Method Id
4669: |
4670: | In Parameters: p_chr_id the contract id
4671: | Out Parameters: x_return_status standard return status
4672: |
4673: +============================================================================*/
4674: PROCEDURE Get_Pay_Method_Info
4675: (p_pay_method_id IN NUMBER
4715: | 3. Make a call to iPayment API for authorization using
4716: | 4. Update OKS header with payment information.
4717: |
4718: | In Parameters: p_chr_id the contract id
4719: | Out Parameters: x_return_status standard return status
4720: |
4721: +============================================================================*/
4722: PROCEDURE Check_Authorize_Payment
4723: (x_return_status OUT NOCOPY VARCHAR2,
4827: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_auth_result.auth_id: '|| l_auth_result.auth_id);
4828: END IF;
4829:
4830: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4831: --show IBY error message on standard FND stack in QA results UI
4832: x_return_status := OKC_API.G_RET_STS_ERROR;
4833:
4834:
4835: --also pick up IBY message in l_response and place onto standard FND message stack
4831: --show IBY error message on standard FND stack in QA results UI
4832: x_return_status := OKC_API.G_RET_STS_ERROR;
4833:
4834:
4835: --also pick up IBY message in l_response and place onto standard FND message stack
4836: IF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
4837: FND_MSG_PUB.add_exc_msg(
4838: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
4839: p_procedure_name => 'Create_Authorization',
4894: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'Result_Message: '|| l_response.Result_Message);
4895: END IF;
4896:
4897: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4898: -- show IBY error message on standard FND stack in QA results UI
4899: x_return_status := OKC_API.G_RET_STS_ERROR;
4900:
4901:
4902: --also pick up IBY message in l_response and place onto standard FND message stack
4898: -- show IBY error message on standard FND stack in QA results UI
4899: x_return_status := OKC_API.G_RET_STS_ERROR;
4900:
4901:
4902: --also pick up IBY message in l_response and place onto standard FND message stack
4903: IF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
4904: FND_MSG_PUB.add_exc_msg(
4905: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
4906: p_procedure_name => 'Create_Authorization',
5077:
5078: ELSIF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5079: x_return_status := OKC_API.G_RET_STS_ERROR; --show IBY error message (should be in stack) in QA results UI
5080:
5081: --also pick up IBY message in l_response and place onto standard FND message stack
5082: IF l_response.Result_Category <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5083: FND_MSG_PUB.add_exc_msg(
5084: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
5085: p_procedure_name => 'Get_Authorization',
5214:
5215: --show IBY error message (should be in stack) in QA results UI
5216: x_return_status := OKC_API.G_RET_STS_ERROR;
5217:
5218: --also pick up IBY message in l_response and place onto standard FND message stack
5219: IF l_response.Result_Category <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5220: FND_MSG_PUB.add_exc_msg(
5221: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
5222: p_procedure_name => 'Get_Authorization',
5335: | level elements (billing schedule period).
5336: | 13. Sub line final price should be same as total billing schedule
5337: |
5338: | In Parameters: p_chr_id the contract id
5339: | Out Parameters: x_return_status standard return status
5340: |
5341: +============================================================================*/
5342: PROCEDURE check_billing_schedule
5343: (
6124: | Purpose: If line status is ENTERED then checks if service is available
6125: | for the covered product or item.
6126: |
6127: | In Parameters: p_chr_id the contract id
6128: | Out Parameters: x_return_status standard return status
6129: |
6130: +============================================================================*/
6131: PROCEDURE Check_product_availability
6132: (
6372: |
6373: | Purpose: Helper procedure for check_customer_availability
6374: |
6375: | In Parameters: p_chr_id the contract id
6376: | Out Parameters: x_return_status standard return status
6377: |
6378: +============================================================================*/
6379: PROCEDURE check_customer_avail_loop
6380: (
6530: | line belongs to the customer/subscriber, third party
6531: | or related customer.
6532: |
6533: | In Parameters: p_chr_id the contract id
6534: | Out Parameters: x_return_status standard return status
6535: |
6536: +============================================================================*/
6537: PROCEDURE check_customer_availability
6538: (
7008: | Purpose: This procedure will check PM schedule and PM programs
7009: | effectivity.
7010: |
7011: | In Parameters: p_chr_id the contract id
7012: | Out Parameters: x_return_status standard return status
7013: |
7014: +============================================================================*/
7015: PROCEDURE check_pm
7016: (
7080: | contract and if so is the other contract active
7081: | or signed.
7082: |
7083: | In Parameters: p_chr_id the contract id
7084: | Out Parameters: x_return_status standard return status
7085: |
7086: +============================================================================*/
7087: PROCEDURE Check_item_instance_valid
7088: (
7186: | should have at least one subscription
7187: | element(delivery schedule).
7188: |
7189: | In Parameters: p_chr_id the contract id
7190: | Out Parameters: x_return_status standard return status
7191: |
7192: +============================================================================*/
7193: PROCEDURE check_subscr_element_exist(p_chr_id IN NUMBER,
7194: x_return_status OUT NOCOPY VARCHAR2) IS
7272: | Purpose: If subscription item is shipable then ship to rule and
7273: | ship to address is required for that subscription line.
7274: |
7275: | In Parameters: p_chr_id the contract id
7276: | Out Parameters: x_return_status standard return status
7277: |
7278: +============================================================================*/
7279: PROCEDURE check_subscr_is_shipable(p_chr_id IN NUMBER,
7280: x_return_status OUT NOCOPY VARCHAR2) IS
7387: | Purpose: Will check the covered product quantity against
7388: | Installedbase.
7389: |
7390: | In Parameters: p_chr_id the contract id
7391: | Out Parameters: x_return_status standard return status
7392: |
7393: +============================================================================*/
7394: PROCEDURE check_covered_product(p_chr_id IN NUMBER,
7395: x_return_status OUT NOCOPY VARCHAR2) IS
7528: |
7529: | Purpose: Check Required Values for Preventive Maintenance
7530: |
7531: | In Parameters: p_chr_id the contract id
7532: | Out Parameters: x_return_status standard return status
7533: |
7534: +============================================================================*/
7535: PROCEDURE check_required_PM(p_chr_id IN NUMBER,
7536: x_return_status OUT NOCOPY VARCHAR2)
7571: | Purpose: Checks if price lock has been carried over from
7572: | original contract
7573: |
7574: | In Parameters: p_chr_id the contract id
7575: | Out Parameters: x_return_status standard return status
7576: |
7577: +============================================================================*/
7578: PROCEDURE check_pirce_lock(p_chr_id IN NUMBER,
7579: x_return_status OUT NOCOPY VARCHAR2)
7683: | relationships to lines on original transferred contract
7684: | that are not in a status of Active, Signed, Hold or Expired
7685: |
7686: | In Parameters: p_chr_id the contract id
7687: | Out Parameters: x_return_status standard return status
7688: |
7689: +============================================================================*/
7690:
7691: PROCEDURE Check_Ren_Source_Lines (p_chr_id IN NUMBER,
7760: | Purpose: Check to see if cancelled lines have a renewal
7761: | relationship to lines on a target contract
7762: |
7763: | In Parameters: p_chr_id the contract id
7764: | Out Parameters: x_return_status standard return status
7765: |
7766: +============================================================================*/
7767:
7768: PROCEDURE Check_Ren_Target_Lines (p_chr_id IN NUMBER,