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 JTF_TAE_CONTROL_PVT

Line 409: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

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; ');
411: Add_To_PackageTable (' RAISE; ');
412: Add_To_PackageTable (' ');
413: Add_To_PackageTable (' WHEN NO_DATA_FOUND THEN ');

Line 417: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

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; ');
419: Add_To_PackageTable (' RAISE; ');
420: Add_To_PackageTable (' ');
421: Add_To_PackageTable (' WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN ');

Line 425: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

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; ');
428: Add_To_PackageTable (' ');
429:

Line 434: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

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; ');
436: Add_To_PackageTable (' RAISE; ');
437:
438: Add_To_PackageTable (' ');

Line 3690: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

3686: Add_To_PackageTable (' || ''Qualifier Combination = ''');
3687: Add_To_PackageTable (' || lp_qual_combination_tbl(i)');
3688: Add_To_PackageTable (' || '': # OF ROWS INSERTED = '' || SQL%ROWCOUNT;');
3689: Add_To_PackageTable (' ');
3690: Add_To_PackageTable (' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');
3691:
3692: Add_To_PackageTable (' END IF; ');
3693: Add_To_PackageTable (' ');
3694: Add_To_PackageTable (' EXCEPTION ');

Line 3701: Add_To_PackageTable (G_INDENT1 || ' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

3697: Add_To_PackageTable (G_INDENT1 || ' x_Msg_Data := ''' || G_DYN_PKG_NAME || '.SEARCH_TERR_RULES: ''');
3698: Add_To_PackageTable (G_INDENT1 || ' || ''Qualifier Combination = ''');
3699: Add_To_PackageTable (G_INDENT1 || ' || lp_qual_combination_tbl(i)');
3700: Add_To_PackageTable (G_INDENT1 || ' || ''NO_DATA_FOUND: NO ROWS INSERTED.'';');
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;');

Line 3710: Add_To_PackageTable (G_INDENT1 || ' JTF_TAE_CONTROL_PVT.WRITE_LOG(2, x_Msg_Data);');

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;');
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; ');

Line 3823: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

3819: --END IF;
3820:
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,

Line 4086: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns(

4082: --END IF;
4083:
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,

Line 4322: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

4318: --END IF;
4319:
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,

Line 4604: JTF_TAE_CONTROL_PVT.Decompose_Terr_Defns

4600: -- dbms_session.set_sql_trace(TRUE);
4601: --END IF;
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,