DBA Data[Home] [Help]

APPS.AR_CREDIT_MEMO_API_PUB dependencies on AR_CREDIT_MEMO_API_PUB

Line 1: PACKAGE BODY AR_CREDIT_MEMO_API_PUB AS

1: PACKAGE BODY AR_CREDIT_MEMO_API_PUB AS
2: /* $Header: ARWCMAPB.pls 120.18 2011/02/06 09:37:33 manishri ship $ */
3:
4: /* =======================================================================
5: Global Data Types

Line 8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_CREDIT_MEMO_API_PUB';

4: /* =======================================================================
5: Global Data Types
6: ======================================================================*/
7:
8: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AR_CREDIT_MEMO_API_PUB';
9: G_MSG_ERROR CONSTANT NUMBER := FND_MSG_PUB.G_MSG_LVL_ERROR;
10:
11: PG_DEBUG varchar2(1) := NVL(FND_PROFILE.value('AFLOG_ENABLED'), 'N');
12:

Line 33: p_request_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',

29: p_cm_reason_code IN VARCHAR2,
30: p_comments IN VARCHAR2 DEFAULT NULL,
31: p_orig_trx_number IN VARCHAR2 DEFAULT NULL,
32: p_tax_ex_cert_num IN VARCHAR2 DEFAULT NULL,
33: p_request_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
34: p_transaction_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
35: p_trans_act_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
36: p_cm_line_tbl IN Cm_Line_Tbl_Type_Cover%type := cm_line_tbl_type_cover ,
37: p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',

Line 34: p_transaction_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',

30: p_comments IN VARCHAR2 DEFAULT NULL,
31: p_orig_trx_number IN VARCHAR2 DEFAULT NULL,
32: p_tax_ex_cert_num IN VARCHAR2 DEFAULT NULL,
33: p_request_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
34: p_transaction_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
35: p_trans_act_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
36: p_cm_line_tbl IN Cm_Line_Tbl_Type_Cover%type := cm_line_tbl_type_cover ,
37: p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',
38: p_credit_method_installments IN VARCHAR2 DEFAULT NULL,

Line 35: p_trans_act_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',

31: p_orig_trx_number IN VARCHAR2 DEFAULT NULL,
32: p_tax_ex_cert_num IN VARCHAR2 DEFAULT NULL,
33: p_request_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
34: p_transaction_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
35: p_trans_act_url IN VARCHAR2 := 'AR_CREDIT_MEMO_API_PUB.print_default_page',
36: p_cm_line_tbl IN Cm_Line_Tbl_Type_Cover%type := cm_line_tbl_type_cover ,
37: p_skip_workflow_flag IN VARCHAR2 DEFAULT 'N',
38: p_credit_method_installments IN VARCHAR2 DEFAULT NULL,
39: p_credit_method_rules IN VARCHAR2 DEFAULT NULL,

Line 76: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()+');

72: l_org_id NUMBER;
73:
74: BEGIN
75: IF PG_DEBUG in ('Y', 'C') THEN
76: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()+');
77: arp_util.debug ( 'p_init_msg_list :'||p_init_msg_list);
78: arp_util.debug ( 'p_commit :'||p_commit);
79: arp_util.debug ( 'p_validation_level :'||p_validation_level);
80: arp_util.debug ( 'p_customer_trx_id :'||p_customer_trx_id);

Line 244: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Failure encountered in AR_CREDIT_MEMO_API_PUB.Create_request' ||

240:
241: -- bug 2290738 : arw_cmreq_cover.ar_request_cm will pass -1 if any error is encountered
242: if x_request_id = '-1' then
243: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
244: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Failure encountered in AR_CREDIT_MEMO_API_PUB.Create_request' ||
245: ' call to arw_cmreq_cover.ar_request_cm');
246: FND_MSG_PUB.Add;
247: raise creation_failed;
248: end if;

Line 298: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()-');

294: arp_util.debug(' Exiting from PT Code Hook');
295: END IF;
296:
297: IF PG_DEBUG in ('Y', 'C') THEN
298: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()-');
299: END IF;
300:
301: EXCEPTION
302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 359: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');

355:
356: x_return_status := FND_API.G_RET_STS_ERROR ;
357:
358: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
359: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
360: FND_MSG_PUB.Add;
361:
362: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
363: p_count => x_msg_count,

Line 408: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters()+');

404:
405: BEGIN
406:
407: IF PG_DEBUG in ('Y', 'C') THEN
408: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters()+');
409: END IF;
410: /*-----------------------------------------+
411: | Validating customer_trx_id |
412: +-----------------------------------------*/

Line 702: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters()-');

698: END IF;
699: -- END Bug 6358930
700: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
701: IF PG_DEBUG in ('Y', 'C') THEN
702: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters()-');
703: END IF;
704:
705: EXCEPTION
706: WHEN OTHERS THEN

Line 808: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Get_request_status()+');

804:
805: BEGIN
806:
807: IF PG_DEBUG in ('Y', 'C') THEN
808: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Get_request_status()+');
809: arp_util.debug ('get_request_status: ' || 'p_init_msg_list :'||p_init_msg_list);
810: arp_util.debug ('get_request_status: ' || 'p_api_version :'||p_api_version);
811: arp_util.debug ('get_request_status: ' || 'p_request_id :'||p_request_id);
812: END IF;

Line 1014: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');

1010: CLOSE notes_cur;
1011:
1012: x_return_status := FND_API.G_RET_STS_SUCCESS;
1013: IF PG_DEBUG in ('Y', 'C') THEN
1014: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
1015: END IF;
1016:
1017: EXCEPTION
1018: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1041: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');

1037: arp_util.debug ('get_request_status: ' || 'Exception OTHERS');
1038: END IF;
1039: x_return_status := FND_API.G_RET_STS_ERROR ;
1040: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
1041: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
1042:
1043: -- Display_Parameters;
1044: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1045: p_count => x_msg_count,

Line 1102: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters(OVERLOADED)+');

1098: L_TRX_NO_ERR VARCHAR2(1);
1099: BEGIN
1100:
1101: IF PG_DEBUG in ('Y', 'C') THEN
1102: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters(OVERLOADED)+');
1103: arp_util.debug ('Batch source name : ' || p_batch_source_name);
1104: END IF;
1105: /*2404776*/
1106: IF nvl(p_skip_workflow_flag,'N') = 'Y' THEN

Line 1154: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');

1150: /*4556000*/
1151: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1152: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1153: IF PG_DEBUG in ('Y', 'C') THEN
1154: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1155: END IF;
1156: return;
1157: END IF;
1158:

Line 1403: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters(OVERLOADED)-');

1399: p_attribute_rec.attribute15:=p_desc_flex_rec.attribute15;
1400:
1401: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
1402: IF PG_DEBUG in ('Y', 'C') THEN
1403: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters(OVERLOADED)-');
1404: END IF;
1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN

Line 1431: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_Int_Desc_Flex ()+');

1427: WHERE application_id = 222
1428: and descriptive_flexfield_name = p_desc_flex_name;
1429: BEGIN
1430: IF PG_DEBUG = 'Y' THEN
1431: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_Int_Desc_Flex ()+');
1432: END IF;
1433: p_return_status := FND_API.G_RET_STS_SUCCESS;
1434:
1435: OPEN desc_flex_exists;

Line 1551: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_LINE_Int_Flex ()+');

1547: WHERE application_id = 222
1548: and descriptive_flexfield_name = p_desc_flex_name;
1549: BEGIN
1550: IF PG_DEBUG = 'Y' THEN
1551: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_LINE_Int_Flex ()+');
1552: END IF;
1553: p_return_status := FND_API.G_RET_STS_SUCCESS;
1554:
1555: OPEN desc_flex_exists;

Line 1653: END AR_CREDIT_MEMO_API_PUB;

1649: END IF;
1650:
1651: END Validate_Line_Int_Flex;
1652:
1653: END AR_CREDIT_MEMO_API_PUB;