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 194: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');

190:
191: BEGIN
192:
193: -- Fix for Bug # 4513291. Added Debug write calls
194: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
195: IF l_debug_mode = 'Y' THEN
196: 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);
197: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
198: 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 196: 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);

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

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

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

Line 198: 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);

194: l_debug_mode := NVL(FND_PROFILE.value_specific('PA_DEBUG_MODE',fnd_global.user_id,fnd_global.login_id,275,null,null), 'N');
195: IF l_debug_mode = 'Y' THEN
196: 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);
197: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
198: 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);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
200: END IF;
201:
202: l_stage := '1';

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

195: IF l_debug_mode = 'Y' THEN
196: 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);
197: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
198: 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);
199: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_TASK', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
200: END IF;
201:
202: l_stage := '1';
203:

Line 689: 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);

685:
686: BEGIN
687: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
688: IF p_debug_mode = 'Y' THEN
689: 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);
690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);

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

686: BEGIN
687: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
688: IF p_debug_mode = 'Y' THEN
689: 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);
690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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 691: 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);

687: -- Fix for Bug # 4513291. Added Debug.write calls instead of debug.debug
688: IF p_debug_mode = 'Y' THEN
689: 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);
690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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);
695: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);

Line 692: 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);

688: IF p_debug_mode = 'Y' THEN
689: 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);
690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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);
695: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
696: END IF;

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

689: 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);
690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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);
695: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
696: END IF;
697:

Line 694: 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);

690: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_project_id='||p_project_id, x_Log_Level=> 3);
691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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);
695: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
696: END IF;
697:
698: SAVEPOINT import_project;

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

691: 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);
692: 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);
693: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id='||p_responsibility_id, x_Log_Level=> 3);
694: 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);
695: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_calling_mode='||p_calling_mode, x_Log_Level=> 3);
696: END IF;
697:
698: SAVEPOINT import_project;
699: x_return_status := 'S';

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

848: -- This was wrong as the calling env. except MSP(I guess) does not look at the x_msg_data array.
849: -- Other calling envs. rely on fnd_msg_pub.count_msg, for which we need to add msgs in stack
850:
851: IF p_debug_mode = 'Y' THEN
852: pa_debug.write(x_Module=>'PA_XC_PROJECT_PUB.IMPORT_PROJECT', x_Msg => 'p_responsibility_id is not specified', x_Log_Level=> 3);
853: END IF;
854:
855: x_msg_count := x_msg_count + 1;
856: x_msg_data.extend(1);

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

921:
922: --dbms_output.put_line('Calling init project ');
923:
924: if (p_debug_mode = 'Y') then
925: pa_debug.debug('Import-Project : Calling init project Program Starts ');
926: end if;
927:
928: -- pa_project_pub.init_project;
929:

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

948: FETCH lock_project_record into l_dummy;
949:
950: if (lock_project_record%NOTFOUND) then
951: if (p_debug_mode = 'Y') then
952: pa_debug.debug('Update Project Detals : Error PA_XC_NO_DATA_FOUND');
953: end if;
954:
955: CLOSE lock_project_record;
956: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');

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

983: l_project_mpx_start_date := fnd_date.canonical_to_date(p_project_mpx_start_date);
984: l_project_mpx_end_date := fnd_date.canonical_to_date(p_project_mpx_end_date);
985:
986: if (p_debug_mode = 'Y') then
987: pa_debug.debug('Import-Project : pa_project_pub.load_project Program Starts ');
988: end if;
989:
990: pa_project_pub.load_project
991: ( p_api_version_number => G_API_VERSION_NUMBER

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

1006: --DELETE_TASK (loop for multiple tasks)
1007: ------------------------
1008:
1009: if (p_debug_mode = 'Y') then
1010: pa_debug.debug('Import-Project : Deleting Task Program Starts ...');
1011: end if;
1012:
1013: OPEN l_get_temp_task_csr(p_project_id);
1014: LOOP

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

1018: ,l_task_id;
1019: EXIT WHEN l_get_temp_task_csr%NOTFOUND;
1020:
1021: if (p_debug_mode = 'Y') then
1022: pa_debug.debug('Import-Project : Delete_Task Program Starts ...');
1023: end if;
1024:
1025: l_msg_count := x_msg_count;
1026: l_msg_data := x_msg_data;

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

1042:
1043: -- Need to add message to the message log.
1044:
1045: if (p_debug_mode = 'Y') then
1046: pa_debug.debug('Import-Project : Error occured in PA_task_Utils.CHECK_DELETE_TASK_OK Procedure ');
1047: end if;
1048:
1049: x_return_status := l_return_status;
1050:

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

1071: -----------------------
1072: --dbms_output.put_line('Calling Execute Update Project here ');
1073:
1074: if (p_debug_mode = 'Y') then
1075: pa_debug.debug('Import-Project : Execute_Update_Project Program Starts ...');
1076: end if;
1077:
1078: IF p_calling_mode = 'PUBLISH' THEN
1079: l_pm_product_code2 := 'WORKPLAN';

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

1145: -----------------------
1146: --Transactions Commit
1147:
1148: if (p_debug_mode = 'Y') then
1149: pa_debug.debug('Import-Project : Transactions Commit Program Starts ...');
1150: end if;
1151:
1152: if p_commit = 'Y' then
1153: commit;

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

1153: commit;
1154: end if;
1155:
1156: if (p_debug_mode = 'Y') then
1157: pa_debug.debug('Import-Project : Calling init project Program Starts ...');
1158: end if;
1159:
1160: pa_project_pub.init_project;
1161:

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

1159:
1160: pa_project_pub.init_project;
1161:
1162: if (p_debug_mode = 'Y') then
1163: pa_debug.debug('Import-Project : Program Ends ...');
1164: end if;
1165:
1166:
1167: EXCEPTION

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

1170: for i in 1..p_msg_count loop
1171: --dbms_output.put_line('INSIDE THE ERROR HANDLING PORTION ');
1172:
1173: if (p_debug_mode = 'Y') then
1174: pa_debug.debug('Import-Project : Inside Error Handling Program ...');
1175: end if;
1176:
1177: -- Fix for Bug # 4513291. Ideally this call should use p_encoded as F
1178: -- So that it gets decoded messages. But not changing Right now.

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

1200: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1201: --dbms_output.put_line('UNHANDLED Exception Error Handling ');
1202:
1203: if (p_debug_mode = 'Y') then
1204: pa_debug.debug('Import-Project : Unhandled Expection ...');
1205: end if;
1206:
1207: p_msg_count := fnd_msg_pub.count_msg;
1208: for i in 1..p_msg_count loop

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

1207: p_msg_count := fnd_msg_pub.count_msg;
1208: for i in 1..p_msg_count loop
1209:
1210: if (p_debug_mode = 'Y') then
1211: pa_debug.debug('Import-Project : Inside Error Handling Program ...');
1212: end if;
1213:
1214: PA_INTERFACE_UTILS_PUB.get_messages (
1215: p_msg_count => 1

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

1239: WHEN NO_DATA_FOUND THEN
1240: -- dbms_output.put_line('NO-DATA-FOUND : YOU ARE IN MAIN PROCEDURE ');
1241:
1242: if (p_debug_mode = 'Y') then
1243: pa_debug.debug('Import-Project : Inside No Data Found Exception ...');
1244: end if;
1245:
1246: fnd_message.set_name('PA', 'PA_XC_NO_DATA_FOUND');
1247: x_msg_count := x_msg_count + 1;

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

1254: WHEN ROW_ALREADY_LOCKED THEN
1255: x_return_status := FND_API.G_RET_STS_ERROR;
1256:
1257: if (p_debug_mode = 'Y') then
1258: pa_debug.debug('Import-Project : Inside Row Already Locked Exception ...');
1259: end if;
1260:
1261: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
1262: FND_MESSAGE.Set_Name('PA', 'PA_XC_ROW_ALREADY_LOCKED');

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

1272: END IF;
1273:
1274: WHEN OTHERS THEN
1275: if (p_debug_mode = 'Y') then
1276: pa_debug.debug('Import-Project : Inside Other Exception ...');
1277: end if;
1278:
1279: l_text := SQLCODE||SUBSTRB(SQLERRM,1,1000); -- 4537865 : Changed substr to substrb
1280: x_msg_count := x_msg_count + 1;