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_DISBURSEMENT_SETUP_PUB dependencies on FND_MSG_PUB

Line 396: FND_MSG_PUB.initialize;

392: END IF;
393:
394: -- Initialize message list if p_init_msg_list is set to TRUE.
395: IF FND_API.to_Boolean(p_init_msg_list) THEN
396: FND_MSG_PUB.initialize;
397: END IF;
398:
399: -- Initialize API return status to success
400: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 414: FND_MSG_PUB.Add;

410: print_debuginfo(l_module_name,'Payee party Id is null.');
411: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
412: FND_MESSAGE.SET_TOKEN('PARAM', 'Payee party Id');
413: l_message := fnd_message.get;
414: FND_MSG_PUB.Add;
415:
416: l_ext_payee_id_rec.Ext_Payee_ID := -1;
417: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
418: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 427: FND_MSG_PUB.Add;

423: print_debuginfo(l_module_name,'Payment function is null.');
424: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
425: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment function');
426: l_message := fnd_message.get;
427: FND_MSG_PUB.Add;
428:
429: l_ext_payee_id_rec.Ext_Payee_ID := -1;
430: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
431: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 442: FND_MSG_PUB.Add;

438: print_debuginfo(l_module_name,'Payer Org Id is null.');
439: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
440: FND_MESSAGE.SET_TOKEN('PARAM', 'Payer Org Id');
441: l_message := fnd_message.get;
442: FND_MSG_PUB.Add;
443:
444: l_ext_payee_id_rec.Ext_Payee_ID := -1;
445: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
446: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 454: FND_MSG_PUB.Add;

450: print_debuginfo(l_module_name,'Payer Org Id is null.');
451: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
452: FND_MESSAGE.SET_TOKEN('PARAM', 'Payer Org Type');
453: l_message := fnd_message.get;
454: FND_MSG_PUB.Add;
455:
456: l_ext_payee_id_rec.Ext_Payee_ID := -1;
457: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
458: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 467: FND_MSG_PUB.Add;

463: print_debuginfo(l_module_name,'Payer Org Id is null but Org_type is not null.');
464: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
465: FND_MESSAGE.SET_TOKEN('PARAM', 'Payer Org Id');
466: l_message := fnd_message.get;
467: FND_MSG_PUB.Add;
468:
469: l_ext_payee_id_rec.Ext_Payee_ID := -1;
470: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
471: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 478: FND_MSG_PUB.Add;

474: print_debuginfo(l_module_name,'Exclusive payment flag is null.');
475: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
476: FND_MESSAGE.SET_TOKEN('PARAM', 'Exclusive payment flag');
477: l_message := fnd_message.get;
478: FND_MSG_PUB.Add;
479:
480: l_ext_payee_id_rec.Ext_Payee_ID := -1;
481: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';
482: l_ext_payee_crt_rec.Payee_Creation_Msg := l_message;

Line 584: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

580: -- End of API body.
581: print_debuginfo(l_module_name, 'End of external payee loop.');
582:
583: -- Standard call to get message count and if count is 1, get message info.
584: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
585:
586: print_debuginfo(l_module_name, 'RETURN');
587:
588: EXCEPTION

Line 592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

588: EXCEPTION
589: WHEN FND_API.G_EXC_ERROR THEN
590: x_return_status := FND_API.G_RET_STS_ERROR;
591:
592: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
593: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
594: print_debuginfo(l_module_name,'SQLerr is :'
595: || substr(SQLERRM, 1, 150));
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

595: || substr(SQLERRM, 1, 150));
596: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
597: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
598:
599: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
600: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
601: print_debuginfo(l_module_name,'SQLerr is :'
602: || substr(SQLERRM, 1, 150));
603: WHEN OTHERS THEN

Line 606: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

602: || substr(SQLERRM, 1, 150));
603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
607: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
608: END IF;
609: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
610: print_debuginfo(l_module_name,'SQLerr is :'

Line 607: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

603: WHEN OTHERS THEN
604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
605:
606: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
607: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
608: END IF;
609: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
610: print_debuginfo(l_module_name,'SQLerr is :'
611: || substr(SQLERRM, 1, 150));

Line 612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

608: END IF;
609: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
610: print_debuginfo(l_module_name,'SQLerr is :'
611: || substr(SQLERRM, 1, 150));
612: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
613:
614: END Create_External_Payee;
615:
616: -- Start of comments

Line 695: FND_MSG_PUB.Add;

691: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
692: debug_level => FND_LOG.LEVEL_ERROR,
693: module => G_DEBUG_MODULE || l_module);
694: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
695: FND_MSG_PUB.Add;
696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 700: FND_MSG_PUB.initialize;

696: RAISE FND_API.G_EXC_ERROR;
697: END IF;
698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
703:
704: Get_Payee_Id(p_payee, FND_API.G_VALID_LEVEL_FULL,l_payee_level, l_payee_id);

Line 702: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

698:
699: IF FND_API.to_Boolean( p_init_msg_list ) THEN
700: FND_MSG_PUB.initialize;
701: END IF;
702: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
703:
704: Get_Payee_Id(p_payee, FND_API.G_VALID_LEVEL_FULL,l_payee_level, l_payee_id);
705:
706: print_debuginfo(l_module, 'After Get_Payee_Id');

Line 874: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

870: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
871: debug_level => FND_LOG.LEVEL_ERROR,
872: module => G_DEBUG_MODULE || l_module);
873: x_return_status := FND_API.G_RET_STS_ERROR ;
874: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
878: ROLLBACK TO Set_Payee_Instr_Assignment;

Line 883: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

879: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
880: debug_level => FND_LOG.LEVEL_UNEXPECTED,
881: module => G_DEBUG_MODULE || l_module);
882: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
883: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
884: p_data => x_msg_data
885: );
886: WHEN OTHERS THEN
887: ROLLBACK TO Set_Payee_Instr_Assignment;

Line 892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

888: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
889: debug_level => FND_LOG.LEVEL_UNEXPECTED,
890: module => G_DEBUG_MODULE || l_module);
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
893: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
894: END IF;
895:
896: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 893: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);

889: debug_level => FND_LOG.LEVEL_UNEXPECTED,
890: module => G_DEBUG_MODULE || l_module);
891: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
893: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
894: END IF;
895:
896: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
897: p_data => x_msg_data

Line 896: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

892: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
893: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
894: END IF;
895:
896: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
897: p_data => x_msg_data
898: );
899: END Set_Payee_Instr_Assignment;
900:

Line 969: FND_MSG_PUB.Add;

965: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
966: debug_level => FND_LOG.LEVEL_ERROR,
967: module => G_DEBUG_MODULE || l_module);
968: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
969: FND_MSG_PUB.Add;
970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 974: FND_MSG_PUB.initialize;

970: RAISE FND_API.G_EXC_ERROR;
971: END IF;
972:
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;
975: END IF;
976: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
977:
978: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);

Line 976: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

972:
973: IF FND_API.to_Boolean( p_init_msg_list ) THEN
974: FND_MSG_PUB.initialize;
975: END IF;
976: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
977:
978: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);
979:
980: IF (l_payee_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN

Line 1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1010: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1011: debug_level => FND_LOG.LEVEL_ERROR,
1012: module => G_DEBUG_MODULE || l_module);
1013: x_return_status := FND_API.G_RET_STS_ERROR ;
1014: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1015: p_data => x_msg_data
1016: );
1017: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1018:

Line 1023: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1019: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1020: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1021: module => G_DEBUG_MODULE || l_module);
1022: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1023: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1024: p_data => x_msg_data
1025: );
1026: WHEN OTHERS THEN
1027:

Line 1032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1028: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1029: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1030: module => G_DEBUG_MODULE || l_module);
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1033: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1034: END IF;
1035:
1036: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1033: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);

1029: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1030: module => G_DEBUG_MODULE || l_module);
1031: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1033: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1034: END IF;
1035:
1036: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1037: p_data => x_msg_data

Line 1036: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1032: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1033: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1034: END IF;
1035:
1036: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1037: p_data => x_msg_data
1038: );
1039: END Get_Payee_Instr_Assignments;
1040:

Line 1102: FND_MSG_PUB.Add;

1098: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1099: debug_level => FND_LOG.LEVEL_ERROR,
1100: module => G_DEBUG_MODULE || l_module);
1101: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1102: FND_MSG_PUB.Add;
1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1107: FND_MSG_PUB.initialize;

1103: RAISE FND_API.G_EXC_ERROR;
1104: END IF;
1105:
1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1107: FND_MSG_PUB.initialize;
1108: END IF;
1109: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1110:
1111: l_instr_count := 0;

Line 1109: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1105:
1106: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1107: FND_MSG_PUB.initialize;
1108: END IF;
1109: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1110:
1111: l_instr_count := 0;
1112: FOR assign_rec IN c_instr_assignments(p_party_id) LOOP
1113: l_instr_count := l_instr_count + 1;

Line 1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1128: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1129: debug_level => FND_LOG.LEVEL_ERROR,
1130: module => G_DEBUG_MODULE || l_module);
1131: x_return_status := FND_API.G_RET_STS_ERROR ;
1132: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1133: p_data => x_msg_data
1134: );
1135: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1136:

Line 1141: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,

1137: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1138: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1139: module => G_DEBUG_MODULE || l_module);
1140: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1141: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1142: p_data => x_msg_data
1143: );
1144: WHEN OTHERS THEN
1145:

Line 1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1146: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1147: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1148: module => G_DEBUG_MODULE || l_module);
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1152: END IF;
1153:
1154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

Line 1151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);

1147: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1148: module => G_DEBUG_MODULE || l_module);
1149: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1152: END IF;
1153:
1154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1155: p_data => x_msg_data

Line 1154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

1150: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1151: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1152: END IF;
1153:
1154: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1155: p_data => x_msg_data
1156: );
1157:
1158: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 1193: FND_MSG_PUB.Add;

1189: IF (l_count = 0) THEN
1190: FND_MESSAGE.set_name('IBY', 'IBY_LOOKUP_VAL_ERROR');
1191: FND_MESSAGE.SET_TOKEN('LOOKUPTYPE', p_loopkup_type);
1192: FND_MESSAGE.SET_TOKEN('VALUE', p_value);
1193: FND_MSG_PUB.Add;
1194: RETURN FALSE;
1195: ELSE
1196: RETURN TRUE;
1197: END IF;

Line 1291: FND_MSG_PUB.initialize;

1287: END IF;
1288:
1289: -- Initialize message list if p_init_msg_list is set to TRUE.
1290: IF FND_API.to_Boolean(p_init_msg_list) THEN
1291: FND_MSG_PUB.initialize;
1292: END IF;
1293:
1294: -- Initialize API return status to success
1295: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1338: FND_MSG_PUB.Add;

1334: IF (l_count = 0) THEN
1335: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1336: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_METHODS_V');
1337: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Default_Pmt_method);
1338: FND_MSG_PUB.Add;
1339: l_valid := FALSE;
1340: END IF;
1341: END IF;
1342:

Line 1364: FND_MSG_PUB.Add;

1360: IF (l_count = 0) THEN
1361: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1362: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_REASONS_VL');
1363: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pay_Reason_Code);
1364: FND_MSG_PUB.Add;
1365: l_valid := FALSE;
1366: END IF;
1367: END IF;
1368:

Line 1380: FND_MSG_PUB.Add;

1376: IF (l_count = 0) THEN
1377: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1378: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_DELIVERY_CHANNELS_VL');
1379: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Delivery_Channel);
1380: FND_MSG_PUB.Add;
1381: l_valid := FALSE;
1382: END IF;
1383: END IF;
1384:

Line 1396: FND_MSG_PUB.Add;

1392: IF (l_count = 0) THEN
1393: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1394: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');
1395: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pmt_Format);
1396: FND_MSG_PUB.Add;
1397: l_valid := FALSE;
1398: END IF;
1399: END IF;
1400:

Line 1417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1413:
1414: -- End of API body
1415:
1416: -- get message count and if count is 1, get message info.
1417: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data);
1420:
1421:

Line 1426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1422: EXCEPTION
1423: WHEN fnd_api.g_exc_error THEN
1424: ROLLBACK TO Validate_External_Payee_pub;
1425: x_return_status := fnd_api.g_ret_sts_error;
1426: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data);
1429:
1430:

Line 1434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1430:
1431: WHEN fnd_api.g_exc_unexpected_error THEN
1432: ROLLBACK TO Validate_External_Payee_pub;
1433: x_return_status := fnd_api.g_ret_sts_unexp_error;
1434: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1435: p_count => x_msg_count,
1436: p_data => x_msg_data);
1437:
1438:

Line 1444: fnd_msg_pub.add;

1440: ROLLBACK TO Validate_External_Payee_pub;
1441: x_return_status := fnd_api.g_ret_sts_unexp_error;
1442: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data);
1448:

Line 1445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1441: x_return_status := fnd_api.g_ret_sts_unexp_error;
1442: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1443: fnd_message.set_token('ERROR',SQLERRM);
1444: fnd_msg_pub.add;
1445: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1446: p_count => x_msg_count,
1447: p_data => x_msg_data);
1448:
1449:

Line 1569: FND_MSG_PUB.initialize;

1565: END IF;
1566:
1567: -- Initialize message list if p_init_msg_list is set to TRUE.
1568: IF FND_API.to_Boolean(p_init_msg_list) THEN
1569: FND_MSG_PUB.initialize;
1570: END IF;
1571:
1572: -- Initialize API return status to success
1573: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1632: END IF;
1633: -- End of API body
1634:
1635: -- get message count and if count is 1, get message info.
1636: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1637: p_count => x_msg_count,
1638: p_data => x_msg_data);
1639:
1640:

Line 1645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1641: EXCEPTION
1642: WHEN fnd_api.g_exc_error THEN
1643: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1644: x_return_status := fnd_api.g_ret_sts_error;
1645: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1646: p_count => x_msg_count,
1647: p_data => x_msg_data);
1648:
1649:

Line 1653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1649:
1650: WHEN fnd_api.g_exc_unexpected_error THEN
1651: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1652: x_return_status := fnd_api.g_ret_sts_unexp_error;
1653: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1654: p_count => x_msg_count,
1655: p_data => x_msg_data);
1656:
1657:

Line 1663: fnd_msg_pub.add;

1659: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1662: fnd_message.set_token('ERROR',SQLERRM);
1663: fnd_msg_pub.add;
1664: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data);
1667:

Line 1664: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1660: x_return_status := fnd_api.g_ret_sts_unexp_error;
1661: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1662: fnd_message.set_token('ERROR',SQLERRM);
1663: fnd_msg_pub.add;
1664: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1665: p_count => x_msg_count,
1666: p_data => x_msg_data);
1667:
1668: END Create_Temp_Ext_Bank_Acct;

Line 1792: FND_MSG_PUB.initialize;

1788: END IF;
1789:
1790: -- Initialize message list if p_init_msg_list is set to TRUE.
1791: IF FND_API.to_Boolean(p_init_msg_list) THEN
1792: FND_MSG_PUB.initialize;
1793: END IF;
1794:
1795: -- Initialize API return status to success
1796: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1865: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1861: END IF;
1862: -- End of API body
1863:
1864: -- get message count and if count is 1, get message info.
1865: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1866: p_count => x_msg_count,
1867: p_data => x_msg_data);
1868:
1869: print_debuginfo(l_module_name, 'EXIT');

Line 1874: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1870: EXCEPTION
1871: WHEN fnd_api.g_exc_error THEN
1872: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1873: x_return_status := fnd_api.g_ret_sts_error;
1874: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1875: p_count => x_msg_count,
1876: p_data => x_msg_data);
1877:
1878:

Line 1882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1878:
1879: WHEN fnd_api.g_exc_unexpected_error THEN
1880: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1881: x_return_status := fnd_api.g_ret_sts_unexp_error;
1882: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1883: p_count => x_msg_count,
1884: p_data => x_msg_data);
1885:
1886:

Line 1892: fnd_msg_pub.add;

1888: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1891: fnd_message.set_token('ERROR',SQLERRM);
1892: fnd_msg_pub.add;
1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:

Line 1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

1889: x_return_status := fnd_api.g_ret_sts_unexp_error;
1890: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1891: fnd_message.set_token('ERROR',SQLERRM);
1892: fnd_msg_pub.add;
1893: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1894: p_count => x_msg_count,
1895: p_data => x_msg_data);
1896:
1897: END Create_Temp_Ext_Bank_Acct;

Line 2051: FND_MSG_PUB.initialize;

2047: END IF;
2048:
2049: -- Initialize message list if p_init_msg_list is set to TRUE.
2050: IF FND_API.to_Boolean(p_init_msg_list) THEN
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Initialize API return status to success
2055: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2143: IF (fnd_msg_pub.count_msg > 0) THEN

2139: x_msg_data => x_msg_data,
2140: x_response => l_response
2141: );
2142:
2143: IF (fnd_msg_pub.count_msg > 0) THEN
2144: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2145: END IF;
2146:
2147: -- End of API body

Line 2150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2146:
2147: -- End of API body
2148:
2149: -- get message count and if count is 1, get message info.
2150: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2151: p_count => x_msg_count,
2152: p_data => x_msg_data);
2153:
2154:

Line 2159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2155: EXCEPTION
2156: WHEN fnd_api.g_exc_error THEN
2157: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2158: x_return_status := fnd_api.g_ret_sts_error;
2159: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2160: p_count => x_msg_count,
2161: p_data => x_msg_data);
2162:
2163:

Line 2167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2163:
2164: WHEN fnd_api.g_exc_unexpected_error THEN
2165: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2166: x_return_status := fnd_api.g_ret_sts_unexp_error;
2167: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2168: p_count => x_msg_count,
2169: p_data => x_msg_data);
2170:
2171:

Line 2177: fnd_msg_pub.add;

2173: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2174: x_return_status := fnd_api.g_ret_sts_unexp_error;
2175: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2176: fnd_message.set_token('ERROR',SQLERRM);
2177: fnd_msg_pub.add;
2178: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:

Line 2178: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

2174: x_return_status := fnd_api.g_ret_sts_unexp_error;
2175: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2176: fnd_message.set_token('ERROR',SQLERRM);
2177: fnd_msg_pub.add;
2178: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2179: p_count => x_msg_count,
2180: p_data => x_msg_data);
2181:
2182: END Validate_Temp_Ext_Bank_Acct;

Line 2261: FND_MSG_PUB.initialize;

2257: END IF;
2258:
2259: -- Initialize message list if p_init_msg_list is set to TRUE.
2260: IF FND_API.to_Boolean(p_init_msg_list) THEN
2261: FND_MSG_PUB.initialize;
2262: END IF;
2263:
2264: -- Initialize API return status to success
2265: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2278: FND_MSG_PUB.Add;

2274: print_debuginfo(l_module_name,'Payee to update does not exist.');
2275: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2276: FND_MESSAGE.SET_TOKEN('PARAM', 'External Payee Id');
2277: l_message := fnd_message.get;
2278: FND_MSG_PUB.Add;
2279:
2280: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2281: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2282:

Line 2290: FND_MSG_PUB.Add;

2286: print_debuginfo(l_module_name,'Payee party Id is null.');
2287: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2288: FND_MESSAGE.SET_TOKEN('PARAM', 'Payee party Id');
2289: l_message := fnd_message.get;
2290: FND_MSG_PUB.Add;
2291:
2292: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2293: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2294:

Line 2302: FND_MSG_PUB.Add;

2298: print_debuginfo(l_module_name,'Payment function is null.');
2299: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2300: FND_MESSAGE.SET_TOKEN('PARAM', 'Payment function');
2301: l_message := fnd_message.get;
2302: FND_MSG_PUB.Add;
2303:
2304: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2305: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2306:

Line 2316: FND_MSG_PUB.Add;

2312: print_debuginfo(l_module_name,'Payer Org Id is null.');
2313: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2314: FND_MESSAGE.SET_TOKEN('PARAM', 'Payer Org Id');
2315: l_message := fnd_message.get;
2316: FND_MSG_PUB.Add;
2317:
2318: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2319: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2320:

Line 2327: FND_MSG_PUB.Add;

2323: print_debuginfo(l_module_name,'Payer Org Id is null.');
2324: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2325: FND_MESSAGE.SET_TOKEN('PARAM', 'Payer Org Type');
2326: l_message := fnd_message.get;
2327: FND_MSG_PUB.Add;
2328:
2329: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2330: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2331:

Line 2337: FND_MSG_PUB.Add;

2333: print_debuginfo(l_module_name,'Exclusive payment flag is null.');
2334: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2335: FND_MESSAGE.SET_TOKEN('PARAM', 'Exclusive payment flag');
2336: l_message := fnd_message.get;
2337: FND_MSG_PUB.Add;
2338:
2339: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2340: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2341:

Line 2364: FND_MSG_PUB.Add;

2360: 'parameter ext_payee_id');
2361: FND_MESSAGE.set_name('IBY', 'IBY_EXT_PAYEE_NOT_EXIST');
2362: FND_MESSAGE.SET_TOKEN('EXT_PAYEE_ID', p_ext_payee_id_tab(counter).ext_payee_id);
2363: l_message := fnd_message.get;
2364: FND_MSG_PUB.Add;
2365:
2366: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2367: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2368:

Line 2497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2493: -- End of API body.
2494:
2495: print_debuginfo(l_module_name, 'End of external payee loop.');
2496: -- Standard call to get message count and if count is 1, get message info.
2497: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2498: print_debuginfo(l_module_name, 'RETURN');
2499:
2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR THEN

Line 2504: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2500: EXCEPTION
2501: WHEN FND_API.G_EXC_ERROR THEN
2502: x_return_status := FND_API.G_RET_STS_ERROR;
2503:
2504: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2505: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2506: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2507:
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2507:
2508: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2510:
2511: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2512: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2513: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2514:
2515: WHEN OTHERS THEN

Line 2518: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN

2514:
2515: WHEN OTHERS THEN
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517:
2518: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2522: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));

Line 2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);

2515: WHEN OTHERS THEN
2516: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2517:
2518: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2522: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2523: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2523: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

2519: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2520: END IF;
2521: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
2522: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
2523: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2524:
2525: END Update_External_Payee;
2526:
2527: