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.AMV_ITEM_PUB dependencies on AMV_UTILITY_PVT

Line 73: AMV_UTILITY_PVT.Get_UserInfo(

69: END IF;
70: -- Initialize API return status to success
71: x_return_status := FND_API.G_RET_STS_SUCCESS;
72: -- Get the current (login) user id.
73: AMV_UTILITY_PVT.Get_UserInfo(
74: x_resource_id => l_resource_id,
75: x_user_id => l_current_user_id,
76: x_login_id => l_current_login_id,
77: x_user_status => l_current_user_status

Line 116: l_item_obj.application_id := AMV_UTILITY_PVT.G_AMV_APP_ID;

112: --Because the application id should not be 0 while publishing an item
113: --
114: IF l_item_obj.application_id = 0 THEN
115:
116: l_item_obj.application_id := AMV_UTILITY_PVT.G_AMV_APP_ID;
117:
118: END IF;
119:
120: -- MAKE SURE THE PASSED ITEM OBJECT HAS ALL THE RIGHT INFORMATION.

Line 129: IF (l_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID ) THEN

125: FND_MSG_PUB.ADD;
126: END IF;
127: RAISE FND_API.G_EXC_ERROR;
128: END IF;
129: IF (l_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID ) THEN
130: -- Check if item type in the item object is null
131: IF (l_item_obj.item_type IS NULL OR
132: l_item_obj.item_type = FND_API.G_MISS_CHAR ) THEN
133: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN

Line 145: IF (AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.owner_id)

141: l_item_obj.owner_id = 0 OR
142: l_item_obj.owner_id = FND_API.G_MISS_NUM) THEN
143: l_item_obj.owner_id := l_resource_id;
144: ELSE
145: IF (AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.owner_id)
146: <> TRUE) THEN
147: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
148: FND_MESSAGE.Set_name('AMV','AMV_INVALID_OWNER_USER_ID');
149: FND_MESSAGE.Set_Token('ID', TO_CHAR(l_item_obj.owner_id));

Line 162: IF(AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.default_approver_id)

158: l_item_obj.default_approver_id = 0 OR
159: l_item_obj.default_approver_id = FND_API.G_MISS_NUM) THEN
160: l_item_obj.default_approver_id := l_resource_id;
161: ELSE
162: IF(AMV_UTILITY_PVT.Is_ResourceIdValid(l_item_obj.default_approver_id)
163: <> TRUE) THEN
164: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
165: FND_MESSAGE.Set_name('AMV','AMV_INVALID_APPROVER_ID');
166: FND_MESSAGE.Set_Token('ID',

Line 178: ELSIF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_obj.content_type_id)

174: -- Check if content type id in the item object is valid
175: IF (l_item_obj.content_type_id IS NULL OR
176: l_item_obj.content_type_id = FND_API.G_MISS_NUM) THEN
177: l_item_obj.content_type_id := NULL;
178: ELSIF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_obj.content_type_id)
179: <> TRUE) THEN
180: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
181: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
182: FND_MESSAGE.Set_Token('ID',

Line 319: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id_array(i))=TRUE)

315: END IF;
316: --Check if channel id array is passed and if so, make sure each id is valid.
317: IF (p_channel_id_array IS NOT NULL) THEN
318: FOR i IN 1..p_channel_id_array.COUNT LOOP
319: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(p_channel_id_array(i))=TRUE)
320: THEN
321: -- match the channel with the newly created content item
322: AMV_MATCH_PVT.Do_ItemChannelMatch
323: (

Line 332: p_match_type => AMV_UTILITY_PVT.G_PUSH

328: p_check_login_user => FND_API.G_FALSE,
329: p_channel_id => p_channel_id_array(i),
330: p_item_id => l_item_id,
331: p_table_name_code => G_USED_BY_ITEM,
332: p_match_type => AMV_UTILITY_PVT.G_PUSH
333: );
334: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
335: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
336: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR AND

Line 351: --IF (l_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN

347: END IF;
348: END IF;
349: END LOOP;
350: END IF;
351: --IF (l_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN
352: -- insert a request to matching engine to process item match.
353: -- Ignore the Messages
354: IF (l_item_rec.item_type <> 'MESSAGE_ITEM' ) THEN
355: AMV_MATCH_PVT.Request_ItemMatch

Line 448: AMV_UTILITY_PVT.Get_UserInfo(

444: END IF;
445: -- Initialize API return status to success
446: x_return_status := FND_API.G_RET_STS_SUCCESS;
447: -- Get the current (login) user id.
448: AMV_UTILITY_PVT.Get_UserInfo(
449: x_resource_id => l_resource_id,
450: x_user_id => l_current_user_id,
451: x_login_id => l_current_login_id,
452: x_user_status => l_current_user_status

Line 484: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

480: RAISE FND_API.G_EXC_ERROR;
481: END IF;
482: END IF;
483: -- Check if item id is valid.
484: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
485: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
486: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
487: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
488: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 628: AND available_due_to_type = AMV_UTILITY_PVT.G_PUSH;

624: CURSOR GetChannelMatch_csr IS
625: SELECT channel_id
626: FROM amv_c_chl_item_match
627: WHERE item_id = p_item_obj.item_id
628: AND available_due_to_type = AMV_UTILITY_PVT.G_PUSH;
629: --
630: BEGIN
631: -- Standard call to check for call compatibility.
632: SAVEPOINT Update_Item_Pub;

Line 647: AMV_UTILITY_PVT.Get_UserInfo(

643: END IF;
644: -- Initialize API return status to success
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646: -- Get the current (login) user id.
647: AMV_UTILITY_PVT.Get_UserInfo(
648: x_resource_id => l_resource_id,
649: x_user_id => l_current_user_id,
650: x_login_id => l_current_login_id,
651: x_user_status => l_current_user_status

Line 689: l_application_id := AMV_UTILITY_PVT.G_AMV_APP_ID;

685: --Because the application id should not be 0 while publishing an item
686: --
687: IF l_application_id = 0 THEN
688:
689: l_application_id := AMV_UTILITY_PVT.G_AMV_APP_ID;
690:
691: END IF;
692:
693:

Line 724: IF (l_item_rec.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN

720: l_item_rec.content_type_id := p_item_obj.content_type_id;
721: l_item_rec.owner_id := p_item_obj.owner_id;
722: l_item_rec.default_approver_id := p_item_obj.default_approver_id;
723: l_item_rec.item_destination_type := p_item_obj.item_destination_type;
724: IF (l_item_rec.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN
725: IF (l_item_rec.external_access_flag <> FND_API.G_TRUE AND
726: l_item_rec.external_access_flag <> FND_API.G_FALSE) THEN
727: l_item_rec.external_access_flag := FND_API.G_MISS_CHAR;
728: END IF;

Line 745: IF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_rec.content_type_id)

741: l_item_rec.item_type := FND_API.G_MISS_CHAR;
742: END IF;
743: IF ( l_item_rec.content_type_id IS NOT NULL AND
744: l_item_rec.content_type_id <> FND_API.G_MISS_NUM) THEN
745: IF (AMV_UTILITY_PVT.Is_ContentTypeIdValid(l_item_rec.content_type_id)
746: <> TRUE) THEN
747: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
748: FND_MESSAGE.Set_name('AMV','AMV_INVALID_CONTENT_TYPE_ID');
749: FND_MESSAGE.Set_Token('ID',

Line 906: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(l_channel_remove_id(i))=TRUE)

902: END LOOP;
903:
904: -- delete removed channels
905: FOR i IN 1..l_channel_remove_id.COUNT LOOP
906: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(l_channel_remove_id(i))=TRUE)
907: THEN
908: -- remove the channel from content item
909: AMV_MATCH_PVT.Remove_ItemChannelMatch
910: (

Line 939: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(l_channel_add_id(i))=TRUE)

935: END LOOP;
936:
937: -- Add items to new channels
938: FOR i IN 1..l_channel_add_id.COUNT LOOP
939: IF (AMV_UTILITY_PVT.Is_ChannelIdValid(l_channel_add_id(i))=TRUE)
940: THEN
941: -- match the channel with the newly created content item
942: AMV_MATCH_PVT.Do_ItemChannelMatch
943: (

Line 952: p_match_type => AMV_UTILITY_PVT.G_PUSH

948: p_check_login_user => FND_API.G_FALSE,
949: p_channel_id => l_channel_add_id(i),
950: p_item_id => p_item_obj.item_id,
951: p_table_name_code => G_USED_BY_ITEM,
952: p_match_type => AMV_UTILITY_PVT.G_PUSH
953: );
954: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
955: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
956: ELSIF (l_return_status = FND_API.G_RET_STS_ERROR AND

Line 971: --IF (p_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN

967: END IF;
968: END IF;
969: END LOOP;
970: END IF;
971: --IF (p_item_obj.application_id = AMV_UTILITY_PVT.G_AMV_APP_ID) THEN
972: -- insert a request to matching engine to process item match.
973: IF (p_item_obj.item_type <> 'MESSAGE_ITEM' ) THEN
974: AMV_MATCH_PVT.Request_ItemMatch
975: (

Line 1073: AMV_UTILITY_PVT.Get_UserInfo(

1069: END IF;
1070: -- Initialize API return status to success
1071: x_return_status := FND_API.G_RET_STS_SUCCESS;
1072: -- Get the current (login) user id.
1073: AMV_UTILITY_PVT.Get_UserInfo(
1074: x_resource_id => l_resource_id,
1075: x_user_id => l_current_user_id,
1076: x_login_id => l_current_login_id,
1077: x_user_status => l_current_user_status

Line 1091: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

1087: RAISE FND_API.G_EXC_ERROR;
1088: END IF;
1089: END IF;
1090: -- Check if item id is valid.
1091: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
1092: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1093: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
1094: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
1095: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 1338: AMV_UTILITY_PVT.Get_UserInfo(

1334: END IF;
1335: -- Initialize API return status to success
1336: x_return_status := FND_API.G_RET_STS_SUCCESS;
1337: -- Get the current (login) user id.
1338: AMV_UTILITY_PVT.Get_UserInfo(
1339: x_resource_id => l_resource_id,
1340: x_user_id => l_current_user_id,
1341: x_login_id => l_current_login_id,
1342: x_user_status => l_current_user_status

Line 1645: AMV_UTILITY_PVT.Get_UserInfo(

1641: END IF;
1642: -- Initialize API return status to success
1643: x_return_status := FND_API.G_RET_STS_SUCCESS;
1644: -- Get the current (login) user id.
1645: AMV_UTILITY_PVT.Get_UserInfo(
1646: x_resource_id => l_resource_id,
1647: x_user_id => l_current_user_id,
1648: x_login_id => l_current_login_id,
1649: x_user_status => l_current_user_status

Line 1800: AMV_UTILITY_PVT.Get_UserInfo(

1796: END IF;
1797: -- Initialize API return status to success
1798: x_return_status := FND_API.G_RET_STS_SUCCESS;
1799: -- Get the current (login) user id.
1800: AMV_UTILITY_PVT.Get_UserInfo(
1801: x_resource_id => l_resource_id,
1802: x_user_id => l_current_user_id,
1803: x_login_id => l_current_login_id,
1804: x_user_status => l_current_user_status

Line 1959: AMV_UTILITY_PVT.Get_UserInfo(

1955: END IF;
1956: -- Initialize API return status to success
1957: x_return_status := FND_API.G_RET_STS_SUCCESS;
1958: -- Get the current (login) user id.
1959: AMV_UTILITY_PVT.Get_UserInfo(
1960: x_resource_id => l_resource_id,
1961: x_user_id => l_current_user_id,
1962: x_login_id => l_current_login_id,
1963: x_user_status => l_current_user_status

Line 2090: AMV_UTILITY_PVT.Get_UserInfo(

2086: END IF;
2087: -- Initialize API return status to success
2088: x_return_status := FND_API.G_RET_STS_SUCCESS;
2089: -- Get the current (login) user id.
2090: AMV_UTILITY_PVT.Get_UserInfo(
2091: x_resource_id => l_resource_id,
2092: x_user_id => l_current_user_id,
2093: x_login_id => l_current_login_id,
2094: x_user_status => l_current_user_status

Line 2189: AMV_UTILITY_PVT.Get_UserInfo(

2185: END IF;
2186: -- Initialize API return status to success
2187: x_return_status := FND_API.G_RET_STS_SUCCESS;
2188: -- Get the current (login) user id.
2189: AMV_UTILITY_PVT.Get_UserInfo(
2190: x_resource_id => l_resource_id,
2191: x_user_id => l_current_user_id,
2192: x_login_id => l_current_login_id,
2193: x_user_status => l_current_user_status

Line 2344: AMV_UTILITY_PVT.Get_UserInfo(

2340: END IF;
2341: -- Initialize API return status to success
2342: x_return_status := FND_API.G_RET_STS_SUCCESS;
2343: -- Get the current (login) user id.
2344: AMV_UTILITY_PVT.Get_UserInfo(
2345: x_resource_id => l_resource_id,
2346: x_user_id => l_current_user_id,
2347: x_login_id => l_current_login_id,
2348: x_user_status => l_current_user_status

Line 2502: AMV_UTILITY_PVT.Get_UserInfo(

2498: END IF;
2499: -- Initialize API return status to success
2500: x_return_status := FND_API.G_RET_STS_SUCCESS;
2501: -- Get the current (login) user id.
2502: AMV_UTILITY_PVT.Get_UserInfo(
2503: x_resource_id => l_resource_id,
2504: x_user_id => l_current_user_id,
2505: x_login_id => l_current_login_id,
2506: x_user_status => l_current_user_status

Line 2538: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

2534: RAISE FND_API.G_EXC_ERROR;
2535: END IF;
2536: END IF;
2537: -- Check if item id is valid.
2538: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2539: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2540: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2541: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2542: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 2643: AMV_UTILITY_PVT.Get_UserInfo(

2639: END IF;
2640: -- Initialize API return status to success
2641: x_return_status := FND_API.G_RET_STS_SUCCESS;
2642: -- Get the current (login) user id.
2643: AMV_UTILITY_PVT.Get_UserInfo(
2644: x_resource_id => l_resource_id,
2645: x_user_id => l_current_user_id,
2646: x_login_id => l_current_login_id,
2647: x_user_status => l_current_user_status

Line 2720: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

2716: x_return_status OUT NOCOPY VARCHAR2,
2717: x_msg_count OUT NOCOPY NUMBER,
2718: x_msg_data OUT NOCOPY VARCHAR2,
2719: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2720: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2721: p_item_id IN NUMBER,
2722: p_file_id_varray IN AMV_NUMBER_VARRAY_TYPE
2723: ) AS
2724: l_api_name CONSTANT VARCHAR2(30) := 'Add_ItemFile';

Line 2771: AMV_UTILITY_PVT.Get_UserInfo(

2767: END IF;
2768: -- Initialize API return status to success
2769: x_return_status := FND_API.G_RET_STS_SUCCESS;
2770: -- Get the current (login) user id.
2771: AMV_UTILITY_PVT.Get_UserInfo(
2772: x_resource_id => l_resource_id,
2773: x_user_id => l_current_user_id,
2774: x_login_id => l_current_login_id,
2775: x_user_status => l_current_user_status

Line 2812: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

2808: l_current_login_id := -1;
2809: l_current_user_id := -1;
2810: END IF;
2811: -- Check if item id is valid.
2812: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
2813: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
2814: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
2815: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
2816: fnd_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 2976: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,

2972: x_return_status OUT NOCOPY VARCHAR2,
2973: x_msg_count OUT NOCOPY NUMBER,
2974: x_msg_data OUT NOCOPY VARCHAR2,
2975: p_check_login_user IN VARCHAR2 := FND_API.G_TRUE,
2976: p_application_id IN NUMBER := AMV_UTILITY_PVT.G_AMV_APP_ID,
2977: p_item_id IN NUMBER,
2978: p_file_id IN NUMBER
2979: ) AS
2980: l_number_varray AMV_NUMBER_VARRAY_TYPE;

Line 3050: AMV_UTILITY_PVT.Get_UserInfo(

3046: END IF;
3047: -- Initialize API return status to success
3048: x_return_status := FND_API.G_RET_STS_SUCCESS;
3049: -- Get the current (login) user id.
3050: AMV_UTILITY_PVT.Get_UserInfo(
3051: x_resource_id => l_resource_id,
3052: x_user_id => l_current_user_id,
3053: x_login_id => l_current_login_id,
3054: x_user_status => l_current_user_status

Line 3086: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

3082: RAISE FND_API.G_EXC_ERROR;
3083: END IF;
3084: END IF;
3085: -- Check if item id is valid.
3086: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3087: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3088: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3089: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3090: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 3255: AMV_UTILITY_PVT.Get_UserInfo(

3251: END IF;
3252: -- Initialize API return status to success
3253: x_return_status := FND_API.G_RET_STS_SUCCESS;
3254: -- Get the current (login) user id.
3255: AMV_UTILITY_PVT.Get_UserInfo(
3256: x_resource_id => l_resource_id,
3257: x_user_id => l_current_user_id,
3258: x_login_id => l_current_login_id,
3259: x_user_status => l_current_user_status

Line 3291: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

3287: RAISE FND_API.G_EXC_ERROR;
3288: END IF;
3289: END IF;
3290: -- Check if item id is valid.
3291: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3292: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3293: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3294: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3295: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 3404: AMV_UTILITY_PVT.Get_UserInfo(

3400: END IF;
3401: -- Initialize API return status to success
3402: x_return_status := FND_API.G_RET_STS_SUCCESS;
3403: -- Get the current (login) user id.
3404: AMV_UTILITY_PVT.Get_UserInfo(
3405: x_resource_id => l_resource_id,
3406: x_user_id => l_current_user_id,
3407: x_login_id => l_current_login_id,
3408: x_user_status => l_current_user_status

Line 3422: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN

3418: RAISE FND_API.G_EXC_ERROR;
3419: END IF;
3420: END IF;
3421: -- Check if item id is valid.
3422: IF (AMV_UTILITY_PVT.Is_ItemIdValid(p_item_id) <> TRUE) THEN
3423: IF FND_MSG_PUB.Check_Msg_level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
3424: FND_MESSAGE.Set_name('AMV','AMV_RECORD_ID_MISSING');
3425: FND_MESSAGE.Set_Token('RECORD', 'AMV_ITEM_TK', TRUE);
3426: FND_MESSAGE.Set_Token('ID', TO_CHAR(p_item_id));

Line 3551: AMV_UTILITY_PVT.Get_UserInfo(

3547: END IF;
3548: -- Initialize API return status to success
3549: x_return_status := FND_API.G_RET_STS_SUCCESS;
3550: -- Get the current (login) user id.
3551: AMV_UTILITY_PVT.Get_UserInfo(
3552: x_resource_id => l_resource_id,
3553: x_user_id => l_current_user_id,
3554: x_login_id => l_current_login_id,
3555: x_user_status => l_current_user_status

Line 3733: AMV_UTILITY_PVT.Get_UserInfo(

3729: END IF;
3730: -- Initialize API return status to success
3731: x_return_status := FND_API.G_RET_STS_SUCCESS;
3732: -- Get the current (login) user id.
3733: AMV_UTILITY_PVT.Get_UserInfo(
3734: x_resource_id => l_resource_id,
3735: x_user_id => l_current_user_id,
3736: x_login_id => l_current_login_id,
3737: x_user_status => l_current_user_status

Line 3870: l_all_match VARCHAR2(60) := ''''||AMV_UTILITY_PVT.G_MATCH||''','''||AMV_UTILITY_PVT.G_PUSH||'''';

3866: --
3867: l_channel_id NUMBER;
3868: l_channel_name VARCHAR2(80);
3869: l_count NUMBER := 1;
3870: l_all_match VARCHAR2(60) := ''''||AMV_UTILITY_PVT.G_MATCH||''','''||AMV_UTILITY_PVT.G_PUSH||'''';
3871: --
3872: CURSOR GetChannels_csr IS
3873: select c.channel_id
3874: , c.channel_name

Line 3879: and c.channel_type = amv_utility_pvt.g_content

3875: from amv_c_channels_vl c
3876: , amv_c_chl_item_match m
3877: where m.item_id = p_item_id
3878: and m.channel_id = c.channel_id
3879: and c.channel_type = amv_utility_pvt.g_content
3880: and c.access_level_type = amv_utility_pvt.g_public
3881: and m.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3882: and m.table_name_code = amv_utility_pvt.g_table_name_code
3883: and decode(p_match_type, FND_API.G_MISS_CHAR, p_match_type, m.available_due_to_type) = p_match_type;

Line 3880: and c.access_level_type = amv_utility_pvt.g_public

3876: , amv_c_chl_item_match m
3877: where m.item_id = p_item_id
3878: and m.channel_id = c.channel_id
3879: and c.channel_type = amv_utility_pvt.g_content
3880: and c.access_level_type = amv_utility_pvt.g_public
3881: and m.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3882: and m.table_name_code = amv_utility_pvt.g_table_name_code
3883: and decode(p_match_type, FND_API.G_MISS_CHAR, p_match_type, m.available_due_to_type) = p_match_type;
3884: --and m.available_due_to_type in (decode(p_match_type,FND_API.G_MISS_CHAR,l_all_match,p_match_type));

Line 3881: and m.approval_status_type = AMV_UTILITY_PVT.G_APPROVED

3877: where m.item_id = p_item_id
3878: and m.channel_id = c.channel_id
3879: and c.channel_type = amv_utility_pvt.g_content
3880: and c.access_level_type = amv_utility_pvt.g_public
3881: and m.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3882: and m.table_name_code = amv_utility_pvt.g_table_name_code
3883: and decode(p_match_type, FND_API.G_MISS_CHAR, p_match_type, m.available_due_to_type) = p_match_type;
3884: --and m.available_due_to_type in (decode(p_match_type,FND_API.G_MISS_CHAR,l_all_match,p_match_type));
3885: --

Line 3882: and m.table_name_code = amv_utility_pvt.g_table_name_code

3878: and m.channel_id = c.channel_id
3879: and c.channel_type = amv_utility_pvt.g_content
3880: and c.access_level_type = amv_utility_pvt.g_public
3881: and m.approval_status_type = AMV_UTILITY_PVT.G_APPROVED
3882: and m.table_name_code = amv_utility_pvt.g_table_name_code
3883: and decode(p_match_type, FND_API.G_MISS_CHAR, p_match_type, m.available_due_to_type) = p_match_type;
3884: --and m.available_due_to_type in (decode(p_match_type,FND_API.G_MISS_CHAR,l_all_match,p_match_type));
3885: --
3886: BEGIN

Line 3902: AMV_UTILITY_PVT.Get_UserInfo(

3898: END IF;
3899: -- Initialize API return status to success
3900: x_return_status := FND_API.G_RET_STS_SUCCESS;
3901: -- Get the current (login) user id.
3902: AMV_UTILITY_PVT.Get_UserInfo(
3903: x_resource_id => l_resource_id,
3904: x_user_id => l_current_user_id,
3905: x_login_id => l_current_login_id,
3906: x_user_status => l_current_user_status