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.

[Home] [Help]

APPS.EGO_IMPORT_UTIL_PVT dependencies on FND_API

Line 391: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

387: ,x_msg_data => l_msg_data
388: );
389:
390: Debug_Conc_Log('Call_UDA_Apply_Template: Done Calling for EGO_ITEMMGMT_GROUP with l_return_status, l_errorcode, l_msg_data='||l_return_status||','|| l_errorcode||','|| l_msg_data);
391: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
392: x_return_status := '2';
393: x_err_msg := l_msg_data;
394: RETURN;
395: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

Line 427: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

423: ,x_msg_data => l_msg_data
424: );
425:
426: Debug_Conc_Log('Call_UDA_Apply_Template: Done Calling for EGO_ITEM_GTIN_ATTRS with l_return_status, l_errorcode, l_msg_data='||l_return_status||','|| l_errorcode||','|| l_msg_data);
427: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
428: x_return_status := '2';
429: x_err_msg := l_msg_data;
430: RETURN;
431: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

Line 463: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN

459: ,x_msg_data => l_msg_data
460: );
461:
462: Debug_Conc_Log('Call_UDA_Apply_Template: Done Calling for EGO_ITEM_GTIN_MULTI_ATTRS with l_return_status, l_errorcode, l_msg_data='||l_return_status||','|| l_errorcode||','|| l_msg_data);
463: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
464: x_return_status := '2';
465: x_err_msg := l_msg_data;
466: RETURN;
467: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

Line 1015: ,p_cleanup_row_identifiers => FND_API.G_FALSE

1011: ,p_source_attr_groups_sql => l_ag_sql
1012: ,p_dest_process_status => '2' -- Bug 10263673
1013: ,p_dest_data_set_id => p_batch_id
1014: ,p_dest_transaction_type => 'CREATE'
1015: ,p_cleanup_row_identifiers => FND_API.G_FALSE
1016: ,x_return_status => l_return_status
1017: ,x_msg_count => l_msg_count
1018: ,x_msg_data => l_msg_data
1019: );

Line 1190: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1186: ,x_return_status => l_return_status
1187: ,x_msg_data => l_err_msg);
1188:
1189: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1190: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1191: x_return_status := '2';
1192: x_err_msg := l_err_msg;
1193: RETURN;
1194: ELSE

Line 1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1310: ,x_return_status => l_return_status
1311: ,x_msg_data => l_err_msg);
1312:
1313: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1314: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1315: x_return_status := '2';
1316: x_err_msg := l_err_msg;
1317: RETURN;
1318: ELSE

Line 1376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1372: ,x_return_status => l_return_status
1373: ,x_msg_data => l_err_msg);
1374:
1375: Debug_Conc_Log('Do_AGLevel_UDA_Defaulting: For Intersections - Done EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows l_return_status, l_err_msg='||l_return_status||','||l_err_msg);
1376: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1377: x_return_status := '2';
1378: x_err_msg := l_err_msg;
1379: RETURN;
1380: ELSE

Line 1549: p_ignore_item_num_upd => FND_API.G_TRUE,

1545: Debug_Conc_Log('Process_Copy_Options_For_UDAs: Calling Clean_Up_UDA_Row_Idents ');
1546: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
1547: p_batch_id => p_batch_id,
1548: p_process_status => 2,
1549: p_ignore_item_num_upd => FND_API.G_TRUE,
1550: p_commit => FND_API.G_FALSE );
1551: Debug_Conc_Log('Process_Copy_Options_For_UDAs: Clean_Up_UDA_Row_Idents Done.');
1552: -- Bug 10263673 : End
1553:

Line 1550: p_commit => FND_API.G_FALSE );

1546: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
1547: p_batch_id => p_batch_id,
1548: p_process_status => 2,
1549: p_ignore_item_num_upd => FND_API.G_TRUE,
1550: p_commit => FND_API.G_FALSE );
1551: Debug_Conc_Log('Process_Copy_Options_For_UDAs: Clean_Up_UDA_Row_Idents Done.');
1552: -- Bug 10263673 : End
1553:
1554: Debug_Conc_Log('Process_Copy_Options_For_UDAs: Done - retcode, errbuf='||retcode||','||errbuf);

Line 2369: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2365: ,p_source_attr_groups_sql => l_ag_sql
2366: ,p_dest_process_status => '2'
2367: ,p_dest_data_set_id => p_batch_id
2368: ,p_dest_transaction_type => 'CREATE'
2369: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2370: ,x_return_status => l_return_status
2371: ,x_msg_count => l_msg_count
2372: ,x_msg_data => l_msg_data
2373: );

Line 2491: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2487: ,p_source_attr_groups_sql => l_ag_sql
2488: ,p_dest_process_status => '2'
2489: ,p_dest_data_set_id => p_batch_id
2490: ,p_dest_transaction_type => 'CREATE'
2491: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2492: ,x_return_status => l_return_status
2493: ,x_msg_count => l_msg_count
2494: ,x_msg_data => l_msg_data
2495: );

Line 2604: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2600: ,p_source_attr_groups_sql => l_ag_sql
2601: ,p_dest_process_status => '2'
2602: ,p_dest_data_set_id => p_batch_id
2603: ,p_dest_transaction_type => 'CREATE'
2604: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2605: ,x_return_status => l_return_status
2606: ,x_msg_count => l_msg_count
2607: ,x_msg_data => l_msg_data
2608: );

Line 2714: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2710: ,p_source_attr_groups_sql => l_ag_sql
2711: ,p_dest_process_status => '2'
2712: ,p_dest_data_set_id => p_batch_id
2713: ,p_dest_transaction_type => 'CREATE'
2714: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2715: ,x_return_status => l_return_status
2716: ,x_msg_count => l_msg_count
2717: ,x_msg_data => l_msg_data
2718: );

Line 2870: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2866: ,p_source_attr_groups_sql => l_ag_sql
2867: ,p_dest_process_status => '2'
2868: ,p_dest_data_set_id => p_batch_id
2869: ,p_dest_transaction_type => 'CREATE'
2870: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2871: ,x_return_status => l_return_status
2872: ,x_msg_count => l_msg_count
2873: ,x_msg_data => l_msg_data
2874: );

Line 2993: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2989: ,p_source_attr_groups_sql => l_ag_sql
2990: ,p_dest_process_status => '2'
2991: ,p_dest_data_set_id => p_batch_id
2992: ,p_dest_transaction_type => 'CREATE'
2993: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2994: ,x_return_status => l_return_status
2995: ,x_msg_count => l_msg_count
2996: ,x_msg_data => l_msg_data
2997: );

Line 3124: ,p_cleanup_row_identifiers => FND_API.G_FALSE -- FND_API.G_TRUE -- Bug 9678667

3120: ,p_source_attr_groups_sql => l_ag_sql
3121: ,p_dest_process_status => '2'
3122: ,p_dest_data_set_id => p_batch_id
3123: ,p_dest_transaction_type => 'CREATE'
3124: ,p_cleanup_row_identifiers => FND_API.G_FALSE -- FND_API.G_TRUE -- Bug 9678667
3125: ,x_return_status => l_return_status
3126: ,x_msg_count => l_msg_count
3127: ,x_msg_data => l_msg_data
3128: );

Line 3268: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3264: ,p_source_attr_groups_sql => l_ag_sql
3265: ,p_dest_process_status => '2'
3266: ,p_dest_data_set_id => p_batch_id
3267: ,p_dest_transaction_type => 'CREATE'
3268: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3269: ,x_return_status => l_return_status
3270: ,x_msg_count => l_msg_count
3271: ,x_msg_data => l_msg_data
3272: );

Line 3365: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3361: ,p_source_attr_groups_sql => l_ag_sql
3362: ,p_dest_process_status => '2'
3363: ,p_dest_data_set_id => p_batch_id
3364: ,p_dest_transaction_type => 'CREATE'
3365: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3366: ,x_return_status => l_return_status
3367: ,x_msg_count => l_msg_count
3368: ,x_msg_data => l_msg_data
3369: );

Line 3465: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3461: ,p_source_attr_groups_sql => l_ag_sql
3462: ,p_dest_process_status => '2'
3463: ,p_dest_data_set_id => p_batch_id
3464: ,p_dest_transaction_type => 'CREATE'
3465: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3466: ,x_return_status => l_return_status
3467: ,x_msg_count => l_msg_count
3468: ,x_msg_data => l_msg_data
3469: );

Line 3567: ,p_cleanup_row_identifiers => FND_API.G_FALSE -- FND_API.G_TRUE -- Bug 9678667

3563: ,p_source_attr_groups_sql => l_ag_sql
3564: ,p_dest_process_status => '2'
3565: ,p_dest_data_set_id => p_batch_id
3566: ,p_dest_transaction_type => 'CREATE'
3567: ,p_cleanup_row_identifiers => FND_API.G_FALSE -- FND_API.G_TRUE -- Bug 9678667
3568: ,x_return_status => l_return_status
3569: ,x_msg_count => l_msg_count
3570: ,x_msg_data => l_msg_data
3571: );

Line 4736: p_validate_only => FND_API.G_TRUE,

4732: (
4733: ERRBUF => l_errbuf,
4734: RETCODE => l_retcode,
4735: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id
4736: p_validate_only => FND_API.G_TRUE,
4737: p_ignore_security_for_validate => FND_API.G_FALSE
4738: );
4739:
4740: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API(NULL); -- Bug 10263673

Line 4737: p_ignore_security_for_validate => FND_API.G_FALSE

4733: ERRBUF => l_errbuf,
4734: RETCODE => l_retcode,
4735: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id
4736: p_validate_only => FND_API.G_TRUE,
4737: p_ignore_security_for_validate => FND_API.G_FALSE
4738: );
4739:
4740: INV_EGO_REVISION_VALIDATE.Set_Process_Control_HTML_API(NULL); -- Bug 10263673
4741:

Line 4823: p_validate_only => FND_API.G_TRUE,

4819: (
4820: ERRBUF => l_errbuf,
4821: RETCODE => l_retcode,
4822: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id
4823: p_validate_only => FND_API.G_TRUE,
4824: p_ignore_security_for_validate => FND_API.G_TRUE
4825: );
4826:
4827: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);

Line 4824: p_ignore_security_for_validate => FND_API.G_TRUE

4820: ERRBUF => l_errbuf,
4821: RETCODE => l_retcode,
4822: p_data_set_id => l_batch_id, -- bug 12693246 changed from p_batch_id to l_batch_id
4823: p_validate_only => FND_API.G_TRUE,
4824: p_ignore_security_for_validate => FND_API.G_TRUE
4825: );
4826:
4827: Debug_Conc_Log('Preprocess_Import: Done EGO_ITEM_USER_ATTRS_CP_PUB.Process_Item_User_Attrs_Data with l_retcode, l_errbuf='||l_retcode||','||l_errbuf);
4828: IF NVL(l_retcode, '0') > RETCODE THEN

Line 4878: p_ignore_item_num_upd => FND_API.G_TRUE,

4874: Debug_Conc_Log('Preprocess_Import: Calling Clean_Up_UDA_Row_Idents ');
4875: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4876: p_batch_id => p_batch_id,
4877: p_process_status => 2,
4878: p_ignore_item_num_upd => FND_API.G_TRUE,
4879: p_commit => FND_API.G_FALSE );
4880: Debug_Conc_Log('Preprocess_Import: Clean_Up_UDA_Row_Idents Done.');
4881: -- Bug 9678667 : End
4882:

Line 4879: p_commit => FND_API.G_FALSE );

4875: EGO_IMPORT_PVT.Clean_Up_UDA_Row_Idents(
4876: p_batch_id => p_batch_id,
4877: p_process_status => 2,
4878: p_ignore_item_num_upd => FND_API.G_TRUE,
4879: p_commit => FND_API.G_FALSE );
4880: Debug_Conc_Log('Preprocess_Import: Clean_Up_UDA_Row_Idents Done.');
4881: -- Bug 9678667 : End
4882:
4883: COMMIT;

Line 5594: IF l_return_status = FND_API.G_TRUE THEN

5590: x_errorcode => l_errorcode
5591: );
5592:
5593: Debug_Conc_Log('Default_Item_People: Returned with l_return_status,l_errorcode='||l_return_status||','||l_errorcode);
5594: IF l_return_status = FND_API.G_TRUE THEN
5595: l_ret_status := '0';
5596: ELSE
5597: l_ret_status := '2';
5598: END IF;

Line 5714: IF l_return_status = FND_API.G_TRUE THEN

5710: x_errorcode => l_errorcode
5711: );
5712:
5713: Debug_Conc_Log('Copy_Item_People_From_Style: Returned with l_return_status,l_errorcode='||l_return_status||','||l_errorcode);
5714: IF l_return_status = FND_API.G_TRUE THEN
5715: l_ret_status := '0';
5716: ELSE
5717: l_ret_status := '2';
5718: END IF;

Line 5801: p_commit => FND_API.G_FALSE,

5797: i.SOURCE_ITEM_ID||','|| i.ORGANIZATION_ID|| i.DEST_ITEM_ID);
5798: EGO_LIFECYCLE_USER_PUB.Copy_Project
5799: (
5800: p_api_version => 1.0,
5801: p_commit => FND_API.G_FALSE,
5802: p_source_item_id => i.SOURCE_ITEM_ID,
5803: p_source_org_id => i.ORGANIZATION_ID,
5804: p_source_rev_id => NULL,
5805: p_association_type => 'EGO_ITEM_PROJ_ASSOC_TYPE',

Line 5816: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5812: x_msg_count => l_msg_count,
5813: x_msg_data => l_msg_data
5814: );
5815: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5816: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5817: l_ret_status := '0';
5818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5819: l_ret_status := '1';
5820: ELSE

Line 5818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5814: );
5815: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5816: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5817: l_ret_status := '0';
5818: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5819: l_ret_status := '1';
5820: ELSE
5821: l_ret_status := '2';
5822: END IF;

Line 5834: p_commit => FND_API.G_FALSE,

5830: i.SOURCE_ITEM_ID||','|| i.ORGANIZATION_ID||','|| i.SOURCE_REVISION_ID||','|| i.DEST_ITEM_ID||','|| i.DEST_REVISION_ID);
5831: EGO_LIFECYCLE_USER_PUB.Copy_Project
5832: (
5833: p_api_version => 1.0,
5834: p_commit => FND_API.G_FALSE,
5835: p_source_item_id => i.SOURCE_ITEM_ID,
5836: p_source_org_id => i.ORGANIZATION_ID,
5837: p_source_rev_id => i.SOURCE_REVISION_ID,
5838: p_association_type => 'EGO_ITEM_PROJ_ASSOC_TYPE',

Line 5849: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5845: x_msg_count => l_msg_count,
5846: x_msg_data => l_msg_data
5847: );
5848: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5849: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5850: l_ret_status := '0';
5851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5852: l_ret_status := '1';
5853: ELSE

Line 5851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5847: );
5848: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5849: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5850: l_ret_status := '0';
5851: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5852: l_ret_status := '1';
5853: ELSE
5854: l_ret_status := '2';
5855: END IF;

Line 6062: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

6058:
6059:
6060: PROCEDURE Process_Import_Copy_Options
6061: ( p_api_version IN NUMBER
6062: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
6063: , p_batch_id IN NUMBER
6064: , p_copy_option IN VARCHAR2
6065: , p_template_name IN VARCHAR2
6066: , p_template_sequence IN NUMBER

Line 6092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6088: l_user_id NUMBER := FND_GLOBAL.USER_ID;
6089: l_batch_exists NUMBER := 0;
6090: BEGIN
6091: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
6092: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6093: x_msg_count := 1;
6094: x_msg_data := 'Batch Id is mandatory';
6095: l_error := 1;
6096: ELSE

Line 6102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6098: FETCH c_batch_exists INTO l_batch_exists;
6099: CLOSE c_batch_exists;
6100:
6101: IF l_batch_exists = 0 THEN
6102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6103: x_msg_count := 1;
6104: x_msg_data := 'Batch contains no items';
6105: l_error := 1;
6106: END IF;

Line 6116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6112: FETCH check_template_name INTO l_template_id;
6113: CLOSE check_template_name;
6114:
6115: IF l_template_id IS NULL THEN
6116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6117: x_msg_count := 1;
6118: x_msg_data := 'Invalid template Name';
6119: l_error := 1;
6120: END IF;

Line 6123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6119: l_error := 1;
6120: END IF;
6121: ELSIF p_copy_option = 'COPY_FIRST' THEN
6122: IF p_selection_flag IS NULL OR p_selection_flag NOT IN ('Y', 'N') THEN
6123: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6124: x_msg_count := 1;
6125: x_msg_data := 'Invalid Copy Option and Selection Flag combination';
6126: l_error := 1;
6127: ELSE

Line 6160: x_return_status := FND_API.G_RET_STS_SUCCESS;

6156: l_user_id,
6157: l_sysdate,
6158: l_user_id
6159: );
6160: x_return_status := FND_API.G_RET_STS_SUCCESS;
6161: END IF;
6162:
6163: IF FND_API.To_Boolean(p_commit) THEN
6164: COMMIT WORK;

Line 6163: IF FND_API.To_Boolean(p_commit) THEN

6159: );
6160: x_return_status := FND_API.G_RET_STS_SUCCESS;
6161: END IF;
6162:
6163: IF FND_API.To_Boolean(p_commit) THEN
6164: COMMIT WORK;
6165: END IF;
6166: EXCEPTION
6167: WHEN others THEN

Line 6168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6164: COMMIT WORK;
6165: END IF;
6166: EXCEPTION
6167: WHEN others THEN
6168: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6169: x_msg_count := 1;
6170: x_msg_data := SQLERRM;
6171: END Process_Import_Copy_Options;
6172:

Line 6175: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

6171: END Process_Import_Copy_Options;
6172:
6173: PROCEDURE Process_Variant_Attrs
6174: ( p_api_version IN NUMBER
6175: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
6176: , p_batch_id IN NUMBER
6177: , p_item_number IN VARCHAR2
6178: , p_organization_id IN NUMBER
6179: , p_attr_group_type IN VARCHAR2

Line 6263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6259: l_error NUMBER := 0;
6260: BEGIN
6261:
6262: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
6263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6264: x_msg_count := 1;
6265: x_msg_data := 'Batch Id is mandatory';
6266: l_error := 1;
6267: END IF;

Line 6279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6275: FETCH c_valid_data_level INTO l_valid_data_level;
6276: CLOSE c_valid_data_level;
6277:
6278: IF l_valid_record = 0 OR l_valid_data_level = 0 THEN
6279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6280: x_msg_count := 1;
6281: x_msg_data := 'Invalid Attr Group Type, Name and Attr Name combination';
6282: l_error := 1;
6283: ELSE

Line 6293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6289: OPEN c_item_details;
6290: FETCH c_item_details INTO l_style_item_flag, l_row_identifier, l_item_catalog_group_id;
6291:
6292: IF c_item_details%NOTFOUND THEN
6293: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6294: x_msg_count := 1;
6295: x_msg_data := 'Batch contains no items';
6296: l_error := 1;
6297: END IF;

Line 6367: x_return_status := FND_API.G_RET_STS_SUCCESS;

6363: ,l_user_id
6364: ,l_sysdate
6365: );
6366:
6367: x_return_status := FND_API.G_RET_STS_SUCCESS;
6368: END IF;
6369:
6370: IF FND_API.To_Boolean(p_commit) THEN
6371: COMMIT WORK;

Line 6370: IF FND_API.To_Boolean(p_commit) THEN

6366:
6367: x_return_status := FND_API.G_RET_STS_SUCCESS;
6368: END IF;
6369:
6370: IF FND_API.To_Boolean(p_commit) THEN
6371: COMMIT WORK;
6372: END IF;
6373:
6374: EXCEPTION

Line 6376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

6372: END IF;
6373:
6374: EXCEPTION
6375: WHEN others THEN
6376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
6377: x_msg_count := 1;
6378: x_msg_data := SQLERRM;
6379: END Process_Variant_Attrs;
6380:

Line 7002: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE) IS

6998: Debug_Conc_Log('Clean_Dirty_SKUs : Error - '||SQLERRM);
6999: END Clean_Dirty_SKUs;
7000:
7001: PROCEDURE check_for_duplicates(p_batch_id IN NUMBER,
7002: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE) IS
7003:
7004: CURSOR Items_in_batch(p_batch_id NUMBER) is
7005: select UNIQUE SOURCE_SYSTEM_REFERENCE
7006: from MTL_SYSTEM_ITEMS_INTERFACE msii