DBA Data[Home] [Help]

APPS.EGO_FUNCTIONS_BULKLOAD_PVT dependencies on FND_MESSAGE

Line 724: FND_MESSAGE.SET_NAME('EGO',message_name );

720: BEGIN
721: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
722:
723: message_name := 'EGO_TRANS_TYPE';
724: FND_MESSAGE.SET_NAME('EGO',message_name );
725: message_text := FND_MESSAGE.GET;
726:
727: /* Error out the rows with Transaction Type null and other than CREATE, UPDATE, DELETE, SYNC */
728: INSERT INTO mtl_interface_errors

Line 725: message_text := FND_MESSAGE.GET;

721: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
722:
723: message_name := 'EGO_TRANS_TYPE';
724: FND_MESSAGE.SET_NAME('EGO',message_name );
725: message_text := FND_MESSAGE.GET;
726:
727: /* Error out the rows with Transaction Type null and other than CREATE, UPDATE, DELETE, SYNC */
728: INSERT INTO mtl_interface_errors
729: (unique_id,

Line 778: FND_MESSAGE.SET_NAME('EGO',message_name );

774: AND process_status = G_PROCESS_RECORD;
775:
776: /* For UPDATE and DELETE transactions, validate function_id if it is not null. */
777: message_name := 'EGO_EF_FUNC_ID_ERR';
778: FND_MESSAGE.SET_NAME('EGO',message_name );
779: message_text := FND_MESSAGE.GET;
780:
781: INSERT INTO mtl_interface_errors
782: (unique_id,

Line 779: message_text := FND_MESSAGE.GET;

775:
776: /* For UPDATE and DELETE transactions, validate function_id if it is not null. */
777: message_name := 'EGO_EF_FUNC_ID_ERR';
778: FND_MESSAGE.SET_NAME('EGO',message_name );
779: message_text := FND_MESSAGE.GET;
780:
781: INSERT INTO mtl_interface_errors
782: (unique_id,
783: transaction_id,

Line 838: FND_MESSAGE.SET_NAME('EGO',message_name );

834:
835: /* For UPDATE and DELETE transactions, validate internal_name if it is not null and
836: function_id is not provided. */
837: message_name := 'EGO_EF_FUNC_INT_NAME_INVL';
838: FND_MESSAGE.SET_NAME('EGO',message_name );
839: message_text := FND_MESSAGE.GET;
840:
841: INSERT INTO mtl_interface_errors
842: (unique_id,

Line 839: message_text := FND_MESSAGE.GET;

835: /* For UPDATE and DELETE transactions, validate internal_name if it is not null and
836: function_id is not provided. */
837: message_name := 'EGO_EF_FUNC_INT_NAME_INVL';
838: FND_MESSAGE.SET_NAME('EGO',message_name );
839: message_text := FND_MESSAGE.GET;
840:
841: INSERT INTO mtl_interface_errors
842: (unique_id,
843: transaction_id,

Line 913: FND_MESSAGE.SET_NAME('EGO',message_name );

909: AND process_status = G_PROCESS_RECORD;
910:
911: /* For UPDATE and DELETE transactions, error out rows that do not have both function_id and internal_name. */
912: message_name := 'EGO_EF_FUNC_ID_INT_NAME_ERR';
913: FND_MESSAGE.SET_NAME('EGO',message_name );
914: message_text := FND_MESSAGE.GET;
915:
916: INSERT INTO mtl_interface_errors
917: (unique_id,

Line 914: message_text := FND_MESSAGE.GET;

910:
911: /* For UPDATE and DELETE transactions, error out rows that do not have both function_id and internal_name. */
912: message_name := 'EGO_EF_FUNC_ID_INT_NAME_ERR';
913: FND_MESSAGE.SET_NAME('EGO',message_name );
914: message_text := FND_MESSAGE.GET;
915:
916: INSERT INTO mtl_interface_errors
917: (unique_id,
918: transaction_id,

Line 1760: FND_MESSAGE.SET_NAME('EGO',message_name );

1756: BEGIN
1757: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1758: /* Error out the rows with Transaction Type null and other than CREATE, UPDATE, DELETE, SYNC */
1759: message_name := 'EGO_TRANS_TYPE';
1760: FND_MESSAGE.SET_NAME('EGO',message_name );
1761: message_text := FND_MESSAGE.GET;
1762:
1763: INSERT INTO mtl_interface_errors
1764: (unique_id,

Line 1761: message_text := FND_MESSAGE.GET;

1757: write_debug(G_PCK_NAME||'.'||l_proc_name||'->'||' Entered into the procedure');
1758: /* Error out the rows with Transaction Type null and other than CREATE, UPDATE, DELETE, SYNC */
1759: message_name := 'EGO_TRANS_TYPE';
1760: FND_MESSAGE.SET_NAME('EGO',message_name );
1761: message_text := FND_MESSAGE.GET;
1762:
1763: INSERT INTO mtl_interface_errors
1764: (unique_id,
1765: transaction_id,

Line 1813: FND_MESSAGE.SET_NAME('EGO',message_name );

1809: AND process_status = G_PROCESS_RECORD;
1810:
1811: /* Validate function_id, if it is not null. */
1812: message_name := 'EGO_EF_FUNC_ID_ERR';
1813: FND_MESSAGE.SET_NAME('EGO',message_name );
1814: message_text := FND_MESSAGE.GET;
1815:
1816: INSERT INTO mtl_interface_errors
1817: (unique_id,

Line 1814: message_text := FND_MESSAGE.GET;

1810:
1811: /* Validate function_id, if it is not null. */
1812: message_name := 'EGO_EF_FUNC_ID_ERR';
1813: FND_MESSAGE.SET_NAME('EGO',message_name );
1814: message_text := FND_MESSAGE.GET;
1815:
1816: INSERT INTO mtl_interface_errors
1817: (unique_id,
1818: transaction_id,

Line 1872: FND_MESSAGE.SET_NAME('EGO',message_name );

1868: /* Validate validate internal_name if it is not null and function_id is not provided.
1869: We do not need to look into ego_functions_interface table for Internal Name, as we call
1870: this function only after processing ego_functions_interface table */
1871: message_name := 'EGO_INVALID_FUNC_INT_NAME';
1872: FND_MESSAGE.SET_NAME('EGO',message_name );
1873: message_text := FND_MESSAGE.GET;
1874:
1875: INSERT INTO mtl_interface_errors
1876: (unique_id,

Line 1873: message_text := FND_MESSAGE.GET;

1869: We do not need to look into ego_functions_interface table for Internal Name, as we call
1870: this function only after processing ego_functions_interface table */
1871: message_name := 'EGO_INVALID_FUNC_INT_NAME';
1872: FND_MESSAGE.SET_NAME('EGO',message_name );
1873: message_text := FND_MESSAGE.GET;
1874:
1875: INSERT INTO mtl_interface_errors
1876: (unique_id,
1877: transaction_id,

Line 1933: FND_MESSAGE.SET_NAME('EGO',message_name );

1929: AND process_status = G_PROCESS_RECORD;
1930:
1931: /* Error out rows that do not have both function_id and internal_name. */
1932: message_name := 'EGO_EF_FUNC_ID_INT_NAME_ERR';
1933: FND_MESSAGE.SET_NAME('EGO',message_name );
1934: message_text := FND_MESSAGE.GET;
1935:
1936: INSERT INTO mtl_interface_errors
1937: (unique_id,

Line 1934: message_text := FND_MESSAGE.GET;

1930:
1931: /* Error out rows that do not have both function_id and internal_name. */
1932: message_name := 'EGO_EF_FUNC_ID_INT_NAME_ERR';
1933: FND_MESSAGE.SET_NAME('EGO',message_name );
1934: message_text := FND_MESSAGE.GET;
1935:
1936: INSERT INTO mtl_interface_errors
1937: (unique_id,
1938: transaction_id,

Line 1987: FND_MESSAGE.SET_NAME('EGO',message_name );

1983:
1984:
1985: /* For UPDATE and DELETE transactions, validate Parameter ID if it is not null. */
1986: message_name := 'EGO_EF_FP_ID_ERR';
1987: FND_MESSAGE.SET_NAME('EGO',message_name );
1988: message_text := FND_MESSAGE.GET;
1989:
1990: INSERT INTO mtl_interface_errors
1991: (unique_id,

Line 1988: message_text := FND_MESSAGE.GET;

1984:
1985: /* For UPDATE and DELETE transactions, validate Parameter ID if it is not null. */
1986: message_name := 'EGO_EF_FP_ID_ERR';
1987: FND_MESSAGE.SET_NAME('EGO',message_name );
1988: message_text := FND_MESSAGE.GET;
1989:
1990: INSERT INTO mtl_interface_errors
1991: (unique_id,
1992: transaction_id,

Line 2058: FND_MESSAGE.SET_NAME('EGO',message_name );

2054: /* For UPDATE and DELETE transactions, validate Parameter Name if it is not null
2055: and Parameter Id is null. */
2056:
2057: message_name := 'EGO_EF_FP_INT_NAME_INVL';
2058: FND_MESSAGE.SET_NAME('EGO',message_name );
2059: message_text := FND_MESSAGE.GET;
2060:
2061: /* Bug 9647937. Modified the condition to validate Parameter Internal Name if it is not null
2062: and Parameter Id is null. Also, added logic to validate Parameter Internal Name

Line 2059: message_text := FND_MESSAGE.GET;

2055: and Parameter Id is null. */
2056:
2057: message_name := 'EGO_EF_FP_INT_NAME_INVL';
2058: FND_MESSAGE.SET_NAME('EGO',message_name );
2059: message_text := FND_MESSAGE.GET;
2060:
2061: /* Bug 9647937. Modified the condition to validate Parameter Internal Name if it is not null
2062: and Parameter Id is null. Also, added logic to validate Parameter Internal Name
2063: against ego_func_params_interface_table also. */

Line 2160: FND_MESSAGE.SET_NAME('EGO',message_name );

2156: AND process_status = G_PROCESS_RECORD;
2157:
2158: /* For UPDATE and DELETE transactions, error out rows that do not have both func_param_id and internal_name. */
2159: message_name := 'EGO_EF_FP_ID_INT_NAME_ERR';
2160: FND_MESSAGE.SET_NAME('EGO',message_name );
2161: message_text := FND_MESSAGE.GET;
2162:
2163: INSERT INTO mtl_interface_errors
2164: (unique_id,

Line 2161: message_text := FND_MESSAGE.GET;

2157:
2158: /* For UPDATE and DELETE transactions, error out rows that do not have both func_param_id and internal_name. */
2159: message_name := 'EGO_EF_FP_ID_INT_NAME_ERR';
2160: FND_MESSAGE.SET_NAME('EGO',message_name );
2161: message_text := FND_MESSAGE.GET;
2162:
2163: INSERT INTO mtl_interface_errors
2164: (unique_id,
2165: transaction_id,