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.AHL_MC_PATH_POSITION_PVT dependencies on FND_LOG

Line 705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

701:
702: --
703: BEGIN
704:
705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
706: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
707: END IF;
708:
709: -- Standard start of API savepoint

Line 706: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');

702: --
703: BEGIN
704:
705: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
706: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.begin','At the start of PLSQL procedure');
707: END IF;
708:
709: -- Standard start of API savepoint
710: SAVEPOINT map_position_to_instances_pvt;

Line 725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

721: IF FND_API.To_Boolean(p_init_msg_list) THEN
722: FND_MSG_PUB.Initialize;
723: END IF;
724:
725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
726: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_position_id --'||p_position_id);
727: fnd_log.string(fnd_log.level_statement,l_full_name,'--Populate position path info--');
728: END IF;
729:

Line 726: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_position_id --'||p_position_id);

722: FND_MSG_PUB.Initialize;
723: END IF;
724:
725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
726: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_position_id --'||p_position_id);
727: fnd_log.string(fnd_log.level_statement,l_full_name,'--Populate position path info--');
728: END IF;
729:
730: l_index :=0;

Line 727: fnd_log.string(fnd_log.level_statement,l_full_name,'--Populate position path info--');

723: END IF;
724:
725: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
726: fnd_log.string(fnd_log.level_statement,l_full_name,'-- p_position_id --'||p_position_id);
727: fnd_log.string(fnd_log.level_statement,l_full_name,'--Populate position path info--');
728: END IF;
729:
730: l_index :=0;
731: --Populate position path info starting at index =0

Line 744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

740: l_index := l_index +1;
741: END LOOP;
742: CLOSE get_position_path_csr;
743:
744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
745: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Opening Cursor check_pos_key_top_csr --');
746: END IF;
747:
748: OPEN check_pos_key_top_csr(l_path_tbl(l_path_tbl.LAST).mc_id,

Line 745: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Opening Cursor check_pos_key_top_csr --');

741: END LOOP;
742: CLOSE get_position_path_csr;
743:
744: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
745: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Opening Cursor check_pos_key_top_csr --');
746: END IF;
747:
748: OPEN check_pos_key_top_csr(l_path_tbl(l_path_tbl.LAST).mc_id,
749: l_path_tbl(l_path_tbl.LAST).version_number,

Line 754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

750: l_path_tbl(l_path_tbl.LAST).position_key);
751: FETCH check_pos_key_top_csr INTO l_dummy;
752: IF (check_pos_key_top_csr%FOUND) THEN
753: l_top_flag := true;
754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
755: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to True --');
756: END IF;
757: ELSE
758: l_top_flag := false;

Line 755: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to True --');

751: FETCH check_pos_key_top_csr INTO l_dummy;
752: IF (check_pos_key_top_csr%FOUND) THEN
753: l_top_flag := true;
754: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
755: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to True --');
756: END IF;
757: ELSE
758: l_top_flag := false;
759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

Line 759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

755: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to True --');
756: END IF;
757: ELSE
758: l_top_flag := false;
759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
760: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to False --');
761: END IF;
762: END IF;
763: CLOSE check_pos_key_top_csr;

Line 760: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to False --');

756: END IF;
757: ELSE
758: l_top_flag := false;
759: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
760: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Set Top FLag to False --');
761: END IF;
762: END IF;
763: CLOSE check_pos_key_top_csr;
764:

Line 771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

767: v_From := ' FROM AHL_UC_HEADER_PATHS_V v0 ';
768: v_Where := ' WHERE v0.mc_id = :mc_id0 ' ||
769: ' AND v0.mc_version_number = nvl(:ver0,v0.mc_version_number) ';
770:
771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
772: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Select --'||v_Select);
773: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -1-'||v_From);
774: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -1-'||v_Where);
775: END IF;

Line 772: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Select --'||v_Select);

768: v_Where := ' WHERE v0.mc_id = :mc_id0 ' ||
769: ' AND v0.mc_version_number = nvl(:ver0,v0.mc_version_number) ';
770:
771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
772: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Select --'||v_Select);
773: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -1-'||v_From);
774: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -1-'||v_Where);
775: END IF;
776:

Line 773: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -1-'||v_From);

769: ' AND v0.mc_version_number = nvl(:ver0,v0.mc_version_number) ';
770:
771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
772: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Select --'||v_Select);
773: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -1-'||v_From);
774: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -1-'||v_Where);
775: END IF;
776:
777: --Build the dynamic sql statement

Line 774: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -1-'||v_Where);

770:
771: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
772: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Select --'||v_Select);
773: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -1-'||v_From);
774: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -1-'||v_Where);
775: END IF;
776:
777: --Build the dynamic sql statement
778: FOR i IN l_path_tbl.FIRST+1..l_path_tbl.LAST LOOP

Line 794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

790: ||' AND AHL_MC_PATH_POSITION_PVT.CHECK_POS_REF_PATH_CHAR(v'||TO_CHAR(i)||'.csi_instance_id, v'||TO_CHAR(i)||'.parent_instance_id) = ''T'' ';
791:
792: END LOOP;
793:
794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
795: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -2-'||v_From);
796: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);
797: END IF;
798:

Line 795: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -2-'||v_From);

791:
792: END LOOP;
793:
794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
795: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -2-'||v_From);
796: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);
797: END IF;
798:
799: IF (l_top_flag) THEN

Line 796: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);

792: END LOOP;
793:
794: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
795: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_From -2-'||v_From);
796: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Where -2-'||v_Where);
797: END IF;
798:
799: IF (l_top_flag) THEN
800: v_Stmt := 'INSERT INTO AHL_APPLICABLE_INSTANCES '||

Line 823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

819: ||' AND TRUNC(nvl(CSI_II.ACTIVE_END_DATE, sysdate+1)) > TRUNC(sysdate) ';
820:
821: END IF;
822:
823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
824: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Stmt --'||v_Stmt);
825: END IF;
826:
827: /*for i in 0..(length(v_Stmt)/255) LOOP

Line 824: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Stmt --'||v_Stmt);

820:
821: END IF;
822:
823: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
824: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_Stmt --'||v_Stmt);
825: END IF;
826:
827: /*for i in 0..(length(v_Stmt)/255) LOOP
828: dbms_output.put_line(substr(v_Stmt,i*255,255));

Line 836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

832: --Due to performance considerations, doing dynamic sql
833: --------------------------------------
834: v_CursorID := DBMS_SQL.OPEN_CURSOR;
835:
836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
837: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Parsing Sql --');
838: END IF;
839:
840: DBMS_SQL.PARSE(v_CursorID, v_Stmt, DBMS_SQL.V7);

Line 837: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Parsing Sql --');

833: --------------------------------------
834: v_CursorID := DBMS_SQL.OPEN_CURSOR;
835:
836: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
837: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Parsing Sql --');
838: END IF;
839:
840: DBMS_SQL.PARSE(v_CursorID, v_Stmt, DBMS_SQL.V7);
841:

Line 842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

838: END IF;
839:
840: DBMS_SQL.PARSE(v_CursorID, v_Stmt, DBMS_SQL.V7);
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
843: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Binding Params Sql --');
844: END IF;
845:
846: --Bind the dynamic sql statement

Line 843: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Binding Params Sql --');

839:
840: DBMS_SQL.PARSE(v_CursorID, v_Stmt, DBMS_SQL.V7);
841:
842: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
843: fnd_log.string(fnd_log.level_statement,l_full_name,'-- Binding Params Sql --');
844: END IF;
845:
846: --Bind the dynamic sql statement
847: FOR i IN l_path_tbl.FIRST..l_path_tbl.LAST LOOP

Line 853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

849: DBMS_SQL.BIND_VARIABLE (v_CursorID, ':ver'||i, l_path_tbl(i).version_number);
850: DBMS_SQL.BIND_VARIABLE (v_CursorID, ':pos_key'||i, l_path_tbl(i).position_key);
851: END LOOP;
852:
853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
854: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Binding - Before Executing Sql --');
855: END IF;
856:
857: --Execute the dynamic sql

Line 854: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Binding - Before Executing Sql --');

850: DBMS_SQL.BIND_VARIABLE (v_CursorID, ':pos_key'||i, l_path_tbl(i).position_key);
851: END LOOP;
852:
853: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
854: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Binding - Before Executing Sql --');
855: END IF;
856:
857: --Execute the dynamic sql
858: v_RowsInserted := DBMS_SQL.EXECUTE(v_CursorID);

Line 860: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN

856:
857: --Execute the dynamic sql
858: v_RowsInserted := DBMS_SQL.EXECUTE(v_CursorID);
859:
860: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
861: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Executing Sql --');
862: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_RowsInserted --'||v_RowsInserted);
863: END IF;
864:

Line 861: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Executing Sql --');

857: --Execute the dynamic sql
858: v_RowsInserted := DBMS_SQL.EXECUTE(v_CursorID);
859:
860: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
861: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Executing Sql --');
862: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_RowsInserted --'||v_RowsInserted);
863: END IF;
864:
865: DBMS_SQL.CLOSE_CURSOR(v_CursorID);

Line 862: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_RowsInserted --'||v_RowsInserted);

858: v_RowsInserted := DBMS_SQL.EXECUTE(v_CursorID);
859:
860: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level)THEN
861: fnd_log.string(fnd_log.level_statement,l_full_name,'-- After Executing Sql --');
862: fnd_log.string(fnd_log.level_statement,l_full_name,'-- v_RowsInserted --'||v_RowsInserted);
863: END IF;
864:
865: DBMS_SQL.CLOSE_CURSOR(v_CursorID);
866:

Line 879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

875: p_data => x_msg_data,
876: p_encoded => fnd_api.g_false
877: );
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
880: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','At the end of PLSQL procedure');
881: END IF;
882:
883: EXCEPTION

Line 880: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','At the end of PLSQL procedure');

876: p_encoded => fnd_api.g_false
877: );
878:
879: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
880: fnd_log.string(fnd_log.level_procedure,L_FULL_NAME||'.end','At the end of PLSQL procedure');
881: END IF;
882:
883: EXCEPTION
884: WHEN FND_API.G_EXC_ERROR THEN

Line 1075: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1071: BEGIN
1072: -- Standard start of API savepoint
1073: SAVEPOINT Get_Pos_Empty_Instance_pvt;
1074:
1075: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1076: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
1077: ', p_position_id = ' || p_position_id);
1078: END IF;
1079: -- Initialize Procedure return status to success

Line 1076: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||

1072: -- Standard start of API savepoint
1073: SAVEPOINT Get_Pos_Empty_Instance_pvt;
1074:
1075: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1076: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
1077: ', p_position_id = ' || p_position_id);
1078: END IF;
1079: -- Initialize Procedure return status to success
1080: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1248: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

1244: END IF;
1245: CLOSE check_pos_ref_csr;
1246: END IF;
1247:
1248: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');
1250: END IF;
1251: -- Standard call to get message count and if count is 1, get message info
1252: FND_MSG_PUB.Count_And_Get

Line 1249: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');

1245: CLOSE check_pos_ref_csr;
1246: END IF;
1247:
1248: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
1249: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to count and get error messages.');
1250: END IF;
1251: -- Standard call to get message count and if count is 1, get message info
1252: FND_MSG_PUB.Count_And_Get
1253: ( p_count => x_msg_count,

Line 2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2539: BEGIN
2540: -- Standard start of API savepoint
2541: SAVEPOINT Map_Instance_To_Pos_ID_pvt;
2542:
2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2544: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
2545: ', p_relationship_id = ' || p_relationship_id);
2546: END IF;
2547: -- Initialize Procedure return status to success

Line 2544: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||

2540: -- Standard start of API savepoint
2541: SAVEPOINT Map_Instance_To_Pos_ID_pvt;
2542:
2543: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2544: fnd_log.string(fnd_log.level_procedure, l_full_name||'.begin', 'At the start of PLSQL procedure. p_csi_item_instance_id = ' || p_csi_item_instance_id ||
2545: ', p_relationship_id = ' || p_relationship_id);
2546: END IF;
2547: -- Initialize Procedure return status to success
2548: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2632: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN

2628: END IF;
2629:
2630: IF (l_path_tbl.COUNT > 0) THEN
2631: --Create position with generated instance path position id
2632: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
2633: fnd_log.string(fnd_log.level_event, l_full_name, 'About to call Create_Position_ID API. l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
2634: end if;
2635:
2636: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 21-Dec-2007

Line 2633: fnd_log.string(fnd_log.level_event, l_full_name, 'About to call Create_Position_ID API. l_path_tbl.COUNT = ' || l_path_tbl.COUNT);

2629:
2630: IF (l_path_tbl.COUNT > 0) THEN
2631: --Create position with generated instance path position id
2632: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
2633: fnd_log.string(fnd_log.level_event, l_full_name, 'About to call Create_Position_ID API. l_path_tbl.COUNT = ' || l_path_tbl.COUNT);
2634: end if;
2635:
2636: -- SATHAPLI::FP OGMA Issue# 105 - Non-Serialized Item Maintenance, 21-Dec-2007
2637: -- There is no need to call the API Create_Position_ID, if there are pending validation errors.

Line 2654: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN

2650: x_position_id => x_path_position_id,
2651: x_return_status => x_return_status,
2652: x_msg_count => x_msg_count,
2653: x_msg_data => x_msg_data);
2654: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
2655: fnd_log.string(fnd_log.level_event, l_full_name, 'Returned from call to Create_Position_ID API. x_return_status = ' || x_return_status ||
2656: ', x_position_id = ' || x_path_position_id);
2657: end if;
2658: END IF;

Line 2655: fnd_log.string(fnd_log.level_event, l_full_name, 'Returned from call to Create_Position_ID API. x_return_status = ' || x_return_status ||

2651: x_return_status => x_return_status,
2652: x_msg_count => x_msg_count,
2653: x_msg_data => x_msg_data);
2654: IF (fnd_log.level_event >= fnd_log.g_current_runtime_level)THEN
2655: fnd_log.string(fnd_log.level_event, l_full_name, 'Returned from call to Create_Position_ID API. x_return_status = ' || x_return_status ||
2656: ', x_position_id = ' || x_path_position_id);
2657: end if;
2658: END IF;
2659:

Line 2660: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN

2656: ', x_position_id = ' || x_path_position_id);
2657: end if;
2658: END IF;
2659:
2660: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2661: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');
2662: END IF;
2663: -- Standard check of p_commit
2664: IF FND_API.TO_BOOLEAN(p_commit) THEN

Line 2661: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');

2657: end if;
2658: END IF;
2659:
2660: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level)THEN
2661: fnd_log.string(fnd_log.level_procedure, l_full_name||'.end', 'At the end of PLSQL procedure. About to commit work.');
2662: END IF;
2663: -- Standard check of p_commit
2664: IF FND_API.TO_BOOLEAN(p_commit) THEN
2665: COMMIT WORK;

Line 2764: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

2760: l_item_group_id NUMBER;
2761: l_serial_number_control_code NUMBER;
2762: --
2763: BEGIN
2764: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2765: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.begin','Start of the API.'||
2766: ' Input parameters p_relationship_id => '||p_relationship_id||
2767: ', p_path_position_id => '||p_path_position_id);
2768: END IF;

Line 2765: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.begin','Start of the API.'||

2761: l_serial_number_control_code NUMBER;
2762: --
2763: BEGIN
2764: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2765: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.begin','Start of the API.'||
2766: ' Input parameters p_relationship_id => '||p_relationship_id||
2767: ', p_path_position_id => '||p_path_position_id);
2768: END IF;
2769:

Line 2776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2772: OPEN get_rel_id_csr(p_path_position_id);
2773: FETCH get_rel_id_csr INTO l_relationship_id;
2774: CLOSE get_rel_id_csr;
2775:
2776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2777: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2778: ' After cursor call l_relationship_id => '||l_relationship_id);
2779: END IF;
2780: END IF;

Line 2777: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

2773: FETCH get_rel_id_csr INTO l_relationship_id;
2774: CLOSE get_rel_id_csr;
2775:
2776: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2777: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2778: ' After cursor call l_relationship_id => '||l_relationship_id);
2779: END IF;
2780: END IF;
2781:

Line 2790: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2786: FETCH get_item_group_id_csr INTO l_item_group_id;
2787:
2788: IF (get_item_group_id_csr%NOTFOUND) THEN
2789: -- relationship id is invalid
2790: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2792: ' Relationship id is invalid.');
2793: END IF;
2794: END IF;

Line 2791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

2787:
2788: IF (get_item_group_id_csr%NOTFOUND) THEN
2789: -- relationship id is invalid
2790: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2791: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2792: ' Relationship id is invalid.');
2793: END IF;
2794: END IF;
2795:

Line 2800: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

2796: CLOSE get_item_group_id_csr;
2797:
2798: -- check for the fetched item group id
2799: IF (l_item_group_id IS NOT NULL) THEN
2800: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2802: ' Fetched item group id => '||l_item_group_id);
2803: END IF;
2804:

Line 2801: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,

2797:
2798: -- check for the fetched item group id
2799: IF (l_item_group_id IS NOT NULL) THEN
2800: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2801: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
2802: ' Fetched item group id => '||l_item_group_id);
2803: END IF;
2804:
2805: -- the MC position doesn't have subconfigurations attached

Line 2821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN

2817: END IF;
2818: END IF;
2819: END IF; -- relationship id check
2820:
2821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2822: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.end','End of the API with return value => '||l_ret_val);
2823: END IF;
2824:
2825: RETURN l_ret_val;

Line 2822: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.end','End of the API with return value => '||l_ret_val);

2818: END IF;
2819: END IF; -- relationship id check
2820:
2821: IF (FND_LOG.level_procedure >= FND_LOG.g_current_runtime_level) THEN
2822: FND_LOG.string(FND_LOG.level_procedure,l_full_name||'.end','End of the API with return value => '||l_ret_val);
2823: END IF;
2824:
2825: RETURN l_ret_val;
2826: END Is_Position_Serial_Controlled;