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.12.12010000.2 2008/09/01 09:58:30 naneja 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 73: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()+');

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

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

226:
227: -- bug 2290738 : arw_cmreq_cover.ar_request_cm will pass -1 if any error is encountered
228: if x_request_id = '-1' then
229: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
230: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','Failure encountered in AR_CREDIT_MEMO_API_PUB.Create_request' ||
231: ' call to arw_cmreq_cover.ar_request_cm');
232: FND_MSG_PUB.Add;
233: raise creation_failed;
234: end if;

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

251: Commit;
252: END IF;
253:
254: IF PG_DEBUG in ('Y', 'C') THEN
255: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Create_request()-');
256: END IF;
257:
258: EXCEPTION
259: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

312:
313: x_return_status := FND_API.G_RET_STS_ERROR ;
314:
315: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
316: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Create_request');
317: FND_MSG_PUB.Add;
318:
319: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
320: p_count => x_msg_count,

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

361:
362: BEGIN
363:
364: IF PG_DEBUG in ('Y', 'C') THEN
365: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters()+');
366: END IF;
367: /*-----------------------------------------+
368: | Validating customer_trx_id |
369: +-----------------------------------------*/

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

655: END IF;
656: -- END Bug 6358930
657: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
658: IF PG_DEBUG in ('Y', 'C') THEN
659: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters()-');
660: END IF;
661:
662: EXCEPTION
663: WHEN OTHERS THEN

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

761:
762: BEGIN
763:
764: IF PG_DEBUG in ('Y', 'C') THEN
765: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Get_request_status()+');
766: arp_util.debug ('get_request_status: ' || 'p_init_msg_list :'||p_init_msg_list);
767: arp_util.debug ('get_request_status: ' || 'p_api_version :'||p_api_version);
768: arp_util.debug ('get_request_status: ' || 'p_request_id :'||p_request_id);
769: END IF;

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

967: CLOSE notes_cur;
968:
969: x_return_status := FND_API.G_RET_STS_SUCCESS;
970: IF PG_DEBUG in ('Y', 'C') THEN
971: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.get_request_status()-');
972: END IF;
973:
974: EXCEPTION
975: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

994: arp_util.debug ('get_request_status: ' || 'Exception OTHERS');
995: END IF;
996: x_return_status := FND_API.G_RET_STS_ERROR ;
997: FND_MESSAGE.SET_NAME ('AR','GENERIC_MESSAGE');
998: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT','AR_CREDIT_MEMO_API_PUB.Get_request_status');
999:
1000: -- Display_Parameters;
1001: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1002: p_count => x_msg_count,

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

1053: interface_line_rec interface_line_rec_type;
1054: BEGIN
1055:
1056: IF PG_DEBUG in ('Y', 'C') THEN
1057: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.validate_request_parameters(OVERLOADED)+');
1058: END IF;
1059: /*Still call old procedure*/
1060: validate_request_parameters (
1061: p_customer_trx_id => p_customer_trx_id,

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

1076: /*4556000*/
1077: IF l_val_return_status <> FND_API.G_RET_STS_SUCCESS then
1078: l_val_return_status:=FND_API.G_RET_STS_ERROR;
1079: IF PG_DEBUG in ('Y', 'C') THEN
1080: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters returned error');
1081: END IF;
1082: return;
1083: END IF;
1084:

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

1325: p_attribute_rec.attribute15:=p_desc_flex_rec.attribute15;
1326:
1327: l_val_return_status := FND_API.G_RET_STS_SUCCESS;
1328: IF PG_DEBUG in ('Y', 'C') THEN
1329: arp_util.debug ('AR_CREDIT_MEMO_API_PUB.Validate_request_parameters(OVERLOADED)-');
1330: END IF;
1331:
1332: EXCEPTION
1333: WHEN OTHERS THEN

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

1353: WHERE application_id = 222
1354: and descriptive_flexfield_name = p_desc_flex_name;
1355: BEGIN
1356: IF PG_DEBUG = 'Y' THEN
1357: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_Int_Desc_Flex ()+');
1358: END IF;
1359: p_return_status := FND_API.G_RET_STS_SUCCESS;
1360:
1361: OPEN desc_flex_exists;

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

1473: WHERE application_id = 222
1474: and descriptive_flexfield_name = p_desc_flex_name;
1475: BEGIN
1476: IF PG_DEBUG = 'Y' THEN
1477: ar_invoice_utils.debug('' || 'AR_CREDIT_MEMO_API_PUB.Validate_LINE_Int_Flex ()+');
1478: END IF;
1479: p_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481: OPEN desc_flex_exists;

Line 1579: END AR_CREDIT_MEMO_API_PUB;

1575: END IF;
1576:
1577: END Validate_Line_Int_Flex;
1578:
1579: END AR_CREDIT_MEMO_API_PUB;