DBA Data[Home] [Help]

APPS.INV_ITEM_REVISION_PUB dependencies on ERROR_HANDLER

Line 137: Error_Handler.Add_Error_Message

133: BEGIN
134:
135: IF G_Message_API = 'BOM' THEN
136: IF p_message_text IS NULL THEN
137: Error_Handler.Add_Error_Message
138: ( p_message_name => p_message_name
139: , p_application_id => p_application_short_name
140: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL
141: , p_message_type => 'E'

Line 140: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL

136: IF p_message_text IS NULL THEN
137: Error_Handler.Add_Error_Message
138: ( p_message_name => p_message_name
139: , p_application_id => p_application_short_name
140: , p_token_tbl => Error_Handler.G_MISS_TOKEN_TBL
141: , p_message_type => 'E'
142: , p_row_identifier => NULL
143: , p_entity_id => NULL
144: , p_entity_index => NULL

Line 149: Error_Handler.Add_Error_Message

145: , p_table_name => NULL
146: , p_entity_code => 'INV_ITEM_REVISION'
147: );
148: ELSE
149: Error_Handler.Add_Error_Message
150: ( p_message_text => p_message_text
151: , p_message_type => 'E'
152: , p_row_identifier => NULL
153: , p_entity_id => NULL

Line 196: IF Error_Handler.Get_Debug = 'Y' THEN

192: IS
193:
194: BEGIN
195:
196: IF Error_Handler.Get_Debug = 'Y' THEN
197: Error_Handler.Write_Debug (p_debug_message);
198: END IF;
199:
200: END;

Line 197: Error_Handler.Write_Debug (p_debug_message);

193:
194: BEGIN
195:
196: IF Error_Handler.Get_Debug = 'Y' THEN
197: Error_Handler.Write_Debug (p_debug_message);
198: END IF;
199:
200: END;
201:

Line 1182: x_msg_count := Error_Handler.Get_Message_Count;

1178:
1179: -- Standard call to get message count and if count is 1, get message info.
1180:
1181: IF G_Message_API = 'BOM' THEN
1182: x_msg_count := Error_Handler.Get_Message_Count;
1183: ELSE
1184: FND_MSG_PUB.Count_And_Get
1185: ( p_count => x_msg_count
1186: , p_data => x_msg_data

Line 1203: x_msg_count := Error_Handler.Get_Message_Count;

1199: ROLLBACK TO Create_Item_Revision_PUB;
1200: x_return_status := FND_API.g_RET_STS_ERROR;
1201: /*Added for Bug 8679971 to ensure error message is displayed*/
1202: IF G_Message_API = 'BOM' THEN
1203: x_msg_count := Error_Handler.Get_Message_Count;
1204: Error_Handler.Get_Message
1205: (x_message_text => x_msg_data
1206: , x_entity_index => l_entity_index
1207: , x_entity_id => l_entity_id

Line 1204: Error_Handler.Get_Message

1200: x_return_status := FND_API.g_RET_STS_ERROR;
1201: /*Added for Bug 8679971 to ensure error message is displayed*/
1202: IF G_Message_API = 'BOM' THEN
1203: x_msg_count := Error_Handler.Get_Message_Count;
1204: Error_Handler.Get_Message
1205: (x_message_text => x_msg_data
1206: , x_entity_index => l_entity_index
1207: , x_entity_id => l_entity_id
1208: , x_message_type => l_message_type

Line 1228: x_msg_count := Error_Handler.Get_Message_Count;

1224: ROLLBACK TO Create_Item_Revision_PUB;
1225: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1226:
1227: IF G_Message_API = 'BOM' THEN
1228: x_msg_count := Error_Handler.Get_Message_Count;
1229: ELSE
1230: FND_MSG_PUB.Count_And_Get
1231: ( p_count => x_msg_count
1232: , p_data => x_msg_data

Line 1251: x_msg_count := Error_Handler.Get_Message_Count;

1247: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
1248: );
1249:
1250: IF G_Message_API = 'BOM' THEN
1251: x_msg_count := Error_Handler.Get_Message_Count;
1252: ELSE
1253: FND_MSG_PUB.Count_And_Get
1254: ( p_count => x_msg_count
1255: , p_data => x_msg_data

Line 1875: x_msg_count := Error_Handler.Get_Message_Count;

1871:
1872: -- Standard call to get message count and if count is 1, get message info.
1873:
1874: IF G_Message_API = 'BOM' THEN
1875: x_msg_count := Error_Handler.Get_Message_Count;
1876: ELSE
1877: FND_MSG_PUB.Count_And_Get
1878: ( p_count => x_msg_count
1879: , p_data => x_msg_data

Line 1895: x_msg_count := Error_Handler.Get_Message_Count;

1891: ROLLBACK TO Update_Item_Revision_PUB;
1892: x_return_status := FND_API.g_RET_STS_ERROR;
1893:
1894: IF G_Message_API = 'BOM' THEN
1895: x_msg_count := Error_Handler.Get_Message_Count;
1896: ELSE
1897: FND_MSG_PUB.Count_And_Get
1898: ( p_count => x_msg_count
1899: , p_data => x_msg_data

Line 1913: x_msg_count := Error_Handler.Get_Message_Count;

1909: ROLLBACK TO Update_Item_Revision_PUB;
1910: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
1911:
1912: IF G_Message_API = 'BOM' THEN
1913: x_msg_count := Error_Handler.Get_Message_Count;
1914: ELSE
1915: FND_MSG_PUB.Count_And_Get
1916: ( p_count => x_msg_count
1917: , p_data => x_msg_data

Line 1936: x_msg_count := Error_Handler.Get_Message_Count;

1932: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
1933: );
1934:
1935: IF G_Message_API = 'BOM' THEN
1936: x_msg_count := Error_Handler.Get_Message_Count;
1937: ELSE
1938: FND_MSG_PUB.Count_And_Get
1939: ( p_count => x_msg_count
1940: , p_data => x_msg_data

Line 2044: x_msg_count := Error_Handler.Get_Message_Count;

2040:
2041: -- Standard call to get message count and if count is 1, get message info.
2042:
2043: IF G_Message_API = 'BOM' THEN
2044: x_msg_count := Error_Handler.Get_Message_Count;
2045: ELSE
2046: FND_MSG_PUB.Count_And_Get
2047: ( p_count => x_msg_count
2048: , p_data => x_msg_data

Line 2064: x_msg_count := Error_Handler.Get_Message_Count;

2060: ROLLBACK TO Lock_Item_Revision_PUB;
2061: x_return_status := FND_API.g_RET_STS_ERROR;
2062:
2063: IF G_Message_API = 'BOM' THEN
2064: x_msg_count := Error_Handler.Get_Message_Count;
2065: ELSE
2066: FND_MSG_PUB.Count_And_Get
2067: ( p_count => x_msg_count
2068: , p_data => x_msg_data

Line 2082: x_msg_count := Error_Handler.Get_Message_Count;

2078: ROLLBACK TO Lock_Item_Revision_PUB;
2079: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2080:
2081: IF G_Message_API = 'BOM' THEN
2082: x_msg_count := Error_Handler.Get_Message_Count;
2083: ELSE
2084: FND_MSG_PUB.Count_And_Get
2085: ( p_count => x_msg_count
2086: , p_data => x_msg_data

Line 2105: x_msg_count := Error_Handler.Get_Message_Count;

2101: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2102: );
2103:
2104: IF G_Message_API = 'BOM' THEN
2105: x_msg_count := Error_Handler.Get_Message_Count;
2106: ELSE
2107: FND_MSG_PUB.Count_And_Get
2108: ( p_count => x_msg_count
2109: , p_data => x_msg_data

Line 2240: x_msg_count := Error_Handler.Get_Message_Count;

2236:
2237: -- Standard call to get message count and if count is 1, get message info.
2238:
2239: IF G_Message_API = 'BOM' THEN
2240: x_msg_count := Error_Handler.Get_Message_Count;
2241: ELSE
2242: FND_MSG_PUB.Count_And_Get
2243: ( p_count => x_msg_count
2244: , p_data => x_msg_data

Line 2260: x_msg_count := Error_Handler.Get_Message_Count;

2256: ROLLBACK TO Delete_Item_Revision_PUB;
2257: x_return_status := FND_API.g_RET_STS_ERROR;
2258:
2259: IF G_Message_API = 'BOM' THEN
2260: x_msg_count := Error_Handler.Get_Message_Count;
2261: ELSE
2262: FND_MSG_PUB.Count_And_Get
2263: ( p_count => x_msg_count
2264: , p_data => x_msg_data

Line 2278: x_msg_count := Error_Handler.Get_Message_Count;

2274: ROLLBACK TO Delete_Item_Revision_PUB;
2275: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2276:
2277: IF G_Message_API = 'BOM' THEN
2278: x_msg_count := Error_Handler.Get_Message_Count;
2279: ELSE
2280: FND_MSG_PUB.Count_And_Get
2281: ( p_count => x_msg_count
2282: , p_data => x_msg_data

Line 2301: x_msg_count := Error_Handler.Get_Message_Count;

2297: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2298: );
2299:
2300: IF G_Message_API = 'BOM' THEN
2301: x_msg_count := Error_Handler.Get_Message_Count;
2302: ELSE
2303: FND_MSG_PUB.Count_And_Get
2304: ( p_count => x_msg_count
2305: , p_data => x_msg_data

Line 2386: Error_Handler.Initialize;

2382:
2383: -- Initialize message list
2384: IF G_Message_API = 'BOM' THEN
2385: IF FND_API.To_Boolean (p_init_msg_list) THEN
2386: Error_Handler.Initialize;
2387: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');
2388: END IF;
2389: ELSE
2390: /* G_Message_API = 'FND' THEN */

Line 2387: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');

2383: -- Initialize message list
2384: IF G_Message_API = 'BOM' THEN
2385: IF FND_API.To_Boolean (p_init_msg_list) THEN
2386: Error_Handler.Initialize;
2387: Error_Handler.Set_BO_Identifier ('INV_ITEM_REVISION');
2388: END IF;
2389: ELSE
2390: /* G_Message_API = 'FND' THEN */
2391: IF FND_API.To_Boolean (p_init_msg_list) THEN

Line 2400: Error_Handler.Set_Debug (p_debug_flag => 'Y');

2396: -- Open the debug session
2397:
2398: IF p_debug = 'Y' THEN
2399:
2400: Error_Handler.Set_Debug (p_debug_flag => 'Y');
2401:
2402: Error_Handler.Open_Debug_Session
2403: ( p_debug_filename => p_debug_filename
2404: , p_output_dir => p_output_dir

Line 2402: Error_Handler.Open_Debug_Session

2398: IF p_debug = 'Y' THEN
2399:
2400: Error_Handler.Set_Debug (p_debug_flag => 'Y');
2401:
2402: Error_Handler.Open_Debug_Session
2403: ( p_debug_filename => p_debug_filename
2404: , p_output_dir => p_output_dir
2405: , x_return_status => l_debug_return_status
2406: , x_error_mesg => l_debug_error_message

Line 2416: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);

2412: END IF;
2413:
2414: END IF;
2415:
2416: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);
2417:
2418: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));
2419:
2420: -- Convert the transaction type if it is SYNC

Line 2418: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));

2414: END IF;
2415:
2416: Error_Handler.Write_Debug('Debug file mode is '||Error_Handler.Get_Debug);
2417:
2418: Error_Handler.Write_Debug('Sysdate is '||to_char(G_sysdate,'DD-MON-YYYY HH24:MI:SS')||' Effectivity date is '||to_char(p_effectivity_date,'DD-MON-YYYY HH24:MI:SS'));
2419:
2420: -- Convert the transaction type if it is SYNC
2421:
2422: IF p_transaction_type = 'SYNC' THEN

Line 2454: x_msg_count := Error_Handler.Get_Message_Count;

2450: Add_Message ('INV', 'INV_INVALID_TRANS_TYPE');
2451: x_return_status := FND_API.g_RET_STS_UNEXP_ERROR;
2452:
2453: IF G_Message_API = 'BOM' THEN
2454: x_msg_count := Error_Handler.Get_Message_Count;
2455: ELSE
2456: FND_MSG_PUB.Count_And_Get
2457: ( p_count => x_msg_count
2458: , p_data => l_msg_data

Line 2466: IF Error_Handler.Get_Debug = 'Y' THEN

2462: l_msg_data := fnd_msg_pub.get(x_msg_count,FND_API.G_FALSE);
2463: END IF;
2464: END IF;
2465:
2466: IF Error_Handler.Get_Debug = 'Y' THEN
2467: Error_Handler.Close_Debug_Session;
2468: END IF;
2469:
2470: Return;

Line 2467: Error_Handler.Close_Debug_Session;

2463: END IF;
2464: END IF;
2465:
2466: IF Error_Handler.Get_Debug = 'Y' THEN
2467: Error_Handler.Close_Debug_Session;
2468: END IF;
2469:
2470: Return;
2471:

Line 2628: IF Error_Handler.Get_Debug = 'Y' THEN

2624: -- end Bug 13865319 change the return status to S incase of 0 , E in case of 1 and U for remaining
2625: End If;
2626: /* End of inherit components... */
2627:
2628: IF Error_Handler.Get_Debug = 'Y' THEN
2629: Error_Handler.Close_Debug_Session;
2630: END IF;
2631: /*Changes made for bug 8679971. To ensure error message is returned back*/
2632: x_msg_data := l_msg_data;

Line 2629: Error_Handler.Close_Debug_Session;

2625: End If;
2626: /* End of inherit components... */
2627:
2628: IF Error_Handler.Get_Debug = 'Y' THEN
2629: Error_Handler.Close_Debug_Session;
2630: END IF;
2631: /*Changes made for bug 8679971. To ensure error message is returned back*/
2632: x_msg_data := l_msg_data;
2633: /*End of comment*/

Line 2644: x_msg_count := Error_Handler.Get_Message_Count;

2640: , p_message_text => 'UNEXP_ERROR : ' || SQLERRM
2641: );
2642:
2643: IF G_Message_API = 'BOM' THEN
2644: x_msg_count := Error_Handler.Get_Message_Count;
2645: ELSE
2646: FND_MSG_PUB.Count_And_Get
2647: ( p_count => x_msg_count
2648: , p_data => l_msg_data

Line 2656: IF Error_Handler.Get_Debug = 'Y' THEN

2652: l_msg_data := fnd_msg_pub.get(x_msg_count,FND_API.G_FALSE);
2653: END IF;
2654: END IF;
2655:
2656: IF Error_Handler.Get_Debug = 'Y' THEN
2657: Error_Handler.Close_Debug_Session;
2658: END IF;
2659:
2660: /*Changes made for bug 8646872. To ensure error message is returned back*/

Line 2657: Error_Handler.Close_Debug_Session;

2653: END IF;
2654: END IF;
2655:
2656: IF Error_Handler.Get_Debug = 'Y' THEN
2657: Error_Handler.Close_Debug_Session;
2658: END IF;
2659:
2660: /*Changes made for bug 8646872. To ensure error message is returned back*/
2661: x_msg_data := l_msg_data;