[Home] [Help]
174: l_message_tbl(l_message_tbl.count+1) := 'Operation seq num [' || p_starting_jobs_tbl(l_index).operation_seq_num || '] ';
175: l_message_tbl(l_message_tbl.count+1) := 'Operation code [' || p_starting_jobs_tbl(l_index).operation_code || '] ';
176: l_message_tbl(l_message_tbl.count+1) := 'Operation description [' || p_starting_jobs_tbl(l_index).operation_description || '] ';
177: l_message_tbl(l_message_tbl.count+1) := 'Operation seq id [' || p_starting_jobs_tbl(l_index).operation_seq_id || '] ';
178: l_message_tbl(l_message_tbl.count+1) := 'Standard operation id [' || p_starting_jobs_tbl(l_index).standard_operation_id || '] ';
179: l_message_tbl(l_message_tbl.count+1) := 'Department id [' || p_starting_jobs_tbl(l_index).department_id || '] ';
180: l_message_tbl(l_message_tbl.count+1) := 'Department code [' || p_starting_jobs_tbl(l_index).department_code || '] ';
181: l_message_tbl(l_message_tbl.count+1) := 'Start quantity [' || p_starting_jobs_tbl(l_index).start_quantity || '] ';
182: l_message_tbl(l_message_tbl.count+1) := 'Quantity available [' || p_starting_jobs_tbl(l_index).quantity_available || '] ';
1735: );
1736: End if;
1737:
1738: l_stmt_num := 130;
1739: /* Standard check of p_commit. */
1740: IF FND_API.To_Boolean( p_commit ) THEN
1741: l_stmt_num := 140;
1742:
1743: COMMIT;
1871: );
1872: End if;
1873:
1874: /* W'll log the parameter values as and where they get modified....*/
1875: /* Log the standard api parameters.... */
1876: l_stmt_num := 20;
1877:
1878: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1879: l_stmt_num := 30;
2226: End if;
2227:
2228: l_stmt_num := 130;
2229:
2230: /* Standard check of p_commit. */
2231: IF FND_API.To_Boolean( p_commit ) THEN
2232: l_stmt_num := 140;
2233: COMMIT;
2234: /* Log the Procedure exit point.... */
2342:
2343: --'Entering the Update Assembly Txn API');
2344:
2345: /* W'll log the parameter values as and where they get modified....*/
2346: /* Log the standard api parameters.... */
2347:
2348: l_stmt_num := 20;
2349:
2350: /* Log the Procedure entry point....proc level */
2701: End if;
2702:
2703:
2704: l_stmt_num := 130;
2705: /* Standard check of p_commit. */
2706: IF FND_API.To_Boolean( p_commit ) THEN
2707: l_stmt_num := 140;
2708: COMMIT;
2709: /* Log the Procedure exit point....event */
2820: /*proc level*/
2821: --'Entering the Update Routing Txn API');
2822:
2823: /* W'll log the parameter values as and where they get modified....*/
2824: /* Log the standard api parameters.... */
2825:
2826: l_stmt_num := 20;
2827:
2828: /* Log the Procedure entry point.... */
3179: );
3180: End if;
3181:
3182: l_stmt_num := 130;
3183: /* Standard check of p_commit. */
3184: IF FND_API.To_Boolean( p_commit ) THEN
3185: l_stmt_num := 140;
3186: COMMIT;
3187: /* Log the Procedure exit point....event */
3293: /*stmt lvl*/
3294: --'Entering the Update Quantity Txn API');
3295:
3296: /* W'll log the parameter values as and where they get modified....*/
3297: /* Log the standard api parameters.... */
3298:
3299: l_stmt_num := 20;
3300:
3301: /* Log the Procedure entry point....proc */
3654: );
3655: End if;
3656:
3657: l_stmt_num := 130;
3658: /* Standard check of p_commit. */
3659: IF FND_API.To_Boolean( p_commit ) THEN
3660: l_stmt_num := 140;
3661: COMMIT;
3662: /* Log the Procedure exit point....event */
4125: );
4126: End if;
4127:
4128: l_stmt_num := 130;
4129: /* Standard check of p_commit. */
4130: IF FND_API.To_Boolean( p_commit ) THEN
4131: l_stmt_num := 140;
4132: COMMIT;
4133: /* Log the Procedure exit point....event */
4510: );
4511: End if;
4512:
4513: l_stmt_num := 130;
4514: /* Standard check of p_commit. */
4515: IF FND_API.To_Boolean( p_commit ) THEN
4516: l_stmt_num := 140;
4517: COMMIT;
4518: /* Log the Procedure exit point....event */