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.PA_XC_PROJECT_PUB dependencies on PA_DEBUG

Line 196: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

192:
193: BEGIN
194:
195: -- Fix for Bug # 4513291. Added Debug write calls
196: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
197: IF l_debug_mode = 'Y' THEN
198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);

Line 198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);

194:
195: -- Fix for Bug # 4513291. Added Debug write calls
196: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
197: IF l_debug_mode = 'Y' THEN
198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
201: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
202: END IF;

Line 199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);

195: -- Fix for Bug # 4513291. Added Debug write calls
196: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
197: IF l_debug_mode = 'Y' THEN
198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
201: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
202: END IF;
203:

Line 200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);

196: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
197: IF l_debug_mode = 'Y' THEN
198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
201: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
202: END IF;
203:
204: l_stage := '1';

Line 201: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);

197: IF l_debug_mode = 'Y' THEN
198: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_TASK Start : Passed Parameters :', x_Log_Level=> 3);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
200: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
201: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
202: END IF;
203:
204: l_stage := '1';
205:

Line 700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);

696:
697: BEGIN
698: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
699: IF p_debug_mode = 'Y' THEN
700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);
701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);

Line 701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);

697: BEGIN
698: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
699: IF p_debug_mode = 'Y' THEN
700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);
701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);

Line 702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);

698: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
699: IF p_debug_mode = 'Y' THEN
700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);
701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);

Line 703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);

699: IF p_debug_mode = 'Y' THEN
700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);
701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
707: END IF;

Line 704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);

700: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'PA_XC_PROJECT_PUB.IMPORT_PROJECT Start : Passed Parameters :', x_Log_Level=> 3);
701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
707: END IF;
708:

Line 705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);

701: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
707: END IF;
708:
709: SAVEPOINT import_project;

Line 706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);

702: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_start_date='||p_project_mpx_start_date, x_Log_Level=> 3);
703: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_mpx_end_date='||p_project_mpx_end_date, x_Log_Level=> 3);
704: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
705: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_structure_version_id='||p_structure_version_id, x_Log_Level=> 3);
706: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
707: END IF;
708:
709: SAVEPOINT import_project;
710: x_return_status := 'S';

Line 863: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id is not specified', x_Log_Level=> 3);

859: -- This was wrong as the calling env. except MSP(I guess) does not look at the x_msg_data array.
860: -- Other calling envs. rely on fnd_msg_pub.count_msg, for which we need to add msgs in stack
861:
862: IF p_debug_mode = 'Y' THEN
863: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id is not specified', x_Log_Level=> 3);
864: END IF;
865:
866: x_msg_count := x_msg_count + 1;
867: x_msg_data.extend(1);

Line 936: pa_debug.debug('Import-Project : Calling init project Program Starts ');

932:
933: --dbms_output.put_line('Calling init project ');
934:
935: if (p_debug_mode = 'Y') then
936: pa_debug.debug('Import-Project : Calling init project Program Starts ');
937: end if;
938:
939: -- pa_project_pub.init_project;
940:

Line 963: pa_debug.debug('Update Project Detals : Error PA_XC_NO_DATA_FOUND');

959: FETCH lock_project_record into l_dummy;
960:
961: if (lock_project_record%NOTFOUND) then
962: if (p_debug_mode = 'Y') then
963: pa_debug.debug('Update Project Detals : Error PA_XC_NO_DATA_FOUND');
964: end if;
965:
966: CLOSE lock_project_record;
967: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');

Line 998: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');

994: l_project_mpx_start_date := fnd_date.canonical_to_date(p_project_mpx_start_date);
995: l_project_mpx_end_date := fnd_date.canonical_to_date(p_project_mpx_end_date);
996:
997: if (p_debug_mode = 'Y') then
998: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
999: end if;
1000:
1001: pa_project_pub.load_project
1002: ( p_api_version_number => G_API_VERSION_NUMBER

Line 1021: pa_debug.debug('Import-Project : Deleting Task Program Starts ...');

1017: --DELETE_TASK (loop for multiple tasks)
1018: ------------------------
1019:
1020: if (p_debug_mode = 'Y') then
1021: pa_debug.debug('Import-Project : Deleting Task Program Starts ...');
1022: end if;
1023:
1024: OPEN l_get_temp_task_csr(p_project_id);
1025: LOOP

Line 1033: pa_debug.debug('Import-Project : Delete_Task Program Starts ...');

1029: ,l_task_id;
1030: EXIT WHEN l_get_temp_task_csr%NOTFOUND;
1031:
1032: if (p_debug_mode = 'Y') then
1033: pa_debug.debug('Import-Project : Delete_Task Program Starts ...');
1034: end if;
1035:
1036: l_msg_count := x_msg_count;
1037: l_msg_data := x_msg_data;

Line 1057: pa_debug.debug('Import-Project : Error occured in PA_task_Utils.CHECK_DELETE_TASK_OK Procedure ');

1053:
1054: -- Need to add message to the message log.
1055:
1056: if (p_debug_mode = 'Y') then
1057: pa_debug.debug('Import-Project : Error occured in PA_task_Utils.CHECK_DELETE_TASK_OK Procedure ');
1058: end if;
1059:
1060: x_return_status := l_return_status;
1061:

Line 1086: pa_debug.debug('Import-Project : Execute_Update_Project Program Starts ...');

1082: -----------------------
1083: --dbms_output.put_line('Calling Execute Update Project here ');
1084:
1085: if (p_debug_mode = 'Y') then
1086: pa_debug.debug('Import-Project : Execute_Update_Project Program Starts ...');
1087: end if;
1088:
1089: IF p_calling_mode = 'PUBLISH' THEN
1090: l_pm_product_code2 := 'WORKPLAN';

Line 1160: pa_debug.debug('Import-Project : Transactions Commit Program Starts ...');

1156: -----------------------
1157: --Transactions Commit
1158:
1159: if (p_debug_mode = 'Y') then
1160: pa_debug.debug('Import-Project : Transactions Commit Program Starts ...');
1161: end if;
1162:
1163: if p_commit = 'Y' then
1164: commit;

Line 1168: pa_debug.debug('Import-Project : Calling init project Program Starts ...');

1164: commit;
1165: end if;
1166:
1167: if (p_debug_mode = 'Y') then
1168: pa_debug.debug('Import-Project : Calling init project Program Starts ...');
1169: end if;
1170:
1171: pa_project_pub.init_project;
1172:

Line 1174: pa_debug.debug('Import-Project : Program Ends ...');

1170:
1171: pa_project_pub.init_project;
1172:
1173: if (p_debug_mode = 'Y') then
1174: pa_debug.debug('Import-Project : Program Ends ...');
1175: end if;
1176:
1177:
1178: EXCEPTION

Line 1185: pa_debug.debug('Import-Project : Inside Error Handling Program ...');

1181: for i in 1..p_msg_count loop
1182: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1183:
1184: if (p_debug_mode = 'Y') then
1185: pa_debug.debug('Import-Project : Inside Error Handling Program ...');
1186: end if;
1187:
1188: -- Fix for Bug # 4513291. Ideally this call should use p_encoded as F
1189: -- So that it gets decoded messages. But not changing Right now.

Line 1215: pa_debug.debug('Import-Project : Unhandled Expection ...');

1211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1212: --dbms_output.put_line('UNHANDLED Exception Error Handling ');
1213:
1214: if (p_debug_mode = 'Y') then
1215: pa_debug.debug('Import-Project : Unhandled Expection ...');
1216: end if;
1217:
1218: p_msg_count := fnd_msg_pub.count_msg;
1219: for i in 1..p_msg_count loop

Line 1222: pa_debug.debug('Import-Project : Inside Error Handling Program ...');

1218: p_msg_count := fnd_msg_pub.count_msg;
1219: for i in 1..p_msg_count loop
1220:
1221: if (p_debug_mode = 'Y') then
1222: pa_debug.debug('Import-Project : Inside Error Handling Program ...');
1223: end if;
1224:
1225: PA_INTERFACE_UTILS_PUB.get_messages (
1226: p_msg_count => 1

Line 1254: pa_debug.debug('Import-Project : Inside No Data Found Exception ...');

1250: WHEN NO_DATA_FOUND THEN
1251: -- dbms_output.put_line('NO-DATA-FOUND : YOU ARE IN MAIN PROCEDURE ');
1252:
1253: if (p_debug_mode = 'Y') then
1254: pa_debug.debug('Import-Project : Inside No Data Found Exception ...');
1255: end if;
1256:
1257: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
1258: x_msg_count := x_msg_count + 1;

Line 1269: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');

1265: WHEN ROW_ALREADY_LOCKED THEN
1266: x_return_status := FND_API.G_RET_STS_ERROR;
1267:
1268: if (p_debug_mode = 'Y') then
1269: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1270: end if;
1271:
1272: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1273: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');

Line 1287: pa_debug.debug('Import-Project : Inside Other Exception ...');

1283: END IF;
1284:
1285: WHEN OTHERS THEN
1286: if (p_debug_mode = 'Y') then
1287: pa_debug.debug('Import-Project : Inside Other Exception ...');
1288: end if;
1289:
1290: l_text := SQLCODE||SUBSTRB(SQLERRM,1,1000); -- 4537865 : Changed substr to substrb
1291: x_msg_count := x_msg_count + 1;