DBA Data[Home] [Help]

APPS.AR_DEPOSIT_API_PUB dependencies on FND_API

Line 96: IF ar_deposit_lib_pvt.pg_profile_batch_source = FND_API.G_MISS_NUM THEN

92: PROCEDURE initialize_profile_globals IS
93: l_dummy varchar2(1);
94: BEGIN
95: arp_util.debug('AR_DEPOSIT_API_PUB.initialize_profile_globals()+ ');
96: IF ar_deposit_lib_pvt.pg_profile_batch_source = FND_API.G_MISS_NUM THEN
97: ar_deposit_lib_pvt.pg_profile_batch_source
98: := fnd_profile.value('AR_RA_BATCH_SOURCE');
99: --To make sure that Batch derived from profile option belongs to same org
100: BEGIN

Line 113: IF ar_deposit_lib_pvt.pg_profile_doc_seq = FND_API.G_MISS_CHAR THEN

109: END;
110:
111: END IF;
112:
113: IF ar_deposit_lib_pvt.pg_profile_doc_seq = FND_API.G_MISS_CHAR THEN
114: ar_deposit_lib_pvt.pg_profile_doc_seq
115: := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
116: END IF;
117:

Line 118: IF ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag = FND_API.G_MISS_CHAR THEN

114: ar_deposit_lib_pvt.pg_profile_doc_seq
115: := fnd_profile.value('UNIQUE:SEQ_NUMBERS');
116: END IF;
117:
118: IF ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag = FND_API.G_MISS_CHAR THEN
119: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag
120: := fnd_profile.value('ZX_ALLOW_TRX_LINE_EXEMPTIONS');
121: END IF;
122:

Line 125: -- IF ar_deposit_lib_pvt.pg_profile_enable_cc = FND_API.G_MISS_CHAR THEN

121: END IF;
122:
123: -- Profile option AR_ENABLE_CROSS_CURRENCY has been obsolited instead it
124: -- now always state 'Y'
125: -- IF ar_deposit_lib_pvt.pg_profile_enable_cc = FND_API.G_MISS_CHAR THEN
126: ar_deposit_lib_pvt.pg_profile_enable_cc := 'Y';
127: -- := fnd_profile.value('AR_ENABLE_CROSS_CURRENCY');
128: -- END IF;
129:

Line 131: IF ar_deposit_lib_pvt.pg_profile_cc_rate_type = FND_API.G_MISS_CHAR THEN

127: -- := fnd_profile.value('AR_ENABLE_CROSS_CURRENCY');
128: -- END IF;
129:
130:
131: IF ar_deposit_lib_pvt.pg_profile_cc_rate_type = FND_API.G_MISS_CHAR THEN
132: ar_deposit_lib_pvt.pg_profile_cc_rate_type
133: := ar_setup.value('AR_CROSS_CURRENCY_RATE_TYPE',null);
134: -- null should be replaced with org_id, to find profile for diffrent org
135: END IF;

Line 137: IF ar_deposit_lib_pvt.pg_profile_dsp_inv_rate = FND_API.G_MISS_CHAR THEN

133: := ar_setup.value('AR_CROSS_CURRENCY_RATE_TYPE',null);
134: -- null should be replaced with org_id, to find profile for diffrent org
135: END IF;
136:
137: IF ar_deposit_lib_pvt.pg_profile_dsp_inv_rate = FND_API.G_MISS_CHAR THEN
138: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate
139: := fnd_profile.value('DISPLAY_INVERSE_RATE');
140: END IF;
141:

Line 142: IF ar_deposit_lib_pvt.pg_profile_def_x_rate_type = FND_API.G_MISS_CHAR THEN

138: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate
139: := fnd_profile.value('DISPLAY_INVERSE_RATE');
140: END IF;
141:
142: IF ar_deposit_lib_pvt.pg_profile_def_x_rate_type = FND_API.G_MISS_CHAR THEN
143: ar_deposit_lib_pvt.pg_profile_def_x_rate_type
144: := fnd_profile.value('AR_DEFAULT_EXCHANGE_RATE_TYPE');
145: END IF;
146:

Line 189: | FND_API.Compatible_API_Call

185: | CALLS PROCEDURES/FUNCTIONS (local to this package body)
186: | Enter a list of all local procedures and funtions which
187: | this package calls.
188: | arp_util.debug(
189: | FND_API.Compatible_API_Call
190: | FND_API.G_EXC_UNEXPECTED_ERROR
191: | FND_API.to_Boolean
192: | FND_MSG_PUB.initialize
193: | AR_DEPOSIT_LIB_PVT.Default_deposit_ids

Line 190: | FND_API.G_EXC_UNEXPECTED_ERROR

186: | Enter a list of all local procedures and funtions which
187: | this package calls.
188: | arp_util.debug(
189: | FND_API.Compatible_API_Call
190: | FND_API.G_EXC_UNEXPECTED_ERROR
191: | FND_API.to_Boolean
192: | FND_MSG_PUB.initialize
193: | AR_DEPOSIT_LIB_PVT.Default_deposit_ids
194: | AR_DEPOSIT_LIB_PVT.Get_deposit_Defaults

Line 191: | FND_API.to_Boolean

187: | this package calls.
188: | arp_util.debug(
189: | FND_API.Compatible_API_Call
190: | FND_API.G_EXC_UNEXPECTED_ERROR
191: | FND_API.to_Boolean
192: | FND_MSG_PUB.initialize
193: | AR_DEPOSIT_LIB_PVT.Default_deposit_ids
194: | AR_DEPOSIT_LIB_PVT.Get_deposit_Defaults
195: | ar_deposit_val_pvt.Validate_Deposit

Line 366: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

362:
363: PROCEDURE CREATE_DEPOSIT(
364: -- Standard API parameters.
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
367: p_commit IN VARCHAR2 := FND_API.G_TRUE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,

Line 367: p_commit IN VARCHAR2 := FND_API.G_TRUE,

363: PROCEDURE CREATE_DEPOSIT(
364: -- Standard API parameters.
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
367: p_commit IN VARCHAR2 := FND_API.G_TRUE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,

Line 368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

364: -- Standard API parameters.
365: p_api_version IN NUMBER,
366: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
367: p_commit IN VARCHAR2 := FND_API.G_TRUE,
368: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
369: x_return_status OUT NOCOPY VARCHAR2,
370: x_msg_count OUT NOCOPY NUMBER,
371: x_msg_data OUT NOCOPY VARCHAR2,
372:

Line 791: IF NOT FND_API.Compatible_API_Call(

787: /*--------------------------------------------------+
788: | Standard call to check for call compatibility |
789: +--------------------------------------------------*/
790:
791: IF NOT FND_API.Compatible_API_Call(
792: l_api_version,
793: p_api_version,
794: l_api_name,
795: G_PKG_NAME

Line 798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

794: l_api_name,
795: G_PKG_NAME
796: )
797: THEN
798: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
799: END IF;
800:
801: /*--------------------------------------------------------------+
802: | Initialize message list if p_init_msg_list is set to TRUE |

Line 805: IF FND_API.to_Boolean( p_init_msg_list )

801: /*--------------------------------------------------------------+
802: | Initialize message list if p_init_msg_list is set to TRUE |
803: +--------------------------------------------------------------*/
804:
805: IF FND_API.to_Boolean( p_init_msg_list )
806: THEN
807: FND_MSG_PUB.initialize;
808: END IF;
809:

Line 814: x_return_status := FND_API.G_RET_STS_SUCCESS;

810: /*-----------------------------------------+
811: | Initialize return status to SUCCESS |
812: +-----------------------------------------*/
813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;
816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;

Line 815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;

811: | Initialize return status to SUCCESS |
812: +-----------------------------------------*/
813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;
816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;

Line 817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;

813:
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;
816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;

Line 818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;

814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;
816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;

Line 819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;

815: l_doc_seq_status := FND_API.G_RET_STS_SUCCESS;
816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;

Line 820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */

816:
817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;
824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;

Line 821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;

817: l_id_return_status := FND_API.G_RET_STS_SUCCESS;
818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;
824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;
825:

Line 822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;

818: l_cdflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;
824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;
825:
826:

Line 823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;

819: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;
824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;
825:
826:
827:

Line 824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;

820: l_intflex_val_return_status := FND_API.G_RET_STS_SUCCESS; /* Bug 4895995 FP Bug 5467022 */
821: l_dft_return_status := FND_API.G_RET_STS_SUCCESS;
822: l_receipt_method_status := FND_API.G_RET_STS_SUCCESS;
823: l_return_val_status := FND_API.G_RET_STS_SUCCESS;
824: l_bank_acct_status := FND_API.G_RET_STS_SUCCESS;
825:
826:
827:
828: /* SSA change */

Line 830: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

826:
827:
828: /* SSA change */
829: l_org_id := p_org_id;
830: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
831: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
832: p_return_status =>l_org_return_status);
833: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;

Line 833: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

829: l_org_id := p_org_id;
830: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
831: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
832: p_return_status =>l_org_return_status);
833: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: ELSE
836: /*-------------------------------------------------+
837: | Initialize the profile option package variables |

Line 834: x_return_status := FND_API.G_RET_STS_ERROR;

830: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
831: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
832: p_return_status =>l_org_return_status);
833: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
834: x_return_status := FND_API.G_RET_STS_ERROR;
835: ELSE
836: /*-------------------------------------------------+
837: | Initialize the profile option package variables |
838: +-------------------------------------------------*/

Line 1031: x_return_status := FND_API.G_RET_STS_ERROR;

1027: l_default_cust_trx_type_id is NULL THEN
1028:
1029: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');
1030: FND_MSG_PUB.Add;
1031: x_return_status := FND_API.G_RET_STS_ERROR;
1032: ELSIF l_cust_trx_type_id is NULL and l_default_cust_trx_type_id is NOT NULL THEN
1033: BEGIN
1034: SELECT cust_trx_type_id
1035: INTO l_cust_trx_type_id

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR;

1043:
1044: WHEN NO_DATA_FOUND THEN
1045: FND_MESSAGE.SET_NAME('AR','AR_DAPI_TRANS_TYPE_NULL');
1046: FND_MSG_PUB.Add;
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: WHEN OTHERS THEN
1049: RAISE;
1050: END;
1051:

Line 1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR

1141: l_cdflex_val_return_status
1142: );
1143: END IF;
1144:
1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR
1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR

Line 1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

1142: );
1143: END IF;
1144:
1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR
1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR

Line 1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

1143: END IF;
1144:
1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR
1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR

Line 1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/

1144:
1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR
1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR
1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS

Line 1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR

1145: IF l_id_return_status <> FND_API.G_RET_STS_SUCCESS OR
1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR
1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS
1153:

Line 1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR

1146: l_cdflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR
1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS
1153:
1154:

Line 1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR

1147: l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR
1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS
1153:
1154:
1155: THEN

Line 1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS

1148: l_intflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR /* Bug 4895995 FP Bug 5467022*/
1149: l_dft_return_status <> FND_API.G_RET_STS_SUCCESS OR
1150: l_return_val_status <> FND_API.G_RET_STS_SUCCESS OR
1151: l_receipt_method_status <> FND_API.G_RET_STS_SUCCESS OR
1152: l_bank_acct_status <> FND_API.G_RET_STS_SUCCESS
1153:
1154:
1155: THEN
1156:

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

1153:
1154:
1155: THEN
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: END IF;
1160:
1161: /*-----------------------------------------------------------------------------+

Line 1166: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1162: | Call the document sequence routine only there have been no errors reported |
1163: | so far. |
1164: +-----------------------------------------------------------------------------*/
1165:
1166: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1167:
1168: ar_deposit_lib_pvt.get_doc_seq(222,
1169: l_default_type_name,
1170: --l_receipt_method_name,

Line 1188: x_return_status <> FND_API.G_RET_STS_SUCCESS

1184: +------------------------------------------------------------*/
1185: arp_util.debug('x_return_status : '||x_return_status);
1186: arp_util.debug('l_doc_seq_status : '||l_doc_seq_status);
1187: IF (
1188: x_return_status <> FND_API.G_RET_STS_SUCCESS
1189: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
1190: )
1191: THEN
1192:

Line 1189: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS

1185: arp_util.debug('x_return_status : '||x_return_status);
1186: arp_util.debug('l_doc_seq_status : '||l_doc_seq_status);
1187: IF (
1188: x_return_status <> FND_API.G_RET_STS_SUCCESS
1189: OR l_doc_seq_status <> FND_API.G_RET_STS_SUCCESS
1190: )
1191: THEN
1192:
1193: ROLLBACK TO Create_Deposit_PVT;

Line 1201: x_return_status := FND_API.G_RET_STS_ERROR ;

1197: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
1198: | in the message stack. If there is only one message in |
1199: | the stack it retrieves this message |
1200: +-------------------------------------------------------*/
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202:
1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);

Line 1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1199: | the stack it retrieves this message |
1200: +-------------------------------------------------------*/
1201: x_return_status := FND_API.G_RET_STS_ERROR ;
1202:
1203: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1204: p_count => x_msg_count,
1205: p_data => x_msg_data);
1206:
1207: arp_util.debug('Error(s) occurred.

Line 1228: x_return_status := FND_API.G_RET_STS_ERROR ;

1224: l_cust_trx_type_id,
1225: l_batch_source_id);
1226: IF NVL(l_legal_entity_id, -1) = -1 then
1227: ROLLBACK TO Create_Deposit_PVT;
1228: x_return_status := FND_API.G_RET_STS_ERROR ;
1229: Return;
1230: END IF;
1231:
1232: IF pg_debug = 'Y' THEN

Line 1240: x_return_status := FND_API.G_RET_STS_ERROR ;

1236: EXCEPTION
1237: WHEN Others THEN
1238: FND_MESSAGE.SET_NAME('AR','AR_LE_NAME_MANDATORY');
1239: FND_MSG_PUB.Add;
1240: x_return_status := FND_API.G_RET_STS_ERROR ;
1241: ROLLBACK TO Create_Deposit_PVT;
1242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1243: p_count => x_msg_count,
1244: p_data => x_msg_data);

Line 1242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1238: FND_MESSAGE.SET_NAME('AR','AR_LE_NAME_MANDATORY');
1239: FND_MSG_PUB.Add;
1240: x_return_status := FND_API.G_RET_STS_ERROR ;
1241: ROLLBACK TO Create_Deposit_PVT;
1242: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1243: p_count => x_msg_count,
1244: p_data => x_msg_data);
1245: return;
1246: END;

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR ;

1423: FND_MSG_PUB.Add;
1424: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1426: FND_MSG_PUB.Add;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: ROLLBACK TO Create_Deposit_PVT;
1429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1430: p_count => x_msg_count,
1431: p_data => x_msg_data);

Line 1429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1425: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1426: FND_MSG_PUB.Add;
1427: x_return_status := FND_API.G_RET_STS_ERROR ;
1428: ROLLBACK TO Create_Deposit_PVT;
1429: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1430: p_count => x_msg_count,
1431: p_data => x_msg_data);
1432: Return;
1433: END;

Line 1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1449:
1450:
1451:
1452:
1453: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1454: FND_MESSAGE.SET_NAME('AR','AR_CC_AUTH_FAILED');
1455: FND_MSG_PUB.Add;
1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);

Line 1459: x_return_status := FND_API.G_RET_STS_ERROR ;

1455: FND_MSG_PUB.Add;
1456: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1458: FND_MSG_PUB.Add;
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: ROLLBACK TO Create_Deposit_PVT;
1461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);

Line 1461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1457: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1458: FND_MSG_PUB.Add;
1459: x_return_status := FND_API.G_RET_STS_ERROR ;
1460: ROLLBACK TO Create_Deposit_PVT;
1461: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1462: p_count => x_msg_count,
1463: p_data => x_msg_data);
1464: Return;
1465: END IF;

Line 1473: x_return_status := FND_API.G_RET_STS_ERROR ;

1469:
1470: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1472: FND_MSG_PUB.Add;
1473: x_return_status := FND_API.G_RET_STS_ERROR ;
1474: ROLLBACK TO Create_Deposit_PVT;
1475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);

Line 1475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1471: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1472: FND_MSG_PUB.Add;
1473: x_return_status := FND_API.G_RET_STS_ERROR ;
1474: ROLLBACK TO Create_Deposit_PVT;
1475: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1476: p_count => x_msg_count,
1477: p_data => x_msg_data);
1478: return;
1479:

Line 1518: x_return_status := FND_API.G_RET_STS_ERROR ;

1514: FND_MSG_PUB.Add;
1515: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1517: FND_MSG_PUB.Add;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: ROLLBACK TO Create_Deposit_PVT;
1520: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data);

Line 1520: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1516: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
1517: FND_MSG_PUB.Add;
1518: x_return_status := FND_API.G_RET_STS_ERROR ;
1519: ROLLBACK TO Create_Deposit_PVT;
1520: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1521: p_count => x_msg_count,
1522: p_data => x_msg_data);
1523: Return;
1524:

Line 1549: IF FND_API.To_Boolean( p_commit )

1545: /*--------------------------------+
1546: | Standard check of p_commit |
1547: +--------------------------------*/
1548:
1549: IF FND_API.To_Boolean( p_commit )
1550: THEN
1551: arp_util.debug('committing');
1552: Commit;
1553: END IF;

Line 1604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,

1600:
1601: (
1602: -- Standard API parameters.
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1605: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,

Line 1605: p_commit IN VARCHAR2 := FND_API.G_TRUE,

1601: (
1602: -- Standard API parameters.
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1605: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,
1609: x_msg_data OUT NOCOPY VARCHAR2,

Line 1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1602: -- Standard API parameters.
1603: p_api_version IN NUMBER,
1604: p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE,
1605: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1606: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1607: x_return_status OUT NOCOPY VARCHAR2,
1608: x_msg_count OUT NOCOPY NUMBER,
1609: x_msg_data OUT NOCOPY VARCHAR2,
1610: p_deposit_number IN VARCHAR2 DEFAULT NULL,

Line 1679: IF NOT FND_API.Compatible_API_Call(

1675: /*--------------------------------------------------+
1676: | Standard call to check for call compatibility |
1677: +--------------------------------------------------*/
1678:
1679: IF NOT FND_API.Compatible_API_Call(
1680: l_api_version,
1681: p_api_version,
1682: l_api_name,
1683: G_PKG_NAME

Line 1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1682: l_api_name,
1683: G_PKG_NAME
1684: )
1685: THEN
1686: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1687: END IF;
1688:
1689: /*--------------------------------------------------------------+
1690: | Initialize message list if p_init_msg_list is set to TRUE |

Line 1693: IF FND_API.to_Boolean( p_init_msg_list )

1689: /*--------------------------------------------------------------+
1690: | Initialize message list if p_init_msg_list is set to TRUE |
1691: +--------------------------------------------------------------*/
1692:
1693: IF FND_API.to_Boolean( p_init_msg_list )
1694: THEN
1695: FND_MSG_PUB.initialize;
1696: END IF;
1697:

Line 1703: x_return_status := FND_API.G_RET_STS_SUCCESS;

1699: /*-----------------------------------------+
1700: | Initialize return status to SUCCESS |
1701: +-----------------------------------------*/
1702:
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;

1700: | Initialize return status to SUCCESS |
1701: +-----------------------------------------*/
1702:
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;

1701: +-----------------------------------------*/
1702:
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;

1702:
1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;
1710:

Line 1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;

1703: x_return_status := FND_API.G_RET_STS_SUCCESS;
1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711:

Line 1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;

1704: l_dflex_val_return_status := FND_API.G_RET_STS_SUCCESS;
1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711:
1712:

Line 1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;

1705: l_dummy_return_status := FND_API.G_RET_STS_SUCCESS;
1706: l_sales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1707: l_nosales_val_return_status := FND_API.G_RET_STS_SUCCESS;
1708: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_SUCCESS;
1709: l_dept_no_return_status := FND_API.G_RET_STS_SUCCESS;
1710:
1711:
1712:
1713:

Line 1716: l_org_return_status := FND_API.G_RET_STS_SUCCESS;

1712:
1713:
1714: /* SSA change */
1715: l_org_id := p_org_id;
1716: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1717: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1718: p_return_status =>l_org_return_status);
1719: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1719: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1715: l_org_id := p_org_id;
1716: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1717: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1718: p_return_status =>l_org_return_status);
1719: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: ELSE
1722:
1723: /*-------------------------------------------------+

Line 1720: x_return_status := FND_API.G_RET_STS_ERROR;

1716: l_org_return_status := FND_API.G_RET_STS_SUCCESS;
1717: ar_mo_cache_utils.set_org_context_in_api(p_org_id =>l_org_id,
1718: p_return_status =>l_org_return_status);
1719: IF l_org_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1720: x_return_status := FND_API.G_RET_STS_ERROR;
1721: ELSE
1722:
1723: /*-------------------------------------------------+
1724: | Initialize the profile option package variables |

Line 1738: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;

1734: p_customer_trx_id IS NULL ) then
1735:
1736: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_ID_REQ');
1737: FND_MSG_PUB.Add;
1738: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1739:
1740: elsif ( p_deposit_number IS NOT NULL AND
1741: p_customer_trx_id IS NOT NULL ) then
1742: begin

Line 1761: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;

1757: exception
1758: when no_data_found then
1759: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');
1760: FND_MSG_PUB.Add;
1761: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1762:
1763: end;
1764: elsif ( p_deposit_number IS NULL AND
1765: p_customer_trx_id IS NOT NULL ) then

Line 1782: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;

1778: exception
1779: when no_data_found then
1780: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_ID_INVALID');
1781: FND_MSG_PUB.Add;
1782: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1783:
1784: end;
1785: elsif ( p_deposit_number IS NOT NULL AND
1786: p_customer_trx_id IS NULL ) then

Line 1803: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;

1799: exception
1800: when no_data_found then
1801: FND_MESSAGE.SET_NAME('AR','AR_DAPI_DEP_NO_INVALID');
1802: FND_MSG_PUB.Add;
1803: l_dept_no_return_status := FND_API.G_RET_STS_ERROR;
1804:
1805: end;
1806: end if;
1807:

Line 1808: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN

1804:
1805: end;
1806: end if;
1807:
1808: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1809: begin
1810: select sum(EXTENDED_AMOUNT)
1811: into l_amount
1812: from ra_customer_trx_lines

Line 1817: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN

1813: where customer_trx_id = l_customer_trx_id;
1814: end;
1815: end if;
1816:
1817: if l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1818: begin
1819: select customer_trx_line_id
1820: into l_customer_trx_line_id
1821: from ra_customer_trx_lines

Line 1831: l_nosales_val_return_status := FND_API.G_RET_STS_ERROR;

1827: p_salesrep_number IS NULL ) then
1828:
1829: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NO_ID_NAME');
1830: FND_MSG_PUB.Add;
1831: l_nosales_val_return_status := FND_API.G_RET_STS_ERROR;
1832:
1833: end if;
1834:
1835:

Line 1855: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;

1851: exception
1852: when no_data_found then
1853: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_NAME_INVALID');
1854: FND_MSG_PUB.Add;
1855: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;
1856:
1857: end;
1858: ELSIF (p_salesrep_id IS NOT NULL) THEN
1859:

Line 1874: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;

1870: exception
1871: when no_data_found then
1872: FND_MESSAGE.SET_NAME('AR','AR_DAPI_SALESREP_ID_INVALID');
1873: FND_MSG_PUB.Add;
1874: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;
1875:
1876: end;
1877: END IF;
1878: if l_sales_val_return_status = FND_API.G_RET_STS_SUCCESS and

Line 1878: if l_sales_val_return_status = FND_API.G_RET_STS_SUCCESS and

1874: l_sales_val_return_status := FND_API.G_RET_STS_ERROR;
1875:
1876: end;
1877: END IF;
1878: if l_sales_val_return_status = FND_API.G_RET_STS_SUCCESS and
1879: l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1880:
1881: If ( p_non_revenue_amount_split IS NULL AND
1882: p_non_revenue_percent_split IS NULL ) then

Line 1879: l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN

1875:
1876: end;
1877: END IF;
1878: if l_sales_val_return_status = FND_API.G_RET_STS_SUCCESS and
1879: l_dept_no_return_status = FND_API.G_RET_STS_SUCCESS THEN
1880:
1881: If ( p_non_revenue_amount_split IS NULL AND
1882: p_non_revenue_percent_split IS NULL ) then
1883:

Line 1886: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_ERROR;

1882: p_non_revenue_percent_split IS NULL ) then
1883:
1884: FND_MESSAGE.SET_NAME('AR','AR_DAPI_NON_REV_AMT_PCT');
1885: FND_MSG_PUB.Add;
1886: l_nonrev_amt_pct_return_status := FND_API.G_RET_STS_ERROR;
1887: elsif ( p_non_revenue_amount_split IS NOT NULL AND
1888: p_non_revenue_percent_split IS NULL ) then
1889: l_non_revenue_amount_split := p_non_revenue_amount_split;
1890: l_non_revenue_percent_split := ROUND(p_non_revenue_amount_split /l_amount,4 )*100;

Line 1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

1931:
1932:
1933: END IF;
1934: END IF;
1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS

Line 1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

1932:
1933: END IF;
1934: END IF;
1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS
1940: THEN

Line 1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR

1933: END IF;
1934: END IF;
1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS
1940: THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR

1934: END IF;
1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS
1940: THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: END IF;

Line 1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS

1935: IF l_dflex_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1936: l_sales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS
1940: THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: END IF;
1943:

Line 1941: x_return_status := FND_API.G_RET_STS_ERROR;

1937: l_nosales_val_return_status <> FND_API.G_RET_STS_SUCCESS OR
1938: l_nonrev_amt_pct_return_status <> FND_API.G_RET_STS_SUCCESS OR
1939: l_dept_no_return_status <> FND_API.G_RET_STS_SUCCESS
1940: THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: END IF;
1943:
1944: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1945: ROLLBACK TO Create_non_rev_sales_PVT;

Line 1944: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN

1940: THEN
1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: END IF;
1943:
1944: IF ( x_return_status <> FND_API.G_RET_STS_SUCCESS ) THEN
1945: ROLLBACK TO Create_non_rev_sales_PVT;
1946: /*-------------------------------------------------------+
1947: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
1948: | in the message stack. If there is only one message in |

Line 1951: x_return_status := FND_API.G_RET_STS_ERROR ;

1947: | FND_MSG_PUB.Count_And_Get used get the count of mesg.|
1948: | in the message stack. If there is only one message in |
1949: | the stack it retrieves this message |
1950: +-------------------------------------------------------*/
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952:
1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);

Line 1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

1949: | the stack it retrieves this message |
1950: +-------------------------------------------------------*/
1951: x_return_status := FND_API.G_RET_STS_ERROR ;
1952:
1953: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
1954: p_count => x_msg_count,
1955: p_data => x_msg_data);
1956:
1957: arp_util.debug('Error(s) occurred.

Line 2011: x_return_status := FND_API.G_RET_STS_ERROR ;

2007: FND_MSG_PUB.Add;
2008: FND_MESSAGE.SET_NAME('AR', 'GENERIC_MESSAGE');
2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2010: FND_MSG_PUB.Add;
2011: x_return_status := FND_API.G_RET_STS_ERROR ;
2012: ROLLBACK TO Create_non_rev_sales_PVT;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);

Line 2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,

2009: FND_MESSAGE.SET_TOKEN('GENERIC_TEXT',SQLERRM);
2010: FND_MSG_PUB.Add;
2011: x_return_status := FND_API.G_RET_STS_ERROR ;
2012: ROLLBACK TO Create_non_rev_sales_PVT;
2013: FND_MSG_PUB.Count_And_Get(p_encoded => FND_API.G_FALSE,
2014: p_count => x_msg_count,
2015: p_data => x_msg_data);
2016: return;
2017: END;

Line 2023: IF FND_API.To_Boolean( p_commit )

2019: /*--------------------------------+
2020: | Standard check of p_commit |
2021: +--------------------------------*/
2022:
2023: IF FND_API.To_Boolean( p_commit )
2024: THEN
2025: arp_util.debug('committing');
2026: Commit;
2027: END IF;

Line 2137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

2133: l_response_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
2134: l_pmt_trxn_extension_id IBY_FNDCPT_COMMON_PUB.Id_tbl_type;
2135: o_payment_trxn_extension_id RA_CUSTOMER_TRX.PAYMENT_TRXN_EXTENSION_ID%TYPE;
2136:
2137: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
2138: l_assignment_id NUMBER;
2139:
2140: l_msg_count NUMBER;
2141: l_msg_data VARCHAR2(2000);

Line 2229: p_init_msg_list => FND_API.G_TRUE,

2225:
2226:
2227: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
2228: ( p_api_version => 1.0,
2229: p_init_msg_list => FND_API.G_TRUE,
2230: p_commit => FND_API.G_FALSE,
2231: x_return_status => l_return_status,
2232: x_msg_count => l_msg_count,
2233: x_msg_data => l_msg_data,

Line 2230: p_commit => FND_API.G_FALSE,

2226:
2227: IBY_FNDCPT_TRXN_PUB.Copy_Transaction_Extension
2228: ( p_api_version => 1.0,
2229: p_init_msg_list => FND_API.G_TRUE,
2230: p_commit => FND_API.G_FALSE,
2231: x_return_status => l_return_status,
2232: x_msg_count => l_msg_count,
2233: x_msg_data => l_msg_data,
2234: p_payer => l_payer_rec,

Line 2243: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2239: x_response => l_response_rec -- out
2240: );
2241:
2242:
2243: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2244:
2245: o_payment_trxn_extension_id := p_trxn_entity_id ;
2246:
2247: arp_standard.debug('the copied value of trx_entn is ' || o_payment_trxn_extension_id );

Line 2257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2253:
2254:
2255: END IF;
2256:
2257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2258:
2259: arp_util.debug('FAILED: ' ||l_response_rec.result_code,0);
2260:
2261: p_return_status := FND_API.G_RET_STS_ERROR ;

Line 2261: p_return_status := FND_API.G_RET_STS_ERROR ;

2257: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2258:
2259: arp_util.debug('FAILED: ' ||l_response_rec.result_code,0);
2260:
2261: p_return_status := FND_API.G_RET_STS_ERROR ;
2262:
2263: END IF;
2264:
2265:

Line 2271: p_return_status := FND_API.G_RET_STS_ERROR ;

2267:
2268: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2269: EXCEPTION
2270: WHEN OTHERS THEN
2271: p_return_status := FND_API.G_RET_STS_ERROR ;
2272:
2273: arp_util.debug('AR_DEPOSIT_API_PUB.create_trxn_extension()'|| SQLERRM);
2274: END copy_trxn_extension;
2275:

Line 2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;

2282:
2283:
2284: BEGIN
2285:
2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;
2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;

Line 2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;

2283:
2284: BEGIN
2285:
2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;
2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;

Line 2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;

2284: BEGIN
2285:
2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;
2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;

Line 2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;

2285:
2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;
2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;
2293:

Line 2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;

2286: ar_deposit_lib_pvt.pg_profile_batch_source := FND_API.G_MISS_NUM;
2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;
2293:
2294:

Line 2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;

2287: ar_deposit_lib_pvt.pg_profile_doc_seq := FND_API.G_MISS_CHAR;
2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;
2293:
2294:
2295: END AR_DEPOSIT_API_PUB;

Line 2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;

2288: ar_deposit_lib_pvt.pg_profile_trxln_excpt_flag := FND_API.G_MISS_CHAR;
2289: ar_deposit_lib_pvt.pg_profile_enable_cc := FND_API.G_MISS_CHAR;
2290: ar_deposit_lib_pvt.pg_profile_cc_rate_type := FND_API.G_MISS_CHAR;
2291: ar_deposit_lib_pvt.pg_profile_dsp_inv_rate := FND_API.G_MISS_CHAR;
2292: ar_deposit_lib_pvt.pg_profile_def_x_rate_type := FND_API.G_MISS_CHAR;
2293:
2294:
2295: END AR_DEPOSIT_API_PUB;