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

Line 406: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');

402: Add_To_PackageTable (' ');
403: Add_To_PackageTable ('EXCEPTION ');
404: Add_To_PackageTable (' ');
405: Add_To_PackageTable (' WHEN VALUE_ERROR THEN ');
406: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
407: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: VALUE_ERROR''); ');
408: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
409: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
410: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');

Line 414: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');

410: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');
411: Add_To_PackageTable (' RAISE; ');
412: Add_To_PackageTable (' ');
413: Add_To_PackageTable (' WHEN NO_DATA_FOUND THEN ');
414: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
415: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: NO_DATA_FOUND''); ');
416: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
417: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
418: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');

Line 421: Add_To_PackageTable (' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN ');

417: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
418: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');
419: Add_To_PackageTable (' RAISE; ');
420: Add_To_PackageTable (' ');
421: Add_To_PackageTable (' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN ');
422: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
423: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: FND_API.G_RET_STS_UNEXP_ERROR''); ');
424: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
425: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

Line 422: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');

418: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');
419: Add_To_PackageTable (' RAISE; ');
420: Add_To_PackageTable (' ');
421: Add_To_PackageTable (' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN ');
422: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
423: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: FND_API.G_RET_STS_UNEXP_ERROR''); ');
424: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
425: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
426: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');

Line 423: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: FND_API.G_RET_STS_UNEXP_ERROR''); ');

419: Add_To_PackageTable (' RAISE; ');
420: Add_To_PackageTable (' ');
421: Add_To_PackageTable (' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN ');
422: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
423: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: FND_API.G_RET_STS_UNEXP_ERROR''); ');
424: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
425: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
426: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');
427: Add_To_PackageTable (' RAISE; ');

Line 431: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');

427: Add_To_PackageTable (' RAISE; ');
428: Add_To_PackageTable (' ');
429:
430: Add_To_PackageTable (' WHEN OTHERS THEN ');
431: Add_To_PackageTable (' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;');
432: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', ''EXCEPTION: OTHERS''); ');
433: Add_To_PackageTable (' FND_MSG_PUB.Add_Exc_Msg(''' || lp_pkg_name || ''', ''' || p_procedure_name || ''', SQLERRM); ');
434: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
435: Add_To_PackageTable (' ROLLBACK TO JTF_TAE_MATCHING_TRANSACTION; ');

Line 3705: Add_To_PackageTable (G_INDENT1 || ' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');

3701: Add_To_PackageTable (G_INDENT1 || ' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
3702: Add_To_PackageTable (' ');
3703: Add_To_PackageTable (G_INDENT1 || ' WHEN OTHERS THEN');
3704: Add_To_PackageTable (' ');
3705: Add_To_PackageTable (G_INDENT1 || ' x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;');
3706: Add_To_PackageTable (G_INDENT1 || ' x_Msg_Data := ''' || G_DYN_PKG_NAME || '.SEARCH_TERR_RULES: ''');
3707: Add_To_PackageTable (G_INDENT1 || ' || ''Qualifier Combination = ''');
3708: Add_To_PackageTable (G_INDENT1 || ' || lp_qual_combination_tbl(i)');
3709: Add_To_PackageTable (G_INDENT1 || ' || '' OTHERS: Program terminated with OTHERS exception: '' || SQLERRM;');

Line 3712: Add_To_PackageTable (G_INDENT1 || ' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');

3708: Add_To_PackageTable (G_INDENT1 || ' || lp_qual_combination_tbl(i)');
3709: Add_To_PackageTable (G_INDENT1 || ' || '' OTHERS: Program terminated with OTHERS exception: '' || SQLERRM;');
3710: Add_To_PackageTable (G_INDENT1 || ' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
3711: Add_To_PackageTable (' ');
3712: Add_To_PackageTable (G_INDENT1 || ' RAISE FND_API.G_EXC_UNEXPECTED_ERROR;');
3713: Add_To_PackageTable (' ');
3714: Add_To_PackageTable (' END; ');
3715:
3716: END LOOP;

Line 3825: p_Init_Msg_List => FND_API.G_FALSE,

3821: /* call procedure to populate prod_relation */
3822: /* ARPATEL: not needed for NM as it has been done for this aource_id/trans_id combo
3823: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
3824: (p_Api_Version_Number => 1.0,
3825: p_Init_Msg_List => FND_API.G_FALSE,
3826: p_Commit => FND_API.G_FALSE,
3827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3828: x_Return_Status => l_return_status,
3829: x_Msg_Count => l_Msg_Count,

Line 3826: p_Commit => FND_API.G_FALSE,

3822: /* ARPATEL: not needed for NM as it has been done for this aource_id/trans_id combo
3823: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
3824: (p_Api_Version_Number => 1.0,
3825: p_Init_Msg_List => FND_API.G_FALSE,
3826: p_Commit => FND_API.G_FALSE,
3827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3828: x_Return_Status => l_return_status,
3829: x_Msg_Count => l_Msg_Count,
3830: x_Msg_Data => l_Msg_Data,

Line 3827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3823: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
3824: (p_Api_Version_Number => 1.0,
3825: p_Init_Msg_List => FND_API.G_FALSE,
3826: p_Commit => FND_API.G_FALSE,
3827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3828: x_Return_Status => l_return_status,
3829: x_Msg_Count => l_Msg_Count,
3830: x_Msg_Data => l_Msg_Data,
3831: p_run_mode => 'FULL',

Line 4088: p_Init_Msg_List => FND_API.G_FALSE,

4084: /* call procedure to populate prod_relation */
4085: /* ARPATEL: this is not needed for NM as it has already been executed for this source_id/trans_id
4086: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns(
4087: p_Api_Version_Number => 1.0,
4088: p_Init_Msg_List => FND_API.G_FALSE,
4089: p_Commit => FND_API.G_FALSE,
4090: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4091: x_Return_Status => l_return_status,
4092: x_Msg_Count => l_Msg_Count,

Line 4089: p_Commit => FND_API.G_FALSE,

4085: /* ARPATEL: this is not needed for NM as it has already been executed for this source_id/trans_id
4086: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns(
4087: p_Api_Version_Number => 1.0,
4088: p_Init_Msg_List => FND_API.G_FALSE,
4089: p_Commit => FND_API.G_FALSE,
4090: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4091: x_Return_Status => l_return_status,
4092: x_Msg_Count => l_Msg_Count,
4093: x_Msg_Data => l_Msg_Data,

Line 4090: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4086: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns(
4087: p_Api_Version_Number => 1.0,
4088: p_Init_Msg_List => FND_API.G_FALSE,
4089: p_Commit => FND_API.G_FALSE,
4090: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4091: x_Return_Status => l_return_status,
4092: x_Msg_Count => l_Msg_Count,
4093: x_Msg_Data => l_Msg_Data,
4094: p_run_mode => 'FULL',

Line 4324: p_Init_Msg_List => FND_API.G_FALSE,

4320: /* call procedure to populate prod_relation */
4321: /* ARPATEL: this is not needed as SC is based on ACCOUNT
4322: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4323: (p_Api_Version_Number => 1.0,
4324: p_Init_Msg_List => FND_API.G_FALSE,
4325: p_Commit => FND_API.G_FALSE,
4326: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4327: x_Return_Status => l_return_status,
4328: x_Msg_Count => l_Msg_Count,

Line 4325: p_Commit => FND_API.G_FALSE,

4321: /* ARPATEL: this is not needed as SC is based on ACCOUNT
4322: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4323: (p_Api_Version_Number => 1.0,
4324: p_Init_Msg_List => FND_API.G_FALSE,
4325: p_Commit => FND_API.G_FALSE,
4326: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4327: x_Return_Status => l_return_status,
4328: x_Msg_Count => l_Msg_Count,
4329: x_Msg_Data => l_Msg_Data,

Line 4326: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4322: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4323: (p_Api_Version_Number => 1.0,
4324: p_Init_Msg_List => FND_API.G_FALSE,
4325: p_Commit => FND_API.G_FALSE,
4326: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4327: x_Return_Status => l_return_status,
4328: x_Msg_Count => l_Msg_Count,
4329: x_Msg_Data => l_Msg_Data,
4330: p_run_mode => 'FULL',

Line 4606: p_Init_Msg_List => FND_API.G_FALSE,

4602:
4603: /* call procedure to populate prod_relation */
4604: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4605: (p_Api_Version_Number => 1.0,
4606: p_Init_Msg_List => FND_API.G_FALSE,
4607: p_Commit => FND_API.G_FALSE,
4608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4609: x_Return_Status => l_return_status,
4610: x_Msg_Count => l_Msg_Count,

Line 4607: p_Commit => FND_API.G_FALSE,

4603: /* call procedure to populate prod_relation */
4604: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4605: (p_Api_Version_Number => 1.0,
4606: p_Init_Msg_List => FND_API.G_FALSE,
4607: p_Commit => FND_API.G_FALSE,
4608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4609: x_Return_Status => l_return_status,
4610: x_Msg_Count => l_Msg_Count,
4611: x_Msg_Data => l_Msg_Data,

Line 4608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4604: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns
4605: (p_Api_Version_Number => 1.0,
4606: p_Init_Msg_List => FND_API.G_FALSE,
4607: p_Commit => FND_API.G_FALSE,
4608: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4609: x_Return_Status => l_return_status,
4610: x_Msg_Count => l_Msg_Count,
4611: x_Msg_Data => l_Msg_Data,
4612: p_run_mode => 'FULL',