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.EGO_IMPORT_UTIL_PVT dependencies on FND_API

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

337: ,x_msg_data => l_msg_data
338: );
339:
340: 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);
341: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
342: x_return_status := '2';
343: x_err_msg := l_msg_data;
344: RETURN;
345: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

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

373: ,x_msg_data => l_msg_data
374: );
375:
376: 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);
377: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
378: x_return_status := '2';
379: x_err_msg := l_msg_data;
380: RETURN;
381: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

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

409: ,x_msg_data => l_msg_data
410: );
411:
412: 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);
413: IF (l_return_status = FND_API.G_RET_STS_UNEXP_ERROR) THEN
414: x_return_status := '2';
415: x_err_msg := l_msg_data;
416: RETURN;
417: ELSIF l_return_status = G_FND_RET_STS_WARNING THEN

Line 914: ,p_cleanup_row_identifiers => FND_API.G_FALSE

910: ,p_source_attr_groups_sql => l_ag_sql
911: ,p_dest_process_status => '1'
912: ,p_dest_data_set_id => p_batch_id
913: ,p_dest_transaction_type => 'CREATE'
914: ,p_cleanup_row_identifiers => FND_API.G_FALSE
915: ,x_return_status => l_return_status
916: ,x_msg_count => l_msg_count
917: ,x_msg_data => l_msg_data
918: );

Line 1080: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1076: ,x_return_status => l_return_status
1077: ,x_msg_data => l_err_msg);
1078:
1079: 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);
1080: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1081: x_return_status := '2';
1082: x_err_msg := l_err_msg;
1083: RETURN;
1084: ELSE

Line 1157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1153: ,x_return_status => l_return_status
1154: ,x_msg_data => l_err_msg);
1155:
1156: 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);
1157: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1158: x_return_status := '2';
1159: x_err_msg := l_err_msg;
1160: RETURN;
1161: ELSE

Line 1219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1215: ,x_return_status => l_return_status
1216: ,x_msg_data => l_err_msg);
1217:
1218: 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);
1219: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1220: x_return_status := '2';
1221: x_err_msg := l_err_msg;
1222: RETURN;
1223: ELSE

Line 2195: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2191: ,p_source_attr_groups_sql => l_ag_sql
2192: ,p_dest_process_status => '2'
2193: ,p_dest_data_set_id => p_batch_id
2194: ,p_dest_transaction_type => 'CREATE'
2195: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2196: ,x_return_status => l_return_status
2197: ,x_msg_count => l_msg_count
2198: ,x_msg_data => l_msg_data
2199: );

Line 2311: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2307: ,p_source_attr_groups_sql => l_ag_sql
2308: ,p_dest_process_status => '2'
2309: ,p_dest_data_set_id => p_batch_id
2310: ,p_dest_transaction_type => 'CREATE'
2311: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2312: ,x_return_status => l_return_status
2313: ,x_msg_count => l_msg_count
2314: ,x_msg_data => l_msg_data
2315: );

Line 2415: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2411: ,p_source_attr_groups_sql => l_ag_sql
2412: ,p_dest_process_status => '2'
2413: ,p_dest_data_set_id => p_batch_id
2414: ,p_dest_transaction_type => 'CREATE'
2415: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2416: ,x_return_status => l_return_status
2417: ,x_msg_count => l_msg_count
2418: ,x_msg_data => l_msg_data
2419: );

Line 2525: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2521: ,p_source_attr_groups_sql => l_ag_sql
2522: ,p_dest_process_status => '2'
2523: ,p_dest_data_set_id => p_batch_id
2524: ,p_dest_transaction_type => 'CREATE'
2525: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2526: ,x_return_status => l_return_status
2527: ,x_msg_count => l_msg_count
2528: ,x_msg_data => l_msg_data
2529: );

Line 2681: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2677: ,p_source_attr_groups_sql => l_ag_sql
2678: ,p_dest_process_status => '2'
2679: ,p_dest_data_set_id => p_batch_id
2680: ,p_dest_transaction_type => 'CREATE'
2681: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2682: ,x_return_status => l_return_status
2683: ,x_msg_count => l_msg_count
2684: ,x_msg_data => l_msg_data
2685: );

Line 2804: ,p_cleanup_row_identifiers => FND_API.G_FALSE

2800: ,p_source_attr_groups_sql => l_ag_sql
2801: ,p_dest_process_status => '2'
2802: ,p_dest_data_set_id => p_batch_id
2803: ,p_dest_transaction_type => 'CREATE'
2804: ,p_cleanup_row_identifiers => FND_API.G_FALSE
2805: ,x_return_status => l_return_status
2806: ,x_msg_count => l_msg_count
2807: ,x_msg_data => l_msg_data
2808: );

Line 2935: ,p_cleanup_row_identifiers => FND_API.G_TRUE

2931: ,p_source_attr_groups_sql => l_ag_sql
2932: ,p_dest_process_status => '2'
2933: ,p_dest_data_set_id => p_batch_id
2934: ,p_dest_transaction_type => 'CREATE'
2935: ,p_cleanup_row_identifiers => FND_API.G_TRUE
2936: ,x_return_status => l_return_status
2937: ,x_msg_count => l_msg_count
2938: ,x_msg_data => l_msg_data
2939: );

Line 3078: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3074: ,p_source_attr_groups_sql => l_ag_sql
3075: ,p_dest_process_status => '2'
3076: ,p_dest_data_set_id => p_batch_id
3077: ,p_dest_transaction_type => 'CREATE'
3078: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3079: ,x_return_status => l_return_status
3080: ,x_msg_count => l_msg_count
3081: ,x_msg_data => l_msg_data
3082: );

Line 3175: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3171: ,p_source_attr_groups_sql => l_ag_sql
3172: ,p_dest_process_status => '2'
3173: ,p_dest_data_set_id => p_batch_id
3174: ,p_dest_transaction_type => 'CREATE'
3175: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3176: ,x_return_status => l_return_status
3177: ,x_msg_count => l_msg_count
3178: ,x_msg_data => l_msg_data
3179: );

Line 3275: ,p_cleanup_row_identifiers => FND_API.G_FALSE

3271: ,p_source_attr_groups_sql => l_ag_sql
3272: ,p_dest_process_status => '2'
3273: ,p_dest_data_set_id => p_batch_id
3274: ,p_dest_transaction_type => 'CREATE'
3275: ,p_cleanup_row_identifiers => FND_API.G_FALSE
3276: ,x_return_status => l_return_status
3277: ,x_msg_count => l_msg_count
3278: ,x_msg_data => l_msg_data
3279: );

Line 3377: ,p_cleanup_row_identifiers => FND_API.G_TRUE

3373: ,p_source_attr_groups_sql => l_ag_sql
3374: ,p_dest_process_status => '2'
3375: ,p_dest_data_set_id => p_batch_id
3376: ,p_dest_transaction_type => 'CREATE'
3377: ,p_cleanup_row_identifiers => FND_API.G_TRUE
3378: ,x_return_status => l_return_status
3379: ,x_msg_count => l_msg_count
3380: ,x_msg_data => l_msg_data
3381: );

Line 4082: p_validate_only => FND_API.G_TRUE,

4078: (
4079: ERRBUF => l_errbuf,
4080: RETCODE => l_retcode,
4081: p_data_set_id => p_batch_id,
4082: p_validate_only => FND_API.G_TRUE,
4083: p_ignore_security_for_validate => FND_API.G_FALSE
4084: );
4085:
4086: 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 4083: p_ignore_security_for_validate => FND_API.G_FALSE

4079: ERRBUF => l_errbuf,
4080: RETCODE => l_retcode,
4081: p_data_set_id => p_batch_id,
4082: p_validate_only => FND_API.G_TRUE,
4083: p_ignore_security_for_validate => FND_API.G_FALSE
4084: );
4085:
4086: 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);
4087: IF NVL(l_retcode, '0') > RETCODE THEN

Line 4156: p_validate_only => FND_API.G_TRUE,

4152: (
4153: ERRBUF => l_errbuf,
4154: RETCODE => l_retcode,
4155: p_data_set_id => p_batch_id,
4156: p_validate_only => FND_API.G_TRUE,
4157: p_ignore_security_for_validate => FND_API.G_TRUE
4158: );
4159:
4160: 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 4157: p_ignore_security_for_validate => FND_API.G_TRUE

4153: ERRBUF => l_errbuf,
4154: RETCODE => l_retcode,
4155: p_data_set_id => p_batch_id,
4156: p_validate_only => FND_API.G_TRUE,
4157: p_ignore_security_for_validate => FND_API.G_TRUE
4158: );
4159:
4160: 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);
4161: IF NVL(l_retcode, '0') > RETCODE THEN

Line 4844: IF l_return_status = FND_API.G_TRUE THEN

4840: x_errorcode => l_errorcode
4841: );
4842:
4843: Debug_Conc_Log('Default_Item_People: Returned with l_return_status,l_errorcode='||l_return_status||','||l_errorcode);
4844: IF l_return_status = FND_API.G_TRUE THEN
4845: l_ret_status := '0';
4846: ELSE
4847: l_ret_status := '2';
4848: END IF;

Line 4964: IF l_return_status = FND_API.G_TRUE THEN

4960: x_errorcode => l_errorcode
4961: );
4962:
4963: Debug_Conc_Log('Copy_Item_People_From_Style: Returned with l_return_status,l_errorcode='||l_return_status||','||l_errorcode);
4964: IF l_return_status = FND_API.G_TRUE THEN
4965: l_ret_status := '0';
4966: ELSE
4967: l_ret_status := '2';
4968: END IF;

Line 5051: p_commit => FND_API.G_FALSE,

5047: i.SOURCE_ITEM_ID||','|| i.ORGANIZATION_ID|| i.DEST_ITEM_ID);
5048: EGO_LIFECYCLE_USER_PUB.Copy_Project
5049: (
5050: p_api_version => 1.0,
5051: p_commit => FND_API.G_FALSE,
5052: p_source_item_id => i.SOURCE_ITEM_ID,
5053: p_source_org_id => i.ORGANIZATION_ID,
5054: p_source_rev_id => NULL,
5055: p_association_type => 'EGO_ITEM_PROJ_ASSOC_TYPE',

Line 5066: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5062: x_msg_count => l_msg_count,
5063: x_msg_data => l_msg_data
5064: );
5065: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5066: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5067: l_ret_status := '0';
5068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5069: l_ret_status := '1';
5070: ELSE

Line 5068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5064: );
5065: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5066: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5067: l_ret_status := '0';
5068: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5069: l_ret_status := '1';
5070: ELSE
5071: l_ret_status := '2';
5072: END IF;

Line 5084: p_commit => FND_API.G_FALSE,

5080: i.SOURCE_ITEM_ID||','|| i.ORGANIZATION_ID||','|| i.SOURCE_REVISION_ID||','|| i.DEST_ITEM_ID||','|| i.DEST_REVISION_ID);
5081: EGO_LIFECYCLE_USER_PUB.Copy_Project
5082: (
5083: p_api_version => 1.0,
5084: p_commit => FND_API.G_FALSE,
5085: p_source_item_id => i.SOURCE_ITEM_ID,
5086: p_source_org_id => i.ORGANIZATION_ID,
5087: p_source_rev_id => i.SOURCE_REVISION_ID,
5088: p_association_type => 'EGO_ITEM_PROJ_ASSOC_TYPE',

Line 5099: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

5095: x_msg_count => l_msg_count,
5096: x_msg_data => l_msg_data
5097: );
5098: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5099: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5100: l_ret_status := '0';
5101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5102: l_ret_status := '1';
5103: ELSE

Line 5101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

5097: );
5098: Debug_Conc_Log('Copy_LC_Projects: Done with l_return_status, l_errorcode, l_msg_data-'||l_return_status||','|| l_errorcode||','|| l_msg_data);
5099: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
5100: l_ret_status := '0';
5101: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
5102: l_ret_status := '1';
5103: ELSE
5104: l_ret_status := '2';
5105: END IF;

Line 5278: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

5274:
5275:
5276: PROCEDURE Process_Import_Copy_Options
5277: ( p_api_version IN NUMBER
5278: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
5279: , p_batch_id IN NUMBER
5280: , p_copy_option IN VARCHAR2
5281: , p_template_name IN VARCHAR2
5282: , p_template_sequence IN NUMBER

Line 5308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5304: l_user_id NUMBER := FND_GLOBAL.USER_ID;
5305: l_batch_exists NUMBER := 0;
5306: BEGIN
5307: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
5308: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5309: x_msg_count := 1;
5310: x_msg_data := 'Batch Id is mandatory';
5311: l_error := 1;
5312: ELSE

Line 5318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5314: FETCH c_batch_exists INTO l_batch_exists;
5315: CLOSE c_batch_exists;
5316:
5317: IF l_batch_exists = 0 THEN
5318: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5319: x_msg_count := 1;
5320: x_msg_data := 'Batch contains no items';
5321: l_error := 1;
5322: END IF;

Line 5332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5328: FETCH check_template_name INTO l_template_id;
5329: CLOSE check_template_name;
5330:
5331: IF l_template_id IS NULL THEN
5332: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5333: x_msg_count := 1;
5334: x_msg_data := 'Invalid template Name';
5335: l_error := 1;
5336: END IF;

Line 5339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5335: l_error := 1;
5336: END IF;
5337: ELSIF p_copy_option = 'COPY_FIRST' THEN
5338: IF p_selection_flag IS NULL OR p_selection_flag NOT IN ('Y', 'N') THEN
5339: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5340: x_msg_count := 1;
5341: x_msg_data := 'Invalid Copy Option and Selection Flag combination';
5342: l_error := 1;
5343: ELSE

Line 5376: x_return_status := FND_API.G_RET_STS_SUCCESS;

5372: l_user_id,
5373: l_sysdate,
5374: l_user_id
5375: );
5376: x_return_status := FND_API.G_RET_STS_SUCCESS;
5377: END IF;
5378:
5379: IF FND_API.To_Boolean(p_commit) THEN
5380: COMMIT WORK;

Line 5379: IF FND_API.To_Boolean(p_commit) THEN

5375: );
5376: x_return_status := FND_API.G_RET_STS_SUCCESS;
5377: END IF;
5378:
5379: IF FND_API.To_Boolean(p_commit) THEN
5380: COMMIT WORK;
5381: END IF;
5382: EXCEPTION
5383: WHEN others THEN

Line 5384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5380: COMMIT WORK;
5381: END IF;
5382: EXCEPTION
5383: WHEN others THEN
5384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5385: x_msg_count := 1;
5386: x_msg_data := SQLERRM;
5387: END Process_Import_Copy_Options;
5388:

Line 5391: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE

5387: END Process_Import_Copy_Options;
5388:
5389: PROCEDURE Process_Variant_Attrs
5390: ( p_api_version IN NUMBER
5391: , p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE
5392: , p_batch_id IN NUMBER
5393: , p_item_number IN VARCHAR2
5394: , p_organization_id IN NUMBER
5395: , p_attr_group_type IN VARCHAR2

Line 5479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5475: l_error NUMBER := 0;
5476: BEGIN
5477:
5478: IF ((p_batch_id IS NULL) OR (p_batch_id = 0)) THEN
5479: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5480: x_msg_count := 1;
5481: x_msg_data := 'Batch Id is mandatory';
5482: l_error := 1;
5483: END IF;

Line 5495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5491: FETCH c_valid_data_level INTO l_valid_data_level;
5492: CLOSE c_valid_data_level;
5493:
5494: IF l_valid_record = 0 OR l_valid_data_level = 0 THEN
5495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5496: x_msg_count := 1;
5497: x_msg_data := 'Invalid Attr Group Type, Name and Attr Name combination';
5498: l_error := 1;
5499: ELSE

Line 5509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5505: OPEN c_item_details;
5506: FETCH c_item_details INTO l_style_item_flag, l_row_identifier, l_item_catalog_group_id;
5507:
5508: IF c_item_details%NOTFOUND THEN
5509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5510: x_msg_count := 1;
5511: x_msg_data := 'Batch contains no items';
5512: l_error := 1;
5513: END IF;

Line 5583: x_return_status := FND_API.G_RET_STS_SUCCESS;

5579: ,l_user_id
5580: ,l_sysdate
5581: );
5582:
5583: x_return_status := FND_API.G_RET_STS_SUCCESS;
5584: END IF;
5585:
5586: IF FND_API.To_Boolean(p_commit) THEN
5587: COMMIT WORK;

Line 5586: IF FND_API.To_Boolean(p_commit) THEN

5582:
5583: x_return_status := FND_API.G_RET_STS_SUCCESS;
5584: END IF;
5585:
5586: IF FND_API.To_Boolean(p_commit) THEN
5587: COMMIT WORK;
5588: END IF;
5589:
5590: EXCEPTION

Line 5592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

5588: END IF;
5589:
5590: EXCEPTION
5591: WHEN others THEN
5592: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
5593: x_msg_count := 1;
5594: x_msg_data := SQLERRM;
5595: END Process_Variant_Attrs;
5596: