DBA Data[Home] [Help]

APPS.EGO_ITEM_USER_ATTRS_CP_PUB dependencies on EGO_USER_ATTRS_BULK_PVT

Line 2895: /* Doing the TEMPLATE APPLICATION for UDAs before calling EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data,

2891:
2892: END IF; */
2893:
2894: -- Bug 10263673 : Start
2895: /* Doing the TEMPLATE APPLICATION for UDAs before calling EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data,
2896: the below peice of code will be executed only in import flow.
2897: This code will be executed always in import flow.
2898: */
2899:

Line 2963: -- Call the EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data API instead of

2959: END IF;
2960: END IF; -- End of l_return = TRUE -- Bug 10263673
2961: -- Bug 10263673 : End
2962:
2963: -- Call the EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data API instead of
2964: -- EGO_USER_ATTRS_DATA_PUB.Process_User_Attrs_Data
2965:
2966: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Starting User Attributes Bulk Load', 1);
2967:

Line 3028: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3024:
3025: IF(l_item_mgmt_count > 0) THEN -- Bug 13434831
3026: /* Fix for bug#9660659 - End */
3027:
3028: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3029: p_api_version => G_API_VERSION --IN NUMBER
3030: ,p_application_id => 431 --IN NUMBER
3031: ,p_attr_group_type => 'EGO_ITEMMGMT_GROUP' --IN VARCHAR2
3032: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 3195: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3191:
3192: IF(l_item_gtin_count > 0) THEN -- Bug 13434831
3193: /* Fix for bug#9660659 - End */
3194:
3195: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3196: p_api_version => G_API_VERSION --IN NUMBER
3197: ,p_application_id => 431 --IN NUMBER
3198: ,p_attr_group_type => 'EGO_ITEM_GTIN_ATTRS' --IN VARCHAR2
3199: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 3251: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3247:
3248: IF(l_item_gtin_multi_count > 0) THEN -- Bug 13434831
3249: /* Fix for bug#9660659 - End */
3250:
3251: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3252: p_api_version => G_API_VERSION --IN NUMBER
3253: ,p_application_id => 431 --IN NUMBER
3254: ,p_attr_group_type => 'EGO_ITEM_GTIN_MULTI_ATTRS' --IN VARCHAR2
3255: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);

3293: -- Calling the API to Mark all such rows which have the same data --
3294: -- as we have for the attribute in the production tables. --
3295: ---------------------------------------------------------------------
3296:
3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
3298: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3299: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3300: p_api_version =>1.0
3301: ,p_application_id =>431

Line 3298: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */

3294: -- as we have for the attribute in the production tables. --
3295: ---------------------------------------------------------------------
3296:
3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
3298: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3299: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3300: p_api_version =>1.0
3301: ,p_application_id =>431
3302: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'

Line 3299: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

3295: ---------------------------------------------------------------------
3296:
3297: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEMMGMT_GROUP ', 1);
3298: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3299: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3300: p_api_version =>1.0
3301: ,p_application_id =>431
3302: ,p_attr_group_type =>'EGO_ITEMMGMT_GROUP'
3303: ,p_object_name =>'EGO_ITEM'

Line 3311: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

3307: ,p_commit =>p_commit
3308: ,x_return_status =>l_return_status
3309: ,x_msg_data =>l_msg_data
3310: );
3311: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
3312:
3313: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3314: ERRBUF := l_msg_data;
3315: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);

3329:
3330:
3331:
3332:
3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
3334: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3335: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3336: p_api_version =>1.0
3337: ,p_application_id =>431

Line 3334: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */

3330:
3331:
3332:
3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
3334: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3335: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3336: p_api_version =>1.0
3337: ,p_application_id =>431
3338: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'

Line 3335: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

3331:
3332:
3333: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_ATTRS ', 1);
3334: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3335: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3336: p_api_version =>1.0
3337: ,p_application_id =>431
3338: ,p_attr_group_type =>'EGO_ITEM_GTIN_ATTRS'
3339: ,p_object_name =>'EGO_ITEM'

Line 3347: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

3343: ,p_commit =>p_commit
3344: ,x_return_status =>l_return_status
3345: ,x_msg_data =>l_msg_data
3346: );
3347: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
3348:
3349: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3350: ERRBUF := l_msg_data;
3351: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);

3362: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN
3363: RETCODE := L_CONC_RET_STS_WARNING;
3364: END IF;
3365:
3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
3367: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3368: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3369: p_api_version =>1.0
3370: ,p_application_id =>431

Line 3367: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */

3363: RETCODE := L_CONC_RET_STS_WARNING;
3364: END IF;
3365:
3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
3367: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3368: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3369: p_api_version =>1.0
3370: ,p_application_id =>431
3371: ,p_attr_group_type =>'EGO_ITEM_GTIN_MULTI_ATTRS'

Line 3368: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (

3364: END IF;
3365:
3366: EGO_USER_ATTRS_DATA_PVT.Debug_Msg('Calling EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows for EGO_ITEM_GTIN_MULTI_ATTRS ', 1);
3367: /** bug 14151154 passing p_commit flag in cal to procedure EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows */
3368: EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows (
3369: p_api_version =>1.0
3370: ,p_application_id =>431
3371: ,p_attr_group_type =>'EGO_ITEM_GTIN_MULTI_ATTRS'
3372: ,p_object_name =>'EGO_ITEM'

Line 3380: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);

3376: ,p_commit =>p_commit
3377: ,x_return_status =>l_return_status
3378: ,x_msg_data =>l_msg_data
3379: );
3380: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' ... Completed EGO_USER_ATTRS_BULK_PVT.Mark_Unchanged_Attr_Rows Return Status-'||l_return_status||' '||l_msg_data, 1);
3381:
3382: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
3383: ERRBUF := l_msg_data;
3384: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

Line 3525: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3521: -- all the attr group types --
3522: ------------------------------------------------
3523: IF p_validate_only = FND_API.G_FALSE THEN
3524: IF(l_item_mgmt_count > 0) THEN -- Bug 13434831 /* Fix for bug#9660659 */
3525: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3526: p_api_version => G_API_VERSION --IN NUMBER
3527: ,p_application_id => 431 --IN NUMBER
3528: ,p_attr_group_type => 'EGO_ITEMMGMT_GROUP' --IN VARCHAR2
3529: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 3564: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3560: END IF;
3561: END IF; -- end of IF (l_item_mgmt_count > 0) /* Fix for bug#9660659 */
3562:
3563: IF(l_item_gtin_count > 0) THEN -- Bug 13434831 /* Fix for bug#9660659 */
3564: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3565: p_api_version => G_API_VERSION --IN NUMBER
3566: ,p_application_id => 431 --IN NUMBER
3567: ,p_attr_group_type => 'EGO_ITEM_GTIN_ATTRS' --IN VARCHAR2
3568: ,p_object_name => G_ITEM_NAME --IN VARCHAR2

Line 3604: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (

3600: END IF;
3601: END IF; -- end of IF (l_item_gtin_count > 0) /* Fix for bug#9660659 */
3602:
3603: IF(l_item_gtin_multi_count > 0) THEN -- Bug 13434831 /* Fix for bug#9660659 */
3604: EGO_USER_ATTRS_BULK_PVT.Bulk_Load_User_Attrs_Data (
3605: p_api_version => G_API_VERSION --IN NUMBER
3606: ,p_application_id => 431 --IN NUMBER
3607: ,p_attr_group_type => 'EGO_ITEM_GTIN_MULTI_ATTRS' --IN VARCHAR2
3608: ,p_object_name => G_ITEM_NAME --IN VARCHAR2