DBA Data[Home] [Help]

APPS.ASO_COPY_TMPL_PUB dependencies on FND_MSG_PUB

Line 87: FND_MSG_PUB.initialize;

83: END IF;
84:
85: -- Initialize message list if p_init_msg_list is set to TRUE.
86: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

Line 91: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

87: FND_MSG_PUB.initialize;
88: END IF;
89:
90: -- Debug Message
91: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
92: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote To Template API: Start' );
93: FND_MSG_PUB.ADD;
94: END IF;
95:

Line 93: FND_MSG_PUB.ADD;

89:
90: -- Debug Message
91: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
92: FND_MESSAGE.Set_Name ('ASO' , 'Copy Quote To Template API: Start' );
93: FND_MSG_PUB.ADD;
94: END IF;
95:
96: -- Initialize API return status to success
97: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 106: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

102: -- ******************************************************************
103: -- Validate Environment
104: -- ******************************************************************
105: IF FND_GLOBAL.User_Id IS NULL THEN
106: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
107: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
108: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
109: FND_MSG_PUB.ADD;
110: END IF;

Line 109: FND_MSG_PUB.ADD;

105: IF FND_GLOBAL.User_Id IS NULL THEN
106: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
107: FND_MESSAGE.Set_Name ('ASO' , 'UT_CANNOT_GET_PROFILE_VALUE' );
108: FND_MESSAGE.Set_Token ('PROFILE' , 'USER_ID', FALSE );
109: FND_MSG_PUB.ADD;
110: END IF;
111: RAISE FND_API.G_EXC_ERROR;
112: END IF;
113:

Line 150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

146: FETCH c_qte_status_id INTO l_qte_header_rec.quote_status_id;
147:
148: IF c_qte_status_id%NOTFOUND THEN
149: x_return_status := FND_API.G_RET_STS_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
151: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
152: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
153: FND_MSG_PUB.ADD;
154: END IF;

Line 153: FND_MSG_PUB.ADD;

149: x_return_status := FND_API.G_RET_STS_ERROR;
150: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
151: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_NO_PROFILE_VALUE' );
152: FND_MESSAGE.Set_Token ( 'PROFILE' , 'ASO_DEFAULT_STATUS_CODE' , FALSE );
153: FND_MSG_PUB.ADD;
154: END IF;
155: CLOSE c_qte_status_id;
156: RAISE FND_API.G_EXC_ERROR;
157: END IF;

Line 218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

214:
215: X_Qte_Number:= l_qte_header_rec.quote_number;
216: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
221: FND_MSG_PUB.ADD;
222: END IF;

Line 221: FND_MSG_PUB.ADD;

217: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
218: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
219: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
220: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
221: FND_MSG_PUB.ADD;
222: END IF;
223: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
224: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
225: x_return_status := FND_API.G_RET_STS_ERROR;

Line 290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

286:
287:
288: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
291: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
293: FND_MSG_PUB.ADD;
294: END IF;

Line 293: FND_MSG_PUB.ADD;

289: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
290: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
291: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
292: FND_MESSAGE.Set_Token ('ROW' , 'ASO_QUOTE_HEADER', TRUE );
293: FND_MSG_PUB.ADD;
294: END IF;
295: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
296: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
297: x_return_status := FND_API.G_RET_STS_ERROR;

Line 355: FND_MSG_PUB.initialize;

351: END IF;
352:
353: -- Initialize message list if p_init_msg_list is set to TRUE.
354: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug Message
359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

Line 359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

355: FND_MSG_PUB.initialize;
356: END IF;
357:
358: -- Debug Message
359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
360: FND_MESSAGE.Set_Name ('ASO' , 'Copy Template Header API: Start'||P_Qte_Header_Rec.quote_number );
361: FND_MSG_PUB.ADD;
362: END IF;
363:

Line 361: FND_MSG_PUB.ADD;

357:
358: -- Debug Message
359: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
360: FND_MESSAGE.Set_Name ('ASO' , 'Copy Template Header API: Start'||P_Qte_Header_Rec.quote_number );
361: FND_MSG_PUB.ADD;
362: END IF;
363:
364: -- Initialize API return status to success
365: l_return_status := FND_API.G_RET_STS_SUCCESS;

Line 411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

407: END IF;
408:
409: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
414: FND_MSG_PUB.ADD;
415: END IF;

Line 414: FND_MSG_PUB.ADD;

410: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
411: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
412: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
413: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYHEADER AFTER_INSERT' , TRUE );
414: FND_MSG_PUB.ADD;
415: END IF;
416: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
417: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
418: x_return_status := FND_API.G_RET_STS_ERROR;

Line 607: FND_MSG_PUB.initialize;

603: END IF;
604:
605: -- Initialize message list if p_init_msg_list is set to TRUE.
606: IF FND_API.to_Boolean ( p_init_msg_list ) THEN
607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Debug Message
611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

Line 611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN

607: FND_MSG_PUB.initialize;
608: END IF;
609:
610: -- Debug Message
611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
612: FND_MESSAGE.Set_Name ('ASO' , 'Copy Template Lines API: Start' );
613: FND_MSG_PUB.ADD;
614: END IF;
615:

Line 613: FND_MSG_PUB.ADD;

609:
610: -- Debug Message
611: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW ) THEN
612: FND_MESSAGE.Set_Name ('ASO' , 'Copy Template Lines API: Start' );
613: FND_MSG_PUB.ADD;
614: END IF;
615:
616: -- Initialize API return status to success
617: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

940:
941:
942: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
945: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
947: FND_MSG_PUB.ADD;
948: END IF;

Line 947: FND_MSG_PUB.ADD;

943: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
944: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
945: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
946: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_INSERT' , TRUE );
947: FND_MSG_PUB.ADD;
948: END IF;
949: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
950: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
951: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1004: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

1000:
1001:
1002: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1005: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
1007: FND_MSG_PUB.ADD;
1008: END IF;

Line 1007: FND_MSG_PUB.ADD;

1003: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1004: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1005: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1006: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_SERVICE' , TRUE );
1007: FND_MSG_PUB.ADD;
1008: END IF;
1009: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1010: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1011: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

1058:
1059:
1060: IF ( l_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1065: FND_MSG_PUB.ADD;
1066: END IF;

Line 1065: FND_MSG_PUB.ADD;

1061: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1062: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1063: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1064: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYLINE AFTER_CONFIG_COPY' , TRUE );
1065: FND_MSG_PUB.ADD;
1066: END IF;
1067: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1068: ELSIF ( l_return_status = FND_API.G_RET_STS_ERROR ) THEN
1069: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1160: FND_MSG_PUB.Count_And_Get (

1156: COMMIT WORK;
1157: END IF;
1158:
1159: -- Standard call to get message count and if count is 1, get message info.
1160: FND_MSG_PUB.Count_And_Get (
1161: p_count => x_msg_count
1162: , p_data => x_msg_data
1163: );
1164:

Line 1171: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR

1167: WHEN FND_API.G_EXC_ERROR THEN
1168: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1169: P_API_NAME => L_API_NAME
1170: , P_PKG_NAME => G_PKG_NAME
1171: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_ERROR
1172: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1173: , X_MSG_COUNT => X_MSG_COUNT
1174: , X_MSG_DATA => X_MSG_DATA
1175: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1182: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR

1178: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1179: ASO_UTILITY_PVT.HANDLE_EXCEPTIONS (
1180: P_API_NAME => L_API_NAME
1181: , P_PKG_NAME => G_PKG_NAME
1182: , P_EXCEPTION_LEVEL => FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR
1183: , P_PACKAGE_TYPE => ASO_UTILITY_PVT.G_PVT
1184: , X_MSG_COUNT => X_MSG_COUNT
1185: , X_MSG_DATA => X_MSG_DATA
1186: , X_RETURN_STATUS => X_RETURN_STATUS

Line 1529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

1525:
1526:
1527:
1528: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1530: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1531: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
1532: FND_MSG_PUB.ADD;
1533: END IF;

Line 1532: FND_MSG_PUB.ADD;

1528: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1529: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1530: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1531: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYSERVICE AFTER_INSERT' , TRUE );
1532: FND_MSG_PUB.ADD;
1533: END IF;
1534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1535: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1536: RAISE FND_API.G_EXC_ERROR;

Line 1941: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

1937:
1938:
1939:
1940: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1941: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1942: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1943: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
1944: FND_MSG_PUB.ADD;
1945: END IF;

Line 1944: FND_MSG_PUB.ADD;

1940: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1941: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1942: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1943: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPYCONFIG AFTER_INSERT' , TRUE );
1944: FND_MSG_PUB.ADD;
1945: END IF;
1946: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1947: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1948: RAISE FND_API.G_EXC_ERROR;

Line 1977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN

1973: );
1974:
1975:
1976: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1978: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1979: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPY_TMPLCONFIG AFTER_SERVICE' , TRUE );
1980: FND_MSG_PUB.ADD;
1981: END IF;

Line 1980: FND_MSG_PUB.ADD;

1976: IF ( x_return_status = FND_API.G_RET_STS_UNEXP_ERROR ) THEN
1977: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_ERROR ) THEN
1978: FND_MESSAGE.Set_Name ('ASO' , 'ASO_API_UNEXP_ERROR' );
1979: FND_MESSAGE.Set_Token ( 'ROW' , 'ASO_COPY_TMPLCONFIG AFTER_SERVICE' , TRUE );
1980: FND_MSG_PUB.ADD;
1981: END IF;
1982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1983: ELSIF ( x_return_status = FND_API.G_RET_STS_ERROR ) THEN
1984: RAISE FND_API.G_EXC_ERROR;