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 494: FND_MSG_PUB.initialize;

490: END IF;
491:
492: -- Initialize message list if p_init_msg_list is set to TRUE.
493: IF FND_API.to_Boolean(p_init_msg_list) THEN
494: FND_MSG_PUB.initialize;
495: END IF;
496:
497: -- Initialize API return status to success
498: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 515: FND_MSG_PUB.Add;

511: print_debuginfo(l_module_name,'Payee party Id is null.');
512: END IF;
513: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
514: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYEE_PARTY_ID_FIELD'));
515: FND_MSG_PUB.Add;
516: l_message := fnd_message.get;
517:
518: l_ext_payee_id_rec.Ext_Payee_ID := -1;
519: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 530: FND_MSG_PUB.Add;

526: print_debuginfo(l_module_name,'Payment function is null.');
527: END IF;
528: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
529: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_FD_PPP_GRP_PMT_T_PF'));
530: FND_MSG_PUB.Add;
531: l_message := fnd_message.get;
532:
533: l_ext_payee_id_rec.Ext_Payee_ID := -1;
534: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 547: FND_MSG_PUB.Add;

543: print_debuginfo(l_module_name,'Payer Org Id is null.');
544: END IF;
545: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
546: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYER_ORG_ID_FIELD'));
547: FND_MSG_PUB.Add;
548: l_message := fnd_message.get;
549:
550: l_ext_payee_id_rec.Ext_Payee_ID := -1;
551: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 562: FND_MSG_PUB.Add;

558: print_debuginfo(l_module_name,'Payer Org Id is null.');
559: END IF;
560: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
561: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYER_ORG_TYPE_FIELD'));
562: FND_MSG_PUB.Add;
563: l_message := fnd_message.get;
564:
565: l_ext_payee_id_rec.Ext_Payee_ID := -1;
566: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 577: FND_MSG_PUB.Add;

573: print_debuginfo(l_module_name,'Payer Org Id is null but Org_type is not null.');
574: END IF;
575: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
576: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYER_ORG_ID_FIELD'));
577: FND_MSG_PUB.Add;
578: l_message := fnd_message.get;
579:
580: l_ext_payee_id_rec.Ext_Payee_ID := -1;
581: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 595: FND_MSG_PUB.Add;

591: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
592: print_debuginfo(l_module_name,'Org Id or Org Type is not null but Party_site_id and supplier_site_id are null.');
593: END IF;
594: FND_MESSAGE.set_name('IBY', 'INVALID_ORG_IN_PAYEE_CONTEXT');
595: FND_MSG_PUB.Add;
596: l_message := fnd_message.get;
597:
598: l_ext_payee_id_rec.Ext_Payee_ID := -1;
599: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 613: FND_MSG_PUB.Add;

609: print_debuginfo(l_module_name,'Exclusive payment flag is null.');
610: END IF;
611: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
612: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_EXCL_PMT_FLAG_FIELD'));
613: FND_MSG_PUB.Add;
614: l_message := fnd_message.get;
615:
616: l_ext_payee_id_rec.Ext_Payee_ID := -1;
617: l_ext_payee_crt_rec.Payee_Creation_Status := 'E';

Line 758: FND_MSG_PUB.Count_And_Get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);

754:
755: /* Bug Number: 8752267
756: */
757: -- Standard call to get message count and if count is 1, get message info.
758: FND_MSG_PUB.Count_And_Get(p_encoded => fnd_api.g_false, p_count => x_msg_count, p_data => x_msg_data);
759:
760:
761: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
762: print_debuginfo(l_module_name, 'RETURN');

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

765: EXCEPTION
766: WHEN FND_API.G_EXC_ERROR THEN
767: x_return_status := FND_API.G_RET_STS_ERROR;
768:
769: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
770: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
771: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
772: print_debuginfo(l_module_name,'SQLerr is :'
773: || substr(SQLERRM, 1, 150));

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

774: END IF;
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
777:
778: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
779: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
780: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
781: print_debuginfo(l_module_name,'SQLerr is :'
782: || substr(SQLERRM, 1, 150));

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

783: END IF;
784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:
787: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
788: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
789: END IF;
790: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
791: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

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

784: WHEN OTHERS THEN
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786:
787: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
788: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
789: END IF;
790: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
791: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
792: print_debuginfo(l_module_name,'SQLerr is :'

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

791: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
792: print_debuginfo(l_module_name,'SQLerr is :'
793: || substr(SQLERRM, 1, 150));
794: END IF;
795: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
796:
797: END Create_External_Payee;
798:
799: -- Start of comments

Line 894: FND_MSG_PUB.Add;

890: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
891: debug_level => FND_LOG.LEVEL_ERROR,
892: module => G_DEBUG_MODULE || l_module);
893: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
894: FND_MSG_PUB.Add;
895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 899: FND_MSG_PUB.initialize;

895: RAISE FND_API.G_EXC_ERROR;
896: END IF;
897:
898: IF FND_API.to_Boolean( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
902:
903: -- Bug# 8470581

Line 901: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

897:
898: IF FND_API.to_Boolean( p_init_msg_list ) THEN
899: FND_MSG_PUB.initialize;
900: END IF;
901: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
902:
903: -- Bug# 8470581
904: -- Do not allow an assignment if the payee party_id is not a joint
905: -- account owner

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

1133: iby_debug_pub.add(debug_msg => 'In G_EXC_ERROR Exception',
1134: debug_level => FND_LOG.LEVEL_ERROR,
1135: module => G_DEBUG_MODULE || l_module);
1136: x_return_status := FND_API.G_RET_STS_ERROR ;
1137: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1138: p_data => x_msg_data
1139: );
1140: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1141: ROLLBACK TO Set_Payee_Instr_Assignment;

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

1142: iby_debug_pub.add(debug_msg => 'In G_EXC_UNEXPECTED_ERROR Exception',
1143: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1144: module => G_DEBUG_MODULE || l_module);
1145: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1146: FND_MSG_PUB.Count_And_Get ( p_count => x_msg_count,
1147: p_data => x_msg_data
1148: );
1149: WHEN OTHERS THEN
1150: ROLLBACK TO Set_Payee_Instr_Assignment;

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

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

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

1152: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1153: module => G_DEBUG_MODULE || l_module);
1154: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1157: END IF;
1158:
1159: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1160: p_data => x_msg_data

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

1155: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1156: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1157: END IF;
1158:
1159: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1160: p_data => x_msg_data
1161: );
1162: END Set_Payee_Instr_Assignment;
1163:

Line 1232: FND_MSG_PUB.Add;

1228: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1229: debug_level => FND_LOG.LEVEL_ERROR,
1230: module => G_DEBUG_MODULE || l_module);
1231: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1232: FND_MSG_PUB.Add;
1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1237: FND_MSG_PUB.initialize;

1233: RAISE FND_API.G_EXC_ERROR;
1234: END IF;
1235:
1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1237: FND_MSG_PUB.initialize;
1238: END IF;
1239: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1240:
1241: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);

Line 1239: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1235:
1236: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1237: FND_MSG_PUB.initialize;
1238: END IF;
1239: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1240:
1241: Get_Payee_Id(p_payee,FND_API.G_VALID_LEVEL_FULL,l_payee_level,l_payee_id);
1242:
1243: IF (l_payee_level = IBY_FNDCPT_COMMON_PUB.G_RC_INVALID_PAYER) THEN

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

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

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

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

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

1291: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1292: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1293: module => G_DEBUG_MODULE || l_module);
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1297: END IF;
1298:
1299: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

1292: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1293: module => G_DEBUG_MODULE || l_module);
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1297: END IF;
1298:
1299: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1300: p_data => x_msg_data

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

1295: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1297: END IF;
1298:
1299: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302: END Get_Payee_Instr_Assignments;
1303:

Line 1365: FND_MSG_PUB.Add;

1361: iby_debug_pub.add(debug_msg => 'Incorrect API Version:=' || p_api_version,
1362: debug_level => FND_LOG.LEVEL_ERROR,
1363: module => G_DEBUG_MODULE || l_module);
1364: FND_MESSAGE.SET_NAME('IBY', 'IBY_204400_API_VER_MISMATCH');
1365: FND_MSG_PUB.Add;
1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 1370: FND_MSG_PUB.initialize;

1366: RAISE FND_API.G_EXC_ERROR;
1367: END IF;
1368:
1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1370: FND_MSG_PUB.initialize;
1371: END IF;
1372: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1373:
1374: l_instr_count := 0;

Line 1372: l_prev_msg_count := FND_MSG_PUB.Count_Msg;

1368:
1369: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1370: FND_MSG_PUB.initialize;
1371: END IF;
1372: l_prev_msg_count := FND_MSG_PUB.Count_Msg;
1373:
1374: l_instr_count := 0;
1375: FOR assign_rec IN c_instr_assignments(p_party_id) LOOP
1376: l_instr_count := l_instr_count + 1;

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

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

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

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

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

1409: iby_debug_pub.add(debug_msg => 'In OTHERS Exception',
1410: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1411: module => G_DEBUG_MODULE || l_module);
1412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1414: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1415: END IF;
1416:
1417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,

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

1410: debug_level => FND_LOG.LEVEL_UNEXPECTED,
1411: module => G_DEBUG_MODULE || l_module);
1412: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1414: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1415: END IF;
1416:
1417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1418: p_data => x_msg_data

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

1413: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1414: FND_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, l_module);
1415: END IF;
1416:
1417: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,
1418: p_data => x_msg_data
1419: );
1420:
1421: iby_debug_pub.add(debug_msg => 'x_return_status=' || x_return_status,

Line 1456: FND_MSG_PUB.Add;

1452: IF (l_count = 0) THEN
1453: FND_MESSAGE.set_name('IBY', 'IBY_LOOKUP_VAL_ERROR');
1454: FND_MESSAGE.SET_TOKEN('LOOKUPTYPE', p_loopkup_type);
1455: FND_MESSAGE.SET_TOKEN('VALUE', p_value);
1456: FND_MSG_PUB.Add;
1457: RETURN FALSE;
1458: ELSE
1459: RETURN TRUE;
1460: END IF;

Line 1554: FND_MSG_PUB.initialize;

1550: END IF;
1551:
1552: -- Initialize message list if p_init_msg_list is set to TRUE.
1553: IF FND_API.to_Boolean(p_init_msg_list) THEN
1554: FND_MSG_PUB.initialize;
1555: END IF;
1556:
1557: -- Initialize API return status to success
1558: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1618: FND_MSG_PUB.Add;

1614: END IF;
1615: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1616: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_METHODS_V');
1617: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Default_Pmt_method);
1618: FND_MSG_PUB.Add;
1619: l_valid := FALSE;
1620: END IF;
1621: END IF;
1622:

Line 1656: FND_MSG_PUB.Add;

1652: END IF;
1653: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1654: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_PAYMENT_REASONS_VL');
1655: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pay_Reason_Code);
1656: FND_MSG_PUB.Add;
1657: l_valid := FALSE;
1658: END IF;
1659: END IF;
1660:

Line 1680: FND_MSG_PUB.Add;

1676: END IF;
1677: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1678: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_DELIVERY_CHANNELS_VL');
1679: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Delivery_Channel);
1680: FND_MSG_PUB.Add;
1681: l_valid := FALSE;
1682: END IF;
1683: END IF;
1684:

Line 1704: FND_MSG_PUB.Add;

1700: END IF;
1701: FND_MESSAGE.set_name('IBY', 'IBY_TABLE_VAL_ERROR');
1702: FND_MESSAGE.SET_TOKEN('TABLE', 'IBY_FORMATS_VL');
1703: FND_MESSAGE.SET_TOKEN('VALUE', p_ext_payee_rec.Pmt_Format);
1704: FND_MSG_PUB.Add;
1705: l_valid := FALSE;
1706: END IF;
1707: END IF;
1708:

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

1728:
1729: -- End of API body
1730:
1731: -- get message count and if count is 1, get message info.
1732: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1733: p_count => x_msg_count,
1734: p_data => x_msg_data);
1735:
1736: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

1739: EXCEPTION
1740: WHEN fnd_api.g_exc_error THEN
1741: ROLLBACK TO Validate_External_Payee_pub;
1742: x_return_status := fnd_api.g_ret_sts_error;
1743: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1744: p_count => x_msg_count,
1745: p_data => x_msg_data);
1746:
1747:

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

1747:
1748: WHEN fnd_api.g_exc_unexpected_error THEN
1749: ROLLBACK TO Validate_External_Payee_pub;
1750: x_return_status := fnd_api.g_ret_sts_unexp_error;
1751: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1752: p_count => x_msg_count,
1753: p_data => x_msg_data);
1754:
1755:

Line 1761: fnd_msg_pub.add;

1757: ROLLBACK TO Validate_External_Payee_pub;
1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1760: fnd_message.set_token('ERROR',SQLERRM);
1761: fnd_msg_pub.add;
1762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1763: p_count => x_msg_count,
1764: p_data => x_msg_data);
1765:

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

1758: x_return_status := fnd_api.g_ret_sts_unexp_error;
1759: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1760: fnd_message.set_token('ERROR',SQLERRM);
1761: fnd_msg_pub.add;
1762: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1763: p_count => x_msg_count,
1764: p_data => x_msg_data);
1765:
1766:

Line 1886: FND_MSG_PUB.initialize;

1882: END IF;
1883:
1884: -- Initialize message list if p_init_msg_list is set to TRUE.
1885: IF FND_API.to_Boolean(p_init_msg_list) THEN
1886: FND_MSG_PUB.initialize;
1887: END IF;
1888:
1889: -- Initialize API return status to success
1890: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1951: END IF;
1952: -- End of API body
1953:
1954: -- get message count and if count is 1, get message info.
1955: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1956: p_count => x_msg_count,
1957: p_data => x_msg_data);
1958:
1959:

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

1960: EXCEPTION
1961: WHEN fnd_api.g_exc_error THEN
1962: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1963: x_return_status := fnd_api.g_ret_sts_error;
1964: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1965: p_count => x_msg_count,
1966: p_data => x_msg_data);
1967:
1968:

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

1968:
1969: WHEN fnd_api.g_exc_unexpected_error THEN
1970: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1971: x_return_status := fnd_api.g_ret_sts_unexp_error;
1972: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1973: p_count => x_msg_count,
1974: p_data => x_msg_data);
1975:
1976:

Line 1982: fnd_msg_pub.add;

1978: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
1979: x_return_status := fnd_api.g_ret_sts_unexp_error;
1980: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1981: fnd_message.set_token('ERROR',SQLERRM);
1982: fnd_msg_pub.add;
1983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986:

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

1979: x_return_status := fnd_api.g_ret_sts_unexp_error;
1980: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
1981: fnd_message.set_token('ERROR',SQLERRM);
1982: fnd_msg_pub.add;
1983: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
1984: p_count => x_msg_count,
1985: p_data => x_msg_data);
1986:
1987: END Create_Temp_Ext_Bank_Acct;

Line 2130: FND_MSG_PUB.initialize;

2126: END IF;
2127:
2128: -- Initialize message list if p_init_msg_list is set to TRUE.
2129: IF FND_API.to_Boolean(p_init_msg_list) THEN
2130: FND_MSG_PUB.initialize;
2131: END IF;
2132:
2133: -- Initialize API return status to success
2134: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2248: FND_MSG_PUB.ADD;

2244: END IF;
2245: ELSE
2246: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2247: FND_MESSAGE.SET_NAME('SQLAP','AP_INVALID_BANK_ACCT_INFO');
2248: FND_MSG_PUB.ADD;
2249: print_debuginfo(l_module_name, 'Bank Account Validation Failed');
2250: END IF;
2251:
2252: /* If Bank account is already existing in the application*/

Line 2327: FND_MSG_PUB.ADD;

2323:
2324: /*ELSE
2325: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2326: FND_MESSAGE.SET_NAME('IBY','IBY_IMP_SUP_NOT_OWN');
2327: FND_MSG_PUB.ADD;
2328: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
2329: print_debuginfo(l_module_name, 'Party is not owner of the account');
2330: END IF;
2331:

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

2369: -- End of API body
2370: END IF;
2371:
2372: -- get message count and if count is 1, get message info.
2373: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2374: p_count => x_msg_count,
2375: p_data => x_msg_data);
2376:
2377: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN

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

2380: EXCEPTION
2381: WHEN fnd_api.g_exc_error THEN
2382: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2383: x_return_status := fnd_api.g_ret_sts_error;
2384: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2385: p_count => x_msg_count,
2386: p_data => x_msg_data);
2387:
2388:

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

2388:
2389: WHEN fnd_api.g_exc_unexpected_error THEN
2390: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2391: x_return_status := fnd_api.g_ret_sts_unexp_error;
2392: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2393: p_count => x_msg_count,
2394: p_data => x_msg_data);
2395:
2396:

Line 2402: fnd_msg_pub.add;

2398: ROLLBACK TO Create_Temp_Ext_Bank_Acct_pub;
2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR',SQLERRM);
2402: fnd_msg_pub.add;
2403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2404: p_count => x_msg_count,
2405: p_data => x_msg_data);
2406:

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

2399: x_return_status := fnd_api.g_ret_sts_unexp_error;
2400: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2401: fnd_message.set_token('ERROR',SQLERRM);
2402: fnd_msg_pub.add;
2403: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2404: p_count => x_msg_count,
2405: p_data => x_msg_data);
2406:
2407: END Create_Temp_Ext_Bank_Acct;

Line 2561: FND_MSG_PUB.initialize;

2557: END IF;
2558:
2559: -- Initialize message list if p_init_msg_list is set to TRUE.
2560: IF FND_API.to_Boolean(p_init_msg_list) THEN
2561: FND_MSG_PUB.initialize;
2562: END IF;
2563:
2564: -- Initialize API return status to success
2565: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2649: x_msg_data => x_msg_data,
2650: x_response => l_response
2651: );
2652:
2653: IF (fnd_msg_pub.count_msg > 0) THEN
2654: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2655: END IF;
2656:
2657: -- End of API body

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

2656:
2657: -- End of API body
2658:
2659: -- get message count and if count is 1, get message info.
2660: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2661: p_count => x_msg_count,
2662: p_data => x_msg_data);
2663:
2664:

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

2665: EXCEPTION
2666: WHEN fnd_api.g_exc_error THEN
2667: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2668: x_return_status := fnd_api.g_ret_sts_error;
2669: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2670: p_count => x_msg_count,
2671: p_data => x_msg_data);
2672:
2673:

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

2673:
2674: WHEN fnd_api.g_exc_unexpected_error THEN
2675: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2676: x_return_status := fnd_api.g_ret_sts_unexp_error;
2677: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2678: p_count => x_msg_count,
2679: p_data => x_msg_data);
2680:
2681:

Line 2687: fnd_msg_pub.add;

2683: ROLLBACK TO Val_Temp_Ext_Bank_Acct_pub;
2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR',SQLERRM);
2687: fnd_msg_pub.add;
2688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2689: p_count => x_msg_count,
2690: p_data => x_msg_data);
2691:

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

2684: x_return_status := fnd_api.g_ret_sts_unexp_error;
2685: fnd_message.set_name('IBY', 'IBY_API_OTHERS_EXCEP');
2686: fnd_message.set_token('ERROR',SQLERRM);
2687: fnd_msg_pub.add;
2688: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
2689: p_count => x_msg_count,
2690: p_data => x_msg_data);
2691:
2692: END Validate_Temp_Ext_Bank_Acct;

Line 2773: FND_MSG_PUB.initialize;

2769: END IF;
2770:
2771: -- Initialize message list if p_init_msg_list is set to TRUE.
2772: IF FND_API.to_Boolean(p_init_msg_list) THEN
2773: FND_MSG_PUB.initialize;
2774: END IF;
2775:
2776: -- Initialize API return status to success
2777: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2794: FND_MSG_PUB.Add;

2790: END IF;
2791: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2792: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_EXT_PAYEE_ID'));
2793: l_message := fnd_message.get;
2794: FND_MSG_PUB.Add;
2795:
2796: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2797: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2798:

Line 2808: FND_MSG_PUB.Add;

2804: END IF;
2805: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2806: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYEE_PARTY_ID_FIELD'));
2807: l_message := fnd_message.get;
2808: FND_MSG_PUB.Add;
2809:
2810: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2811: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2812:

Line 2822: FND_MSG_PUB.Add;

2818: END IF;
2819: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2820: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_FD_PPP_GRP_PMT_T_PF'));
2821: l_message := fnd_message.get;
2822: FND_MSG_PUB.Add;
2823:
2824: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2825: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2826:

Line 2838: FND_MSG_PUB.Add;

2834: END IF;
2835: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2836: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYER_ORG_ID_FIELD'));
2837: l_message := fnd_message.get;
2838: FND_MSG_PUB.Add;
2839:
2840: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2841: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2842:

Line 2851: FND_MSG_PUB.Add;

2847: END IF;
2848: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2849: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_PAYER_ORG_TYPE_FIELD'));
2850: l_message := fnd_message.get;
2851: FND_MSG_PUB.Add;
2852:
2853: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2854: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2855:

Line 2863: FND_MSG_PUB.Add;

2859: END IF;
2860: FND_MESSAGE.set_name('IBY', 'IBY_MISSING_MANDATORY_PARAM');
2861: FND_MESSAGE.SET_TOKEN('PARAM', fnd_message.GET_String('IBY','IBY_EXCL_PMT_FLAG_FIELD'));
2862: l_message := fnd_message.get;
2863: FND_MSG_PUB.Add;
2864:
2865: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2866: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2867:

Line 2894: FND_MSG_PUB.Add;

2890: END IF;
2891: FND_MESSAGE.set_name('IBY', 'IBY_EXT_PAYEE_NOT_EXIST');
2892: FND_MESSAGE.SET_TOKEN('EXT_PAYEE_ID', p_ext_payee_id_tab(counter).ext_payee_id);
2893: l_message := fnd_message.get;
2894: FND_MSG_PUB.Add;
2895:
2896: l_ext_payee_upd_rec.Payee_Update_Status := 'E';
2897: l_ext_payee_upd_rec.Payee_Update_Msg := l_message;
2898:

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

3030: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3031: print_debuginfo(l_module_name, 'End of external payee loop.');
3032: END IF;
3033: -- Standard call to get message count and if count is 1, get message info.
3034: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3035: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3036: print_debuginfo(l_module_name, 'RETURN');
3037:
3038: END IF;

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

3039: EXCEPTION
3040: WHEN FND_API.G_EXC_ERROR THEN
3041: x_return_status := FND_API.G_RET_STS_ERROR;
3042:
3043: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3044: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3045: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
3046: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3047:

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

3048: END IF;
3049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3051:
3052: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3053: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3054: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
3055: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3056:

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

3057: END IF;
3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060:
3061: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3063: END IF;
3064: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3065: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');

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

3058: WHEN OTHERS THEN
3059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3060:
3061: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)) THEN
3062: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
3063: END IF;
3064: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3065: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
3066: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));

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

3064: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
3065: print_debuginfo(l_module_name,'ERROR: Exception occured during call to API ');
3066: print_debuginfo(l_module_name,'SQLerr is :'|| substr(SQLERRM, 1, 150));
3067: END IF;
3068: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
3069:
3070: END Update_External_Payee;
3071:
3072: