DBA Data[Home] [Help]

APPS.PA_RBS_PUB dependencies on FND_MSG_PUB

Line 600: Fnd_Msg_Pub.initialize;

596: l_Api_Name CONSTANT Varchar2(30) := 'Init_Rbs_Processing';
597:
598: Begin
599:
600: Fnd_Msg_Pub.initialize;
601:
602: G_Rbs_Hdr_Rec := G_Empty_Rbs_Hdr_Rec;
603: G_Rbs_Hdr_Out_Rec := G_Empty_Rbs_Hdr_Out_Rec;
604: G_Rbs_Ver_Rec := G_Empty_Rbs_Ver_Rec;

Line 612: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

608:
609: Exception
610: When Others Then
611:
612: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
613: Fnd_Msg_Pub.Add_Exc_Msg
614: ( P_Pkg_Name => G_Pkg_Name ,
615: P_Procedure_Name => l_Api_Name );
616:

Line 613: Fnd_Msg_Pub.Add_Exc_Msg

609: Exception
610: When Others Then
611:
612: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
613: Fnd_Msg_Pub.Add_Exc_Msg
614: ( P_Pkg_Name => G_Pkg_Name ,
615: P_Procedure_Name => l_Api_Name );
616:
617: End If;

Line 732: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';

728:
729: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
730: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
731:
732: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
733: Fnd_Msg_Pub.Initialize;
734:
735: End If;
736:

Line 733: Fnd_Msg_Pub.Initialize;

729: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
730: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
731:
732: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
733: Fnd_Msg_Pub.Initialize;
734:
735: End If;
736:
737: Pa_Debug.G_Stage := 'Initialize error handling variables.';

Line 1097: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;

1093: Pa_Debug.TrackPath('STRIP','Create_Rbs');
1094:
1095: Exception
1096: When l_ERROR Then
1097: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
1098: If l_Msg_Count = 1 Then
1099: Pa_Interface_Utils_Pub.Get_Messages(
1100: P_Encoded => Fnd_Api.G_True,
1101: P_Msg_Index => 1,

Line 1277: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';

1273:
1274: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
1275: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
1276:
1277: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
1278: Fnd_Msg_Pub.Initialize;
1279:
1280: End If;
1281:

Line 1278: Fnd_Msg_Pub.Initialize;

1274: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
1275: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
1276:
1277: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
1278: Fnd_Msg_Pub.Initialize;
1279:
1280: End If;
1281:
1282: Pa_Debug.G_Stage := 'Initialize error handling variables.';

Line 1935: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;

1931: Pa_Debug.TrackPath('STRIP','Update_Rbs');
1932:
1933: Exception
1934: When l_ERROR Then
1935: l_Msg_Count := Fnd_Msg_Pub.Count_Msg;
1936:
1937: If l_Msg_Count = 1 Then
1938:
1939: Pa_Interface_Utils_Pub.Get_Messages(

Line 2029: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2025: Rollback;
2026: When Others Then
2027: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2028:
2029: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2030:
2031: Fnd_Msg_Pub.Add_Exc_Msg(
2032: P_Pkg_Name => G_Pkg_Name,
2033: P_Procedure_Name => l_api_name);

Line 2031: Fnd_Msg_Pub.Add_Exc_Msg(

2027: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2028:
2029: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2030:
2031: Fnd_Msg_Pub.Add_Exc_Msg(
2032: P_Pkg_Name => G_Pkg_Name,
2033: P_Procedure_Name => l_api_name);
2034:
2035: END IF;

Line 2092: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2088: Rollback;
2089: When Others Then
2090: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2091:
2092: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2093:
2094: Fnd_Msg_Pub.Add_Exc_Msg(
2095: P_Pkg_Name => G_Pkg_Name,
2096: P_Procedure_Name => l_api_name);

Line 2094: Fnd_Msg_Pub.Add_Exc_Msg(

2090: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2091:
2092: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2093:
2094: Fnd_Msg_Pub.Add_Exc_Msg(
2095: P_Pkg_Name => G_Pkg_Name,
2096: P_Procedure_Name => l_api_name);
2097:
2098: End If;

Line 2167: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2163: Rollback;
2164: When Others Then
2165: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2166:
2167: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2168:
2169: Fnd_Msg_Pub.Add_Exc_Msg(
2170: P_Pkg_Name => G_Pkg_Name,
2171: P_Procedure_Name => l_Api_Name);

Line 2169: Fnd_Msg_Pub.Add_Exc_Msg(

2165: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2166:
2167: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2168:
2169: Fnd_Msg_Pub.Add_Exc_Msg(
2170: P_Pkg_Name => G_Pkg_Name,
2171: P_Procedure_Name => l_Api_Name);
2172:
2173: End If;

Line 2227: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2223: Rollback;
2224: When Others Then
2225: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2226:
2227: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2228:
2229: Fnd_Msg_Pub.Add_Exc_Msg(
2230: P_Pkg_Name => G_Pkg_Name,
2231: P_Procedure_Name => l_Api_Name);

Line 2229: Fnd_Msg_Pub.Add_Exc_Msg(

2225: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2226:
2227: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2228:
2229: Fnd_Msg_Pub.Add_Exc_Msg(
2230: P_Pkg_Name => G_Pkg_Name,
2231: P_Procedure_Name => l_Api_Name);
2232:
2233: End If;

Line 2288: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2284: Rollback;
2285: When Others Then
2286: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2287:
2288: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2289:
2290: Fnd_Msg_Pub.Add_Exc_Msg(
2291: P_Pkg_Name => G_Pkg_Name,
2292: P_Procedure_Name => l_Api_Name);

Line 2290: Fnd_Msg_Pub.Add_Exc_Msg(

2286: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2287:
2288: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2289:
2290: Fnd_Msg_Pub.Add_Exc_Msg(
2291: P_Pkg_Name => G_Pkg_Name,
2292: P_Procedure_Name => l_Api_Name);
2293:
2294: End If;

Line 2377: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2373: Rollback;
2374: When Others Then
2375: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2376:
2377: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2378:
2379: Fnd_Msg_Pub.Add_Exc_Msg(
2380: P_Pkg_Name => G_Pkg_Name,
2381: P_Procedure_Name => l_Api_Name);

Line 2379: Fnd_Msg_Pub.Add_Exc_Msg(

2375: X_Return_Status := Fnd_Api.G_Ret_Sts_UnExp_Error ;
2376:
2377: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2378:
2379: Fnd_Msg_Pub.Add_Exc_Msg(
2380: P_Pkg_Name => G_Pkg_Name,
2381: P_Procedure_Name => l_Api_Name);
2382:
2383: End If;

Line 2452: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2448: Rollback;
2449: When Others Then
2450: X_return_status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2451:
2452: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2453: Fnd_Msg_Pub.Add_Exc_Msg(
2454: P_Pkg_Name => G_Pkg_Name,
2455: P_Procedure_Name => l_Api_Name);
2456:

Line 2453: Fnd_Msg_Pub.Add_Exc_Msg(

2449: When Others Then
2450: X_return_status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2451:
2452: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2453: Fnd_Msg_Pub.Add_Exc_Msg(
2454: P_Pkg_Name => G_Pkg_Name,
2455: P_Procedure_Name => l_Api_Name);
2456:
2457: End If;

Line 2459: Fnd_Msg_Pub.Count_And_Get(

2455: P_Procedure_Name => l_Api_Name);
2456:
2457: End If;
2458:
2459: Fnd_Msg_Pub.Count_And_Get(
2460: P_Count => X_Msg_Count,
2461: P_Data => X_Msg_Data );
2462: Rollback;
2463:

Line 2526: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2522:
2523: When Others Then
2524: X_return_status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2525:
2526: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2527: Fnd_Msg_Pub.Add_Exc_Msg(
2528: P_Pkg_Name => G_Pkg_Name,
2529: P_Procedure_Name => l_Api_Name);
2530:

Line 2527: Fnd_Msg_Pub.Add_Exc_Msg(

2523: When Others Then
2524: X_return_status := Fnd_Api.G_Ret_Sts_UnExp_Error;
2525:
2526: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2527: Fnd_Msg_Pub.Add_Exc_Msg(
2528: P_Pkg_Name => G_Pkg_Name,
2529: P_Procedure_Name => l_Api_Name);
2530:
2531: End If;

Line 2533: Fnd_Msg_Pub.Count_And_Get(

2529: P_Procedure_Name => l_Api_Name);
2530:
2531: End If;
2532:
2533: Fnd_Msg_Pub.Count_And_Get(
2534: P_Count => X_Msg_Count,
2535: P_Data => X_Msg_Data );
2536:
2537: End Exec_Update_Rbs;

Line 2631: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';

2627:
2628: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2629: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2630:
2631: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2632: Fnd_Msg_Pub.Initialize;
2633:
2634: End If;
2635:

Line 2632: Fnd_Msg_Pub.Initialize;

2628: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2629: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2630:
2631: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2632: Fnd_Msg_Pub.Initialize;
2633:
2634: End If;
2635:
2636: Pa_Debug.G_Stage := 'Initialize error handling variables.';

Line 2717: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2713: X_Msg_Count := 1;
2714: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
2715:
2716: --For bug 4061935.
2717: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2718: Fnd_Msg_Pub.Add_Exc_Msg(
2719: P_Pkg_Name => G_Pkg_Name,
2720: P_Procedure_Name => l_Api_Name);
2721: End If;

Line 2718: Fnd_Msg_Pub.Add_Exc_Msg(

2714: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
2715:
2716: --For bug 4061935.
2717: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2718: Fnd_Msg_Pub.Add_Exc_Msg(
2719: P_Pkg_Name => G_Pkg_Name,
2720: P_Procedure_Name => l_Api_Name);
2721: End If;
2722:

Line 2799: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';

2795: --For bug 4061935.
2796: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2797: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2798:
2799: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2800: Fnd_Msg_Pub.Initialize;
2801:
2802: End If;
2803:

Line 2800: Fnd_Msg_Pub.Initialize;

2796: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2797: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2798:
2799: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2800: Fnd_Msg_Pub.Initialize;
2801:
2802: End If;
2803:
2804: Pa_Debug.G_Stage := 'Initialize error handling variables.';

Line 2871: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

2867: X_Return_Status := 'U';
2868: X_Msg_Count := 1;
2869: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
2870:
2871: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2872: Fnd_Msg_Pub.Add_Exc_Msg(
2873: P_Pkg_Name => G_Pkg_Name,
2874: P_Procedure_Name => l_Api_Name);
2875: End If;

Line 2872: Fnd_Msg_Pub.Add_Exc_Msg(

2868: X_Msg_Count := 1;
2869: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
2870:
2871: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
2872: Fnd_Msg_Pub.Add_Exc_Msg(
2873: P_Pkg_Name => G_Pkg_Name,
2874: P_Procedure_Name => l_Api_Name);
2875: End If;
2876:

Line 2965: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';

2961: --For bug 4061935.
2962: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2963: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2964:
2965: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2966: Fnd_Msg_Pub.Initialize;
2967:
2968: End If;
2969:

Line 2966: Fnd_Msg_Pub.Initialize;

2962: Pa_Debug.G_Stage := 'Check if need to initialize the message stack(T-True,F-False) - ' || P_Init_Msg_List;
2963: If Fnd_Api.To_Boolean(nvl(P_Init_Msg_List,Fnd_Api.G_True)) Then
2964:
2965: Pa_Debug.G_Stage := 'Initializing message stack by calling Fnd_Msg_Pub.Initialize().';
2966: Fnd_Msg_Pub.Initialize;
2967:
2968: End If;
2969:
2970: Pa_Debug.G_Stage := 'Initialize error handling variables.';

Line 3106: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then

3102: X_Return_Status := 'U';
3103: X_Msg_Count := 1;
3104: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
3105:
3106: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
3107: Fnd_Msg_Pub.Add_Exc_Msg(
3108: P_Pkg_Name => G_Pkg_Name,
3109: P_Procedure_Name => l_Api_Name);
3110: End If;

Line 3107: Fnd_Msg_Pub.Add_Exc_Msg(

3103: X_Msg_Count := 1;
3104: X_Error_Msg_Data := Pa_Rbs_Pub.G_Pkg_Name || ':::' || Pa_Debug.G_Path || '::' || Pa_Debug.G_Stage || ':' || SqlErrm;
3105:
3106: If Fnd_Msg_Pub.Check_Msg_Level(Fnd_Msg_Pub.G_Msg_Lvl_UnExp_Error) Then
3107: Fnd_Msg_Pub.Add_Exc_Msg(
3108: P_Pkg_Name => G_Pkg_Name,
3109: P_Procedure_Name => l_Api_Name);
3110: End If;
3111: