eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IBY_FNDCPT_SETUP_PUB dependencies on FND_API

Line 110: IF FND_API.to_Boolean(p_is_update) THEN

106: l_addressid := p_creditcard.Billing_Address_Id;
107: l_billing_zip := p_creditcard.Billing_Postal_Code;
108: l_billing_terr := p_creditcard.Billing_Address_Territory;
109:
110: IF FND_API.to_Boolean(p_is_update) THEN
111: IF (l_addressid = FND_API.G_MISS_NUM) THEN
112: l_addressid := NULL;
113: ELSIF (l_addressid IS NULL) THEN
114: l_addressid := FND_API.G_MISS_NUM;

Line 111: IF (l_addressid = FND_API.G_MISS_NUM) THEN

107: l_billing_zip := p_creditcard.Billing_Postal_Code;
108: l_billing_terr := p_creditcard.Billing_Address_Territory;
109:
110: IF FND_API.to_Boolean(p_is_update) THEN
111: IF (l_addressid = FND_API.G_MISS_NUM) THEN
112: l_addressid := NULL;
113: ELSIF (l_addressid IS NULL) THEN
114: l_addressid := FND_API.G_MISS_NUM;
115: END IF;

Line 114: l_addressid := FND_API.G_MISS_NUM;

110: IF FND_API.to_Boolean(p_is_update) THEN
111: IF (l_addressid = FND_API.G_MISS_NUM) THEN
112: l_addressid := NULL;
113: ELSIF (l_addressid IS NULL) THEN
114: l_addressid := FND_API.G_MISS_NUM;
115: END IF;
116: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
117: l_billing_zip := NULL;
118: ELSIF (l_billing_zip IS NULL) THEN

Line 116: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN

112: l_addressid := NULL;
113: ELSIF (l_addressid IS NULL) THEN
114: l_addressid := FND_API.G_MISS_NUM;
115: END IF;
116: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
117: l_billing_zip := NULL;
118: ELSIF (l_billing_zip IS NULL) THEN
119: l_billing_zip := FND_API.G_MISS_CHAR;
120: END IF;

Line 119: l_billing_zip := FND_API.G_MISS_CHAR;

115: END IF;
116: IF (l_billing_zip = FND_API.G_MISS_CHAR) THEN
117: l_billing_zip := NULL;
118: ELSIF (l_billing_zip IS NULL) THEN
119: l_billing_zip := FND_API.G_MISS_CHAR;
120: END IF;
121: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
122: l_billing_terr := NULL;
123: ELSIF (l_billing_terr IS NULL) THEN

Line 121: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN

117: l_billing_zip := NULL;
118: ELSIF (l_billing_zip IS NULL) THEN
119: l_billing_zip := FND_API.G_MISS_CHAR;
120: END IF;
121: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
122: l_billing_terr := NULL;
123: ELSIF (l_billing_terr IS NULL) THEN
124: l_billing_terr := FND_API.G_MISS_CHAR;
125: END IF;

Line 124: l_billing_terr := FND_API.G_MISS_CHAR;

120: END IF;
121: IF (l_billing_terr = FND_API.G_MISS_CHAR) THEN
122: l_billing_terr := NULL;
123: ELSIF (l_billing_terr IS NULL) THEN
124: l_billing_terr := FND_API.G_MISS_CHAR;
125: END IF;
126: END IF;
127:
128: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))

Line 128: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))

124: l_billing_terr := FND_API.G_MISS_CHAR;
125: END IF;
126: END IF;
127:
128: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))
129: AND
130: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
131: )
132: THEN

Line 130: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))

126: END IF;
127:
128: IF ( (NOT (l_addressid IS NULL OR l_addressid = FND_API.G_MISS_NUM))
129: AND
130: (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
131: )
132: THEN
133: RETURN FALSE;
134: END IF;

Line 136: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))

132: THEN
133: RETURN FALSE;
134: END IF;
135:
136: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
137: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
138: )
139: THEN
140: RETURN FALSE;

Line 137: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)

133: RETURN FALSE;
134: END IF;
135:
136: IF ( (NOT (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR))
137: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
138: )
139: THEN
140: RETURN FALSE;
141: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))

Line 141: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))

137: AND (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR)
138: )
139: THEN
140: RETURN FALSE;
141: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))
142:
143: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)
144: )
145: THEN

Line 143: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)

139: THEN
140: RETURN FALSE;
141: ELSIF ( (NOT (l_billing_terr IS NULL OR l_billing_terr = FND_API.G_MISS_CHAR))
142:
143: AND (l_billing_zip IS NULL OR l_billing_zip = FND_API.G_MISS_CHAR)
144: )
145: THEN
146: RETURN FALSE;
147: END IF;

Line 150: (1.0, FND_API.G_FALSE, lx_return_status, lx_msg_count, lx_msg_data,

146: RETURN FALSE;
147: END IF;
148:
149: Get_Payment_Channel_Attribs
150: (1.0, FND_API.G_FALSE, lx_return_status, lx_msg_count, lx_msg_data,
151: G_CHANNEL_CREDIT_CARD, lx_channel_attribs, lx_result);
152:
153: IF ((lx_channel_attribs.Instr_Billing_Address = G_CHNNL_ATTRIB_USE_REQUIRED)
154: AND ((l_addressid IS NULL) AND (l_billing_zip IS NULL))

Line 228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

224:
225: PROCEDURE Set_Payer_Attributes
226: (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_TRUE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,

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

225: PROCEDURE Set_Payer_Attributes
226: (
227: p_api_version IN NUMBER,
228: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
229: p_commit IN VARCHAR2 := FND_API.G_TRUE,
230: x_return_status OUT NOCOPY VARCHAR2,
231: x_msg_count OUT NOCOPY NUMBER,
232: x_msg_data OUT NOCOPY VARCHAR2,
233: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 247: IF NOT FND_API.Compatible_API_Call (l_api_version,

243: l_prev_msg_count NUMBER;
244:
245: BEGIN
246:
247: IF NOT FND_API.Compatible_API_Call (l_api_version,
248: p_api_version,
249: l_module,
250: G_PKG_NAME)
251: THEN

Line 257: RAISE FND_API.G_EXC_ERROR;

253: debug_level => FND_LOG.LEVEL_ERROR,
254: module => G_DEBUG_MODULE || l_module);
255: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;

Line 260: IF FND_API.to_Boolean( p_init_msg_list ) THEN

256: FND_MSG_PUB.Add;
257: RAISE FND_API.G_EXC_ERROR;
258: END IF;
259:
260: IF FND_API.to_Boolean( p_init_msg_list ) THEN
261: FND_MSG_PUB.initialize;
262: END IF;
263: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
264:

Line 265: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

261: FND_MSG_PUB.initialize;
262: END IF;
263: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
264:
265: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
266: l_payer_level,x_payer_attribs_id,l_payer_attribs);
267:
268: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
269: x_response.Result_Code := l_payer_level;

Line 300: FND_API.G_MISS_CHAR,NULL, dirdeb_instruction_code),

296: UPDATE iby_external_payers_all
297: SET
298: dirdeb_instruction_code =
299: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
300: FND_API.G_MISS_CHAR,NULL, dirdeb_instruction_code),
301: bank_charge_bearer_code =
302: DECODE(p_payer_attributes.Bank_Charge_Bearer,
303: FND_API.G_MISS_CHAR,NULL, bank_charge_bearer_code),
304: last_updated_by = fnd_global.user_id,

Line 303: FND_API.G_MISS_CHAR,NULL, bank_charge_bearer_code),

299: DECODE(p_payer_attributes.DirectDebit_BankInstruction,
300: FND_API.G_MISS_CHAR,NULL, dirdeb_instruction_code),
301: bank_charge_bearer_code =
302: DECODE(p_payer_attributes.Bank_Charge_Bearer,
303: FND_API.G_MISS_CHAR,NULL, bank_charge_bearer_code),
304: last_updated_by = fnd_global.user_id,
305: last_update_date = SYSDATE,
306: last_update_login = fnd_global.login_id,
307: object_version_number = object_version_number + 1

Line 311: IF FND_API.To_Boolean(p_commit) THEN

307: object_version_number = object_version_number + 1
308: WHERE (ext_payer_id = x_payer_attribs_id);
309: END IF;
310:
311: IF FND_API.To_Boolean(p_commit) THEN
312: COMMIT;
313: END IF;
314:
315: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;

Line 321: WHEN FND_API.G_EXC_ERROR THEN

317: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
318:
319: EXCEPTION
320:
321: WHEN FND_API.G_EXC_ERROR THEN
322:
323: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
324: debug_level => FND_LOG.LEVEL_ERROR,
325: module => G_DEBUG_MODULE || l_module);

Line 326: x_return_status := FND_API.G_RET_STS_ERROR ;

322:
323: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
324: debug_level => FND_LOG.LEVEL_ERROR,
325: module => G_DEBUG_MODULE || l_module);
326: x_return_status := FND_API.G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

326: x_return_status := FND_API.G_RET_STS_ERROR ;
327: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
328: p_data => x_msg_data
329: );
330: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
331:
332: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
333: debug_level => FND_LOG.LEVEL_UNEXPECTED,
334: module => G_DEBUG_MODULE || l_module);

Line 335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

331:
332: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
333: debug_level => FND_LOG.LEVEL_UNEXPECTED,
334: module => G_DEBUG_MODULE || l_module);
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
336: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
337: p_data => x_msg_data
338: );
339: WHEN OTHERS THEN

Line 347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

343: module => G_DEBUG_MODULE || l_module);
344:
345: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
346:
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
349: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
350: END IF;
351:

Line 360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

356:
357: PROCEDURE Get_Payer_Attributes
358: (
359: p_api_version IN NUMBER,
360: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
361: x_return_status OUT NOCOPY VARCHAR2,
362: x_msg_count OUT NOCOPY NUMBER,
363: x_msg_data OUT NOCOPY VARCHAR2,
364: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 377: IF NOT FND_API.Compatible_API_Call (l_api_version,

373: l_prev_msg_count NUMBER;
374:
375: BEGIN
376:
377: IF NOT FND_API.Compatible_API_Call (l_api_version,
378: p_api_version,
379: l_module,
380: G_PKG_NAME)
381: THEN

Line 387: RAISE FND_API.G_EXC_ERROR;

383: debug_level => FND_LOG.LEVEL_ERROR,
384: module => G_DEBUG_MODULE || l_module);
385: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
386: FND_MSG_PUB.Add;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;

Line 390: IF FND_API.to_Boolean( p_init_msg_list ) THEN

386: FND_MSG_PUB.Add;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: IF FND_API.to_Boolean( p_init_msg_list ) THEN
391: FND_MSG_PUB.initialize;
392: END IF;
393: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
394:

Line 395: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

391: FND_MSG_PUB.initialize;
392: END IF;
393: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
394:
395: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
396: l_payer_level,x_payer_attribs_id,x_payer_attributes);
397: IF (x_payer_attribs_id IS NULL) THEN
398: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;
399: ELSE

Line 408: WHEN FND_API.G_EXC_ERROR THEN

404: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
405:
406: EXCEPTION
407:
408: WHEN FND_API.G_EXC_ERROR THEN
409:
410: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
411: debug_level => FND_LOG.LEVEL_ERROR,
412: module => G_DEBUG_MODULE || l_module);

Line 413: x_return_status := FND_API.G_RET_STS_ERROR ;

409:
410: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
411: debug_level => FND_LOG.LEVEL_ERROR,
412: module => G_DEBUG_MODULE || l_module);
413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

413: x_return_status := FND_API.G_RET_STS_ERROR ;
414: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
415: p_data => x_msg_data
416: );
417: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
418:
419: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
421: module => G_DEBUG_MODULE || l_module);

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

418:
419: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
420: debug_level => FND_LOG.LEVEL_UNEXPECTED,
421: module => G_DEBUG_MODULE || l_module);
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
423: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
424: p_data => x_msg_data
425: );
426: WHEN OTHERS THEN

Line 431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

427:
428: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
429: debug_level => FND_LOG.LEVEL_UNEXPECTED,
430: module => G_DEBUG_MODULE || l_module);
431: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
432: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
433: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
434: END IF;
435:

Line 444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

440:
441: PROCEDURE Get_Payment_Channel_Attribs
442: (
443: p_api_version IN NUMBER,
444: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
445: x_return_status OUT NOCOPY VARCHAR2,
446: x_msg_count OUT NOCOPY NUMBER,
447: x_msg_data OUT NOCOPY VARCHAR2,
448: p_channel_code IN VARCHAR2,

Line 511: IF NOT FND_API.Compatible_API_Call (l_api_version,

507: BEGIN
508:
509: IF (c_appl_attribs%ISOPEN) THEN CLOSE c_appl_attribs; END IF;
510:
511: IF NOT FND_API.Compatible_API_Call (l_api_version,
512: p_api_version,
513: l_module,
514: G_PKG_NAME)
515: THEN

Line 521: RAISE FND_API.G_EXC_ERROR;

517: debug_level => FND_LOG.LEVEL_ERROR,
518: module => G_DEBUG_MODULE || l_module);
519: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
520: FND_MSG_PUB.Add;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: IF FND_API.to_Boolean( p_init_msg_list ) THEN
525: FND_MSG_PUB.initialize;

Line 524: IF FND_API.to_Boolean( p_init_msg_list ) THEN

520: FND_MSG_PUB.Add;
521: RAISE FND_API.G_EXC_ERROR;
522: END IF;
523:
524: IF FND_API.to_Boolean( p_init_msg_list ) THEN
525: FND_MSG_PUB.initialize;
526: END IF;
527: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
528:

Line 553: WHEN FND_API.G_EXC_ERROR THEN

549: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
550:
551: EXCEPTION
552:
553: WHEN FND_API.G_EXC_ERROR THEN
554:
555: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
556: debug_level => FND_LOG.LEVEL_ERROR,
557: module => G_DEBUG_MODULE || l_module);

Line 558: x_return_status := FND_API.G_RET_STS_ERROR ;

554:
555: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
556: debug_level => FND_LOG.LEVEL_ERROR,
557: module => G_DEBUG_MODULE || l_module);
558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

558: x_return_status := FND_API.G_RET_STS_ERROR ;
559: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
563:
564: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
565: debug_level => FND_LOG.LEVEL_UNEXPECTED,
566: module => G_DEBUG_MODULE || l_module);

Line 567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

563:
564: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
565: debug_level => FND_LOG.LEVEL_UNEXPECTED,
566: module => G_DEBUG_MODULE || l_module);
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
568: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
569: p_data => x_msg_data
570: );
571: WHEN OTHERS THEN

Line 579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

575: module => G_DEBUG_MODULE || l_module);
576:
577: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
578:
579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
580: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
581: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
582: END IF;
583:

Line 592: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

588:
589: PROCEDURE Set_Payer_Default_Pmt_Channel
590: (
591: p_api_version IN NUMBER,
592: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
593: p_commit IN VARCHAR2 := FND_API.G_TRUE,
594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,

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

589: PROCEDURE Set_Payer_Default_Pmt_Channel
590: (
591: p_api_version IN NUMBER,
592: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
593: p_commit IN VARCHAR2 := FND_API.G_TRUE,
594: x_return_status OUT NOCOPY VARCHAR2,
595: x_msg_count OUT NOCOPY NUMBER,
596: x_msg_data OUT NOCOPY VARCHAR2,
597: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 627: IF NOT FND_API.Compatible_API_Call (l_api_version,

623: IF (c_chnnl_assign%ISOPEN) THEN
624: CLOSE c_chnnl_assign;
625: END IF;
626:
627: IF NOT FND_API.Compatible_API_Call (l_api_version,
628: p_api_version,
629: l_module,
630: G_PKG_NAME)
631: THEN

Line 637: RAISE FND_API.G_EXC_ERROR;

633: debug_level => FND_LOG.LEVEL_ERROR,
634: module => G_DEBUG_MODULE || l_module);
635: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
636: FND_MSG_PUB.Add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;

Line 640: IF FND_API.to_Boolean( p_init_msg_list ) THEN

636: FND_MSG_PUB.Add;
637: RAISE FND_API.G_EXC_ERROR;
638: END IF;
639:
640: IF FND_API.to_Boolean( p_init_msg_list ) THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
644:

Line 645: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,

641: FND_MSG_PUB.initialize;
642: END IF;
643: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
644:
645: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,l_payer_level,
646: l_payer_id,l_payer_attribs);
647:
648: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
649: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 660: FND_API.G_FALSE,

656: IF (l_payer_id IS NULL) THEN
657: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
658: (
659: 1.0,
660: FND_API.G_FALSE,
661: FND_API.G_FALSE,
662: x_return_status,
663: x_msg_count,
664: x_msg_data,

Line 661: FND_API.G_FALSE,

657: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
658: (
659: 1.0,
660: FND_API.G_FALSE,
661: FND_API.G_FALSE,
662: x_return_status,
663: x_msg_count,
664: x_msg_data,
665: p_payer,

Line 718: IF FND_API.To_Boolean(p_commit) THEN

714:
715: iby_fndcpt_common_pub.Prepare_Result
716: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
717:
718: IF FND_API.To_Boolean(p_commit) THEN
719: COMMIT;
720: END IF;
721:
722: EXCEPTION

Line 724: WHEN FND_API.G_EXC_ERROR THEN

720: END IF;
721:
722: EXCEPTION
723:
724: WHEN FND_API.G_EXC_ERROR THEN
725: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
726: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
727: debug_level => FND_LOG.LEVEL_ERROR,
728: module => G_DEBUG_MODULE || l_module);

Line 729: x_return_status := FND_API.G_RET_STS_ERROR ;

725: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
726: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
727: debug_level => FND_LOG.LEVEL_ERROR,
728: module => G_DEBUG_MODULE || l_module);
729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

729: x_return_status := FND_API.G_RET_STS_ERROR ;
730: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
731: p_data => x_msg_data
732: );
733: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
734: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
735: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
736: debug_level => FND_LOG.LEVEL_UNEXPECTED,
737: module => G_DEBUG_MODULE || l_module);

Line 738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

734: ROLLBACK TO Set_Payer_Default_Pmt_Channel;
735: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
736: debug_level => FND_LOG.LEVEL_UNEXPECTED,
737: module => G_DEBUG_MODULE || l_module);
738: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
739: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
740: p_data => x_msg_data
741: );
742: WHEN OTHERS THEN

Line 751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

747: module => G_DEBUG_MODULE || l_module);
748:
749: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
750:
751: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
752: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
753: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
754: END IF;
755:

Line 764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

760:
761: PROCEDURE Get_Payer_Default_Pmt_Channel
762: (
763: p_api_version IN NUMBER,
764: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
765: x_return_status OUT NOCOPY VARCHAR2,
766: x_msg_count OUT NOCOPY NUMBER,
767: x_msg_data OUT NOCOPY VARCHAR2,
768: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 796: IF NOT FND_API.Compatible_API_Call (l_api_version,

792: IF (c_chnnl_assign%ISOPEN) THEN
793: CLOSE c_chnnl_assign;
794: END IF;
795:
796: IF NOT FND_API.Compatible_API_Call (l_api_version,
797: p_api_version,
798: l_module,
799: G_PKG_NAME)
800: THEN

Line 806: RAISE FND_API.G_EXC_ERROR;

802: debug_level => FND_LOG.LEVEL_ERROR,
803: module => G_DEBUG_MODULE || l_module);
804: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;

Line 809: IF FND_API.to_Boolean( p_init_msg_list ) THEN

805: FND_MSG_PUB.Add;
806: RAISE FND_API.G_EXC_ERROR;
807: END IF;
808:
809: IF FND_API.to_Boolean( p_init_msg_list ) THEN
810: FND_MSG_PUB.initialize;
811: END IF;
812: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
813:

Line 814: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

810: FND_MSG_PUB.initialize;
811: END IF;
812: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
813:
814: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
815: l_payer_level,l_payer_id,l_payer_attribs);
816:
817: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
818: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 836: WHEN FND_API.G_EXC_ERROR THEN

832: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
833:
834: EXCEPTION
835:
836: WHEN FND_API.G_EXC_ERROR THEN
837:
838: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
839: debug_level => FND_LOG.LEVEL_ERROR,
840: module => G_DEBUG_MODULE || l_module);

Line 841: x_return_status := FND_API.G_RET_STS_ERROR ;

837:
838: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
839: debug_level => FND_LOG.LEVEL_ERROR,
840: module => G_DEBUG_MODULE || l_module);
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
843: p_data => x_msg_data
844: );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846:
847: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
848: debug_level => FND_LOG.LEVEL_UNEXPECTED,
849: module => G_DEBUG_MODULE || l_module);

Line 850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

846:
847: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
848: debug_level => FND_LOG.LEVEL_UNEXPECTED,
849: module => G_DEBUG_MODULE || l_module);
850: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
851: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
852: p_data => x_msg_data
853: );
854: WHEN OTHERS THEN

Line 862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

858: module => G_DEBUG_MODULE || l_module);
859:
860: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
861:
862: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
863: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
864: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
865: END IF;
866:

Line 875: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

871:
872: PROCEDURE Get_Trxn_Appl_Pmt_Channels
873: (
874: p_api_version IN NUMBER,
875: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
876: x_return_status OUT NOCOPY VARCHAR2,
877: x_msg_count OUT NOCOPY NUMBER,
878: x_msg_data OUT NOCOPY VARCHAR2,
879: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 930: IF NOT FND_API.Compatible_API_Call (l_api_version,

926: IF (c_trxn_channels%ISOPEN) THEN
927: CLOSE c_trxn_channels;
928: END IF;
929:
930: IF NOT FND_API.Compatible_API_Call (l_api_version,
931: p_api_version,
932: l_module,
933: G_PKG_NAME)
934: THEN

Line 940: RAISE FND_API.G_EXC_ERROR;

936: debug_level => FND_LOG.LEVEL_ERROR,
937: module => G_DEBUG_MODULE || l_module);
938: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
939: FND_MSG_PUB.Add;
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN
944: FND_MSG_PUB.initialize;

Line 943: IF FND_API.to_Boolean( p_init_msg_list ) THEN

939: FND_MSG_PUB.Add;
940: RAISE FND_API.G_EXC_ERROR;
941: END IF;
942:
943: IF FND_API.to_Boolean( p_init_msg_list ) THEN
944: FND_MSG_PUB.initialize;
945: END IF;
946: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
947:

Line 948: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

944: FND_MSG_PUB.initialize;
945: END IF;
946: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
947:
948: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
949: l_payer_level,l_payer_id,l_payer_attribs);
950:
951: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
952: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 973: WHEN FND_API.G_EXC_ERROR THEN

969: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
970:
971: EXCEPTION
972:
973: WHEN FND_API.G_EXC_ERROR THEN
974:
975: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
976: debug_level => FND_LOG.LEVEL_ERROR,
977: module => G_DEBUG_MODULE || l_module);

Line 978: x_return_status := FND_API.G_RET_STS_ERROR ;

974:
975: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
976: debug_level => FND_LOG.LEVEL_ERROR,
977: module => G_DEBUG_MODULE || l_module);
978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

978: x_return_status := FND_API.G_RET_STS_ERROR ;
979: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
980: p_data => x_msg_data
981: );
982: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
983:
984: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
985: debug_level => FND_LOG.LEVEL_UNEXPECTED,
986: module => G_DEBUG_MODULE || l_module);

Line 987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

983:
984: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
985: debug_level => FND_LOG.LEVEL_UNEXPECTED,
986: module => G_DEBUG_MODULE || l_module);
987: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
988: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
989: p_data => x_msg_data
990: );
991: WHEN OTHERS THEN

Line 999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

995: module => G_DEBUG_MODULE || l_module);
996:
997: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
998:
999: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1000: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1001: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1002: END IF;
1003:

Line 1013: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1009:
1010: PROCEDURE Set_Payer_Instr_Assignment
1011: (
1012: p_api_version IN NUMBER,
1013: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1014: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1015: x_return_status OUT NOCOPY VARCHAR2,
1016: x_msg_count OUT NOCOPY NUMBER,
1017: x_msg_data OUT NOCOPY VARCHAR2,

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

1010: PROCEDURE Set_Payer_Instr_Assignment
1011: (
1012: p_api_version IN NUMBER,
1013: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1014: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1015: x_return_status OUT NOCOPY VARCHAR2,
1016: x_msg_count OUT NOCOPY NUMBER,
1017: x_msg_data OUT NOCOPY VARCHAR2,
1018: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1069: IF NOT FND_API.Compatible_API_Call (l_api_version,

1065: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1066:
1067: IF (c_instr_assignment%ISOPEN) THEN CLOSE c_instr_assignment; END IF;
1068:
1069: IF NOT FND_API.Compatible_API_Call (l_api_version,
1070: p_api_version,
1071: l_module,
1072: G_PKG_NAME)
1073: THEN

Line 1079: RAISE FND_API.G_EXC_ERROR;

1075: debug_level => FND_LOG.LEVEL_ERROR,
1076: module => G_DEBUG_MODULE || l_module);
1077: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1078: FND_MSG_PUB.Add;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1083: FND_MSG_PUB.initialize;

Line 1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1078: FND_MSG_PUB.Add;
1079: RAISE FND_API.G_EXC_ERROR;
1080: END IF;
1081:
1082: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1086:

Line 1087: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1083: FND_MSG_PUB.initialize;
1084: END IF;
1085: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1086:
1087: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1088: l_payer_level,l_payer_id,l_payer_attribs);
1089:
1090: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1091: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1107: FND_API.G_FALSE,

1103: IF (l_payer_id IS NULL) THEN
1104: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1105: (
1106: 1.0,
1107: FND_API.G_FALSE,
1108: FND_API.G_FALSE,
1109: x_return_status,
1110: x_msg_count,
1111: x_msg_data,

Line 1108: FND_API.G_FALSE,

1104: IBY_FNDCPT_SETUP_PUB.Set_Payer_Attributes
1105: (
1106: 1.0,
1107: FND_API.G_FALSE,
1108: FND_API.G_FALSE,
1109: x_return_status,
1110: x_msg_count,
1111: x_msg_data,
1112: p_payer,

Line 1243: (p_init_msg_list => fnd_api.g_false,

1239: SELECT party_type INTO l_party_type
1240: FROM hz_parties WHERE party_id = p_payer.Party_Id;
1241:
1242: HZ_BES_BO_TRACKING_PVT.Create_Bot
1243: (p_init_msg_list => fnd_api.g_false,
1244: p_child_bo_code => NULL,
1245: p_child_tbl_name => 'IBY_FNDCPT_PAYER_ASSGN_INSTR_V',
1246: p_child_id => x_assign_id,
1247: p_child_opr_flag => l_op_type,

Line 1265: IF FND_API.To_Boolean(p_commit) THEN

1261:
1262: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS;
1263: END IF;
1264:
1265: IF FND_API.To_Boolean(p_commit) THEN
1266: COMMIT;
1267: END IF;
1268:
1269: iby_fndcpt_common_pub.Prepare_Result

Line 1275: WHEN FND_API.G_EXC_ERROR THEN

1271:
1272: iby_debug_pub.add('Exit',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1273: EXCEPTION
1274:
1275: WHEN FND_API.G_EXC_ERROR THEN
1276: ROLLBACK TO Set_Payer_Instr_Assignment;
1277: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1278: debug_level => FND_LOG.LEVEL_ERROR,
1279: module => G_DEBUG_MODULE || l_module);

Line 1280: x_return_status := FND_API.G_RET_STS_ERROR ;

1276: ROLLBACK TO Set_Payer_Instr_Assignment;
1277: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1278: debug_level => FND_LOG.LEVEL_ERROR,
1279: module => G_DEBUG_MODULE || l_module);
1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1280: x_return_status := FND_API.G_RET_STS_ERROR ;
1281: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1282: p_data => x_msg_data
1283: );
1284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1285: ROLLBACK TO Set_Payer_Instr_Assignment;
1286: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1287: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1288: module => G_DEBUG_MODULE || l_module);

Line 1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1285: ROLLBACK TO Set_Payer_Instr_Assignment;
1286: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1287: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1288: module => G_DEBUG_MODULE || l_module);
1289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1290: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1291: p_data => x_msg_data
1292: );
1293: WHEN OTHERS THEN

Line 1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1297: module => G_DEBUG_MODULE || l_module);
1298:
1299: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1300:
1301: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1302: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1303: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1304: END IF;
1305:

Line 1315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1311:
1312: PROCEDURE Get_Payer_Instr_Assignments
1313: (
1314: p_api_version IN NUMBER,
1315: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1316: x_return_status OUT NOCOPY VARCHAR2,
1317: x_msg_count OUT NOCOPY NUMBER,
1318: x_msg_data OUT NOCOPY VARCHAR2,
1319: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1347: IF NOT FND_API.Compatible_API_Call (l_api_version,

1343: IF (c_instr_assignments%ISOPEN) THEN
1344: CLOSE c_instr_assignments;
1345: END IF;
1346:
1347: IF NOT FND_API.Compatible_API_Call (l_api_version,
1348: p_api_version,
1349: l_module,
1350: G_PKG_NAME)
1351: THEN

Line 1357: RAISE FND_API.G_EXC_ERROR;

1353: debug_level => FND_LOG.LEVEL_ERROR,
1354: module => G_DEBUG_MODULE || l_module);
1355: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1356: FND_MSG_PUB.Add;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359:
1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1361: FND_MSG_PUB.initialize;

Line 1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1356: FND_MSG_PUB.Add;
1357: RAISE FND_API.G_EXC_ERROR;
1358: END IF;
1359:
1360: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1361: FND_MSG_PUB.initialize;
1362: END IF;
1363: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1364:

Line 1365: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1361: FND_MSG_PUB.initialize;
1362: END IF;
1363: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1364:
1365: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1366: l_payer_level,l_payer_id,l_payer_attribs);
1367:
1368: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1369: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1395: WHEN FND_API.G_EXC_ERROR THEN

1391: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1392:
1393: EXCEPTION
1394:
1395: WHEN FND_API.G_EXC_ERROR THEN
1396:
1397: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1398: debug_level => FND_LOG.LEVEL_ERROR,
1399: module => G_DEBUG_MODULE || l_module);

Line 1400: x_return_status := FND_API.G_RET_STS_ERROR ;

1396:
1397: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1398: debug_level => FND_LOG.LEVEL_ERROR,
1399: module => G_DEBUG_MODULE || l_module);
1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1400: x_return_status := FND_API.G_RET_STS_ERROR ;
1401: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1402: p_data => x_msg_data
1403: );
1404: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1405:
1406: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1408: module => G_DEBUG_MODULE || l_module);

Line 1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1405:
1406: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1407: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1408: module => G_DEBUG_MODULE || l_module);
1409: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1410: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1411: p_data => x_msg_data
1412: );
1413: WHEN OTHERS THEN

Line 1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1417: module => G_DEBUG_MODULE || l_module);
1418:
1419: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1420:
1421: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1422: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1423: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1424: END IF;
1425:

Line 1435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1431:
1432: PROCEDURE Get_Payer_All_Instruments
1433: (
1434: p_api_version IN NUMBER,
1435: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1436: x_return_status OUT NOCOPY VARCHAR2,
1437: x_msg_count OUT NOCOPY NUMBER,
1438: x_msg_data OUT NOCOPY VARCHAR2,
1439: p_party_id IN NUMBER,

Line 1465: IF NOT FND_API.Compatible_API_Call (l_api_version,

1461: IF (c_instr_assignments%ISOPEN) THEN
1462: CLOSE c_instr_assignments;
1463: END IF;
1464:
1465: IF NOT FND_API.Compatible_API_Call (l_api_version,
1466: p_api_version,
1467: l_module,
1468: G_PKG_NAME)
1469: THEN

Line 1475: RAISE FND_API.G_EXC_ERROR;

1471: debug_level => FND_LOG.LEVEL_ERROR,
1472: module => G_DEBUG_MODULE || l_module);
1473: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1474: FND_MSG_PUB.Add;
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1479: FND_MSG_PUB.initialize;

Line 1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1474: FND_MSG_PUB.Add;
1475: RAISE FND_API.G_EXC_ERROR;
1476: END IF;
1477:
1478: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1479: FND_MSG_PUB.initialize;
1480: END IF;
1481: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1482:

Line 1500: WHEN FND_API.G_EXC_ERROR THEN

1496: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1497:
1498: EXCEPTION
1499:
1500: WHEN FND_API.G_EXC_ERROR THEN
1501:
1502: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1503: debug_level => FND_LOG.LEVEL_ERROR,
1504: module => G_DEBUG_MODULE || l_module);

Line 1505: x_return_status := FND_API.G_RET_STS_ERROR ;

1501:
1502: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1503: debug_level => FND_LOG.LEVEL_ERROR,
1504: module => G_DEBUG_MODULE || l_module);
1505: x_return_status := FND_API.G_RET_STS_ERROR ;
1506: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1505: x_return_status := FND_API.G_RET_STS_ERROR ;
1506: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1507: p_data => x_msg_data
1508: );
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510:
1511: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1513: module => G_DEBUG_MODULE || l_module);

Line 1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1510:
1511: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1512: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1513: module => G_DEBUG_MODULE || l_module);
1514: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1515: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1516: p_data => x_msg_data
1517: );
1518: WHEN OTHERS THEN

Line 1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1522: module => G_DEBUG_MODULE || l_module);
1523:
1524: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1525:
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1527: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1528: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1529: END IF;
1530:

Line 1547: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1543:
1544: PROCEDURE Get_Trxn_Appl_Instr_Assign
1545: (
1546: p_api_version IN NUMBER,
1547: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1548: x_return_status OUT NOCOPY VARCHAR2,
1549: x_msg_count OUT NOCOPY NUMBER,
1550: x_msg_data OUT NOCOPY VARCHAR2,
1551: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 1606: IF NOT FND_API.Compatible_API_Call (l_api_version,

1602: IF (c_instr_assigns%ISOPEN) THEN
1603: CLOSE c_instr_assigns;
1604: END IF;
1605:
1606: IF NOT FND_API.Compatible_API_Call (l_api_version,
1607: p_api_version,
1608: l_module,
1609: G_PKG_NAME)
1610: THEN

Line 1616: RAISE FND_API.G_EXC_ERROR;

1612: debug_level => FND_LOG.LEVEL_ERROR,
1613: module => G_DEBUG_MODULE || l_module);
1614: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1620: FND_MSG_PUB.initialize;

Line 1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1615: FND_MSG_PUB.Add;
1616: RAISE FND_API.G_EXC_ERROR;
1617: END IF;
1618:
1619: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1620: FND_MSG_PUB.initialize;
1621: END IF;
1622: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1623:

Line 1624: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

1620: FND_MSG_PUB.initialize;
1621: END IF;
1622: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1623:
1624: Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
1625: l_payer_level,l_payer_id,l_payer_attribs);
1626:
1627: IF (l_payer_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN
1628: x_response.Result_Code := IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER;

Line 1652: WHEN FND_API.G_EXC_ERROR THEN

1648: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1649:
1650: EXCEPTION
1651:
1652: WHEN FND_API.G_EXC_ERROR THEN
1653:
1654: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1655: debug_level => FND_LOG.LEVEL_ERROR,
1656: module => G_DEBUG_MODULE || l_module);

Line 1657: x_return_status := FND_API.G_RET_STS_ERROR ;

1653:
1654: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1655: debug_level => FND_LOG.LEVEL_ERROR,
1656: module => G_DEBUG_MODULE || l_module);
1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1657: x_return_status := FND_API.G_RET_STS_ERROR ;
1658: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1659: p_data => x_msg_data
1660: );
1661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1662:
1663: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1664: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1665: module => G_DEBUG_MODULE || l_module);

Line 1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1662:
1663: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1664: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1665: module => G_DEBUG_MODULE || l_module);
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1667: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1668: p_data => x_msg_data
1669: );
1670: WHEN OTHERS THEN

Line 1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1674: module => G_DEBUG_MODULE || l_module);
1675:
1676: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
1677:
1678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1679: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1680: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
1681: END IF;
1682:

Line 1814: FND_API.G_FALSE,

1810:
1811:
1812: -- call Create_Card
1813: Create_Card(1.0,
1814: FND_API.G_FALSE,
1815: p_commit,
1816: x_return_status,
1817: x_msg_count,
1818: x_msg_data,

Line 1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1827:
1828: PROCEDURE Create_Card
1829: (
1830: p_api_version IN NUMBER,
1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1832: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1833: x_return_status OUT NOCOPY VARCHAR2,
1834: x_msg_count OUT NOCOPY NUMBER,
1835: x_msg_data OUT NOCOPY VARCHAR2,

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

1828: PROCEDURE Create_Card
1829: (
1830: p_api_version IN NUMBER,
1831: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1832: p_commit IN VARCHAR2 := FND_API.G_TRUE,
1833: x_return_status OUT NOCOPY VARCHAR2,
1834: x_msg_count OUT NOCOPY NUMBER,
1835: x_msg_data OUT NOCOPY VARCHAR2,
1836: p_card_instrument IN CreditCard_rec_type,

Line 1865: IF NOT FND_API.Compatible_API_Call (l_api_version,

1861:
1862: BEGIN
1863: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
1864:
1865: IF NOT FND_API.Compatible_API_Call (l_api_version,
1866: p_api_version,
1867: l_module,
1868: G_PKG_NAME)
1869: THEN

Line 1875: RAISE FND_API.G_EXC_ERROR;

1871: debug_level => FND_LOG.LEVEL_ERROR,
1872: module => G_DEBUG_MODULE || l_module);
1873: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1874: FND_MSG_PUB.Add;
1875: RAISE FND_API.G_EXC_ERROR;
1876: END IF;
1877:
1878: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;
1879:

Line 1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1876: END IF;
1877:
1878: IF (c_sec_mode%ISOPEN) THEN CLOSE c_sec_mode; END IF;
1879:
1880: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1881: FND_MSG_PUB.initialize;
1882: END IF;
1883: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1884:

Line 1890: FND_API.G_FALSE,

1886:
1887: IBY_FNDCPT_SETUP_PUB.Card_Exists
1888: (
1889: 1.0,
1890: FND_API.G_FALSE,
1891: x_return_status,
1892: x_msg_count,
1893: x_msg_data,
1894: p_card_instrument.Owner_Id,

Line 1907: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN

1903:
1904: IF (lx_card_rec.Card_Id IS NULL) THEN
1905:
1906: -- validate billing address information
1907: IF (NOT Validate_CC_Billing(FND_API.G_FALSE,p_card_instrument)) THEN
1908: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
1909: iby_fndcpt_common_pub.Prepare_Result
1910: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
1911: RETURN;

Line 1945: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,

1941: l_instr_reg.CreditCardInstr := l_cc_reg;
1942: l_instr_reg.InstrumentType := IBY_INSTRREG_PUB.C_INSTRTYPE_CREDITCARD;
1943:
1944: IBY_INSTRREG_PUB.OraInstrAdd
1945: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, FND_API.G_VALID_LEVEL_FULL,
1946: l_instr_reg, x_return_status, x_msg_count, x_msg_data,
1947: x_card_id, lx_result
1948: );
1949:

Line 1952: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))

1948: );
1949:
1950: -- should not be a validation error at this point
1951: IF ((NVL(x_card_id,-1)<0))
1952: --OR (x_return_status <> FND_API.G_RET_STS_ERROR))
1953: THEN
1954: iby_debug_pub.add('instrument reg failed',
1955: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1956: iby_debug_pub.add('result code:=' || lx_result.Result_Code,

Line 1979: (FND_API.G_FALSE,

1975: iby_debug_pub.add('database registration',
1976: iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
1977:
1978: iby_creditcard_pkg.Create_Card
1979: (FND_API.G_FALSE,
1980: p_card_instrument.Owner_Id, p_card_instrument.Card_Holder_Name,
1981: p_card_instrument.Billing_Address_Id,
1982: p_card_instrument.Address_Type,
1983: p_card_instrument.Billing_Postal_Code,

Line 2036: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN

2032: l_info_only := p_card_instrument.Info_Only_Flag;
2033: END IF;
2034:
2035: -- validate billing address information
2036: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2037: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2038: iby_fndcpt_common_pub.Prepare_Result
2039: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2040: RETURN;

Line 2052: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,

2048: RETURN;
2049: END IF;
2050:
2051: iby_creditcard_pkg.Update_Card
2052: (FND_API.G_FALSE, lx_card_rec.Card_Id, p_card_instrument.Owner_Id,
2053: p_card_instrument.Card_Holder_Name,
2054: p_card_instrument.Billing_Address_Id,
2055: p_card_instrument.Address_Type,
2056: p_card_instrument.Billing_Postal_Code,

Line 2063: NVL(p_card_instrument.Inactive_Date,FND_API.G_MISS_DATE),

2059: p_card_instrument.PurchaseCard_Flag, p_card_instrument.PurchaseCard_SubType,
2060: p_card_instrument.FI_Name, p_card_instrument.Single_Use_Flag,
2061: l_info_only, p_card_instrument.Card_Purpose,
2062: p_card_instrument.Card_Description, p_card_instrument.Active_Flag,
2063: NVL(p_card_instrument.Inactive_Date,FND_API.G_MISS_DATE),
2064: p_card_instrument.attribute_category,
2065: p_card_instrument.attribute1, p_card_instrument.attribute2,
2066: p_card_instrument.attribute3, p_card_instrument.attribute4,
2067: p_card_instrument.attribute5, p_card_instrument.attribute6,

Line 2088: IF FND_API.To_Boolean(p_commit) THEN

2084: x_response.Result_Code := NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
2085: iby_fndcpt_common_pub.Prepare_Result
2086: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2087:
2088: IF FND_API.To_Boolean(p_commit) THEN
2089: COMMIT;
2090: END IF;
2091:
2092: EXCEPTION

Line 2094: WHEN FND_API.G_EXC_ERROR THEN

2090: END IF;
2091:
2092: EXCEPTION
2093:
2094: WHEN FND_API.G_EXC_ERROR THEN
2095: ROLLBACK TO Create_Card;
2096: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2097: debug_level => FND_LOG.LEVEL_ERROR,
2098: module => G_DEBUG_MODULE || l_module);

Line 2099: x_return_status := FND_API.G_RET_STS_ERROR ;

2095: ROLLBACK TO Create_Card;
2096: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2097: debug_level => FND_LOG.LEVEL_ERROR,
2098: module => G_DEBUG_MODULE || l_module);
2099: x_return_status := FND_API.G_RET_STS_ERROR ;
2100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2099: x_return_status := FND_API.G_RET_STS_ERROR ;
2100: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2101: p_data => x_msg_data
2102: );
2103: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2104: --ROLLBACK TO Create_Card;
2105: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2106: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2107: module => G_DEBUG_MODULE || l_module);

Line 2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2104: --ROLLBACK TO Create_Card;
2105: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2106: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2107: module => G_DEBUG_MODULE || l_module);
2108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2109: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2110: p_data => x_msg_data
2111: );
2112: WHEN OTHERS THEN

Line 2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2116: module => G_DEBUG_MODULE || l_module);
2117:
2118: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2119:
2120: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2121: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2122: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2123: END IF;
2124:

Line 2253: FND_API.G_FALSE,

2249:
2250:
2251: -- call Update_Card
2252: Update_Card(1.0,
2253: FND_API.G_FALSE,
2254: p_commit,
2255: x_return_status,
2256: x_msg_count,
2257: x_msg_data,

Line 2268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2264:
2265: PROCEDURE Update_Card
2266: (
2267: p_api_version IN NUMBER,
2268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2269: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2270: x_return_status OUT NOCOPY VARCHAR2,
2271: x_msg_count OUT NOCOPY NUMBER,
2272: x_msg_data OUT NOCOPY VARCHAR2,

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

2265: PROCEDURE Update_Card
2266: (
2267: p_api_version IN NUMBER,
2268: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2269: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2270: x_return_status OUT NOCOPY VARCHAR2,
2271: x_msg_count OUT NOCOPY NUMBER,
2272: x_msg_data OUT NOCOPY VARCHAR2,
2273: p_card_instrument IN CreditCard_rec_type,

Line 2287: IF NOT FND_API.Compatible_API_Call (l_api_version,

2283:
2284: l_info_only iby_creditcard.information_only_flag%TYPE := NULL;
2285:
2286: BEGIN
2287: IF NOT FND_API.Compatible_API_Call (l_api_version,
2288: p_api_version,
2289: l_module,
2290: G_PKG_NAME)
2291: THEN

Line 2297: RAISE FND_API.G_EXC_ERROR;

2293: debug_level => FND_LOG.LEVEL_ERROR,
2294: module => G_DEBUG_MODULE || l_module);
2295: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2296: FND_MSG_PUB.Add;
2297: RAISE FND_API.G_EXC_ERROR;
2298: END IF;
2299:
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2301: FND_MSG_PUB.initialize;

Line 2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2296: FND_MSG_PUB.Add;
2297: RAISE FND_API.G_EXC_ERROR;
2298: END IF;
2299:
2300: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2301: FND_MSG_PUB.initialize;
2302: END IF;
2303: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2304:

Line 2312: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN

2308: IF (NOT p_card_instrument.Info_Only_Flag = 'Y') THEN
2309: l_info_only := p_card_instrument.Info_Only_Flag;
2310: END IF;
2311: -- validate billing address information
2312: IF (NOT Validate_CC_Billing(FND_API.G_TRUE,p_card_instrument)) THEN
2313: x_response.Result_Code := iby_creditcard_pkg.G_RC_INVALID_ADDRESS;
2314: iby_fndcpt_common_pub.Prepare_Result
2315: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2316: RETURN;

Line 2320: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,

2316: RETURN;
2317: END IF;
2318:
2319: iby_creditcard_pkg.Update_Card
2320: (FND_API.G_FALSE, p_card_instrument.Card_Id, p_card_instrument.Owner_Id,
2321: p_card_instrument.Card_Holder_Name,
2322: p_card_instrument.Billing_Address_Id,
2323: p_card_instrument.Address_Type,
2324: p_card_instrument.Billing_Postal_Code,

Line 2356: IF FND_API.To_Boolean(p_commit) THEN

2352: NVL(lx_result_code,IBY_FNDCPT_COMMON_PUB.G_RC_SUCCESS);
2353: iby_fndcpt_common_pub.Prepare_Result
2354: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2355:
2356: IF FND_API.To_Boolean(p_commit) THEN
2357: COMMIT;
2358: END IF;
2359:
2360: EXCEPTION

Line 2362: WHEN FND_API.G_EXC_ERROR THEN

2358: END IF;
2359:
2360: EXCEPTION
2361:
2362: WHEN FND_API.G_EXC_ERROR THEN
2363: ROLLBACK TO Update_Card;
2364: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2365: debug_level => FND_LOG.LEVEL_ERROR,
2366: module => G_DEBUG_MODULE || l_module);

Line 2367: x_return_status := FND_API.G_RET_STS_ERROR ;

2363: ROLLBACK TO Update_Card;
2364: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2365: debug_level => FND_LOG.LEVEL_ERROR,
2366: module => G_DEBUG_MODULE || l_module);
2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2369: p_data => x_msg_data
2370: );
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2367: x_return_status := FND_API.G_RET_STS_ERROR ;
2368: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2369: p_data => x_msg_data
2370: );
2371: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2372: ROLLBACK TO Update_Card;
2373: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2374: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2375: module => G_DEBUG_MODULE || l_module);

Line 2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2372: ROLLBACK TO Update_Card;
2373: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2374: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2375: module => G_DEBUG_MODULE || l_module);
2376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2377: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2378: p_data => x_msg_data
2379: );
2380: WHEN OTHERS THEN

Line 2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2384: module => G_DEBUG_MODULE || l_module);
2385:
2386: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2387:
2388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2389: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2390: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2391: END IF;
2392:

Line 2409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2405:
2406: PROCEDURE Get_Card
2407: (
2408: p_api_version IN NUMBER,
2409: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2410: x_return_status OUT NOCOPY VARCHAR2,
2411: x_msg_count OUT NOCOPY NUMBER,
2412: x_msg_data OUT NOCOPY VARCHAR2,
2413: p_card_id NUMBER,

Line 2437: IF NOT FND_API.Compatible_API_Call (l_api_version,

2433: IF (c_card%ISOPEN) THEN
2434: CLOSE c_card;
2435: END IF;
2436:
2437: IF NOT FND_API.Compatible_API_Call (l_api_version,
2438: p_api_version,
2439: l_module,
2440: G_PKG_NAME)
2441: THEN

Line 2447: RAISE FND_API.G_EXC_ERROR;

2443: debug_level => FND_LOG.LEVEL_ERROR,
2444: module => G_DEBUG_MODULE || l_module);
2445: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2446: FND_MSG_PUB.Add;
2447: RAISE FND_API.G_EXC_ERROR;
2448: END IF;
2449:
2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2451: FND_MSG_PUB.initialize;

Line 2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2446: FND_MSG_PUB.Add;
2447: RAISE FND_API.G_EXC_ERROR;
2448: END IF;
2449:
2450: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2451: FND_MSG_PUB.initialize;
2452: END IF;
2453: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2454:

Line 2476: WHEN FND_API.G_EXC_ERROR THEN

2472: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2473:
2474: EXCEPTION
2475:
2476: WHEN FND_API.G_EXC_ERROR THEN
2477:
2478: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2479: debug_level => FND_LOG.LEVEL_ERROR,
2480: module => G_DEBUG_MODULE || l_module);

Line 2481: x_return_status := FND_API.G_RET_STS_ERROR ;

2477:
2478: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2479: debug_level => FND_LOG.LEVEL_ERROR,
2480: module => G_DEBUG_MODULE || l_module);
2481: x_return_status := FND_API.G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2483: p_data => x_msg_data
2484: );
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2481: x_return_status := FND_API.G_RET_STS_ERROR ;
2482: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2483: p_data => x_msg_data
2484: );
2485: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2486:
2487: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2488: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2489: module => G_DEBUG_MODULE || l_module);

Line 2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2486:
2487: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2488: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2489: module => G_DEBUG_MODULE || l_module);
2490: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2491: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2492: p_data => x_msg_data
2493: );
2494: WHEN OTHERS THEN

Line 2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2498: module => G_DEBUG_MODULE || l_module);
2499:
2500: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2501:
2502: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2503: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2504: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2505: END IF;
2506:

Line 2522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2518:
2519: PROCEDURE Card_Exists
2520: (
2521: p_api_version IN NUMBER,
2522: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2523: x_return_status OUT NOCOPY VARCHAR2,
2524: x_msg_count OUT NOCOPY NUMBER,
2525: x_msg_data OUT NOCOPY VARCHAR2,
2526: p_owner_id NUMBER,

Line 2566: IF NOT FND_API.Compatible_API_Call (l_api_version,

2562: IF (c_card%ISOPEN) THEN
2563: CLOSE c_card;
2564: END IF;
2565:
2566: IF NOT FND_API.Compatible_API_Call (l_api_version,
2567: p_api_version,
2568: l_module,
2569: G_PKG_NAME)
2570: THEN

Line 2576: RAISE FND_API.G_EXC_ERROR;

2572: debug_level => FND_LOG.LEVEL_ERROR,
2573: module => G_DEBUG_MODULE || l_module);
2574: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2575: FND_MSG_PUB.Add;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2580: FND_MSG_PUB.initialize;

Line 2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2575: FND_MSG_PUB.Add;
2576: RAISE FND_API.G_EXC_ERROR;
2577: END IF;
2578:
2579: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2580: FND_MSG_PUB.initialize;
2581: END IF;
2582: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2583: IF (nvl(p_card_instr_type,IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD ) = IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_PAYMENTCARD) THEN

Line 2588: (1.0, FND_API.G_FALSE, p_card_number,

2584: l_char_allowed := 'Y';
2585: END IF;
2586:
2587: iby_cc_validate.StripCC
2588: (1.0, FND_API.G_FALSE, p_card_number,
2589: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2590: );
2591:
2592: IF (lx_cc_number IS NULL) THEN

Line 2612: FND_API.G_FALSE,

2608: ELSE
2609: IBY_FNDCPT_SETUP_PUB.Get_Card
2610: (
2611: 1.0,
2612: FND_API.G_FALSE,
2613: x_return_status,
2614: x_msg_count,
2615: x_msg_data,
2616: l_card_id,

Line 2627: WHEN FND_API.G_EXC_ERROR THEN

2623: (l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2624:
2625: EXCEPTION
2626:
2627: WHEN FND_API.G_EXC_ERROR THEN
2628:
2629: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2630: debug_level => FND_LOG.LEVEL_ERROR,
2631: module => G_DEBUG_MODULE || l_module);

Line 2632: x_return_status := FND_API.G_RET_STS_ERROR ;

2628:
2629: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2630: debug_level => FND_LOG.LEVEL_ERROR,
2631: module => G_DEBUG_MODULE || l_module);
2632: x_return_status := FND_API.G_RET_STS_ERROR ;
2633: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2632: x_return_status := FND_API.G_RET_STS_ERROR ;
2633: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2634: p_data => x_msg_data
2635: );
2636: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2637:
2638: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2639: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2640: module => G_DEBUG_MODULE || l_module);

Line 2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2637:
2638: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2639: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2640: module => G_DEBUG_MODULE || l_module);
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2642: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2643: p_data => x_msg_data
2644: );
2645: WHEN OTHERS THEN

Line 2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2649: module => G_DEBUG_MODULE || l_module);
2650:
2651: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2652:
2653: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2654: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2655: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2656: END IF;
2657:

Line 2673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2669:
2670: PROCEDURE Process_Credit_Card
2671: (
2672: p_api_version IN NUMBER,
2673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2674: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2675: x_return_status OUT NOCOPY VARCHAR2,
2676: x_msg_count OUT NOCOPY NUMBER,
2677: x_msg_data OUT NOCOPY VARCHAR2,

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

2670: PROCEDURE Process_Credit_Card
2671: (
2672: p_api_version IN NUMBER,
2673: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2674: p_commit IN VARCHAR2 := FND_API.G_TRUE,
2675: x_return_status OUT NOCOPY VARCHAR2,
2676: x_msg_count OUT NOCOPY NUMBER,
2677: x_msg_data OUT NOCOPY VARCHAR2,
2678: p_payer IN IBY_FNDCPT_COMMON_PUB.PayerContext_rec_type,

Line 2701: IF NOT FND_API.Compatible_API_Call (l_api_version,

2697: l_dbg_mod VARCHAR2(100) := G_DEBUG_MODULE || '.' || l_module;
2698: BEGIN
2699: iby_debug_pub.add('Enter',iby_debug_pub.G_LEVEL_PROCEDURE,l_dbg_mod);
2700:
2701: IF NOT FND_API.Compatible_API_Call (l_api_version,
2702: p_api_version,
2703: l_module,
2704: G_PKG_NAME)
2705: THEN

Line 2711: RAISE FND_API.G_EXC_ERROR;

2707: debug_level => FND_LOG.LEVEL_ERROR,
2708: module => G_DEBUG_MODULE || l_module);
2709: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
2710: FND_MSG_PUB.Add;
2711: RAISE FND_API.G_EXC_ERROR;
2712: END IF;
2713:
2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2715: FND_MSG_PUB.initialize;

Line 2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2710: FND_MSG_PUB.Add;
2711: RAISE FND_API.G_EXC_ERROR;
2712: END IF;
2713:
2714: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2715: FND_MSG_PUB.initialize;
2716: END IF;
2717: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
2718:

Line 2728: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,

2724:
2725: iby_debug_pub.add('create card',iby_debug_pub.G_LEVEL_INFO,l_dbg_mod);
2726:
2727: Create_Card
2728: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, lx_return_status, lx_msg_count,
2729: lx_msg_data, p_credit_card,
2730: lx_assign_attribs.Instrument.Instrument_Id,
2731: lx_response
2732: );

Line 2743: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, x_return_status, x_msg_count,

2739:
2740: lx_assign_attribs.Instrument.Instrument_Type :=
2741: IBY_FNDCPT_COMMON_PUB.G_INSTR_TYPE_CREDITCARD;
2742: Set_Payer_Instr_Assignment
2743: (1.0, FND_API.G_FALSE, FND_API.G_FALSE, x_return_status, x_msg_count,
2744: x_msg_data, p_payer, lx_assign_attribs, x_assign_id,
2745: x_response
2746: );
2747: END IF;

Line 2753: IF FND_API.To_Boolean(p_commit) THEN

2749: iby_fndcpt_common_pub.Prepare_Result
2750: (iby_fndcpt_common_pub.G_INTERFACE_CODE,x_response.Result_Message,
2751: l_prev_msg_count,x_return_status,x_msg_count,x_msg_data,x_response);
2752:
2753: IF FND_API.To_Boolean(p_commit) THEN
2754: COMMIT;
2755: END IF;
2756:
2757: EXCEPTION

Line 2759: WHEN FND_API.G_EXC_ERROR THEN

2755: END IF;
2756:
2757: EXCEPTION
2758:
2759: WHEN FND_API.G_EXC_ERROR THEN
2760: ROLLBACK TO Process_Credit_Card;
2761: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2762: debug_level => FND_LOG.LEVEL_ERROR,
2763: module => G_DEBUG_MODULE || l_module);

Line 2764: x_return_status := FND_API.G_RET_STS_ERROR ;

2760: ROLLBACK TO Process_Credit_Card;
2761: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
2762: debug_level => FND_LOG.LEVEL_ERROR,
2763: module => G_DEBUG_MODULE || l_module);
2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2764: x_return_status := FND_API.G_RET_STS_ERROR ;
2765: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2766: p_data => x_msg_data
2767: );
2768: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2769: ROLLBACK TO Process_Credit_Card;
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2772: module => G_DEBUG_MODULE || l_module);

Line 2773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2769: ROLLBACK TO Process_Credit_Card;
2770: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
2771: debug_level => FND_LOG.LEVEL_UNEXPECTED,
2772: module => G_DEBUG_MODULE || l_module);
2773: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2774: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
2775: p_data => x_msg_data
2776: );
2777: WHEN OTHERS THEN

Line 2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2781: module => G_DEBUG_MODULE || l_module);
2782:
2783: iby_fndcpt_common_pub.Clear_Msg_Stack(l_prev_msg_count);
2784:
2785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2786: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2787: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_module, SUBSTR(SQLERRM,1,100));
2788: END IF;
2789:

Line 2804: (1.0, FND_API.G_FALSE, p_number,

2800: lx_msg_data VARCHAR2(200);
2801: lx_cc_number iby_creditcard.ccnumber%TYPE;
2802: BEGIN
2803: iby_cc_validate.StripCC
2804: (1.0, FND_API.G_FALSE, p_number,
2805: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2806: );
2807: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt);
2808: END Get_Hash;

Line 2819: (1.0, FND_API.G_FALSE, p_number,

2815: lx_msg_data VARCHAR2(200);
2816: lx_cc_number iby_creditcard.ccnumber%TYPE;
2817: BEGIN
2818: iby_cc_validate.StripCC
2819: (1.0, FND_API.G_FALSE, p_number,
2820: lx_return_status, lx_msg_count, lx_msg_data, lx_cc_number
2821: );
2822: RETURN iby_security_pkg.get_hash(lx_cc_number,p_salt,p_site_salt);
2823: END Get_Hash;

Line 2856: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,

2852: ORDER BY p.acct_site_use_id, p.cust_account_id, p.org_id;
2853:
2854: BEGIN
2855:
2856: IBY_FNDCPT_SETUP_PUB.Get_Payer_Id(p_payer,FND_API.G_VALID_LEVEL_FULL,
2857: l_payer_level,l_payer_id,l_payer_attribs);
2858:
2859: FOR l_payer_attr_rec in l_payer_attr_cur(p_payer,l_payer_level,p_payer_equivalency) LOOP
2860: IF (x_payer_attributes.Bank_Charge_Bearer is NULL) THEN