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.EGO_ITEM_AML_PVT dependencies on FND_MESSAGE

Line 541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

537: WHEN OTHERS THEN
538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := 1;
540: -- for SQL errors
541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');
544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
545: x_msg_data := FND_MESSAGE.get();

Line 542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

538: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
539: x_msg_count := 1;
540: -- for SQL errors
541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');
544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
545: x_msg_data := FND_MESSAGE.get();
546: END ValueToIdConversion;

Line 543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');

539: x_msg_count := 1;
540: -- for SQL errors
541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');
544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
545: x_msg_data := FND_MESSAGE.get();
546: END ValueToIdConversion;
547:

Line 544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

540: -- for SQL errors
541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');
544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
545: x_msg_data := FND_MESSAGE.get();
546: END ValueToIdConversion;
547:
548:

Line 545: x_msg_data := FND_MESSAGE.get();

541: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
542: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
543: FND_MESSAGE.Set_Token('API_NAME', 'ValueToIdConversion');
544: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
545: x_msg_data := FND_MESSAGE.get();
546: END ValueToIdConversion;
547:
548:
549: PROCEDURE TransactionCheck (p_data_set_id IN NUMBER

Line 649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

645: WHEN OTHERS THEN
646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: x_msg_count := 1;
648: -- for SQL errors
649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');
652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
653: x_msg_data := FND_MESSAGE.get();

Line 650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

646: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
647: x_msg_count := 1;
648: -- for SQL errors
649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');
652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
653: x_msg_data := FND_MESSAGE.get();
654: END TransactionCheck;

Line 651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');

647: x_msg_count := 1;
648: -- for SQL errors
649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');
652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
653: x_msg_data := FND_MESSAGE.get();
654: END TransactionCheck;
655:

Line 652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

648: -- for SQL errors
649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');
652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
653: x_msg_data := FND_MESSAGE.get();
654: END TransactionCheck;
655:
656:

Line 653: x_msg_data := FND_MESSAGE.get();

649: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
650: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
651: FND_MESSAGE.Set_Token('API_NAME', 'TransactionCheck');
652: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
653: x_msg_data := FND_MESSAGE.get();
654: END TransactionCheck;
655:
656:
657: PROCEDURE performDupRecordCheck

Line 697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

693: WHEN OTHERS THEN
694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: x_msg_count := 1;
696: -- for SQL errors
697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');
700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
701: x_msg_data := FND_MESSAGE.get();

Line 698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

694: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
695: x_msg_count := 1;
696: -- for SQL errors
697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');
700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
701: x_msg_data := FND_MESSAGE.get();
702: END performDupRecordCheck;

Line 699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');

695: x_msg_count := 1;
696: -- for SQL errors
697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');
700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
701: x_msg_data := FND_MESSAGE.get();
702: END performDupRecordCheck;
703:

Line 700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

696: -- for SQL errors
697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');
700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
701: x_msg_data := FND_MESSAGE.get();
702: END performDupRecordCheck;
703:
704:

Line 701: x_msg_data := FND_MESSAGE.get();

697: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
698: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
699: FND_MESSAGE.Set_Token('API_NAME', 'performDupRecordCheck');
700: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
701: x_msg_data := FND_MESSAGE.get();
702: END performDupRecordCheck;
703:
704:
705: PROCEDURE performCMSeggregation (p_data_set_id IN NUMBER

Line 857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

853: END IF;
854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_msg_count := 1;
856: -- for SQL errors
857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');
860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
861: x_msg_data := FND_MESSAGE.get();

Line 858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

854: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
855: x_msg_count := 1;
856: -- for SQL errors
857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');
860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
861: x_msg_data := FND_MESSAGE.get();
862: END performCMSeggregation;

Line 859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');

855: x_msg_count := 1;
856: -- for SQL errors
857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');
860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
861: x_msg_data := FND_MESSAGE.get();
862: END performCMSeggregation;
863:

Line 860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

856: -- for SQL errors
857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');
860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
861: x_msg_data := FND_MESSAGE.get();
862: END performCMSeggregation;
863:
864:

Line 861: x_msg_data := FND_MESSAGE.get();

857: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
858: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
859: FND_MESSAGE.Set_Token('API_NAME', 'performCMSeggregation');
860: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
861: x_msg_data := FND_MESSAGE.get();
862: END performCMSeggregation;
863:
864:
865: PROCEDURE performItemValidation (p_data_set_id IN NUMBER

Line 920: -- message on the FND_MESSAGE stack which

916: -- 'L' Value too long- predicate too large for
917: -- database VPD.
918: --
919: -- If 'E', 'U, or 'L' is returned, there will be an error
920: -- message on the FND_MESSAGE stack which
921: -- can be retrieved with FND_MESSAGE.GET_ENCODED()
922: -- If that message is not used, it must be cleared.
923: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
924: ,p_module => l_api_name

Line 921: -- can be retrieved with FND_MESSAGE.GET_ENCODED()

917: -- database VPD.
918: --
919: -- If 'E', 'U, or 'L' is returned, there will be an error
920: -- message on the FND_MESSAGE stack which
921: -- can be retrieved with FND_MESSAGE.GET_ENCODED()
922: -- If that message is not used, it must be cleared.
923: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
924: ,p_module => l_api_name
925: ,p_message => 'Returning get Security Predicate with status - '

Line 961: x_msg_data := FND_MESSAGE.GET_ENCODED();

957: ELSE
958: IF x_return_status = 'L' THEN
959: x_return_status := FND_API.G_RET_STS_ERROR;
960: END IF;
961: x_msg_data := FND_MESSAGE.GET_ENCODED();
962: log_now (p_log_level => G_DEBUG_LEVEL_STATEMENT
963: ,p_module => l_api_name
964: ,p_message => 'Security Predicate has returned with message - '
965: ||x_msg_data

Line 1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1291: END IF;
1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: x_msg_count := 1;
1294: -- for SQL errors
1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');
1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1299: x_msg_data := FND_MESSAGE.get();

Line 1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1292: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1293: x_msg_count := 1;
1294: -- for SQL errors
1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');
1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1299: x_msg_data := FND_MESSAGE.get();
1300: END performItemValidation;

Line 1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');

1293: x_msg_count := 1;
1294: -- for SQL errors
1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');
1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1299: x_msg_data := FND_MESSAGE.get();
1300: END performItemValidation;
1301:

Line 1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1294: -- for SQL errors
1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');
1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1299: x_msg_data := FND_MESSAGE.get();
1300: END performItemValidation;
1301:
1302:

Line 1299: x_msg_data := FND_MESSAGE.get();

1295: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1296: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1297: FND_MESSAGE.Set_Token('API_NAME', 'performItemValidation');
1298: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1299: x_msg_data := FND_MESSAGE.get();
1300: END performItemValidation;
1301:
1302:
1303: PROCEDURE resetDFFFieldUsage

Line 1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

1804: END IF;
1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: x_msg_count := 1;
1807: -- for SQL errors
1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');
1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1812: x_msg_data := FND_MESSAGE.get();

Line 1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

1805: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1806: x_msg_count := 1;
1807: -- for SQL errors
1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');
1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1812: x_msg_data := FND_MESSAGE.get();
1813: END performDFFValidation;

Line 1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');

1806: x_msg_count := 1;
1807: -- for SQL errors
1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');
1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1812: x_msg_data := FND_MESSAGE.get();
1813: END performDFFValidation;
1814:

Line 1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

1807: -- for SQL errors
1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');
1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1812: x_msg_data := FND_MESSAGE.get();
1813: END performDFFValidation;
1814:
1815: PROCEDURE populateProductionTable (p_data_set_id IN NUMBER

Line 1812: x_msg_data := FND_MESSAGE.get();

1808: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
1809: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
1810: FND_MESSAGE.Set_Token('API_NAME', 'performDFFValidation');
1811: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
1812: x_msg_data := FND_MESSAGE.get();
1813: END performDFFValidation;
1814:
1815: PROCEDURE populateProductionTable (p_data_set_id IN NUMBER
1816: ,x_return_status OUT NOCOPY VARCHAR2

Line 2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2001: WHEN OTHERS THEN
2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: x_msg_count := 1;
2004: -- for SQL errors
2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');
2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2009: x_msg_data := FND_MESSAGE.get();

Line 2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2002: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2003: x_msg_count := 1;
2004: -- for SQL errors
2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');
2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2009: x_msg_data := FND_MESSAGE.get();
2010: END populateProductionTable;

Line 2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');

2003: x_msg_count := 1;
2004: -- for SQL errors
2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');
2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2009: x_msg_data := FND_MESSAGE.get();
2010: END populateProductionTable;
2011:

Line 2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2004: -- for SQL errors
2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');
2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2009: x_msg_data := FND_MESSAGE.get();
2010: END populateProductionTable;
2011:
2012:

Line 2009: x_msg_data := FND_MESSAGE.get();

2005: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2006: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2007: FND_MESSAGE.Set_Token('API_NAME', 'populateProductionTable');
2008: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2009: x_msg_data := FND_MESSAGE.get();
2010: END populateProductionTable;
2011:
2012:
2013: --

Line 2096: fnd_message.set_name('EGO', 'EGO_TRANSACTION_TYPE');

2092: IF error_rec.process_flag = G_PS_MAND_PARAM_MISSING THEN
2093: l_err_msg_name := 'EGO_INTF_MAND_PARAM_MISSING';
2094: ELSIF error_rec.process_flag = G_PS_INVALID_TRANS_TYPE THEN
2095: l_message_has_token := TRUE;
2096: fnd_message.set_name('EGO', 'EGO_TRANSACTION_TYPE');
2097: l_dummy_message := fnd_message.get();
2098: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2099: l_err_token_table(1).TOKEN_NAME := 'NAME';
2100: l_err_token_table(1).TOKEN_VALUE := l_err_msg_name;

Line 2097: l_dummy_message := fnd_message.get();

2093: l_err_msg_name := 'EGO_INTF_MAND_PARAM_MISSING';
2094: ELSIF error_rec.process_flag = G_PS_INVALID_TRANS_TYPE THEN
2095: l_message_has_token := TRUE;
2096: fnd_message.set_name('EGO', 'EGO_TRANSACTION_TYPE');
2097: l_dummy_message := fnd_message.get();
2098: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2099: l_err_token_table(1).TOKEN_NAME := 'NAME';
2100: l_err_token_table(1).TOKEN_VALUE := l_err_msg_name;
2101: l_err_token_table(2).TOKEN_NAME := 'VALUE';

Line 2107: fnd_message.set_name('EGO', 'EGO_FIRST_ARTICLE_STATUS');

2103: ELSIF error_rec.process_flag = G_PS_SD_GT_ED_ERROR THEN
2104: l_err_msg_name := 'EGO_STARTDATE_PRECEDES_ENDDATE';
2105: ELSIF error_rec.process_flag = G_PS_FA_STATUS_ERR THEN
2106: l_message_has_token := TRUE;
2107: fnd_message.set_name('EGO', 'EGO_FIRST_ARTICLE_STATUS');
2108: l_dummy_message := fnd_message.get();
2109: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2110: l_err_token_table(1).TOKEN_NAME := 'NAME';
2111: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;

Line 2108: l_dummy_message := fnd_message.get();

2104: l_err_msg_name := 'EGO_STARTDATE_PRECEDES_ENDDATE';
2105: ELSIF error_rec.process_flag = G_PS_FA_STATUS_ERR THEN
2106: l_message_has_token := TRUE;
2107: fnd_message.set_name('EGO', 'EGO_FIRST_ARTICLE_STATUS');
2108: l_dummy_message := fnd_message.get();
2109: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2110: l_err_token_table(1).TOKEN_NAME := 'NAME';
2111: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;
2112: l_err_token_table(2).TOKEN_NAME := 'VALUE';

Line 2121: fnd_message.set_name('EGO', 'EGO_APPROVAL_STATUS');

2117: := error_rec.first_article_status_meaning;
2118: END IF;
2119: ELSIF error_rec.process_flag = G_PS_APPROVAL_STATUS_ERR THEN
2120: l_message_has_token := TRUE;
2121: fnd_message.set_name('EGO', 'EGO_APPROVAL_STATUS');
2122: l_dummy_message := fnd_message.get();
2123: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2124: l_err_token_table(1).TOKEN_NAME := 'NAME';
2125: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;

Line 2122: l_dummy_message := fnd_message.get();

2118: END IF;
2119: ELSIF error_rec.process_flag = G_PS_APPROVAL_STATUS_ERR THEN
2120: l_message_has_token := TRUE;
2121: fnd_message.set_name('EGO', 'EGO_APPROVAL_STATUS');
2122: l_dummy_message := fnd_message.get();
2123: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2124: l_err_token_table(1).TOKEN_NAME := 'NAME';
2125: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;
2126: l_err_token_table(2).TOKEN_NAME := 'VALUE';

Line 2134: fnd_message.set_name('EGO', 'EGO_MFG');

2130: l_err_token_table(2).TOKEN_VALUE := error_rec.approval_status_meaning;
2131: END IF;
2132: ELSIF error_rec.process_flag = G_PS_MANUFACTURER_ERR THEN
2133: l_message_has_token := TRUE;
2134: fnd_message.set_name('EGO', 'EGO_MFG');
2135: l_dummy_message := fnd_message.get();
2136: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2137: l_err_token_table(1).TOKEN_NAME := 'NAME';
2138: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;

Line 2135: l_dummy_message := fnd_message.get();

2131: END IF;
2132: ELSIF error_rec.process_flag = G_PS_MANUFACTURER_ERR THEN
2133: l_message_has_token := TRUE;
2134: fnd_message.set_name('EGO', 'EGO_MFG');
2135: l_dummy_message := fnd_message.get();
2136: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2137: l_err_token_table(1).TOKEN_NAME := 'NAME';
2138: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;
2139: l_err_token_table(2).TOKEN_NAME := 'VALUE';

Line 2147: fnd_message.set_name('EGO', 'EGO_ORGANIZATION');

2143: l_err_token_table(2).TOKEN_VALUE := error_rec.manufacturer_name;
2144: END IF;
2145: ELSIF error_rec.process_flag = G_PS_ORGANIZATION_ERR THEN
2146: l_message_has_token := TRUE;
2147: fnd_message.set_name('EGO', 'EGO_ORGANIZATION');
2148: l_dummy_message := fnd_message.get();
2149: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2150: l_err_token_table(1).TOKEN_NAME := 'NAME';
2151: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;

Line 2148: l_dummy_message := fnd_message.get();

2144: END IF;
2145: ELSIF error_rec.process_flag = G_PS_ORGANIZATION_ERR THEN
2146: l_message_has_token := TRUE;
2147: fnd_message.set_name('EGO', 'EGO_ORGANIZATION');
2148: l_dummy_message := fnd_message.get();
2149: l_err_msg_name := 'EGO_IPI_INVALID_VALUE';
2150: l_err_token_table(1).TOKEN_NAME := 'NAME';
2151: l_err_token_table(1).TOKEN_VALUE := l_dummy_message;
2152: l_err_token_table(2).TOKEN_NAME := 'VALUE';

Line 2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2301: END IF;
2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: x_msg_count := 1;
2304: -- for SQL errors
2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');
2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2309: x_msg_data := FND_MESSAGE.get();

Line 2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2302: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2303: x_msg_count := 1;
2304: -- for SQL errors
2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');
2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2309: x_msg_data := FND_MESSAGE.get();
2310: RETURN FALSE;

Line 2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');

2303: x_msg_count := 1;
2304: -- for SQL errors
2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');
2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2309: x_msg_data := FND_MESSAGE.get();
2310: RETURN FALSE;
2311: END Log_Errors_Now;

Line 2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2304: -- for SQL errors
2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');
2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2309: x_msg_data := FND_MESSAGE.get();
2310: RETURN FALSE;
2311: END Log_Errors_Now;
2312:

Line 2309: x_msg_data := FND_MESSAGE.get();

2305: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2306: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2307: FND_MESSAGE.Set_Token('API_NAME', 'Log_Errors_Now');
2308: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2309: x_msg_data := FND_MESSAGE.get();
2310: RETURN FALSE;
2311: END Log_Errors_Now;
2312:
2313:

Line 2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');

2377: ,EGO_ITEM_PUB.G_INTF_DELETE_NONE
2378: )
2379: ) THEN
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');
2382: fnd_message.set_token('PROG_NAME',G_PKG_NAME||'.'||l_api_name);
2383: fnd_msg_pub.Add;
2384: fnd_msg_pub.Count_And_Get(p_encoded => FND_API.G_FALSE
2385: ,p_count => x_msg_count

Line 2382: fnd_message.set_token('PROG_NAME',G_PKG_NAME||'.'||l_api_name);

2378: )
2379: ) THEN
2380: x_return_status := FND_API.G_RET_STS_ERROR;
2381: fnd_message.set_name('EGO','EGO_IPI_INSUFFICIENT_PARAMS');
2382: fnd_message.set_token('PROG_NAME',G_PKG_NAME||'.'||l_api_name);
2383: fnd_msg_pub.Add;
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);

Line 2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2447: ROLLBACK TO DELETE_AML_INTF_LINES_SP;
2448: END IF;
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: x_msg_count := 1;
2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2455: x_msg_data := FND_MESSAGE.get();

Line 2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2448: END IF;
2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: x_msg_count := 1;
2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2455: x_msg_data := FND_MESSAGE.get();
2456: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2449: x_return_status := FND_API.G_RET_STS_ERROR;
2450: x_msg_count := 1;
2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2455: x_msg_data := FND_MESSAGE.get();
2456: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2457: ,p_module => l_api_name

Line 2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2450: x_msg_count := 1;
2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2455: x_msg_data := FND_MESSAGE.get();
2456: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2457: ,p_module => l_api_name
2458: ,p_message => x_msg_data

Line 2455: x_msg_data := FND_MESSAGE.get();

2451: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2452: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2453: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2454: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2455: x_msg_data := FND_MESSAGE.get();
2456: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2457: ,p_module => l_api_name
2458: ,p_message => x_msg_data
2459: );

Line 2542: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');

2538: ,p_module => l_api_name
2539: ,p_message => 'All globals initialized'
2540: );
2541: IF (p_data_set_id IS NULL) THEN
2542: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2543: l_msg_data := fnd_msg_pub.get();
2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2546: fnd_message.set_token('VALUE', l_msg_data);

Line 2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');

2540: );
2541: IF (p_data_set_id IS NULL) THEN
2542: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2543: l_msg_data := fnd_msg_pub.get();
2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2546: fnd_message.set_token('VALUE', l_msg_data);
2547: ERRBUF := fnd_message.get();
2548: RETCODE := G_CONC_RET_STS_ERROR;

Line 2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);

2541: IF (p_data_set_id IS NULL) THEN
2542: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2543: l_msg_data := fnd_msg_pub.get();
2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2546: fnd_message.set_token('VALUE', l_msg_data);
2547: ERRBUF := fnd_message.get();
2548: RETCODE := G_CONC_RET_STS_ERROR;
2549: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION

Line 2546: fnd_message.set_token('VALUE', l_msg_data);

2542: fnd_message.set_name('EGO', 'EGO_DATA_SET_ID');
2543: l_msg_data := fnd_msg_pub.get();
2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2546: fnd_message.set_token('VALUE', l_msg_data);
2547: ERRBUF := fnd_message.get();
2548: RETCODE := G_CONC_RET_STS_ERROR;
2549: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2550: ,p_module => l_api_name

Line 2547: ERRBUF := fnd_message.get();

2543: l_msg_data := fnd_msg_pub.get();
2544: fnd_message.set_name('EGO','EGO_PKG_MAND_VALUES_MISS1');
2545: fnd_message.set_token('PACKAGE', G_PKG_NAME ||'.'|| l_api_name);
2546: fnd_message.set_token('VALUE', l_msg_data);
2547: ERRBUF := fnd_message.get();
2548: RETCODE := G_CONC_RET_STS_ERROR;
2549: log_now (p_log_level => G_DEBUG_LEVEL_EXCEPTION
2550: ,p_module => l_api_name
2551: ,p_message => ERRBUF

Line 2568: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');

2564: AND PROCESS_FLAG = G_PS_TO_BE_PROCESSED
2565: AND ROWNUM = 1;
2566: EXCEPTION
2567: WHEN NO_DATA_FOUND THEN
2568: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2569: l_msg_data := fnd_message.get();
2570: log_now (p_log_level => G_DEBUG_LEVEL_PROCEDURE
2571: ,p_module => l_api_name
2572: ,p_message => l_msg_data

Line 2569: l_msg_data := fnd_message.get();

2565: AND ROWNUM = 1;
2566: EXCEPTION
2567: WHEN NO_DATA_FOUND THEN
2568: fnd_message.set_name('EGO','EGO_IPI_NO_LINES');
2569: l_msg_data := fnd_message.get();
2570: log_now (p_log_level => G_DEBUG_LEVEL_PROCEDURE
2571: ,p_module => l_api_name
2572: ,p_message => l_msg_data
2573: );

Line 2943: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');

2939: RETCODE := G_CONC_RET_STS_SUCCESS;
2940: WHEN OTHERS THEN
2941: ROLLBACK TO LOAD_INTERFACE_LINES_SP;
2942: RETCODE := G_CONC_RET_STS_ERROR;
2943: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2944: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2945: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2946: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2947: ERRBUF := FND_MSG_PUB.get();

Line 2944: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);

2940: WHEN OTHERS THEN
2941: ROLLBACK TO LOAD_INTERFACE_LINES_SP;
2942: RETCODE := G_CONC_RET_STS_ERROR;
2943: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2944: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2945: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2946: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2947: ERRBUF := FND_MSG_PUB.get();
2948: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED

Line 2945: FND_MESSAGE.Set_Token('API_NAME', l_api_name);

2941: ROLLBACK TO LOAD_INTERFACE_LINES_SP;
2942: RETCODE := G_CONC_RET_STS_ERROR;
2943: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2944: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2945: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2946: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2947: ERRBUF := FND_MSG_PUB.get();
2948: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2949: ,p_module => l_api_name

Line 2946: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);

2942: RETCODE := G_CONC_RET_STS_ERROR;
2943: FND_MESSAGE.Set_Name('EGO', 'EGO_PLSQL_ERR');
2944: FND_MESSAGE.Set_Token('PKG_NAME', G_PKG_NAME);
2945: FND_MESSAGE.Set_Token('API_NAME', l_api_name);
2946: FND_MESSAGE.Set_Token('SQL_ERR_MSG', SQLERRM);
2947: ERRBUF := FND_MSG_PUB.get();
2948: log_now (p_log_level => G_DEBUG_LEVEL_UNEXPECTED
2949: ,p_module => l_api_name
2950: ,p_message => ERRBUF