[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: (
1178: | Purpose: Check if the currency conversion date falls within
1179: | contract's header effectivity.
1180: |
1181: | In Parameters: p_chr_id the contract id
1182: | Out Parameters: x_return_status standard return status
1183: |
1184: +============================================================================*/
1185: PROCEDURE check_curr_conv_date
1186: (
1242: | contract. The existing contract should not be
1243: | cancelled, terminated or expired.
1244: |
1245: | In Parameters: p_chr_id the contract id
1246: | Out Parameters: x_return_status standard return status
1247: |
1248: +============================================================================*/
1249: PROCEDURE check_covlvl_Overlap
1250: (
1603: |
1604: | Purpose:
1605: |
1606: | In Parameters: p_chr_id the contract id
1607: | Out Parameters: x_return_status standard return status
1608: |
1609: +============================================================================*/
1610: PROCEDURE check_covered_levels(
1611: x_return_status OUT NOCOPY VARCHAR2,
2092: | Modified: mkhayer -- to support merchant and subscriber for
2093: | subscription contracts
2094: |
2095: | In Parameters: p_chr_id the contract id
2096: | Out Parameters: x_return_status standard return status
2097: |
2098: +============================================================================*/
2099: PROCEDURE check_req_values(
2100: x_return_status OUT NOCOPY VARCHAR2,
2884: | if the line start date is not between the satrt date and
2885: | end date of the tax exemption.
2886: |
2887: | In Parameters: p_chr_id the contract id
2888: | Out Parameters: x_return_status standard return status
2889: |
2890: +============================================================================*/
2891: PROCEDURE check_tax_exemption(
2892: x_return_status OUT NOCOPY VARCHAR2,
3748: |
3749: | Purpose: Checks if the customer is on credit hold.
3750: |
3751: | In Parameters: p_chr_id the contract id
3752: | Out Parameters: x_return_status standard return status
3753: |
3754: +============================================================================*/
3755: PROCEDURE check_cust_credit_hold(
3756: x_return_status OUT NOCOPY VARCHAR2,
3914: | 2. Checks if bill to address is active for service, usage
3915: | and extended warranty lines.
3916: |
3917: | In Parameters: p_chr_id the contract id
3918: | Out Parameters: x_return_status standard return status
3919: |
3920: +============================================================================*/
3921: PROCEDURE check_address(
3922: x_return_status OUT NOCOPY VARCHAR2,
4335: | 6. Checks if covered system status is active.
4336: | 7. Checks if covered site status is active.
4337: |
4338: | In Parameters: p_chr_id the contract id
4339: | Out Parameters: x_return_status standard return status
4340: |
4341: +============================================================================*/
4342: PROCEDURE check_item_effectivity
4343: (
4814: | Purpose: Returns Payment Method Details for a given Receipt
4815: | Method Id
4816: |
4817: | In Parameters: p_chr_id the contract id
4818: | Out Parameters: x_return_status standard return status
4819: |
4820: +============================================================================*/
4821: PROCEDURE Get_Pay_Method_Info
4822: (p_pay_method_id IN NUMBER
4862: | 3. Make a call to iPayment API for authorization using
4863: | 4. Update OKS header with payment information.
4864: |
4865: | In Parameters: p_chr_id the contract id
4866: | Out Parameters: x_return_status standard return status
4867: |
4868: +============================================================================*/
4869: PROCEDURE Check_Authorize_Payment
4870: (x_return_status OUT NOCOPY VARCHAR2,
4974: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'l_auth_result.auth_id: '|| l_auth_result.auth_id);
4975: END IF;
4976:
4977: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
4978: --show IBY error message on standard FND stack in QA results UI
4979: x_return_status := OKC_API.G_RET_STS_ERROR;
4980:
4981:
4982: --also pick up IBY message in l_response and place onto standard FND message stack
4978: --show IBY error message on standard FND stack in QA results UI
4979: x_return_status := OKC_API.G_RET_STS_ERROR;
4980:
4981:
4982: --also pick up IBY message in l_response and place onto standard FND message stack
4983: IF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
4984: FND_MSG_PUB.add_exc_msg(
4985: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
4986: p_procedure_name => 'Create_Authorization',
5041: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME || '.' || l_api_name,'Result_Message: '|| l_response.Result_Message);
5042: END IF;
5043:
5044: IF x_return_status <> OKC_API.G_RET_STS_SUCCESS THEN
5045: -- show IBY error message on standard FND stack in QA results UI
5046: x_return_status := OKC_API.G_RET_STS_ERROR;
5047:
5048:
5049: --also pick up IBY message in l_response and place onto standard FND message stack
5045: -- show IBY error message on standard FND stack in QA results UI
5046: x_return_status := OKC_API.G_RET_STS_ERROR;
5047:
5048:
5049: --also pick up IBY message in l_response and place onto standard FND message stack
5050: IF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5051: FND_MSG_PUB.add_exc_msg(
5052: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
5053: p_procedure_name => 'Create_Authorization',
5224:
5225: ELSIF NVL(l_response.Result_Category,'x') <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5226: x_return_status := OKC_API.G_RET_STS_ERROR; --show IBY error message (should be in stack) in QA results UI
5227:
5228: --also pick up IBY message in l_response and place onto standard FND message stack
5229: IF l_response.Result_Category <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5230: FND_MSG_PUB.add_exc_msg(
5231: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
5232: p_procedure_name => 'Get_Authorization',
5361:
5362: --show IBY error message (should be in stack) in QA results UI
5363: x_return_status := OKC_API.G_RET_STS_ERROR;
5364:
5365: --also pick up IBY message in l_response and place onto standard FND message stack
5366: IF l_response.Result_Category <> IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS THEN --'SUCCESS'
5367: FND_MSG_PUB.add_exc_msg(
5368: p_pkg_name => 'IBY_FNDCPT_TRXN_PUB',
5369: p_procedure_name => 'Get_Authorization',
5482: | level elements (billing schedule period).
5483: | 13. Sub line final price should be same as total billing schedule
5484: |
5485: | In Parameters: p_chr_id the contract id
5486: | Out Parameters: x_return_status standard return status
5487: |
5488: +============================================================================*/
5489: PROCEDURE check_billing_schedule
5490: (
6271: | Purpose: If line status is ENTERED then checks if service is available
6272: | for the covered product or item.
6273: |
6274: | In Parameters: p_chr_id the contract id
6275: | Out Parameters: x_return_status standard return status
6276: |
6277: +============================================================================*/
6278: PROCEDURE Check_product_availability
6279: (
6519: |
6520: | Purpose: Helper procedure for check_customer_availability
6521: |
6522: | In Parameters: p_chr_id the contract id
6523: | Out Parameters: x_return_status standard return status
6524: |
6525: +============================================================================*/
6526: PROCEDURE check_customer_avail_loop
6527: (
6677: | line belongs to the customer/subscriber, third party
6678: | or related customer.
6679: |
6680: | In Parameters: p_chr_id the contract id
6681: | Out Parameters: x_return_status standard return status
6682: |
6683: +============================================================================*/
6684: PROCEDURE check_customer_availability
6685: (
7157: | Purpose: This procedure will check PM schedule and PM programs
7158: | effectivity.
7159: |
7160: | In Parameters: p_chr_id the contract id
7161: | Out Parameters: x_return_status standard return status
7162: |
7163: +============================================================================*/
7164: PROCEDURE check_pm
7165: (
7229: | contract and if so is the other contract active
7230: | or signed.
7231: |
7232: | In Parameters: p_chr_id the contract id
7233: | Out Parameters: x_return_status standard return status
7234: |
7235: +============================================================================*/
7236: PROCEDURE Check_item_instance_valid
7237: (
7335: | should have at least one subscription
7336: | element(delivery schedule).
7337: |
7338: | In Parameters: p_chr_id the contract id
7339: | Out Parameters: x_return_status standard return status
7340: |
7341: +============================================================================*/
7342: PROCEDURE check_subscr_element_exist(p_chr_id IN NUMBER,
7343: x_return_status OUT NOCOPY VARCHAR2) IS
7421: | Purpose: If subscription item is shipable then ship to rule and
7422: | ship to address is required for that subscription line.
7423: |
7424: | In Parameters: p_chr_id the contract id
7425: | Out Parameters: x_return_status standard return status
7426: |
7427: +============================================================================*/
7428: PROCEDURE check_subscr_is_shipable(p_chr_id IN NUMBER,
7429: x_return_status OUT NOCOPY VARCHAR2) IS
7536: | Purpose: Will check the covered product quantity against
7537: | Installedbase.
7538: |
7539: | In Parameters: p_chr_id the contract id
7540: | Out Parameters: x_return_status standard return status
7541: |
7542: +============================================================================*/
7543: PROCEDURE check_covered_product(p_chr_id IN NUMBER,
7544: x_return_status OUT NOCOPY VARCHAR2) IS
7677: |
7678: | Purpose: Check Required Values for Preventive Maintenance
7679: |
7680: | In Parameters: p_chr_id the contract id
7681: | Out Parameters: x_return_status standard return status
7682: |
7683: +============================================================================*/
7684: PROCEDURE check_required_PM(p_chr_id IN NUMBER,
7685: x_return_status OUT NOCOPY VARCHAR2)
7720: | Purpose: Checks if price lock has been carried over from
7721: | original contract
7722: |
7723: | In Parameters: p_chr_id the contract id
7724: | Out Parameters: x_return_status standard return status
7725: |
7726: +============================================================================*/
7727: PROCEDURE check_pirce_lock(p_chr_id IN NUMBER,
7728: x_return_status OUT NOCOPY VARCHAR2)
7832: | relationships to lines on original transferred contract
7833: | that are not in a status of Active, Signed, Hold or Expired
7834: |
7835: | In Parameters: p_chr_id the contract id
7836: | Out Parameters: x_return_status standard return status
7837: |
7838: +============================================================================*/
7839:
7840: PROCEDURE Check_Ren_Source_Lines (p_chr_id IN NUMBER,
7909: | Purpose: Check to see if cancelled lines have a renewal
7910: | relationship to lines on a target contract
7911: |
7912: | In Parameters: p_chr_id the contract id
7913: | Out Parameters: x_return_status standard return status
7914: |
7915: +============================================================================*/
7916:
7917: PROCEDURE Check_Ren_Target_Lines (p_chr_id IN NUMBER,
8120: |
8121: | Purpose: Check to see if there is any active request runnning in the background for Reprice
8122: |
8123: | In Parameters: p_chr_id the contract id
8124: | Out Parameters: x_return_status standard return status
8125: |
8126: +============================================================================*/
8127:
8128: PROCEDURE check_reprice_request(
8210: |
8211: | Purpose: Checks for the covered level quantity.
8212: |
8213: | In Parameters: p_chr_id the contract id
8214: | Out Parameters: x_return_status standard return status
8215: |
8216:
8217: +============================================================================*/
8218: PROCEDURE check_qty(p_chr_id IN NUMBER,
8282: |
8283: | Purpose: Check to see if there is any active request runnning in the background for cascade attributes
8284: |
8285: | In Parameters: p_chr_id the contract id
8286: | Out Parameters: x_return_status standard return status
8287: |
8288: +============================================================================*/
8289:
8290: PROCEDURE check_cascade_request(