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.ENG_VAL_TO_ID dependencies on ERROR_HANDLER

Line 6: g_Token_Tbl Error_Handler.Token_Tbl_Type;

2: /* $Header: ENGSVIDB.pls 120.8 2007/06/01 09:10:49 pguharay ship $ */
3: -- Global constant holding the package name
4:
5: G_PKG_NAME CONSTANT VARCHAR2(30) := 'ENG_Val_To_Id';
6: g_Token_Tbl Error_Handler.Token_Tbl_Type;
7:
8: -- Prototypes for val_to_id functions.
9:
10: -- START GEN val_to_id

Line 1033: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1029: PROCEDURE Change_Order_VID
1030: ( p_ECO_rec IN Eng_Eco_Pub.ECO_Rec_Type
1031: , p_old_eco_unexp_rec IN Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1032: , P_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.ECO_Unexposed_Rec_Type
1033: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: )
1036: IS
1037: l_Token_Tbl Error_Handler.Token_Tbl_Type;

Line 1037: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1033: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1034: , x_return_status OUT NOCOPY VARCHAR2
1035: )
1036: IS
1037: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1038: l_change_order_type_id NUMBER;
1039: l_change_mgmt_type_code VARCHAR2(30);
1040: l_disable_date DATE;
1041: l_object_id NUMBER;

Line 1042: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1038: l_change_order_type_id NUMBER;
1039: l_change_mgmt_type_code VARCHAR2(30);
1040: l_disable_date DATE;
1041: l_object_id NUMBER;
1042: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1043: l_err_text VARCHAR2(2000);
1044:
1045: l_change_type_code VARCHAR2(80);
1046: l_change_mgmt_type_name VARCHAR2(45);

Line 1087: Error_Handler.Add_Error_Token

1083: l_token_tbl(2).token_value := l_change_mgmt_type_name;
1084:
1085: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1086: THEN
1087: Error_Handler.Add_Error_Token
1088: (
1089: p_Message_Name => 'ENG_CHANGE_MGMT_TYPE_INVALID'
1090: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1091: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1122: Error_Handler.Add_Error_Token

1118: l_token_tbl(2).token_value := l_change_type_code;
1119:
1120: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1121: THEN
1122: Error_Handler.Add_Error_Token
1123: ( p_Message_Name => 'ENG_CHANGE_TYPE_INVALID'
1124: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1125: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1126: , p_Token_Tbl => l_Token_Tbl

Line 1136: Error_Handler.Add_Error_Token

1132: ELSIF l_change_order_type_id = FND_API.G_MISS_NUM
1133: THEN
1134: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1135: THEN
1136: Error_Handler.Add_Error_Token
1137: ( p_Message_Text => l_err_text
1138: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1139: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1140: );

Line 1155: Error_Handler.Add_Error_Token

1151: IF l_transaction_type = Bom_GLOBALS.G_OPR_CREATE
1152: THEN
1153: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1154: THEN
1155: Error_Handler.Add_Error_Token
1156: ( p_Message_Name => 'ENG_CHANGE_TYPE_MISSING'
1157: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1158: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1159: , p_Token_Tbl => l_Token_Tbl

Line 1179: Error_Handler.Add_Error_Token

1175: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1176: THEN
1177: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
1178: l_token_tbl(2).token_value := l_change_type_code;
1179: Error_Handler.Add_Error_Token
1180: ( p_Message_Name => 'ENG_CHANGE_TYPE_DISABLED'
1181: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1182: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1183: , p_Token_Tbl => l_Token_Tbl

Line 1207: Error_Handler.Add_Error_Token

1203: THEN
1204: l_token_tbl(1).token_name := 'STATUS_TYPE';
1205: l_token_tbl(1).token_value := p_ECO_rec.Status_Name;
1206:
1207: Error_Handler.Add_Error_Token
1208: ( p_message_name => 'ENG_STATUS_TYPE_INVALID'
1209: , p_mesg_token_tbl => l_mesg_token_tbl
1210: , p_token_tbl => l_token_tbl
1211: , x_mesg_token_tbl => l_mesg_token_tbl

Line 1847: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

1843: * revised item entity.
1844: ****************************************************************************/
1845: PROCEDURE Revised_Item_VID
1846: ( x_Return_Status OUT NOCOPY VARCHAR2
1847: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
1848: , p_rev_item_unexp_Rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1849: , x_rev_item_unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
1850: , p_revised_item_Rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
1851: )

Line 1855: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

1851: )
1852: IS
1853: l_return_value NUMBER;
1854: l_Return_Status VARCHAR2(1);
1855: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1856: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1857: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1858: l_Err_Text VARCHAR2(2000);
1859: l_bill_seq_id NUMBER;

Line 1856: l_Token_Tbl Error_Handler.Token_Tbl_Type;

1852: IS
1853: l_return_value NUMBER;
1854: l_Return_Status VARCHAR2(1);
1855: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
1856: l_Token_Tbl Error_Handler.Token_Tbl_Type;
1857: l_Rev_Item_Unexp_Rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
1858: l_Err_Text VARCHAR2(2000);
1859: l_bill_seq_id NUMBER;
1860: l_eco_type VARCHAR2(3);

Line 1890: Error_Handler.Add_Error_Token

1886: l_token_tbl(2).token_name := 'ORGANIZATION_CODE';
1887: l_token_tbl(2).token_value :=
1888: p_revised_item_rec.organization_code;
1889:
1890: Error_Handler.Add_Error_Token
1891: ( p_Message_Name =>'ENG_USE_UP_ITEM_ID_VID_INVALID'
1892: , p_Message_Text => NULL
1893: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1894: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1916: Error_Handler.Add_Error_Token

1912: );
1913:
1914: IF l_err_text IS NOT NULL
1915: THEN
1916: Error_Handler.Add_Error_Token
1917: ( p_Message_Name => NULL
1918: , p_Message_Text => l_err_text
1919: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1920: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1932: Error_Handler.Add_Error_Token

1928: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1929: l_token_tbl(2).token_value :=
1930: p_revised_item_rec.organization_code;
1931:
1932: Error_Handler.Add_Error_Token
1933: ( p_Message_Name => 'ENG_RIT_REQUESTOR_INVALID'
1934: , p_Message_Text => NULL
1935: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1936: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1964: Error_Handler.Add_Error_Token

1960: );
1961:
1962: IF l_err_text IS NOT NULL
1963: THEN
1964: Error_Handler.Add_Error_Token
1965: ( p_Message_Name => NULL
1966: , p_Message_Text => l_err_text
1967: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1968: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 1980: Error_Handler.Add_Error_Token

1976: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
1977: l_token_tbl(2).token_value :=
1978: p_revised_item_rec.revised_item_name ;
1979:
1980: Error_Handler.Add_Error_Token
1981: ( p_Message_Name => 'ENG_RIT_FROM_WO_INVALID'
1982: , p_Message_Text => NULL
1983: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
1984: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2003: Error_Handler.Add_Error_Token

1999: );
2000:
2001: IF l_err_text IS NOT NULL
2002: THEN
2003: Error_Handler.Add_Error_Token
2004: ( p_Message_Name => NULL
2005: , p_Message_Text => l_err_text
2006: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2007: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2019: Error_Handler.Add_Error_Token

2015: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2016: l_token_tbl(2).token_value :=
2017: p_revised_item_rec.revised_item_name ;
2018:
2019: Error_Handler.Add_Error_Token
2020: ( p_Message_Name => 'ENG_RIT_TO_WO_INVALID'
2021: , p_Message_Text => NULL
2022: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2023: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2045: Error_Handler.Add_Error_Token

2041: , x_err_text => l_err_text
2042: );
2043: IF l_err_text IS NOT NULL
2044: THEN
2045: Error_Handler.Add_Error_Token
2046: ( p_Message_Name => NULL
2047: , p_Message_Text => l_err_text
2048: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2049: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2061: Error_Handler.Add_Error_Token

2057: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2058: l_token_tbl(2).token_value :=
2059: p_revised_item_rec.revised_item_name ;
2060:
2061: Error_Handler.Add_Error_Token
2062: ( p_Message_Name => 'ENG_RIT_LOCATION_NAME_INVALID'
2063: , p_Message_Text => NULL
2064: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2065: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2092: Error_Handler.Write_Debug('Getting Bill Seq Id . . . : ' ||

2088: , x_err_text => l_err_text
2089: );
2090:
2091: IF Bom_Globals.Get_Debug = 'Y' THEN
2092: Error_Handler.Write_Debug('Getting Bill Seq Id . . . : ' ||
2093: to_char(l_rev_item_unexp_rec.bill_sequence_id));
2094: END IF;
2095:
2096: END IF;

Line 2116: Error_Handler.Write_Debug('Getting Routing Seq Id . . . : ' ||

2112: );
2113:
2114:
2115: IF Bom_Globals.Get_Debug = 'Y' THEN
2116: Error_Handler.Write_Debug('Getting Routing Seq Id . . . : ' ||
2117: to_char(l_rev_item_unexp_rec.routing_sequence_id));
2118: END IF;
2119:
2120: END IF;

Line 2199: Error_Handler.Write_Debug('Getting From Revision Id . . . : ' ||

2195: , x_err_text => l_err_text
2196: );
2197: IF Bom_Globals.Get_Debug = 'Y'
2198: THEN
2199: Error_Handler.Write_Debug('Getting From Revision Id . . . : ' ||
2200: to_char(l_rev_item_unexp_rec.from_item_revision_id));
2201: END IF;
2202:
2203: IF ( l_rev_item_unexp_rec.from_item_revision_id IS NULL OR

Line 2211: Error_Handler.Add_Error_Token

2207: l_token_tbl(1).token_value := l_rev_item_unexp_rec.from_item_revision_id ;
2208: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2209: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name ;
2210:
2211: Error_Handler.Add_Error_Token
2212: ( p_Message_Name => 'ENG_INVALID_FROM_REVISION'
2213: , p_Message_Text => NULL
2214: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2215: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2243: Error_Handler.Add_Error_Token

2239: l_token_tbl(1).token_value := p_revised_item_rec.new_revision_reason ;
2240: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2241: l_token_tbl(2).token_value := p_revised_item_rec.revised_item_name ;
2242:
2243: Error_Handler.Add_Error_Token
2244: ( p_Message_Name => 'ENG_INVALID_REVISION_REASON'
2245: , p_Message_Text => NULL
2246: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2247: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2255: Error_Handler.Write_Debug('Getting New Revision reason Code . . . : ' ||

2251: END IF;
2252:
2253: IF Bom_Globals.Get_Debug = 'Y'
2254: THEN
2255: Error_Handler.Write_Debug('Getting New Revision reason Code . . . : ' ||
2256: l_rev_item_unexp_rec.new_revision_reason_code); -- bug 4309885: removed to_char(varchar) as it is not supported in 8i
2257: END IF;
2258: END IF;
2259: END IF; -- End of (l_eco_type = 'PLM')

Line 2275: Error_Handler.Add_Error_Token

2271: , x_err_text => l_err_text
2272: );
2273: IF l_err_text IS NOT NULL
2274: THEN
2275: Error_Handler.Add_Error_Token
2276: ( p_Message_Name => NULL
2277: , p_Message_Text => l_err_text
2278: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2279: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2291: Error_Handler.Add_Error_Token

2287: l_token_tbl(2).token_name := 'REVISED_ITEM_NAME';
2288: l_token_tbl(2).token_value :=
2289: p_revised_item_rec.revised_item_name ;
2290:
2291: Error_Handler.Add_Error_Token
2292: ( p_Message_Name => 'ENG_STRUC_TYPE_NAME_INVALID'
2293: , p_Message_Text => NULL
2294: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2295: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 2311: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

2307:
2308:
2309: PROCEDURE ECO_Header_VID
2310: ( x_Return_Status OUT NOCOPY VARCHAR2
2311: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
2312: , p_ECO_Rec IN Eng_Eco_Pub.ECO_Rec_Type
2313: , p_ECO_Unexp_Rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2314: , x_ECO_Unexp_Rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
2315: )

Line 2320: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

2316: IS
2317: l_err_text VARCHAR2(2000) := NULL;
2318: l_return_value NUMBER;
2319: l_Return_Status VARCHAR2(1);
2320: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2321: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2322: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2323:
2324:

Line 2321: l_Token_Tbl Error_Handler.Token_Tbl_Type;

2317: l_err_text VARCHAR2(2000) := NULL;
2318: l_return_value NUMBER;
2319: l_Return_Status VARCHAR2(1);
2320: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
2321: l_Token_Tbl Error_Handler.Token_Tbl_Type;
2322: l_ECO_Unexp_Rec Eng_Eco_Pub.Eco_Unexposed_Rec_Type;
2323:
2324:
2325: l_change_mgmt_type_code VARCHAR2(30) ;

Line 2367: Error_Handler.Add_Error_Token

2363: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2364: l_token_tbl(1).token_name := 'APPROVAL_LIST_NAME';
2365: l_token_tbl(1).token_value := p_ECO_rec.Approval_List_Name;
2366:
2367: Error_Handler.Add_Error_Token
2368: ( p_Message_Name => 'ENG_APPROVAL_LIST_INVALID'
2369: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2370: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2371: , p_Token_Tbl => l_Token_Tbl

Line 2381: Error_Handler.Add_Error_Token

2377: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2378:
2379: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2380: THEN
2381: Error_Handler.Add_Error_Token
2382: ( p_Message_Text => l_err_text
2383: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2384: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2385: );

Line 2419: Error_Handler.Add_Error_Token

2415: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2416: l_token_tbl(1).token_name := 'ECO_DEPARTMENT';
2417: l_token_tbl(1).token_value := p_ECO_rec.ECO_Department_name;
2418:
2419: Error_Handler.Add_Error_Token
2420: ( p_Message_Name => 'ENG_RESP_ORG_INVALID'
2421: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2422: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2423: , p_Token_Tbl => l_Token_Tbl

Line 2433: Error_Handler.Add_Error_Token

2429: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2430:
2431: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2432: THEN
2433: Error_Handler.Add_Error_Token
2434: ( p_Message_Text => l_err_text
2435: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2436: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2437: );

Line 2466: Error_Handler.Add_Error_Token(

2462: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2463: l_token_tbl(1).token_name := 'EMPLOYEE_NUMBER';
2464: l_token_tbl(1).token_value := p_ECO_rec.employee_number;
2465:
2466: Error_Handler.Add_Error_Token(
2467: p_Message_Name => 'ENG_EMP_NUMBER_INVALID'
2468: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2469: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2470: , p_Token_Tbl => l_Token_Tbl );

Line 2479: Error_Handler.Add_Error_Token(

2475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2476:
2477: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2478: THEN
2479: Error_Handler.Add_Error_Token(
2480: p_Message_Text => l_err_text
2481: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2482: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl );
2483: END IF;

Line 2513: Error_Handler.Add_Error_Token

2509: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2510: l_token_tbl(1).token_name := 'REQUESTOR';
2511: l_token_tbl(1).token_value := p_ECO_rec.Requestor;
2512:
2513: Error_Handler.Add_Error_Token
2514: ( p_Message_Name => 'ENG_REQUESTOR_INVALID'
2515: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2516: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2517: , p_Token_Tbl => l_Token_Tbl

Line 2527: Error_Handler.Add_Error_Token

2523: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2524:
2525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2526: THEN
2527: Error_Handler.Add_Error_Token
2528: ( p_Message_Text => l_err_text
2529: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2530: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2531: );

Line 2561: Error_Handler.Add_Error_Token

2557: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2558: l_token_tbl(1).token_name := 'PROJECT_NUMBER';
2559: l_token_tbl(1).token_value := p_ECO_rec.project_name;
2560:
2561: Error_Handler.Add_Error_Token
2562: ( p_Message_Name => 'ENG_PROJECT_INVALID'
2563: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2564: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2565: , p_Token_Tbl => l_Token_Tbl

Line 2575: Error_Handler.Add_Error_Token

2571: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2572:
2573: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2574: THEN
2575: Error_Handler.Add_Error_Token
2576: ( p_Message_Text => l_err_text
2577: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2578: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2579: );

Line 2610: Error_Handler.Add_Error_Token

2606: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2607: l_token_tbl(1).token_name := 'TASK_NUMBER';
2608: l_token_tbl(1).token_value := p_ECO_rec.task_number;
2609:
2610: Error_Handler.Add_Error_Token
2611: ( p_Message_Name => 'ENG_TASK_INVALID'
2612: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2613: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2614: , p_Token_Tbl => l_Token_Tbl

Line 2624: Error_Handler.Add_Error_Token

2620: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2621:
2622: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2623: THEN
2624: Error_Handler.Add_Error_Token
2625: ( p_Message_Text => l_err_text
2626: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2627: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2628: );

Line 2666: Error_Handler.Add_Error_Token

2662: l_token_tbl(1).token_value := p_ECO_rec.Assignee ;
2663: --l_token_tbl(3).token_name := 'COMPANY_NAME';
2664: --l_token_tbl(3).token_value := p_ECO_rec.Assignee_Company_Name ;
2665:
2666: Error_Handler.Add_Error_Token
2667: ( p_Message_Name => 'ENG_ASSIGNEE_INVALID'
2668: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2669: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2670: , p_Token_Tbl => l_Token_Tbl

Line 2682: Error_Handler.Add_Error_Token

2678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2679:
2680: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2681: THEN
2682: Error_Handler.Add_Error_Token
2683: ( p_Message_Text => l_err_text
2684: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2685: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2686: );

Line 2723: Error_Handler.Add_Error_Token

2719: THEN
2720: l_token_tbl(1).token_name := 'CHANGE_MANAGEMENT_TYPE';
2721: l_token_tbl(1).token_value := p_ECO_rec.Change_Management_Type;
2722:
2723: Error_Handler.Add_Error_Token
2724: ( p_message_name => 'ENG_CHG_MGMT_TYPE_INVALID'
2725: , p_mesg_token_tbl => l_mesg_token_tbl
2726: , p_token_tbl => g_token_tbl
2727: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2740: Error_Handler.Add_Error_Token

2736: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2737:
2738: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2739: THEN
2740: Error_Handler.Add_Error_Token
2741: ( p_Message_Text => l_err_text
2742: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2743: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2744: );

Line 2778: Error_Handler.Add_Error_Token

2774: THEN
2775: l_token_tbl(1).token_name := 'STATUS_TYPE';
2776: l_token_tbl(1).token_value := p_ECO_rec.Status_Name;
2777:
2778: Error_Handler.Add_Error_Token
2779: ( p_message_name => 'ENG_STATUS_TYPE_INVALID'
2780: , p_mesg_token_tbl => l_mesg_token_tbl
2781: , p_token_tbl => g_token_tbl
2782: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2809: Error_Handler.Add_Error_Token

2805: THEN
2806: l_token_tbl(1).token_name := 'APPROVAL_STATUS_TYPE';
2807: l_token_tbl(1).token_value := p_ECO_rec.Approval_Status_Name;
2808:
2809: Error_Handler.Add_Error_Token
2810: ( p_message_name => 'ENG_APPR_STATUS_TYPE_INVALID'
2811: , p_mesg_token_tbl => l_mesg_token_tbl
2812: , p_token_tbl => g_token_tbl
2813: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2845: Error_Handler.Add_Error_Token

2841: THEN
2842: l_token_tbl(1).token_name := 'SOURCE_TYPE';
2843: l_token_tbl(1).token_value := p_ECO_rec.Source_Type ;
2844:
2845: Error_Handler.Add_Error_Token
2846: ( p_message_name => 'ENG_CHG_SRC_TYPE_INVALID'
2847: , p_mesg_token_tbl => l_mesg_token_tbl
2848: , p_token_tbl => g_token_tbl
2849: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2862: Error_Handler.Add_Error_Token

2858: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2859:
2860: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2861: THEN
2862: Error_Handler.Add_Error_Token
2863: ( p_Message_Text => l_err_text
2864: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2865: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2866: );

Line 2905: Error_Handler.Add_Error_Token

2901: l_token_tbl(1).token_value := p_ECO_rec.Source_Type ;
2902: l_token_tbl(2).token_name := 'SOURCE_NAME';
2903: l_token_tbl(2).token_value := p_ECO_rec.Source_Name ;
2904:
2905: Error_Handler.Add_Error_Token
2906: ( p_message_name => 'ENG_CHG_SRC_NAME_INVALID'
2907: , p_mesg_token_tbl => l_mesg_token_tbl
2908: , p_token_tbl => g_token_tbl
2909: , x_mesg_token_tbl => l_mesg_token_tbl

Line 2922: Error_Handler.Add_Error_Token

2918: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2919:
2920: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2921: THEN
2922: Error_Handler.Add_Error_Token
2923: ( p_Message_Text => l_err_text
2924: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2925: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2926: );

Line 2957: Error_Handler.Add_Error_Token

2953: l_token_tbl(2).token_value := p_ECO_rec.ECO_name;
2954: l_token_tbl(1).token_name := 'ORGANIZATION_HIERARCHY';
2955: l_token_tbl(1).token_value := p_ECO_rec.Organization_Hierarchy;
2956:
2957: Error_Handler.Add_Error_Token
2958: ( p_Message_Name => 'ENG_HIERARCHY_INVALID'
2959: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2960: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2961: , p_Token_Tbl => l_Token_Tbl

Line 2971: Error_Handler.Add_Error_Token

2967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2968:
2969: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2970: THEN
2971: Error_Handler.Add_Error_Token
2972: ( p_Message_Text => l_err_text
2973: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2974: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
2975: );

Line 3011: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3007: PROCEDURE ECO_Header_UUI_To_UI
3008: ( p_eco_rec IN Eng_Eco_Pub.Eco_Rec_Type
3009: , p_eco_unexp_rec IN Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3010: , x_eco_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Unexposed_Rec_Type
3011: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3012: , x_Return_Status OUT NOCOPY VARCHAR2
3013: )
3014: IS
3015:

Line 3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3039: PROCEDURE ECO_Revision_UUI_To_UI
3040: ( p_eco_revision_rec IN ENG_Eco_PUB.Eco_Revision_Rec_Type
3041: , p_eco_rev_unexp_rec IN Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3042: , x_eco_rev_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Eco_Rev_Unexposed_Rec_Type
3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3044: , x_Return_Status OUT NOCOPY VARCHAR2
3045: )
3046: IS
3047: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

Line 3047: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3043: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3044: , x_Return_Status OUT NOCOPY VARCHAR2
3045: )
3046: IS
3047: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3048: l_dummy VARCHAR2(30);
3049:
3050: BEGIN
3051:

Line 3058: Error_Handler.Add_Error_Token

3054:
3055: IF p_eco_revision_rec.revision IS NULL OR
3056: p_eco_revision_rec.revision = FND_API.G_MISS_CHAR
3057: THEN
3058: Error_Handler.Add_Error_Token
3059: ( p_Message_Name => 'ENG_REVISION_KEYCOL_NULL'
3060: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3061: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3062: );

Line 3088: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3084: PROCEDURE Revised_Item_UUI_To_UI
3085: ( p_revised_item_rec IN Eng_Eco_Pub.Revised_Item_Rec_Type
3086: , p_rev_item_unexp_rec IN Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3087: , x_rev_item_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type
3088: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3089: , x_Return_Status OUT NOCOPY VARCHAR2
3090: )
3091: IS
3092: l_err_text VARCHAR2(2000);

Line 3094: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3090: )
3091: IS
3092: l_err_text VARCHAR2(2000);
3093: l_rev_item_unexp_rec Eng_Eco_Pub.Rev_Item_Unexposed_Rec_Type;
3094: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3095: l_return_status VARCHAR2(1);
3096: l_dummy VARCHAR2(30);
3097: BEGIN
3098:

Line 3113: Error_Handler.Add_Error_Token

3109: ************************************************************/
3110: IF p_revised_item_rec.revised_item_name IS NULL OR
3111: p_revised_item_rec.revised_item_name = FND_API.G_MISS_CHAR
3112: THEN
3113: Error_Handler.Add_Error_Token
3114: ( p_Message_Name => 'ENG_RITEM_NAME_KEYCOL_NULL'
3115: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3116: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3117: );

Line 3124: Error_Handler.Add_Error_Token

3120:
3121: IF p_revised_item_rec.start_effective_date IS NULL OR
3122: p_revised_item_rec.start_Effective_date = FND_API.G_MISS_DATE
3123: THEN
3124: Error_Handler.Add_Error_Token
3125: ( p_Message_Name => 'ENG_RITEM_DATE_KEYCOL_NULL'
3126: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3127: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3128: );

Line 3162: Error_Handler.Add_Error_Token

3158: THEN
3159: g_token_tbl(2).token_name := 'ORGANIZATION_CODE';
3160: g_token_tbl(2).token_value :=
3161: p_revised_item_rec.organization_code;
3162: Error_Handler.Add_Error_Token
3163: ( p_Message_Name => 'ENG_REVISED_ITEM_INVALID'
3164: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3165: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3166: , p_Token_Tbl => g_Token_Tbl

Line 3180: Error_Handler.Add_Error_Token

3176: THEN
3177: g_token_tbl(2).token_name := 'CHANGE_NOTICE';
3178: g_token_tbl(2).token_value :=
3179: p_revised_item_rec.eco_name;
3180: Error_Handler.Add_Error_Token
3181: ( p_Message_Name => 'ENG_REVISED_ITEM_INVALID'
3182: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3183: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3184: , p_Token_Tbl => g_Token_Tbl

Line 3474: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3470: , p_transaction_type IN VARCHAR2 := NULL
3471: , x_revised_item_sequence_id OUT NOCOPY NUMBER
3472: , x_bill_sequence_id OUT NOCOPY NUMBER
3473: , x_component_sequence_id OUT NOCOPY NUMBER
3474: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3475: , x_other_message OUT NOCOPY VARCHAR2
3476: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3477: , x_return_status OUT NOCOPY VARCHAR2
3478: )

Line 3476: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type

3472: , x_bill_sequence_id OUT NOCOPY NUMBER
3473: , x_component_sequence_id OUT NOCOPY NUMBER
3474: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3475: , x_other_message OUT NOCOPY VARCHAR2
3476: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3477: , x_return_status OUT NOCOPY VARCHAR2
3478: )
3479: IS
3480: l_lot_number VARCHAR2(30) ;

Line 3488: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3484: l_eco_for_production NUMBER ;
3485: l_cfm_routing_flag NUMBER ;
3486:
3487: l_err_text VARCHAR2(2000);
3488: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3489: l_return_status VARCHAR2(1);
3490: BEGIN
3491:
3492: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3523: Error_Handler.Add_Error_Token

3519: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3520: g_token_tbl(3).token_name := 'ECO_NAME';
3521: g_token_tbl(3).token_value := p_change_notice ;
3522:
3523: Error_Handler.Add_Error_Token
3524: ( p_Message_Name => 'BOM_REV_SEQUENCE_NOT_FOUND'
3525: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3526: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3527: , p_Token_Tbl => g_Token_Tbl

Line 3537: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('And this call returned with ' || l_Return_Status); END IF ;

3533: x_other_message := 'BOM_CMP_UUI_SEV_ERROR';
3534: x_other_token_tbl(1).token_name := 'REVISED_COMPONENT_NAME';
3535: x_other_token_tbl(1).token_value := p_component_item_name ;
3536:
3537: IF Bom_Globals.Get_Debug = 'Y' THEN Error_Handler.Write_Debug('And this call returned with ' || l_Return_Status); END IF ;
3538:
3539: RETURN;
3540:
3541: ELSIF p_transaction_type IN

Line 3552: Error_Handler.Add_Error_Token

3548:
3549: g_Token_Tbl(1).Token_Name := 'REVISED_ITEM_NAME';
3550: g_Token_Tbl(1).Token_Value := p_revised_item_name;
3551:
3552: Error_Handler.Add_Error_Token
3553: ( p_Message_Name => 'BOM_BILL_SEQUENCE_NOT_FOUND'
3554: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3555: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3556: , p_Token_Tbl => g_Token_Tbl

Line 3576: Error_Handler.Add_Error_Token

3572: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3573: g_token_tbl(3).token_name := 'ECO_NAME';
3574: g_token_tbl(3).token_value := p_change_notice ;
3575:
3576: Error_Handler.Add_Error_Token
3577: ( p_Message_Name => 'BOM_SBC_REV_SEQ_NOT_FOUND'
3578: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3579: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3580: , p_Token_Tbl => g_Token_Tbl

Line 3606: Error_Handler.Add_Error_Token

3602: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3603: g_Token_Tbl(3).Token_Name := 'ECO_NAME';
3604: g_Token_Tbl(3).Token_Value := p_change_notice ;
3605:
3606: Error_Handler.Add_Error_Token
3607: ( p_Message_Name => 'BOM_RFD_REV_SEQ_NOT_FOUND'
3608: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3609: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3610: , p_Token_Tbl => g_Token_Tbl

Line 3633: Error_Handler.Add_Error_Token

3629: g_Token_Tbl(1).Token_Value := p_revised_item_name ;
3630: g_Token_Tbl(2).Token_Name := 'REFERENCE_DESIGNATOR_NAME';
3631: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3632:
3633: Error_Handler.Add_Error_Token
3634: ( p_Message_Name => 'BOM_RFD_BILL_SEQ_NOT_FOUND'
3635: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3636: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3637: , p_Token_Tbl => g_Token_Tbl

Line 3666: IF Bom_Globals.get_debug = 'Y' then Error_Handler.write_debug

3662: , p_bill_sequence_id => x_bill_sequence_id
3663: , x_err_text => l_Err_Text
3664: );
3665:
3666: IF Bom_Globals.get_debug = 'Y' then Error_Handler.write_debug
3667: ('Component sequence ' || x_component_sequence_id ) ;
3668: END IF;
3669:
3670: IF x_component_sequence_id IS NULL

Line 3680: Error_Handler.Add_Error_Token

3676: g_Token_Tbl(2).Token_Value := p_revised_item_name ;
3677: g_Token_Tbl(3).Token_Name := 'SUBSTITUTE_ITEM_NAME';
3678: g_Token_Tbl(3).Token_Value := p_rfd_sbc_name ;
3679:
3680: Error_Handler.Add_Error_Token
3681: ( p_Message_Name => 'BOM_SBC_COMP_SEQ_NOT_FOUND'
3682: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3683: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3684: , p_Token_Tbl => g_Token_Tbl

Line 3706: Error_Handler.Add_Error_Token

3702: g_Token_Tbl(2).Token_Value := p_rfd_sbc_name ;
3703: g_Token_Tbl(3).Token_Name := 'REVISED_COMPONENT_NAME';
3704: g_Token_Tbl(3).Token_Value := p_component_item_name ;
3705:
3706: Error_Handler.Add_Error_Token
3707: ( p_Message_Name => 'BOM_RFD_COMP_SEQ_NOT_FOUND'
3708: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3709: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3710: , p_Token_Tbl => g_Token_Tbl

Line 3770: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3766: , p_transaction_type IN VARCHAR2 := NULL
3767: , x_revised_item_sequence_id OUT NOCOPY NUMBER
3768: , x_routing_sequence_id OUT NOCOPY NUMBER
3769: , x_operation_sequence_id OUT NOCOPY NUMBER
3770: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3771: , x_other_message OUT NOCOPY VARCHAR2
3772: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3773: , x_return_status OUT NOCOPY VARCHAR2
3774: )

Line 3772: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type

3768: , x_routing_sequence_id OUT NOCOPY NUMBER
3769: , x_operation_sequence_id OUT NOCOPY NUMBER
3770: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3771: , x_other_message OUT NOCOPY VARCHAR2
3772: , x_other_token_tbl OUT NOCOPY Error_Handler.Token_Tbl_Type
3773: , x_return_status OUT NOCOPY VARCHAR2
3774: )
3775: IS
3776: l_lot_number VARCHAR2(30) ;

Line 3783: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3779: l_from_cum_qty NUMBER ;
3780: l_eco_for_production NUMBER ;
3781: l_cfm_routing_flag NUMBER ;
3782: l_err_text VARCHAR2(2000);
3783: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3784: l_return_status VARCHAR2(1);
3785: BEGIN
3786:
3787: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3816: Error_Handler.Add_Error_Token

3812: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3813: g_token_tbl(3).token_name := 'ECO_NAME';
3814: g_token_tbl(3).token_value := p_change_notice ;
3815:
3816: Error_Handler.Add_Error_Token
3817: ( p_Message_Name => 'BOM_OP_RIT_SEQUENCE_NOT_FOUND'
3818: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3819: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3820: , p_Token_Tbl => g_Token_Tbl

Line 3840: Error_Handler.Add_Error_Token

3836: g_Token_Tbl(2).Token_Value := p_revised_item_name;
3837: g_token_tbl(3).token_name := 'ECO_NAME';
3838: g_token_tbl(3).token_value := p_change_notice ;
3839:
3840: Error_Handler.Add_Error_Token
3841: ( p_Message_Name => 'BOM_RES_RIT_SEQUENCE_NOT_FOUND'
3842: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3843: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3844: , p_Token_Tbl => g_Token_Tbl

Line 3864: Error_Handler.Add_Error_Token

3860: g_Token_Tbl(3).Token_Value := p_revised_item_name;
3861: g_token_tbl(4).token_name := 'ECO_NAME';
3862: g_token_tbl(4).token_value := p_change_notice ;
3863:
3864: Error_Handler.Add_Error_Token
3865: ( p_Message_Name => 'BOM_SUB_RES_RIT_SEQ_NOT_FOUND'
3866: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3867: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3868: , p_Token_Tbl => g_Token_Tbl

Line 3895: Error_Handler.Add_Error_Token

3891: IF x_operation_sequence_id IS NULL AND p_entity_processed = 'RES'
3892: THEN
3893: g_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
3894: g_token_tbl(1).token_value := p_operation_sequence_number ;
3895: Error_Handler.Add_Error_Token
3896: ( p_Message_Name => 'BOM_RES_OP_NOT_FOUND'
3897: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3898: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3899: , p_Token_Tbl => g_Token_Tbl

Line 3908: Error_Handler.Add_Error_Token

3904: THEN
3905: g_token_tbl(1).token_name := 'OP_SEQ_NUMBER';
3906: g_token_tbl(1).token_value := p_operation_sequence_number ;
3907:
3908: Error_Handler.Add_Error_Token
3909: ( p_Message_Name => 'BOM_SUB_RES_OP_NOT_FOUND'
3910: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3911: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3912: , p_Token_Tbl => g_Token_Tbl

Line 3923: Error_Handler.Add_Error_Token

3919: x_operation_sequence_id = FND_API.G_MISS_NUM
3920: )
3921: THEN
3922: -- This is an unexpected error.
3923: Error_Handler.Add_Error_Token
3924: ( p_Message_Name => NULL
3925: , p_Message_Text => l_err_text || ' in ' ||
3926: G_PKG_NAME
3927: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 3952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

3948: PROCEDURE Change_Line_UUI_To_UI
3949: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
3950: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3951: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
3952: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
3953: , x_Return_Status OUT NOCOPY VARCHAR2
3954: )
3955: IS
3956:

Line 3959: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

3955: IS
3956:
3957: l_err_text VARCHAR2(2000);
3958: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
3959: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
3960: l_return_status VARCHAR2(1);
3961: BEGIN
3962:
3963: l_change_line_unexp_rec := p_change_line_unexp_rec;

Line 3978: Error_Handler.Add_Error_Token

3974: IF (p_change_line_rec.name IS NULL OR
3975: p_change_line_rec.name = FND_API.G_MISS_CHAR)
3976:
3977: THEN
3978: Error_Handler.Add_Error_Token
3979: ( p_Message_Name => 'ENG_CL_NAME_KEYCOL_NULL'
3980: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3981: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
3982: );

Line 4016: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type

4012: PROCEDURE Change_Line_VID
4013: ( p_change_line_rec IN Eng_Eco_Pub.Change_Line_Rec_Type
4014: , p_change_line_unexp_rec IN Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4015: , x_change_line_unexp_rec IN OUT NOCOPY Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type
4016: , x_Mesg_Token_Tbl OUT NOCOPY Error_Handler.Mesg_Token_Tbl_Type
4017: , x_Return_Status OUT NOCOPY VARCHAR2
4018: )
4019: IS
4020:

Line 4023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;

4019: IS
4020:
4021: l_err_text VARCHAR2(2000) := NULL;
4022: l_Return_Status VARCHAR2(1);
4023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4024: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4025: l_change_mgmt_type_code VARCHAR2(30);
4026: l_hdr_change_mgmt_type_code VARCHAR2(30);
4027: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;

Line 4024: l_Token_Tbl Error_Handler.Token_Tbl_Type;

4020:
4021: l_err_text VARCHAR2(2000) := NULL;
4022: l_Return_Status VARCHAR2(1);
4023: l_Mesg_Token_Tbl Error_Handler.Mesg_Token_Tbl_Type;
4024: l_Token_Tbl Error_Handler.Token_Tbl_Type;
4025: l_change_mgmt_type_code VARCHAR2(30);
4026: l_hdr_change_mgmt_type_code VARCHAR2(30);
4027: l_change_line_unexp_rec Eng_Eco_Pub.Change_Line_Unexposed_Rec_Type ;
4028: l_dynamic_sql VARCHAR2(4000);

Line 4103: Error_Handler.Add_Error_Token

4099: l_token_tbl(2).token_value := p_change_line_rec.change_management_type;
4100:
4101: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4102: THEN
4103: Error_Handler.Add_Error_Token
4104: (
4105: p_Message_Name => 'ENG_CHANGE_MGMT_TYPE_INVALID'
4106: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4107: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl

Line 4147: Error_Handler.Add_Error_Token

4143: l_token_tbl(2).token_value := p_change_line_rec.change_type_code;
4144:
4145: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4146: THEN
4147: Error_Handler.Add_Error_Token
4148: ( p_Message_Name => 'ENG_CL_CHANGE_TYPE_INVALID'
4149: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4150: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4151: , p_Token_Tbl => l_Token_Tbl

Line 4162: Error_Handler.Add_Error_Token

4158: ELSIF l_change_type_id = FND_API.G_MISS_NUM
4159: THEN
4160: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4161: THEN
4162: Error_Handler.Add_Error_Token
4163: ( p_Message_Text => l_err_text
4164: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4165: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4166: );

Line 4187: Error_Handler.Add_Error_Token

4183: THEN
4184: l_token_tbl(2).token_name := 'CHANGE_TYPE_CODE';
4185: l_token_tbl(2).token_value := p_change_line_rec.change_type_code ;
4186:
4187: Error_Handler.Add_Error_Token
4188: ( p_Message_Name => 'ENG_CL_CHANGE_TYPE_DISABLED'
4189: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4190: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4191: , p_Token_Tbl => l_Token_Tbl

Line 4252: error_handler.add_error_token (

4248: ELSE
4249: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4250: l_token_tbl (1).token_value :=
4251: p_change_line_rec.change_type_code;
4252: error_handler.add_error_token (
4253: p_message_name=> 'ENG_PK1_NAME_INVALID',
4254: p_mesg_token_tbl=> l_mesg_token_tbl,
4255: x_mesg_token_tbl=> l_mesg_token_tbl,
4256: p_token_tbl=> l_token_tbl

Line 4264: error_handler.add_error_token (

4260: ELSE
4261: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4262: l_token_tbl (1).token_value :=
4263: p_change_line_rec.change_type_code;
4264: error_handler.add_error_token (
4265: p_message_name=> 'ENG_PK3_NAME_INVALID',
4266: p_mesg_token_tbl=> l_mesg_token_tbl,
4267: x_mesg_token_tbl=> l_mesg_token_tbl,
4268: p_token_tbl=> l_token_tbl

Line 4276: error_handler.add_error_token (

4272: ELSE
4273: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4274: l_token_tbl (1).token_value :=
4275: p_change_line_rec.change_type_code;
4276: error_handler.add_error_token (
4277: p_message_name=> 'ENG_PK4_NAME_INVALID',
4278: p_mesg_token_tbl=> l_mesg_token_tbl,
4279: x_mesg_token_tbl=> l_mesg_token_tbl,
4280: p_token_tbl=> l_token_tbl

Line 4292: error_handler.add_error_token (

4288: THEN
4289: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4290: l_token_tbl (1).token_value :=
4291: p_change_line_rec.change_type_code;
4292: error_handler.add_error_token (
4293: p_message_name=> 'ENG_PK1_NAME_INVALID',
4294: p_mesg_token_tbl=> l_mesg_token_tbl,
4295: x_mesg_token_tbl=> l_mesg_token_tbl,
4296: p_token_tbl=> l_token_tbl

Line 4308: error_handler.add_error_token (

4304: THEN
4305: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4306: l_token_tbl (1).token_value :=
4307: p_change_line_rec.change_type_code;
4308: error_handler.add_error_token (
4309: p_message_name=> 'ENG_PK3_NAME_INVALID',
4310: p_mesg_token_tbl=> l_mesg_token_tbl,
4311: x_mesg_token_tbl=> l_mesg_token_tbl,
4312: p_token_tbl=> l_token_tbl

Line 4324: error_handler.add_error_token (

4320: THEN
4321: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4322: l_token_tbl (1).token_value :=
4323: p_change_line_rec.change_type_code;
4324: error_handler.add_error_token (
4325: p_message_name=> 'ENG_PK4_NAME_INVALID',
4326: p_mesg_token_tbl=> l_mesg_token_tbl,
4327: x_mesg_token_tbl=> l_mesg_token_tbl,
4328: p_token_tbl=> l_token_tbl

Line 4359: error_handler.add_error_token (

4355: ELSE
4356: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4357: l_token_tbl (1).token_value :=
4358: p_change_line_rec.change_type_code;
4359: error_handler.add_error_token (
4360: p_message_name=> 'ENG_PK1_NAME_INVALID',
4361: p_mesg_token_tbl=> l_mesg_token_tbl,
4362: x_mesg_token_tbl=> l_mesg_token_tbl,
4363: p_token_tbl=> l_token_tbl

Line 4371: error_handler.add_error_token (

4367: ELSE
4368: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4369: l_token_tbl (1).token_value :=
4370: p_change_line_rec.change_type_code;
4371: error_handler.add_error_token (
4372: p_message_name=> 'ENG_PK3_NAME_INVALID',
4373: p_mesg_token_tbl=> l_mesg_token_tbl,
4374: x_mesg_token_tbl=> l_mesg_token_tbl,
4375: p_token_tbl=> l_token_tbl

Line 4387: error_handler.add_error_token (

4383: THEN
4384: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4385: l_token_tbl (1).token_value :=
4386: p_change_line_rec.change_type_code;
4387: error_handler.add_error_token (
4388: p_message_name=> 'ENG_PK1_NAME_INVALID',
4389: p_mesg_token_tbl=> l_mesg_token_tbl,
4390: x_mesg_token_tbl=> l_mesg_token_tbl,
4391: p_token_tbl=> l_token_tbl

Line 4403: error_handler.add_error_token (

4399: THEN
4400: l_token_tbl (1).token_name := 'CHANGE_LINE_TYPE';
4401: l_token_tbl (1).token_value :=
4402: p_change_line_rec.change_type_code;
4403: error_handler.add_error_token (
4404: p_message_name=> 'ENG_PK3_NAME_INVALID',
4405: p_mesg_token_tbl=> l_mesg_token_tbl,
4406: x_mesg_token_tbl=> l_mesg_token_tbl,
4407: p_token_tbl=> l_token_tbl

Line 4449: Error_Handler.Add_Error_Token

4445: THEN
4446: l_token_tbl(2).token_name := 'ASSIGNEE';
4447: l_token_tbl(2).token_value := p_change_line_rec.Assignee_Name;
4448:
4449: Error_Handler.Add_Error_Token
4450: ( p_Message_Name => 'ENG_ASSIGNEE_INVALID'
4451: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4452: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4453: , p_Token_Tbl => l_Token_Tbl

Line 4465: Error_Handler.Add_Error_Token

4461: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
4462:
4463: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4464: THEN
4465: Error_Handler.Add_Error_Token
4466: ( p_Message_Text => l_err_text
4467: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4468: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4469: );

Line 4643: Error_Handler.Add_Error_Token

4639: l_token_tbl(2).token_value := p_change_line_rec.pk1_name ;
4640:
4641: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
4642: THEN
4643: Error_Handler.Add_Error_Token
4644: ( p_Message_Name => 'ENG_PK_VALUES_INVALID'
4645: , p_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4646: , x_Mesg_Token_Tbl => l_Mesg_Token_Tbl
4647: , p_Token_Tbl => l_Token_Tbl