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
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:
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:
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:
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;
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:
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:
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
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
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
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,
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,
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:
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
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 |
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:
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;
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;
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;
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;
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;
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;
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:
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:
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:
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 */
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;
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 |
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: +-------------------------------------------------*/
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
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:
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
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
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
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
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:
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:
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
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:
1153:
1154:
1155: THEN
1156:
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158:
1159: END IF;
1160:
1161: /*-----------------------------------------------------------------------------+
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,
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:
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;
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);
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.
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
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);
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;
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);
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;
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);
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);
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;
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);
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:
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);
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:
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;
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,
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,
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,
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
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 |
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:
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;
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;
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;
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:
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:
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:
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:
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;
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: /*-------------------------------------------------+
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 |
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
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
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
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:
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
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
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:
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:
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
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
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:
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;
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
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
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;
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;
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:
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;
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 |
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);
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.
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);
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;
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;
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);
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,
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,
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 );
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 ;
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:
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:
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;
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;
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;
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:
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:
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;
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;